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