using System.Collections.Generic;
using System.Data.SqlClient;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ProjectManagement
const string ConnectionString = "Server=.;Initial Catalog=ProjectManagement;User ID=sa;Password=wipro@123";
public string AddProject(Project obj)
ProjectUtility pu = new ProjectUtility();
string id = pu.GenerateProjectID(obj.ProjectName);
int d = (obj.StartDate - obj.EndDate).Days;
string ap = "INSERT INTO PROJECTS VALUES ('" + obj.ProjectID + "','" + obj.ProjectName + "','" + obj.StartDate + "','" + obj.EndDate + "','" + obj.Duration + "')";
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(ap, con);
int i = cmd.ExecuteNonQuery();
public Project GetProjctByID(string strProjectID)
if (strProjectID == null || string.IsNullOrEmpty(strProjectID))
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("Select * from Projects where ProjectID=@PID", con);
cmd.Parameters.AddWithValue("@PID", strProjectID);
SqlDataReader dr = cmd.ExecuteReader();
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());
public int UpdateProject(Project obj)
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);
int row = cmd.ExecuteNonQuery();
public int DeleteProject(string strProjectID)
if (strProjectID == null || string.IsNullOrEmpty(strProjectID))
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("Delete from Projects where ProjectID=@pid", con);
cmd.Parameters.AddWithValue("@pid", strProjectID);
int row = cmd.ExecuteNonQuery();