public ResponseData AddByEntity(CapabilityViewModel data)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
tb_Capability model = new tb_Capability();
model.CapID = data.CapID;
model.CapYear = data.CapYear;
model.CapTID = data.CapTID;
model.CapGID = data.CapGID;
model.CapGTID = data.CapGTID;
model.CreateBy = UtilityService.User.UserID;
model.CreateDate = DateTime.Now;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.tb_Capability.Add(model);
db.SaveChanges();
}
catch (Exception)
{
}
return(result);
}
}
public ActionResult CapabilityHeader(int?id)
{
CapabilityViewModel model = new CapabilityViewModel();
if (id.HasValue)
{
model = new CapabilityRepository().GetByID((int)id);
}
ViewBag.CapabilityType = DropDownList.GetCapabilityType(model.CapTID);
ViewBag.CapabilityGroup = DropDownList.GetCapabilityGroup(model.CapGID);
ViewBag.CapabilityGroupType = DropDownList.GetCapabilityGroupType(model.CapGID, model.CapGTID);
return(PartialView("_Capability", model));
}
public JsonResult SaveCapability(CapabilityViewModel model)
{
ResponseData result = new Models.ResponseData();
if (model.CapID != 0)
{
result = new CapabilityRepository().UpdateByEntity(model);
}
else
{
result = new CapabilityRepository().AddByEntity(model);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ResponseData UpdateByEntity(CapabilityViewModel newdata)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
var data = db.tb_Capability.Single(x => x.CapID == newdata.CapID);
data.CapYear = newdata.CapYear;
data.CapTID = newdata.CapTID;
data.CapGID = newdata.CapGID;
data.CapGTID = newdata.CapGTID;
data.ModifyBy = UtilityService.User.UserID;
data.ModifyDate = DateTime.Now;
db.SaveChanges();
}
catch (Exception)
{
}
return(result);
}
}