public List <AD_Projects> ListCompany(string filter, string value = null)
{
AD_ProjectsDL dl = new AD_ProjectsDL();
DataTable dt = dl.Get(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 c = new AD_Projects();
c.CompanyID = int.Parse(dt.Rows[i]["ClientId"].ToString());
c.Company = dt.Rows[i]["ClientName"].ToString();
lst.Add(c);
}
}
return(lst);
}
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);
}
public List <AD_Projects> ListStatus(string filter, string value = null)
{
AD_ProjectsDL dl = new AD_ProjectsDL();
DataTable dt = dl.GetScopeOrStatus(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.StatusID = int.Parse(dt.Rows[i]["DefinationId"].ToString());
p.Status = dt.Rows[i]["DefinationName"].ToString();
lst.Add(p);
}
}
return(lst);
}
//public List<SelectedList> SelectedList(string filter, string value = null, string Message = null)
//{
// SelectedList sl = new SelectedList();
// var rec = ToListMarket(filter, value).Select(m => new SelectedList { Text = m.DefinationName, Value = m.DefinationId.ToString() }).ToList();
// if (!string.IsNullOrEmpty(Message))
// {
// sl.Text = Message;
// sl.Value = "0";
// rec.Add(sl);
// rec = rec.OrderBy(m => m.Value).ToList();
// }
// return rec;
//}
//public List<AD_Projects> ToListMarket(string filter, string value = null)
//{
// AD_ProjectsDL dl = new AD_ProjectsDL();
// DataTable dt = dl.GetCitiesMarkeet(filter, value);
// List<AD_Projects> lst = dt.ToList<AD_Projects>();
// return lst;
//}
public List <AD_Projects> ListCitiesMarket(string filter, string value = null)
{
AD_ProjectsDL dl = new AD_ProjectsDL();
DataTable dt = dl.GetCitiesMarket(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.TypeValue = Convert.ToInt32(dt.Rows[i]["DefinationId"].ToString());
p.DefinationName = dt.Rows[i]["DefinationName"].ToString();
p.TypeId = int.Parse(dt.Rows[i]["DefinationTypeId"].ToString());
lst.Add(p);
}
}
return(lst);
}
