Int64 ICMBillRequisitionItemMapDataAccess.Add(CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cMBillRequisitionItemMapEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cMBillRequisitionItemMapEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMBillRequisitionItemMap_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@BillRequisitionItemMapID", DbType.Int64, cMBillRequisitionItemMapEntity.BillRequisitionItemMapID); db.AddInParameter(cmd, "@BillID", DbType.Int64, cMBillRequisitionItemMapEntity.BillID); db.AddInParameter(cmd, "@RequisitionID", DbType.Int64, cMBillRequisitionItemMapEntity.RequisitionID); db.AddInParameter(cmd, "@RequisitionItemID", DbType.Int64, cMBillRequisitionItemMapEntity.RequisitionItemID); db.AddInParameter(cmd, "@RequisitionPrice", DbType.Decimal, cMBillRequisitionItemMapEntity.RequisitionPrice); db.AddInParameter(cmd, "@BillPrice", DbType.Decimal, cMBillRequisitionItemMapEntity.BillPrice); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private Int64 Update(CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMBillRequisitionItemMap_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@BillRequisitionItemMapID", DbType.Int64, cMBillRequisitionItemMapEntity.BillRequisitionItemMapID); Database.AddInParameter(cmd, "@BillID", DbType.Int64, cMBillRequisitionItemMapEntity.BillID); Database.AddInParameter(cmd, "@RequisitionID", DbType.Int64, cMBillRequisitionItemMapEntity.RequisitionID); Database.AddInParameter(cmd, "@RequisitionItemID", DbType.Int64, cMBillRequisitionItemMapEntity.RequisitionItemID); Database.AddInParameter(cmd, "@RequisitionPrice", DbType.Decimal, cMBillRequisitionItemMapEntity.RequisitionPrice); Database.AddInParameter(cmd, "@BillPrice", DbType.Decimal, cMBillRequisitionItemMapEntity.BillPrice); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CMBillRequisitionItemMapEntity already exists. Please specify another CMBillRequisitionItemMapEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CMBillRequisitionItemMapEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CMBillRequisitionItemMapEntity already exists. Please specify another CMBillRequisitionItemMapEntity."); } } } } return(returnCode); }
Int64 ICMBillRequisitionItemMapFacade.Delete(CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMBillRequisitionItemMapDataAccess().Delete(cMBillRequisitionItemMapEntity, filterExpression, option, reqTran)); }
Int64 ICMBillRequisitionItemMapFacade.Add(CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMBillRequisitionItemMapDataAccess().Add(cMBillRequisitionItemMapEntity, option, reqTran)); }
private void SaveCMBillEntity() { if (ValidationInput()) { if (IsValid) { try { CMBillEntity cMBillEntity = BuildCMBillEntity(); Int64 result = -1; if (cMBillEntity.IsNew) { result = FCCCMBill.GetFacadeCreate().Add(cMBillEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, cMBillEntity.BillID.ToString(), SQLMatchType.Equal); result = FCCCMBill.GetFacadeCreate().Update(cMBillEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { #region Update WO Final Bill Status if (cMBillEntity.BillStatusID == MasterDataConstants.MDBillStatus.FINAL_BILL) { PRMWorkOrderEntity prmWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(cMBillEntity.WorkOrderID); prmWorkOrderEntity.IsFinalBilled = true; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, prmWorkOrderEntity.WorkOrderID.ToString(), SQLMatchType.Equal); FCCPRMWorkOrder.GetFacadeCreate().Update(prmWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); } #endregion #region Bill Requisition Item Map CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity = new CMBillRequisitionItemMapEntity(); try { IList <ListViewDataItem> list = lvREQRequisitionItem.Items; if (list != null && list.Count > 0) { foreach (ListViewDataItem lvdi in list) { Decimal billPriceLV; TextBox txtBillPriceLV = (TextBox)lvdi.FindControl("txtBillPriceLV"); Decimal.TryParse(txtBillPriceLV.Text.Trim(), out billPriceLV); if (billPriceLV > 0) { Label lblRequisitionIDLV = (Label)lvdi.FindControl("lblRequisitionIDLV"); Label lblRequisitionPriceLV = (Label)lvdi.FindControl("lblRequisitionPriceLV"); Label lblRequisitionItemIDLV = (Label)lvdi.FindControl("lblRequisitionItemIDLV"); cMBillRequisitionItemMapEntity.BillID = result; cMBillRequisitionItemMapEntity.RequisitionID = Int64.Parse(lblRequisitionIDLV.Text); cMBillRequisitionItemMapEntity.RequisitionItemID = Int64.Parse(lblRequisitionItemIDLV.Text); cMBillRequisitionItemMapEntity.RequisitionPrice = Decimal.Parse(lblRequisitionPriceLV.Text.Trim()); if (billPriceLV > 0) { cMBillRequisitionItemMapEntity.BillPrice = Decimal.Parse(txtBillPriceLV.Text.Trim()); } FCCCMBillRequisitionItemMap.GetFacadeCreate().Add(cMBillRequisitionItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); //else //{ // cMBillRequisitionItemMapEntity.BillPrice = null; //} } } } } catch (Exception ex) { } #endregion CMBillEntity _cMBillEntity = CurrentCMBillEntity; _BillID = 0; _CMBillEntity = new CMBillEntity(); PrepareInitialView(); BindCMBillList(); if (cMBillEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Bill Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Bill Information has been updated successfully.", false); } String NavUrl = UrlHelper.BuildSecureUrl("~/CM/CMBillUploadInfo.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, result.ToString()).ToString(); Response.Redirect(NavUrl); } else { if (cMBillEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Bill Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Bill Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }