using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

​

namespace ProjectManagement

{

    public class ProjectData

    {

        const string ConnectionString = "Server=.;Initial Catalog=ProjectManagement;User ID=sa;Password=wipro@123";

        public string AddProject(Project obj)

        {

            //throw new NotImplementedException();

            if (obj == null)

                return null;

            else

            {

                ProjectUtility pu = new ProjectUtility();

                string id = pu.GenerateProjectID(obj.ProjectName);

                Random r = new Random();

                id += r.Next(100, 1000);

                obj.ProjectID = id;

                int d = (obj.StartDate - obj.EndDate).Days;

                obj.Duration = d;

                string ap = "INSERT INTO PROJECTS VALUES ('" + obj.ProjectID + "','" + obj.ProjectName + "','" + obj.StartDate + "','" + obj.EndDate + "','" + obj.Duration + "')";

                SqlConnection con = new SqlConnection(ConnectionString);

                con.Open();

                SqlCommand cmd = new SqlCommand(ap, con);

                int i = cmd.ExecuteNonQuery();

                con.Close();

                if (i > 0)

                    return obj.ProjectID;

                else

                    return null;

            }

        }

​

        public Project GetProjctByID(string strProjectID)

        {

            //throw new NotImplementedException();

            if (strProjectID == null || string.IsNullOrEmpty(strProjectID))

            {

                return null;

            }

            else

            {

                SqlConnection con = new SqlConnection(ConnectionString);

                SqlCommand cmd = new SqlCommand("Select * from Projects where ProjectID=@PID", con);

​

                cmd.Parameters.AddWithValue("@PID", strProjectID);

                con.Open();

                SqlDataReader dr = cmd.ExecuteReader();

                if (dr.HasRows)

                {

                    dr.Read();

                    Project p = new Project();

                    p.ProjectID = dr["ProjectID"].ToString();

                    p.ProjectName = dr["ProjectName"].ToString();

                    p.StartDate = DateTime.Parse(dr["StartDate"].ToString());

                    p.EndDate = DateTime.Parse(dr["EndDate"].ToString());

                    p.Duration = int.Parse(dr["Duration"].ToString());

                    con.Close();

                    return p;

​

                }

                else

                {

                    return null;

​

                }

​

            }

        }

​

        public int UpdateProject(Project obj)

        {

            //throw new NotImplementedException();

            if (obj == null)

            {

                return -1;

            }

            else

            {

                SqlConnection con = new SqlConnection(ConnectionString);

                SqlCommand cmd = new SqlCommand("Update Projects set ProjectID=@pid,ProjectName=@pn,StartDate=@sd,EndDate=@ed,Duration=@dur", con);

                cmd.Parameters.AddWithValue("@pid", obj.ProjectID);

                cmd.Parameters.AddWithValue("@pn", obj.ProjectName);

                cmd.Parameters.AddWithValue("@sd", obj.StartDate);

                cmd.Parameters.AddWithValue("@ed", obj.EndDate);

                cmd.Parameters.AddWithValue("@dur", obj.Duration);

                con.Open();

                int row = cmd.ExecuteNonQuery();

                con.Close();

                if (row > 0)

                {

                    return row;

                }

                else

                {

                    return 0;

                }

​

            }

​

        }

​

        public int DeleteProject(string strProjectID)

        {

            //throw new NotImplementedException();

            if (strProjectID == null || string.IsNullOrEmpty(strProjectID))

            {

                return -1;

            }

            else

            {

                SqlConnection con = new SqlConnection(ConnectionString);

                SqlCommand cmd = new SqlCommand("Delete from Projects where ProjectID=@pid", con);

                cmd.Parameters.AddWithValue("@pid", strProjectID);

                con.Open();

                int row = cmd.ExecuteNonQuery();

                con.Close();

                if (row > 0)

                {

                    return row;

                }

                else

                {

                    return 0;

                }

​

            }

        }

    }

}

​