public int AddEditPart(PurchaseOrderPart_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var dt_POPart = new DataTable();
if (Model.POPart_TableTypeList != null && Model.POPart_TableTypeList.Count > 0)
{
dt_POPart = ConvertToDatatable(Model.POPart_TableTypeList);
}
else
{
dt_POPart = ConvertToDatatable(new List <POPart_TableType_VM>());
}
var par = new SqlParameter[] {
new SqlParameter("@p_POID", GetDBNULL(Model.POID)),
new SqlParameter("@p_POPart", dt_POPart)
{
TypeName = "POPart_TableType"
},
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
result = db.ExecuteNonQueryRollBack("AddPurchaseOrderPart", par);
}
}
catch (Exception ex)
{
logger.Error("PurchaseOrderRepository_AddPart Error: ", ex);
throw;
}
return(result);
}
public JsonResult AddUpdateDataPart(PurchaseOrderPart_VM Model)
{
if (ModelState.IsValid)
{
try
{
GetUserInfo(Model);
if (Model.POID > 0)
{
var data = _PurchaseOrderRepo.AddEditPart(Model);
return(GetAddEditDeleteResponse(data, "Update"));
}
}
catch (Exception ex)
{
logger.Error("PurchaseOrderController_AddUpdateData Error: ", ex);
return(GetAddEditErrorException(ex));
}
}
return(GetModelStateIsValidException(ViewData));
}
