public int Delete(Invoice_VM Model) { int result = 0; try { using (var db = new DBConnection()) { var par = new SqlParameter[] { new SqlParameter("@p_InvoiceID", GetDBNULL(Model.InvoiceID, true)), 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("DeleteInvoice", par); } } catch (Exception ex) { logger.Error("InvoiceRepository_Delete Error: ", ex); throw; } return(result); }
public int Add(Invoice_VM Model) { int result = 0; try { using (var db = new DBConnection()) { var output = new SqlParameter("@p_InvoiceID", 0) { Direction = ParameterDirection.Output }; var par = new SqlParameter[] { new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID, true)), new SqlParameter("@p_OrderDate", GetDBNULL(Model.OrderDate)), new SqlParameter("@p_ExpectedDeliveryDate", GetDBNULL(Model.ExpectedDeliveryDate)), new SqlParameter("@p_InvoiceName", GetDBNULL(Model.InvoiceName, true)), new SqlParameter("@p_Frame", GetDBNULL(Model.Frame, true)), new SqlParameter("@p_Lens", GetDBNULL(Model.Lens, true)), new SqlParameter("@p_FrameAmount", GetDBNULL(Model.FrameAmount, true)), new SqlParameter("@p_LensAmount", GetDBNULL(Model.LensAmount, true)), new SqlParameter("@p_RefractionBy", GetDBNULL(Model.RefractionBy, true)), new SqlParameter("@p_Remarks", GetDBNULLString(Model.Remarks)), new SqlParameter("@p_RESPH", GetDBNULLString(Model.RESPH)), new SqlParameter("@p_RECYL", GetDBNULLString(Model.RECYL)), new SqlParameter("@p_REAXIS", GetDBNULLString(Model.REAXIS)), new SqlParameter("@p_REVA", GetDBNULLString(Model.REVA)), new SqlParameter("@p_READD", GetDBNULLString(Model.READD)), new SqlParameter("@p_LESPH", GetDBNULLString(Model.LESPH)), new SqlParameter("@p_LECYL", GetDBNULLString(Model.LECYL)), new SqlParameter("@p_LEAXIS", GetDBNULLString(Model.LEAXIS)), new SqlParameter("@p_LEVA", GetDBNULLString(Model.LEVA)), new SqlParameter("@p_LEADD", GetDBNULLString(Model.LEADD)), new SqlParameter("@p_AdvanceAmount", GetDBNULL(Model.AdvanceAmount)), 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)), output }; result = db.ExecuteNonQueryRollBack("AddInvoice", par); result = Convert.ToInt32(output.Value); } } catch (Exception ex) { logger.Error("InvoiceRepository_Add: ", ex); throw; } return(result); }
public List <Invoice_VM> GetData(Invoice_VM Model) { List <Invoice_VM> query = new List <Invoice_VM>(); try { using (var db = new DBConnection()) { var ds = new DataSet(); var par = new SqlParameter[] { new SqlParameter("@p_InvoiceID", GetDBNULL(Model.InvoiceID, true)), new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID, true)), new SqlParameter("@p_OrderDate", GetDBNULL(Model.OrderDate)), new SqlParameter("@p_ExpectedDeliveryDate", GetDBNULL(Model.ExpectedDeliveryDate)), new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID, true)), new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID, true)), new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID, true)), new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)) }; ds = db.ExecuteDataSet("GetInvoice", par); query = ConvertToList <Invoice_VM>(ds.Tables[0]); } } catch (Exception ex) { logger.Error("InvoiceRepository_GetData Error: ", ex); throw; } return(query); }
public JsonResult GetData(Invoice_VM Model) { try { List <Invoice_VM> vm = _InvoiceRepo.GetData(Model); return(GetDataResponse(vm)); } catch (Exception ex) { return(GetDataResponseException(ex)); } }
public JsonResult Delete(Invoice_VM Model) { if (CheckAccess(Model.CurrentScreenID, "Invoice")) { try { GetUserInfo(Model); if (Model.InvoiceID > 0 && Model.InvoiceID != null) { var data = _InvoiceRepo.Delete(Model); return(GetAddEditDeleteResponse(data, "Delete")); } } catch (Exception ex) { logger.Error("InvoiceController_Delete Error: ", ex); return(GetAddEditErrorException(ex)); } } return(GetModelStateIsValidException(ViewData)); }