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); }