public int VoidTransaction(VoidTranCreate VoidTransactionEntity) { LockHandler Lock = new LockHandler(); int SPResult = Lock.InsertLockRecord(0, Dns.GetHostName(), "VOID", "TreasuryID", VoidTransactionEntity.TreasuryID.ToString()); int ReturnValue = -1; switch (SPResult) { case 0: ReturnValue = voidTransaction.VoidCreate(VoidTransactionEntity); break; case 1: ReturnValue = -2; //LockExists return(ReturnValue); case 2: ReturnValue = -3; //LockError return(ReturnValue); default: ReturnValue = -4; //DatabaseError return(ReturnValue); } Lock.DeleteLockRecord(0, Dns.GetHostName(), "VOID", "TreasuryID", VoidTransactionEntity.TreasuryID.ToString()); return(ReturnValue); }
//<summary> //Void the treasury transactions. //</summary> //<returns>success or failure</returns> public int VoidTreasuryNegativeTrans(VoidTranCreate NegativeTransaction) { int?OutVal = 0; int result; try { result = linqDB.VoidCreate(int.Parse(NegativeTransaction.TreasuryID), NegativeTransaction.Date, int.Parse(NegativeTransaction.UserNo), ref OutVal); return(OutVal.Value); } catch (Exception Ex) { ExceptionManager.Publish(Ex); return(-99); } }
private void btnVoid_Click(object sender, RoutedEventArgs e) { IVoidTransaction objCashDeskOperator = VoidTransactionBusinessObject.CreateInstance(); if (lvUnprocessedHandpays.Items.Count == 0) { MessageBox.showBox("No handpay entry exists to make it Void", BMC_Icon.Information); return; } else if (lvUnprocessedHandpays.SelectedIndex != -1) { System.Windows.Forms.DialogResult dr = System.Windows.Forms.MessageBox.Show("Are you sure you want to void this handpay?", "Cash Desk Operator", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question); if (dr.ToString() == "Yes") { SaveDetails_EventsFromConnexus(true); VoidTranCreate objVoidTreasury = new VoidTranCreate(); objVoidTreasury.UserNo = BMC.Common.clsSecurity.UserID.ToString(); objVoidTreasury.Time = DateTime.Now.ToString("HH:mm:ss"); objVoidTreasury.Date = DateTime.Now.Date.ToString("dd MMM yyyy"); objVoidTreasury.TreasuryID = iTreasuryID.ToString(); int iResult = objCashDeskOperator.VoidTransaction(objVoidTreasury); if (iResult == -1) { MessageBox.showBox("This Handpay entry has already been voided!", BMC_Icon.Information); } else if (iResult == 0) { MessageBox.showBox("The Handpay entry voided successfully ", BMC_Icon.Information); } else { MessageBox.showBox("Error occured while voiding Handpay entry", BMC_Icon.Information); return; } } } FillHandpays(); }
public int VoidTreasuryNegGen(VoidTranCreate VoidTranCreate) { //DataBaseServiceHandler.AddParameter<DateTime>("dDate", System.Data.DbType.DateTime, VoidTranCreate.Date), //DataBaseServiceHandler.AddParameter<string>("dTime", System.Data.DbType.String, ""), SqlParameter outputValue = DataBaseServiceHandler.AddParameter <int>("OutVal", System.Data.DbType.Int32, 0, System.Data.ParameterDirection.Output); try { //DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString; DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_USP_CREATEVOIDTREASURY, DataBaseServiceHandler.AddParameter <string>("TreasuryNo", System.Data.DbType.String, VoidTranCreate.TreasuryID), DataBaseServiceHandler.AddParameter <DateTime>("VoidedDate", System.Data.DbType.DateTime, VoidTranCreate.Date), DataBaseServiceHandler.AddParameter <string>("UserNo", System.Data.DbType.String, VoidTranCreate.UserNo), outputValue); return(int.Parse(outputValue.Value.ToString())); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } return(99); }
public int VoidTransaction(VoidTranCreate VoidTransactionEntity) { return(handPay.VoidTreasuryNegativeTrans(VoidTransactionEntity)); }
public int VoidCreate(VoidTranCreate VoidTransactionEntiy) { return(voidTransactionDataAccess.VoidTreasuryNegGen(VoidTransactionEntiy)); }
private void Button_Click(object sender, RoutedEventArgs e) { if (lstVoidTransaction.Items.Count <= 0) { MessageBox.ShowBox("MessageID115", BMC_Icon.Information); return; } if (lstVoidTransaction.SelectedItems.Count == 0) { return; } int returnValue; string strType; string amount; var objCDOEntity = new VoidTranCreate(); var objCDO = VoidTransactionBusinessObject.CreateInstance(); try { if ((((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem)).Treasury_Reason != "NEGATIVE TREASURY ENTRY") { if (MessageBox.ShowBox("MessageID109", BMC_Icon.Question, BMC_Button.YesNo) == System.Windows.Forms.DialogResult.Yes) { objCDOEntity.TreasuryID = ((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).Treasury_No.ToString(); objCDOEntity.UserNo = SecurityHelper.CurrentUser.User_No.ToString(); objCDOEntity.Date = DateTime.Now; //clsSecurity.UserNo.ToString(); //SecurityHelper.CurrentUser.User_No.ToString(); // ((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).User_No.ToString(); strType = ((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).Type; amount = BMC.Business.CashDeskOperator.CommonUtilities.GetCurrency(((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).Amount.Value); returnValue = objCDO.VoidTransaction(objCDOEntity); if (returnValue > 0) { MessageBox.ShowBox("MessageID125", BMC_Icon.Information); AuditViewerBusiness.InsertAuditData(new Audit_History { AuditModuleName = ModuleName.Void, Audit_Screen_Name = "Void|VoidTransaction", Audit_Desc = strType + " Date: " + ((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).FormattedDate + " Amount: " + amount, AuditOperationType = OperationType.ADD, Audit_Field = "Treasury Number", Audit_New_Vl = ((GetVoidTransactionListResult)lstVoidTransaction.SelectedItem).Treasury_No.ToString() }); (oCommonUtilities.CreateInstance()).PrintCommonReceipt(true, strType, returnValue.ToString()); FillData(); _common.CustomPaging(Helper_classes.Common.PagingMode.Next, _dtTabVoid, _pagingNoOfRecPerPage, lstVoidTransaction, true); _common.DisplayPagingInfo(_dtTabVoid, _common, _pagingNoOfRecPerPage); } else { switch (returnValue) { case -2: //LockExists case -3: //LockError { MessageBox.ShowBox("MessageID375", BMC_Icon.Error); AuditViewerBusiness.InsertAuditData(new Audit.Transport.Audit_History { AuditModuleName = ModuleName.Void, Audit_Screen_Name = "Void|VoidTransaction", Audit_Desc = "Locked by another user for processing.", AuditOperationType = OperationType.ADD }); break; } case -4: //DatabaseError { MessageBox.ShowBox("MessageID374", BMC_Icon.Error); AuditViewerBusiness.InsertAuditData(new Audit.Transport.Audit_History { AuditModuleName = ModuleName.Void, Audit_Screen_Name = "Void|VoidTransaction", Audit_Desc = "Unable to Access the database.", AuditOperationType = OperationType.ADD }); break; } case -5: //Cashdesk transaction included in drop { MessageBox.ShowBox("MessageID546", BMC_Icon.Information); AuditViewerBusiness.InsertAuditData(new Audit_History { AuditModuleName = ModuleName.Void, Audit_Screen_Name = "Void|VoidTransaction", Audit_Desc = "Transaction already included in drop.", AuditOperationType = OperationType.ADD }); FillData(); break; } default: { MessageBox.ShowBox("MessageID126", BMC_Icon.Information); AuditViewerBusiness.InsertAuditData(new Audit_History { AuditModuleName = ModuleName.Void, Audit_Screen_Name = "Void|VoidTransaction", Audit_Desc = "Error occured while voiding this transaction.", AuditOperationType = OperationType.ADD }); break; } } } //else if (returnValue == -1) //{ // MessageBox.ShowBox("MessageID126", BMC_Icon.Information); // AuditViewerBusiness.InsertAuditData(new Audit_History // { // AuditModuleName = ModuleName.Void, // Audit_Screen_Name = "Void|VoidTransaction", // Audit_Desc = "Error occured while voiding this transaction.", // AuditOperationType = OperationType.ADD // }); //} //else // MessageBox.ShowBox("MessageID127", BMC_Icon.Error); } else { return; } } else { MessageBox.ShowBox("MessageID128", BMC_Icon.Information); } } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }