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