/// <summary> /// /// </summary> /// <param name="clientid"></param> public Lookup(string clientid) { c = new ClientServer(clientid); ClientID = clientid; LookupID = ""; Name = ""; LookupItems = new List <LookupItem>(); dataLookup = new Data.Component.LookUp(c.GetServer().Connection()); }
/// <summary> /// /// </summary> /// <param name="clientid"></param> /// <param name="lookupid"></param> public Lookup(string clientid, string lookupid) { ClientID = clientid; c = new ClientServer(clientid); LookupID = lookupid; LookupItems = new List <LookupItem>(); dataLookup = new Data.Component.LookUp(c.GetServer().Connection()); Load(); }
public bool Save(string conn) { var dataLookup = new Data.Component.LookUp(conn); if (dataLookup.Save(this.ClientID, this.Label, this.ShortLabel, this.Description, this.ParentID, this.LookUpID, this.Order, this.IsActive, this.Value) != "") { return(true); } else { return(false); } }
/// <summary> /// /// </summary> /// <param name="clientid"></param> /// <returns></returns> public static List <Lookup> GetLookUps(string clientid, string lookupIds = "") { ClientServer c = new ClientServer(clientid); var dataLookup = new Data.Component.LookUp(c.GetServer().Connection()); DataTable dt = dataLookup.GetLookUpList(clientid, lookupIds); List <Lookup> lup = new List <Lookup>(); foreach (DataRow dr in dt.Rows) { Lookup l = new Lookup(clientid); l.Name = dr["Name"] == null ? "" : dr["Name"].ToString(); l.IsCore = DBNull.Value.Equals(dr["IsCore"]) == true ? false : Convert.ToBoolean(dr["IsCore"]); l.Description = DBNull.Value.Equals(dr["Description"]) == true ? "" : dr["Description"].ToString(); l.CreatedOn = DBNull.Value.Equals(dr["CreatedOn"]) == true ? DateTime.Now : Convert.ToDateTime(dr["LastUPD"]); l.LastUPD = DBNull.Value.Equals(dr["LastUPD"]) == true ? DateTime.Now : Convert.ToDateTime(dr["LastUPD"]); l.LookupID = dr["LookUpID"] == null? "": dr["LookUpID"].ToString(); // l.Value = DBNull.Value.Equals(dr["Value"]) == true ? "" : (string)(dr["Value"]); lup.Add(l); } return(lup); }
public bool ChangeOrder(string conn, int order) { var dataLookup = new Data.Component.LookUp(conn); return(dataLookup.UpdateOrder(this.ClientID, this.LookUpItemID, order)); }
public bool ChangeActive(string conn, bool isActive) { var dataLookup = new Data.Component.LookUp(conn); return(dataLookup.UpateActive(this.ClientID, this.LookUpItemID, isActive)); }
public bool Remove(string conn) { var dataLookup = new Data.Component.LookUp(conn); return(dataLookup.RemoveLookupItems(this.ClientID, this.LookUpItemID, this.LookUpID)); }