public bool Update(VM.ResourceInfoItem model) { var data = Ctx.tbl_Common_Resource.First(r => r.ResourceKey == model.ResourceKey_Old); //data.ResourceKey = model.ResourceKey; data.ResourceValueENUS = model.ResourceValueENUS; data.ResourceValueZHCN = model.ResourceValueZHCN; data.ResourceValueZHHK = model.ResourceValueZHHK; //data.IsDeleted = model.IsDeleted; data.UpdatedBy = model.UpdatedBy; data.UpdatedDate = DateTime.Now; var result = Ctx.SaveChanges(); if (result > 0) { ResourceHelper.UpdateCommonResourceList(); return(true); } return(false); }
public bool Create(VM.ResourceInfoItem model) { var temp = (from ri in Ctx.tbl_Common_Resource.Where(r => r.ResourceKey == model.ResourceKey) select ri).ToList(); if (temp.Count() == 0) { MD.tbl_Common_Resource data = new MD.tbl_Common_Resource(); data.ResourceKey = model.ResourceKey; data.ResourceValueZHCN = model.ResourceValueZHCN; data.ResourceValueZHHK = model.ResourceValueZHHK; data.ResourceValueENUS = model.ResourceValueENUS; data.IsDeleted = null; data.CreatedBy = model.CreatedBy; data.CreatedDate = DateTime.Now; Ctx.tbl_Common_Resource.Add(data); Ctx.SaveChanges(); ResourceHelper.UpdateCommonResourceList(); return(true); } else if (temp.First().IsDeleted == true) { temp.First().ResourceValueENUS = model.ResourceValueENUS; temp.First().ResourceValueZHCN = model.ResourceValueZHCN; temp.First().ResourceValueZHHK = model.ResourceValueZHHK; temp.First().IsDeleted = null; temp.First().CreatedBy = model.CreatedBy; temp.First().CreatedDate = DateTime.Now; Ctx.SaveChanges(); ResourceHelper.UpdateCommonResourceList(); return(true); } else { return(false); } }