public static bool IsNameAvailable(entitiesEvolveCentral ctx, string value, int?id) { bool retval = true; try { DAL.ServiceTemplateCrmEvolutionItem item = (from i in ctx.ServiceTemplateCrmEvolutionItems where i.Name.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.ServiceTemplateCrmEvolution.IsNameAvailable(entitiesEvolveCentral ctx, string value, int? id)", ex.Message); retval = false; } return(retval);; }
void DeleteItem(int itemid) { DAL.ServiceTemplateCrmEvolutionItem item = DAL.ServiceTemplateCrmEvolution.Get(ctx, itemid); bool succeded = DAL.ServiceTemplateCrmEvolution.Delete(ctx, item); rgvData.Rebind(); }
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); }
void LoadData() { string id = GetId(); DAL.ServiceTemplateCrmEvolutionItem item = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(id)); if (item != null) { txtId.Text = item.Id.ToString(); txtCode.Text = item.Code; txtName.Text = item.Name; txtDescription.Text = item.Description; txtServiceType.Text = item.ServiceTypeItem.Name; txtActive.Text = (item.IsActive) ? "Yes" : "No"; } }
void LoadData() { string id = (Request.QueryString["id"] != null && !string.IsNullOrEmpty(Request.QueryString["id"])) ? Request.QueryString["id"].ToString() : null; DAL.ServiceTemplateCrmEvolutionItem item = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(id)); if (item != null) { txtId.Text = item.Id.ToString(); txtCode.Text = item.Code; txtName.Text = item.Name; txtDescription.Text = item.Description; txtServiceType.Text = item.ServiceTypeItem.Name; chkActive.Checked = item.IsActive; } }
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); }
bool Save() { if (!IsValid()) { return(false); } DateTime currentdate = DateTime.Now; var item = new DAL.ServiceTemplateCrmEvolutionItem(); item.Code = txtCode.Text; item.Name = txtName.Text; item.Description = txtDescription.Text; item.ServiceTypeId = DAL.ServiceType.GetByCode(ctx, Helper.Constant.CODE_SERVICE_CRMEVOLUTION).Id; item.IsActive = chkActive.Checked; bool succeeded = DAL.ServiceTemplateCrmEvolution.Save(ctx, item); return(succeeded); }