public AD_Projects Single(string filter, string value = null)
{
try
{
DataTable dt = pDL.GetProjects(filter, value);
AD_Projects projects = new AD_Projects();
if (dt != null && dt.Rows.Count > 0)
{
int i = 0;
projects.ProjectID = int.Parse(dt.Rows[i]["ProjectID"].ToString());
projects.ProjectName = dt.Rows[i]["ProjectName"].ToString();
projects.ProjectScopeID = dt.Rows[i]["ProjectScopeID"].ToString();
projects.CompanyID = int.Parse(dt.Rows[i]["CompanyID"].ToString());
projects.Company = dt.Rows[i]["Company"].ToString();
projects.VendorID = int.Parse(dt.Rows[i]["VendorID"].ToString());
projects.Vendor = dt.Rows[i]["Vendor"].ToString();
projects.StartDate = Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString());
if (!String.IsNullOrEmpty((dt.Rows[i]["EndDate"].ToString())))
{
projects.EndDate = Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString());
}
//projects.EndDate = Convert.ToDateTime(String.IsNullOrEmpty(dt.Rows[i]["EndDate"].ToString()) ? "NULL" : dt.Rows[i]["EndDate"].ToString());
projects.StatusID = int.Parse(dt.Rows[i]["StatusID"].ToString());
projects.Status = dt.Rows[i]["Status"].ToString();
projects.Color = dt.Rows[i]["Color"].ToString();
projects.Description = dt.Rows[i]["Description"].ToString();
projects.IsActive = bool.Parse(dt.Rows[i]["IsActive"].ToString());
return(projects);
}
return(null);
}
catch (Exception)
{
return(null);
}
}
public List <AD_Projects> ListProject(string filter, string value = null)
{
AD_ProjectsDL dl = new AD_ProjectsDL();
DataTable dt = dl.GetProjects(filter, value);
List <AD_Projects> lst = new List <AD_Projects>();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AD_Projects p = new AD_Projects();
p.ProjectID = int.Parse(dt.Rows[i]["ProjectID"].ToString());
p.ProjectName = dt.Rows[i]["ProjectName"].ToString();
lst.Add(p);
}
}
return(lst);
}
