public ResponseData AddByEntity(CapabilityDetailViewModel data)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
tb_Capability_Detail model = new tb_Capability_Detail();
model.CapDID = data.CapDID;
model.CapDName = data.CapDName;
model.CapDDesc = data.CapDDesc;
model.CapID = data.CapID;
model.Score1 = data.Score1;
model.Score2 = data.Score2;
model.CreateBy = UtilityService.User.UserID;
model.CreateDate = DateTime.Now;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.tb_Capability_Detail.Add(model);
db.SaveChanges();
}
catch (Exception)
{
}
return(result);
}
}
public ResponseData SubmitByEntity(List <CapabilityDetailViewModel> newdata)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
foreach (var item in newdata)
{
if (item.CapDID != 0)
{
var data = db.tb_Capability_Detail.Single(x => x.CapDID == item.CapDID);
data.CapDID = item.CapDID;
data.CapDName = item.CapDName;
data.CapDDesc = item.CapDDesc;
data.CapID = item.CapID;
data.Score1 = item.Score1;
data.Score2 = item.Score2;
data.ModifyBy = UtilityService.User.UserID;
data.ModifyDate = DateTime.Now;
db.SaveChanges();
}
else
{
tb_Capability_Detail model = new tb_Capability_Detail();
model.CapDID = item.CapDID;
model.CapDName = item.CapDName;
model.CapDDesc = item.CapDDesc;
model.CapID = item.CapID;
model.Score1 = item.Score1;
model.Score2 = item.Score2;
model.CreateBy = UtilityService.User.UserID;
model.CreateDate = DateTime.Now;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.tb_Capability_Detail.Add(model);
db.SaveChanges();
}
}
}
catch (Exception)
{
}
return(result);
}
}
