public static List <ApplicationSettingsItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <ApplicationSettingsItem>(); items = (from i in ctx.ApplicationSettingsItems select i).ToList(); return(items); }
public static ServiceTypeItem GetByCode(entitiesEvolveCentral ctx, string code) { var item = new ServiceTypeItem(); item = (from i in ctx.ServiceTypeItems where i.Code == code orderby i.Name ascending select i).FirstOrDefault(); return(item); }
public static ApplicationSettingsItem GetByCode(entitiesEvolveCentral ctx, string code) { var item = new ApplicationSettingsItem(); item = (from i in ctx.ApplicationSettingsItems where i.Code == code select i).FirstOrDefault(); return(item); }
public static List <ServiceCrmEvolutionDetailItem> GetByService(entitiesEvolveCentral ctx, int id) { var items = new List <ServiceCrmEvolutionDetailItem>(); items = (from i in ctx.ServiceCrmEvolutionDetailItems where i.ServiceCrmEvolutionId == id orderby i.Sequence ascending select i).ToList(); return(items); }
public static SyncLogCrmEvolutionDetailItem Get(entitiesEvolveCentral ctx, int id) { var item = new SyncLogCrmEvolutionDetailItem(); item = (from i in ctx.SyncLogCrmEvolutionDetailItems where i.Id == id orderby i.CreateDate descending select i).FirstOrDefault(); return(item); }
public static ServiceCrmEvolutionItem GetByCode(entitiesEvolveCentral ctx, string servicecode) { var item = new ServiceCrmEvolutionItem(); item = (from i in ctx.ServiceCrmEvolutionItems where i.Code == servicecode where i.IsActive == true select i).FirstOrDefault(); return(item); }
public static bool DeleteByService(entitiesEvolveCentral ctx, int id, bool deleteUnique) { var item = new ServiceCrmEvolutionDetailItem(); try { DAL.ServiceCrmEvolutionItem sitem = DAL.ServiceCrmEvolution.Get(ctx, id); DAL.ServiceTemplateCrmEvolutionItem stitem = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(sitem.ServiceTemplateCrmEvolutionId)); List <DAL.ServiceCrmEvolutionDetailItem> detailitems = DAL.ServiceCrmEvolutionDetail.GetByService(ctx, id); for (int i = 0; i < detailitems.Count; i++) { int detailid = detailitems[i].Id; DAL.ServiceCrmEvolutionDetailItem sditem = ctx.ServiceCrmEvolutionDetailItems.Find(detailid); if (deleteUnique) { ctx.ServiceCrmEvolutionDetailItems.Remove(sditem); } else { if (!Convert.ToBoolean(sditem.IsUnique)) { ctx.ServiceCrmEvolutionDetailItems.Remove(sditem); } } } ctx.SaveChanges(); } catch (Exception ex) { return(false); } return(true); }
public static bool IsCodeAvailable(entitiesEvolveCentral ctx, string value, int?id) { bool retval = true; try { DAL.ServiceCrmEvolutionItem item = (from i in ctx.ServiceCrmEvolutionItems where i.Code.ToUpper() == value.ToUpper() select i).FirstOrDefault(); if (item != null) { if (id == null) { retval = false; } if (id != null && item.Id != id) { retval = false; } } } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceCrmEvolution.IsCodeAvailable(entitiesEvolveCentral ctx, string value, int? id)", ex.Message); retval = false; } return(retval);; }
public static List <ServiceCrmEvolutionItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <ServiceCrmEvolutionItem>(); items = (from i in ctx.ServiceCrmEvolutionItems orderby i.Name ascending select i).ToList(); return(items); }
//public static ServiceItem GetByCode(entitiesEvolveCentral ctx, string clientcode,string servicetypecode) //{ // var item = new ServiceItem(); // item = (from i in ctx.ServiceItems where i.ClientItem.Code == clientcode && i.ServiceTypeItem.Code == servicetypecode orderby i.Name ascending select i).FirstOrDefault(); // return item; //} public static ServiceCrmEvolutionItem Get(entitiesEvolveCentral ctx, int id) { var item = new ServiceCrmEvolutionItem(); item = (from i in ctx.ServiceCrmEvolutionItems where i.Id == id orderby i.Name ascending select i).FirstOrDefault(); return(item); }
public static List <SyncLogCrmEvolutionDetailItem> GetByLog(entitiesEvolveCentral ctx, int id) { var items = new List <SyncLogCrmEvolutionDetailItem>(); items = (from i in ctx.SyncLogCrmEvolutionDetailItems where i.SyncLogCrmEvolutionId == id orderby i.CreateDate descending select i).ToList(); return(items); }
public static List <SyncLogCrmEvolutionItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <SyncLogCrmEvolutionItem>(); items = (from i in ctx.SyncLogCrmEvolutionItems orderby i.CreateDate descending select i).ToList(); return(items); }
public static List <ServiceTemplateCrmEvolutionDetailItem> GetByService(entitiesEvolveCentral ctx, int id) { var items = new List <ServiceTemplateCrmEvolutionDetailItem>(); try { items = (from i in ctx.ServiceTemplateCrmEvolutionDetailItems where i.ServiceTemplateCrmEvolutionId == id orderby i.Sequence ascending select i).ToList(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolutionDetail.GetByService(entitiesEvolveCentral ctx, int id)", ex.Message); items = null; } return(items); }
public static ServiceTemplateCrmEvolutionItem Get(entitiesEvolveCentral ctx, int id) { var item = new ServiceTemplateCrmEvolutionItem(); try { item = (from i in ctx.ServiceTemplateCrmEvolutionItems where i.Id == id orderby i.Name ascending select i).FirstOrDefault(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolution.Get(entitiesEvolveCentral ctx, int id)", ex.Message); item = null; } return(item); }
public static List <ApplicationLogItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <ApplicationLogItem>(); try { items = (from i in ctx.ApplicationLogItems orderby i.CreatedOn descending select i).ToList(); } catch (Exception ex) { items = null; } return(items); }
public static ApplicationLogItem Get(entitiesEvolveCentral ctx, int itemid) { var item = new ApplicationLogItem(); try { item = (from i in ctx.ApplicationLogItems where i.Id == itemid select i).FirstOrDefault(); } catch (Exception ex) { item = null; } return(item); }
public static ServiceTemplateCrmEvolutionDetailItem GetByCode(entitiesEvolveCentral ctx, string code, int servicetemplateid) { var item = new ServiceTemplateCrmEvolutionDetailItem(); try { item = (from i in ctx.ServiceTemplateCrmEvolutionDetailItems where i.Code == code && i.ServiceTemplateCrmEvolutionId == servicetemplateid orderby i.Name ascending select i).FirstOrDefault(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolutionDetail.GetByCode(entitiesEvolveCentral ctx, string code, int servicetemplateid)", ex.Message); item = null; } return(item); }
public static List <AdministratorAccountItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <AdministratorAccountItem>(); try { items = (from i in ctx.AdministratorAccountItems orderby i.FirstName ascending, i.LastName ascending select i).ToList(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.AdministratorAccount.GetAll(entitiesEvolveCentral ctx)", ex.Message); items = null; } return(items); }
public static AdministratorAccountItem Get(entitiesEvolveCentral ctx, int itemid) { var item = new AdministratorAccountItem(); try { item = (from i in ctx.AdministratorAccountItems where i.Id == itemid select i).FirstOrDefault(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.AdministratorAccount.Get(entitiesEvolveCentral ctx, int itemid)", ex.Message); item = null; } return(item); }
public static AdministratorAccountItem Login(entitiesEvolveCentral ctx, string email, string password) { var item = new AdministratorAccountItem(); try { item = (from i in ctx.AdministratorAccountItems where i.Email == email && i.Password == password select i).FirstOrDefault(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.AdministratorAccount.Login(entitiesEvolveCentral ctx, string email,string password)", ex.Message); item = null; } return(item); }
public static List <AdministratorPermissionItem> GetSelectable(entitiesEvolveCentral ctx) { var items = new List <AdministratorPermissionItem>(); try { items = (from i in ctx.AdministratorPermissionItems where i.IsSelectable == true orderby i.Name ascending select i).ToList(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.GetSelectable(entitiesEvolveCentral ctx)", ex.Message); items = null; } return(items); }
public static bool Delete(entitiesEvolveCentral ctx, ApplicationLogItem item) { bool retval = true; try { ctx.ApplicationLogItems.Remove(item); ctx.SaveChanges(); } catch (Exception ex) { retval = false; } return(retval); }
public static List <ServiceTemplateCrmEvolutionItem> GetAll(entitiesEvolveCentral ctx) { var items = new List <ServiceTemplateCrmEvolutionItem>(); try { items = (from i in ctx.ServiceTemplateCrmEvolutionItems orderby i.Name ascending select i).ToList(); return(items); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolution.GetAll(entitiesEvolveCentral ctx)", ex.Message); items = null; } return(items); }
public static bool Delete(entitiesEvolveCentral ctx, ServiceTemplateCrmEvolutionDetailItem item) { bool retval = true; try { ctx.ServiceTemplateCrmEvolutionDetailItems.Remove(item); ctx.SaveChanges(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolution.Delete(entitiesEvolveCentral ctx, ServiceTemplateCrmEvolutionDetailItem item)", ex.Message); retval = false; } return(retval); }
public static bool RemoveAllPermissions(entitiesEvolveCentral ctx, AdministratorRoleItem item) { bool retval = true; try { item.AdministratorPermissionItems.Clear(); ctx.SaveChanges(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.RemoveAllPermissions(entitiesEvolveCentral ctx, AdministratorRoleItem item)", ex.Message); retval = false; } return(retval); }
public static bool Delete(entitiesEvolveCentral ctx, AdministratorAccountItem item) { bool retval = true; try { ctx.AdministratorAccountItems.Remove(item); ctx.SaveChanges(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.AdministratorAccount.Delete(entitiesEvolveCentral ctx, AdministratorAccountItem item)", ex.Message); retval = false; } return(retval); }
public static bool Save(entitiesEvolveCentral ctx, ServiceCrmEvolutionItem item) { try { if (item.Id == 0) { ctx.ServiceCrmEvolutionItems.Add(item); } ctx.SaveChanges(); } catch (Exception ex) { return(false); } return(true); }
public static bool Revert(entitiesEvolveCentral ctx, int id) { var item = new ServiceCrmEvolutionItem(); try { DAL.ServiceCrmEvolutionItem sitem = Get(ctx, id); DAL.ServiceTemplateCrmEvolutionItem stitem = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(sitem.ServiceTemplateCrmEvolutionId)); DAL.ServiceCrmEvolutionDetail.DeleteByService(ctx, id, false); DateTime cdate = DateTime.Now; foreach (DAL.ServiceTemplateCrmEvolutionDetailItem i in stitem.ServiceTemplateCrmEvolutionDetailItems) { DAL.ServiceCrmEvolutionDetailItem newitem = new DAL.ServiceCrmEvolutionDetailItem(); newitem.IsActive = i.IsActive; newitem.Code = i.Code; newitem.Command = i.Command; newitem.IsUnique = false; newitem.CommandType = i.CommandType; newitem.Description = i.Description; newitem.DestinationTable = i.DestinationTable; newitem.Name = i.Name; newitem.Sequence = i.Sequence; newitem.ServiceCrmEvolutionId = sitem.Id; newitem.SourceTable = i.SourceTable; if (DAL.ServiceCrmEvolutionDetail.GetByServiceAndCode(ctx, Convert.ToInt32(newitem.ServiceCrmEvolutionId), newitem.Code).Count == 0) { DAL.ServiceCrmEvolutionDetail.Save(ctx, newitem); } } } catch (Exception ex) { return(false); } return(true); }
public static bool Save(entitiesEvolveCentral ctx, ServiceTemplateCrmEvolutionDetailItem item) { try { if (item.Id == 0) { ctx.ServiceTemplateCrmEvolutionDetailItems.Add(item); } ctx.SaveChanges(); } catch (Exception ex) { ApplicationLog.Log(ctx, "DAL.ServiceTemplateCrmEvolutionDetail.Save(entitiesEvolveCentral ctx, ServiceTemplateCrmEvolutionDetailItem item)", ex.Message); return(false); } return(true); }
public static bool Revert(entitiesEvolveCentral ctx, int detailid) { try { //DAL.ServiceCrmEvolutionDetailItem detailitem = GetByID(ctx, detailid); //DAL.ServiceCrmEvolutionItem serviceitem = DAL.ServiceCrmEvolution.GetByID(ctx, Convert.ToInt32(detailitem.ServiceCrmEvolutionId)); //DAL.ServiceTemplateCrmEvolutionItem servicetemplateitem = DAL.ServiceTemplateCrmEvolution.GetByID(ctx, Convert.ToInt32(serviceitem.ServiceTemplateCrmEvolutionId)); //DAL.ServiceTemplateCrmEvolutionDetailItem servicetemplatedetailitem = DAL.ServiceTemplateCrmEvolutionDetail.GetByCode(ctx, detailitem.Code, servicetemplateitem.Id); //if(servicetemplatedetailitem != null) //{ //Delete(ctx, detailid); //DateTime cdate = DateTime.Now; //DAL.ServiceCrmEvolutionDetailItem newitem = new DAL.ServiceCrmEvolutionDetailItem(); // newitem.IsActive = servicetemplatedetailitem.IsActive; // newitem.Code = servicetemplatedetailitem.Code; // newitem.Command = servicetemplatedetailitem.Command; // newitem.IsUnique = false; // newitem.CommandType = servicetemplatedetailitem.CommandType; // newitem.Description = servicetemplatedetailitem.Description; // newitem.DestinationTable = servicetemplatedetailitem.DestinationTable; // newitem.Name = servicetemplatedetailitem.Name; // newitem.Sequence = servicetemplatedetailitem.Sequence; // newitem.ServiceCrmEvolutionId = serviceitem.Id; // newitem.SourceTable = servicetemplatedetailitem.SourceTable; // DAL.ServiceCrmEvolutionDetail.Save(ctx, newitem); //} } catch (Exception ex) { return(false); } return(true); }