private void SaveAuditTrail(string strReference, string strAuditEntry, int employeeId) { // ACMS.Util.AuditTrail at = new ACMS.Util.AuditTrail(); // at.SaveAuditTrail(strReference,strAuditEntry,employeeId); ACMSLogic.AuditTrail.AuditTrail auditTrail = new ACMSLogic.AuditTrail.AuditTrail(); auditTrail.SaveAuditTrail(1, strReference, strAuditEntry, employeeId); }
private void Process_Btn_Click(object sender, System.EventArgs e) { //Update stock request status if (this.txtRemarks.Text == "") { ACMS.Utils.UI.ShowErrorMessage(this, "Please enter reason for rejection", "Error"); } else { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); stockRequest.RejectStockRequest(Convert.ToInt32(StockRequestNo), 2, this.txtRemarks.Text); ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(7, "Reject Stock Request Status No " + this.StockRequestNo, "Stock Request", this.employee.Id); // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // Hashtable htStockRequest = new Hashtable(); // htStockRequest.Add("Id",StockRequestNo); // // //int // htStockRequest.Add("nStatusID",2); // // htStockRequest.Add("strRemarks",this.txtRemarks.Text); // // srf.MakeUpdateStockRequest(htStockRequest); // // SaveAuditTrail("Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Updated", "Save"); this.DialogResult = DialogResult.OK; this.Close(); } }
private void SaveAuditTrail(int nAuditTypeId,string strReference,string strAuditEntry,int employeeId) { // ACMS.Util.AuditTrail at = new ACMS.Util.AuditTrail(); // at.SaveAuditTrail(strReference,strAuditEntry,employeeId); ACMSLogic.AuditTrail.AuditTrail auditTrail = new ACMSLogic.AuditTrail.AuditTrail(); auditTrail.SaveAuditTrail(nAuditTypeId,strReference,strAuditEntry,employeeId); }
private void btn_Save_Click(object sender, System.EventArgs e) { // simpleButton2_Click(sender,e); //if (btn_Save.Text=="Update") canSave=true; if(this.lkBranchTo.EditValue.ToString()=="Select Branch" |this.lkBranchTo.EditValue.ToString()=="" ) { ACMS.Utils.UI.ShowErrorMessage(this,"Please select valid Branch Code","Error"); } else { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); if(canSave) { int nStockRequestNo = 0; if(isEdit) { if(!stockRequest.EditStockRequest(trans,Convert.ToDateTime(this.dateEdit1.EditValue),this.lkBranchTo.EditValue.ToString(),this.employee.Id,DateTime.Today,Convert.ToInt32(StockRequestNo),this.txtRequestedBy.Text)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequest","Error"); return; } } else { try { nStockRequestNo = stockRequest.SaveStockRequest(trans,DateTime.Today,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Today,0,this.txtRequestedBy.Text); } catch(Exception ex) { UI.ShowErrorMessage(this,ex.Message,"Error"); } if(nStockRequestNo==0) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Insert StockRequest ","Error"); return; } } DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for(int i=0;i<this.gridView1.DataRowCount;i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = gridView1.GetRowCellValue(i, col3); if(cellValue1.ToString()=="" | cellValue2.ToString()=="") { ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error"); canSave=false; return; } else { if(isEdit) { if(!stockRequest.UpdateStockRequestEntries(trans,Convert.ToInt32(cellValue3.ToString()),Convert.ToInt32(cellValue2.ToString()),cellValue1.ToString(),this.lkBranchTo.EditValue.ToString())) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequestEntries","Error"); return; } } else { if(!stockRequest.SaveStockRequestEntries(trans,nStockRequestNo,cellValue1.ToString(),Convert.ToInt32(cellValue2.ToString()),this.lkBranchTo.EditValue.ToString())) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Insert StockRequestEntries","Error"); return; } } } } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); if(isEdit) { if(!audit.SaveAuditTrail(trans,7,"Update Stock Request No "+StockRequestNo,"Stock Request",this.employee.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Insert Audit","Error"); return; } UI.ShowErrorMessage(this,"Record Has Been Updated", "Save"); } else { if(!audit.SaveAuditTrail(trans,7,"Add New Stock Request No "+nStockRequestNo,"Stock Request",this.employee.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Insert Audit","Error"); return; } UI.ShowErrorMessage(this,"Record Has Been Saved", "Save"); } trans.Commit(); sqlcon.Close(); this.DialogResult = DialogResult.OK; this.Close(); canSave=true; } #region nHibernate Code // if(canSave) // { // //Variable Hashtable // Hashtable htStockRequest = new Hashtable(); // //htint // if(isEdit) // { // htStockRequest.Add("Id",this.StockRequestNo); // // htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString()); // } // else // { // //DateTime // htStockRequest.Add("dtDate",DateTime.Today); // //Add pending value // htStockRequest.Add("nStatusID",0);//this.lkStatus.Properties.ValueMember); // //DateTime // htStockRequest.Add("dtLastEditDate",DateTime.Today); // // //string // //htStockRequest.Add("Branch_strBranchCodeFrom",this.lkBranchTo.EditValue.ToString()); // htStockRequest.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // //htStockRequest.Add("Branch_strBranchCodeTo",this.terminalUser.Branch.Id); // htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString()); // // //int // htStockRequest.Add("Employee_nEmployeeID",this.employee.Id); // } // // //int // //htStockRequest.Add("IBT_nIBTNo",this.lkIBT.EditValue.ToString()); // // ArrayList stockRequestList = new ArrayList(); // // DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode"); // DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity"); // // for(int i=0;i<this.gridView1.DataRowCount;i++) // { // // object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode"); // object cellValue2 = gridView1.GetRowCellValue(i, col2); // if(cellValue1.ToString()=="" | cellValue2.ToString()=="") // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error"); // canSave=false; // return; // } // else // { // Hashtable htStockRequestEntries = new Hashtable(); // // htStockRequestEntries.Add("Product_strItemCode",cellValue1.ToString()); // //htStockRequestEntries.Add("Test_strProductCode",2); // //int // htStockRequestEntries.Add("nQuantity",cellValue2.ToString()); // // stockRequestList.Add(htStockRequestEntries); // } // } // // //Object In ArrayList // htStockRequest.Add("StockRequestEntries",stockRequestList); // // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // // if(canSave) // { // try // { // if(!isEdit) // { // srf.MakeSaveStockRequest(htStockRequest); // SaveAuditTrail("Add New Stock Request","Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Saved", "Save"); // } // else // { // srf.MakeUpdateStockRequest(htStockRequest); // SaveAuditTrail("Update Stock Request","Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Updated", "Updated"); // isEdit=false; // } // this.DialogResult = DialogResult.OK; // this.Close(); // canSave=true; // } // catch // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid Quantity","Error"); // } // } // // } // else // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter a valid quantity","Error"); // } #endregion } }
private void Process_Btn_Click(object sender, System.EventArgs e) { //Update stock request status if(this.txtRemarks.Text=="") { ACMS.Utils.UI.ShowErrorMessage(this,"Please enter reason for rejection","Error"); } else { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); stockRequest.RejectStockRequest(Convert.ToInt32(StockRequestNo),2,this.txtRemarks.Text); ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(7,"Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id); // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // Hashtable htStockRequest = new Hashtable(); // htStockRequest.Add("Id",StockRequestNo); // // //int // htStockRequest.Add("nStatusID",2); // // htStockRequest.Add("strRemarks",this.txtRemarks.Text); // // srf.MakeUpdateStockRequest(htStockRequest); // // SaveAuditTrail("Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Updated", "Save"); this.DialogResult = DialogResult.OK; this.Close(); } }
private void simpleButton1_Click(object sender, System.EventArgs e) { DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle); try { if (dr.Table.Rows.Count==0) { MessageBox.Show("Not allowed to Save Empty Entries","Warning"); return; } } catch (Exception ex) { return; } SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); if(this.lkBranchTo.EditValue.ToString()=="Select Branch" | this.lkBranchTo.EditValue.ToString()=="") { ACMS.Utils.UI.ShowErrorMessage(this,"Please select valid Branch Code","Error"); } else if(canSave) { ACMSLogic.InterBranchTransfer.InterBranchTransfer ibts = new ACMSLogic.InterBranchTransfer.InterBranchTransfer(); int nIBTNo = 0; //Hashtable htIBT = new Hashtable(); //htint if(isEdit) { if(!ibts.UpdateIBT(trans,DateTime.Now,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Now,this.txtRemarks.Text,this.nIBTNo)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update IBT","Error"); return; } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans,8,"Update IBT "+this.nIBTNo,"IBT",this.employee.Id); } else { nIBTNo = ibts.SaveIBT(trans,DateTime.Now,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Now,this.txtRemarks.Text); ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans,8,"Save IBT "+this.nIBTNo,"IBT",this.employee.Id); #region nHibernate Code // //DateTime // htIBT.Add("dtDate",DateTime.Now); // //int // //Status 0 - Pending Request // htIBT.Add("nStatusID",0); // //DateTime // htIBT.Add("dtLastEditDate",DateTime.Now); // //string // htIBT.Add("strRemarks",this.txtRemarks.Text); // // //string // htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // htIBT.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue); // // //int // htIBT.Add("Employee_nEmployeeID",this.employee.Id); #endregion } ArrayList ibtEntryList = new ArrayList(); ArrayList ibtProductTransferList = new ArrayList(); DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for(int i=0;i<this.gridView1.DataRowCount;i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = null; IBTProductTransfer ibt; int nEntryID = 0; string strProductCode = cellValue1.ToString(); int quantity = Convert.ToInt32(cellValue2.ToString()); if(isEdit) { cellValue3 = gridView1.GetRowCellValue(i, col3); nEntryID = Convert.ToInt32(cellValue3); ibt = new IBTProductTransfer(strProductCode,quantity,nEntryID); } else { ibt = new IBTProductTransfer(strProductCode,quantity); } if(ibtProductTransferList.Count==0) { ibtProductTransferList.Add(ibt); } else { bool duplicate=false; for(int _i=0;_i<ibtProductTransferList.Count;_i++) { IBTProductTransfer _ibt = ibtProductTransferList[_i] as IBTProductTransfer; if(strProductCode==_ibt.StrProductCode) { _ibt.Quantity=_ibt.Quantity+quantity; duplicate=true; } } if(!duplicate) ibtProductTransferList.Add(ibt); } } //Variable Hashtable //bool doubleCheckCanSave=true; if(isEdit) { foreach(IBTProductTransfer ibt in ibtProductTransferList) { if(!ibts.UpdateIBTEntries(trans,NIBTNo,ibt.StrProductCode,ibt.Quantity,this.terminalUser.Branch.Id,ibt.NEntryID)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update IBTEntries","Error"); return; } } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans,8,"Update IBTEntries "+NIBTNo,"IBTEntries",this.employee.Id); UI.ShowMessage(this,"Record Has Been Updated"); } else { if(nIBTNo!=0) { foreach(IBTProductTransfer ibt in ibtProductTransferList) { if(!ibts.SaveIBTEntries(trans,nIBTNo,ibt.StrProductCode,ibt.Quantity,this.terminalUser.Branch.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequestEntries","Error"); return; } #region nHibernate Code // Hashtable htIBTEntries = new Hashtable(); // // htIBTEntries.Add("strItemCode",ibt.StrProductCode); // //int // htIBTEntries.Add("nQuantity",ibt.Quantity); // // Rp.ProductRepository pr = new Rp.ProductRepository(); // // Acms.Core.Domain.ProductInventory pi = pr.CheckQuantityAvailable(ibt.StrProductCode,this.terminalUser.Branch.Id); // if(pi!=null) // { // // if(!pi.IsValidQuantityRequest(ibt.Quantity)) // { // doubleCheckCanSave=false; // //return; // } // } // // ibtEntryList.Add(htIBTEntries); #endregion } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans,8,"Save IBTEntries "+NIBTNo,"IBTEntries",this.employee.Id); } UI.ShowMessage(this,"Record Has Been Saved"); } } trans.Commit(); sqlcon.Close(); this.DialogResult = DialogResult.OK; }
private void btn_Save_Click(object sender, System.EventArgs e) { // simpleButton2_Click(sender,e); //if (btn_Save.Text=="Update") canSave = true; if (this.lkBranchTo.EditValue.ToString() == "Select Branch" | this.lkBranchTo.EditValue.ToString() == "") { ACMS.Utils.UI.ShowErrorMessage(this, "Please select valid Branch Code", "Error"); } else { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); if (canSave) { int nStockRequestNo = 0; if (isEdit) { if (!stockRequest.EditStockRequest(trans, Convert.ToDateTime(this.dateEdit1.EditValue), this.lkBranchTo.EditValue.ToString(), this.employee.Id, DateTime.Today, Convert.ToInt32(StockRequestNo), this.txtRequestedBy.Text)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequest", "Error"); return; } } else { try { nStockRequestNo = stockRequest.SaveStockRequest(trans, DateTime.Today, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Today, 0, this.txtRequestedBy.Text); } catch (Exception ex) { UI.ShowErrorMessage(this, ex.Message, "Error"); } if (nStockRequestNo == 0) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Insert StockRequest ", "Error"); return; } } DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for (int i = 0; i < this.gridView1.DataRowCount; i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = gridView1.GetRowCellValue(i, col3); if (cellValue1.ToString() == "" | cellValue2.ToString() == "") { ACMS.Utils.UI.ShowErrorMessage(this, "Please enter valid Product Code and valid quantity", "Error"); canSave = false; return; } else { if (isEdit) { if (!stockRequest.UpdateStockRequestEntries(trans, Convert.ToInt32(cellValue3.ToString()), Convert.ToInt32(cellValue2.ToString()), cellValue1.ToString(), this.lkBranchTo.EditValue.ToString())) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequestEntries", "Error"); return; } } else { if (!stockRequest.SaveStockRequestEntries(trans, nStockRequestNo, cellValue1.ToString(), Convert.ToInt32(cellValue2.ToString()), this.lkBranchTo.EditValue.ToString())) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Insert StockRequestEntries", "Error"); return; } } } } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); if (isEdit) { if (!audit.SaveAuditTrail(trans, 7, "Update Stock Request No " + StockRequestNo, "Stock Request", this.employee.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Insert Audit", "Error"); return; } UI.ShowErrorMessage(this, "Record Has Been Updated", "Save"); } else { if (!audit.SaveAuditTrail(trans, 7, "Add New Stock Request No " + nStockRequestNo, "Stock Request", this.employee.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Insert Audit", "Error"); return; } UI.ShowErrorMessage(this, "Record Has Been Saved", "Save"); } trans.Commit(); sqlcon.Close(); this.DialogResult = DialogResult.OK; this.Close(); canSave = true; } #region nHibernate Code // if(canSave) // { // //Variable Hashtable // Hashtable htStockRequest = new Hashtable(); // //htint // if(isEdit) // { // htStockRequest.Add("Id",this.StockRequestNo); // // htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString()); // } // else // { // //DateTime // htStockRequest.Add("dtDate",DateTime.Today); // //Add pending value // htStockRequest.Add("nStatusID",0);//this.lkStatus.Properties.ValueMember); // //DateTime // htStockRequest.Add("dtLastEditDate",DateTime.Today); // // //string // //htStockRequest.Add("Branch_strBranchCodeFrom",this.lkBranchTo.EditValue.ToString()); // htStockRequest.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // //htStockRequest.Add("Branch_strBranchCodeTo",this.terminalUser.Branch.Id); // htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString()); // // //int // htStockRequest.Add("Employee_nEmployeeID",this.employee.Id); // } // // //int // //htStockRequest.Add("IBT_nIBTNo",this.lkIBT.EditValue.ToString()); // // ArrayList stockRequestList = new ArrayList(); // // DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode"); // DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity"); // // for(int i=0;i<this.gridView1.DataRowCount;i++) // { // // object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode"); // object cellValue2 = gridView1.GetRowCellValue(i, col2); // if(cellValue1.ToString()=="" | cellValue2.ToString()=="") // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error"); // canSave=false; // return; // } // else // { // Hashtable htStockRequestEntries = new Hashtable(); // // htStockRequestEntries.Add("Product_strItemCode",cellValue1.ToString()); // //htStockRequestEntries.Add("Test_strProductCode",2); // //int // htStockRequestEntries.Add("nQuantity",cellValue2.ToString()); // // stockRequestList.Add(htStockRequestEntries); // } // } // // //Object In ArrayList // htStockRequest.Add("StockRequestEntries",stockRequestList); // // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // // if(canSave) // { // try // { // if(!isEdit) // { // srf.MakeSaveStockRequest(htStockRequest); // SaveAuditTrail("Add New Stock Request","Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Saved", "Save"); // } // else // { // srf.MakeUpdateStockRequest(htStockRequest); // SaveAuditTrail("Update Stock Request","Stock Request",this.employee.Id); // MessageBox.Show("Record Has Been Updated", "Updated"); // isEdit=false; // } // this.DialogResult = DialogResult.OK; // this.Close(); // canSave=true; // } // catch // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid Quantity","Error"); // } // } // // } // else // { // ACMS.Utils.UI.ShowErrorMessage(this,"Please enter a valid quantity","Error"); // } #endregion } }
private void Process_Btn_Click(object sender, System.EventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); //string strBranchCodeFrom=this.terminalUser.Branch.Id; //string strBranchCodeTo=this._strBranchCodeTo; int IBTNo = stockRequest.ProcessStockRequest(trans, DateTime.Now, 0, DateTime.Now, this.txtRemarks.Text, this.terminalUser.Branch.Id, this._strBranchCodeFrom, this.employee.Id); DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for (int i = 0; i < this.gridView1.DataRowCount; i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = gridView1.GetRowCellValue(i, col3); if (!stockRequest.ProcessStockRequestEntries(trans, cellValue1.ToString(), Convert.ToInt32(cellValue2.ToString()), IBTNo, this.terminalUser.Branch.Id, Convert.ToInt32(cellValue3.ToString()))) { int rowNumber = i + 1; trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Process StockRequest :: Invalid Quantity For Product = " + cellValue1.ToString(), "Error"); return; } } if (!stockRequest.UpdateStockRequestIBTNo(trans, IBTNo, Convert.ToInt32(this.StockRequestNo))) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequest", "Error"); return; } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans, 7, "Save Process IBT No " + IBTNo, "IBT", this.employee.Id); audit.SaveAuditTrail(trans, 7, "Update Stock Request Status No " + this.StockRequestNo, "IBT", this.employee.Id); trans.Commit(); sqlcon.Close(); MessageBox.Show("Record Has Been Saved", "Save"); this.DialogResult = DialogResult.OK; #region nHibernate Code // //Variable Hashtable // Hashtable htIBT = new Hashtable(); // //htint // //htIBT.Add("Id",""); // //DateTime // htIBT.Add("dtDate",DateTime.Now); // //int // //Status 0 - Pending Request // htIBT.Add("nStatusID",0); // //DateTime // htIBT.Add("dtLastEditDate",DateTime.Now); // //string // htIBT.Add("strRemarks",this.txtRemarks.Text); // // //string // htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // htIBT.Add("Branch_strBranchCodeTo",sr.BranchFrom.Id); // // //int // htIBT.Add("Employee_nEmployeeID",this.employee.Id); // // ArrayList ibtEntryList = new ArrayList(); // // DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode"); // DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity"); // // for(int i=0;i<this.gridView1.DataRowCount;i++) // { // // object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode"); // object cellValue2 = gridView1.GetRowCellValue(i, col2); // //Variable Hashtable // Hashtable htIBTEntries = new Hashtable(); // //string // htIBTEntries.Add("strItemCode",cellValue1.ToString()); // //int // htIBTEntries.Add("nQuantity",cellValue2.ToString()); // // ibtEntryList.Add(htIBTEntries); // // //Need to refactoring using Service Layer later // Rp.ProductRepository pr = new Rp.ProductRepository(); // pr.UpdateProductInventoryQuantity(cellValue1.ToString(),this.terminalUser.Branch.Id,"VW",Convert.ToInt32(cellValue2.ToString()),0); // // } // // htIBT.Add("IBTEntries",ibtEntryList); // // //Save IBT and IBTEntries // Fc.IBTFactory ifactory = new Fc.IBTFactory(); // ifactory.MakeSaveIBT(htIBT); // // //Update stock request status // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // Hashtable htStockRequest = new Hashtable(); // htStockRequest.Add("Id",StockRequestNo); // // //int // htStockRequest.Add("nStatusID",1); // // htStockRequest.Add("IBT_nIBTNo",Fc.IBTFactory.GetIBT.Id); // // srf.MakeUpdateStockRequest(htStockRequest); // // //Update ProductInventory for Virtual Warehouse // // // #endregion }
private void Process_Btn_Click(object sender, System.EventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); //string strBranchCodeFrom=this.terminalUser.Branch.Id; //string strBranchCodeTo=this._strBranchCodeTo; int IBTNo = stockRequest.ProcessStockRequest(trans,DateTime.Now,0,DateTime.Now,this.txtRemarks.Text,this.terminalUser.Branch.Id,this._strBranchCodeFrom,this.employee.Id); DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for(int i=0;i<this.gridView1.DataRowCount;i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = gridView1.GetRowCellValue(i, col3); if(!stockRequest.ProcessStockRequestEntries(trans,cellValue1.ToString(),Convert.ToInt32(cellValue2.ToString()),IBTNo,this.terminalUser.Branch.Id,Convert.ToInt32(cellValue3.ToString()))) { int rowNumber =i+1; trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Process StockRequest :: Invalid Quantity For Product = "+cellValue1.ToString(),"Error"); return; } } if(!stockRequest.UpdateStockRequestIBTNo(trans,IBTNo,Convert.ToInt32(this.StockRequestNo))) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequest","Error"); return; } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans,7,"Save Process IBT No "+IBTNo,"IBT",this.employee.Id); audit.SaveAuditTrail(trans,7,"Update Stock Request Status No "+this.StockRequestNo,"IBT",this.employee.Id); trans.Commit(); sqlcon.Close(); MessageBox.Show("Record Has Been Saved", "Save"); this.DialogResult = DialogResult.OK; #region nHibernate Code // //Variable Hashtable // Hashtable htIBT = new Hashtable(); // //htint // //htIBT.Add("Id",""); // //DateTime // htIBT.Add("dtDate",DateTime.Now); // //int // //Status 0 - Pending Request // htIBT.Add("nStatusID",0); // //DateTime // htIBT.Add("dtLastEditDate",DateTime.Now); // //string // htIBT.Add("strRemarks",this.txtRemarks.Text); // // //string // htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // htIBT.Add("Branch_strBranchCodeTo",sr.BranchFrom.Id); // // //int // htIBT.Add("Employee_nEmployeeID",this.employee.Id); // // ArrayList ibtEntryList = new ArrayList(); // // DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode"); // DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity"); // // for(int i=0;i<this.gridView1.DataRowCount;i++) // { // // object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode"); // object cellValue2 = gridView1.GetRowCellValue(i, col2); // //Variable Hashtable // Hashtable htIBTEntries = new Hashtable(); // //string // htIBTEntries.Add("strItemCode",cellValue1.ToString()); // //int // htIBTEntries.Add("nQuantity",cellValue2.ToString()); // // ibtEntryList.Add(htIBTEntries); // // //Need to refactoring using Service Layer later // Rp.ProductRepository pr = new Rp.ProductRepository(); // pr.UpdateProductInventoryQuantity(cellValue1.ToString(),this.terminalUser.Branch.Id,"VW",Convert.ToInt32(cellValue2.ToString()),0); // // } // // htIBT.Add("IBTEntries",ibtEntryList); // // //Save IBT and IBTEntries // Fc.IBTFactory ifactory = new Fc.IBTFactory(); // ifactory.MakeSaveIBT(htIBT); // // //Update stock request status // Fc.StockRequestFactory srf = new Fc.StockRequestFactory(); // Hashtable htStockRequest = new Hashtable(); // htStockRequest.Add("Id",StockRequestNo); // // //int // htStockRequest.Add("nStatusID",1); // // htStockRequest.Add("IBT_nIBTNo",Fc.IBTFactory.GetIBT.Id); // // srf.MakeUpdateStockRequest(htStockRequest); // // //Update ProductInventory for Virtual Warehouse // // // #endregion }
private void simpleButton1_Click(object sender, System.EventArgs e) { DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle); try { if (dr.Table.Rows.Count == 0) { MessageBox.Show("Not allowed to Save Empty Entries", "Warning"); return; } } catch (Exception ex) { return; } SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction trans = sqlcon.BeginTransaction(); if (this.lkBranchTo.EditValue.ToString() == "Select Branch" | this.lkBranchTo.EditValue.ToString() == "") { ACMS.Utils.UI.ShowErrorMessage(this, "Please select valid Branch Code", "Error"); } else if (canSave) { ACMSLogic.InterBranchTransfer.InterBranchTransfer ibts = new ACMSLogic.InterBranchTransfer.InterBranchTransfer(); int nIBTNo = 0; //Hashtable htIBT = new Hashtable(); //htint if (isEdit) { if (!ibts.UpdateIBT(trans, DateTime.Now, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Now, this.txtRemarks.Text, this.nIBTNo)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update IBT", "Error"); return; } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans, 8, "Update IBT " + this.nIBTNo, "IBT", this.employee.Id); } else { nIBTNo = ibts.SaveIBT(trans, DateTime.Now, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Now, this.txtRemarks.Text); ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans, 8, "Save IBT " + this.nIBTNo, "IBT", this.employee.Id); #region nHibernate Code // //DateTime // htIBT.Add("dtDate",DateTime.Now); // //int // //Status 0 - Pending Request // htIBT.Add("nStatusID",0); // //DateTime // htIBT.Add("dtLastEditDate",DateTime.Now); // //string // htIBT.Add("strRemarks",this.txtRemarks.Text); // // //string // htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id); // // //string // htIBT.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue); // // //int // htIBT.Add("Employee_nEmployeeID",this.employee.Id); #endregion } ArrayList ibtEntryList = new ArrayList(); ArrayList ibtProductTransferList = new ArrayList(); DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID"); for (int i = 0; i < this.gridView1.DataRowCount; i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue2 = gridView1.GetRowCellValue(i, col2); object cellValue3 = null; IBTProductTransfer ibt; int nEntryID = 0; string strProductCode = cellValue1.ToString(); int quantity = Convert.ToInt32(cellValue2.ToString()); if (isEdit) { cellValue3 = gridView1.GetRowCellValue(i, col3); nEntryID = Convert.ToInt32(cellValue3); ibt = new IBTProductTransfer(strProductCode, quantity, nEntryID); } else { ibt = new IBTProductTransfer(strProductCode, quantity); } if (ibtProductTransferList.Count == 0) { ibtProductTransferList.Add(ibt); } else { bool duplicate = false; for (int _i = 0; _i < ibtProductTransferList.Count; _i++) { IBTProductTransfer _ibt = ibtProductTransferList[_i] as IBTProductTransfer; if (strProductCode == _ibt.StrProductCode) { _ibt.Quantity = _ibt.Quantity + quantity; duplicate = true; } } if (!duplicate) { ibtProductTransferList.Add(ibt); } } } //Variable Hashtable //bool doubleCheckCanSave=true; if (isEdit) { foreach (IBTProductTransfer ibt in ibtProductTransferList) { if (!ibts.UpdateIBTEntries(trans, NIBTNo, ibt.StrProductCode, ibt.Quantity, this.terminalUser.Branch.Id, ibt.NEntryID)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update IBTEntries", "Error"); return; } } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans, 8, "Update IBTEntries " + NIBTNo, "IBTEntries", this.employee.Id); UI.ShowMessage(this, "Record Has Been Updated"); } else { if (nIBTNo != 0) { foreach (IBTProductTransfer ibt in ibtProductTransferList) { if (!ibts.SaveIBTEntries(trans, nIBTNo, ibt.StrProductCode, ibt.Quantity, this.terminalUser.Branch.Id)) { trans.Rollback(); sqlcon.Close(); UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequestEntries", "Error"); return; } #region nHibernate Code // Hashtable htIBTEntries = new Hashtable(); // // htIBTEntries.Add("strItemCode",ibt.StrProductCode); // //int // htIBTEntries.Add("nQuantity",ibt.Quantity); // // Rp.ProductRepository pr = new Rp.ProductRepository(); // // Acms.Core.Domain.ProductInventory pi = pr.CheckQuantityAvailable(ibt.StrProductCode,this.terminalUser.Branch.Id); // if(pi!=null) // { // // if(!pi.IsValidQuantityRequest(ibt.Quantity)) // { // doubleCheckCanSave=false; // //return; // } // } // // ibtEntryList.Add(htIBTEntries); #endregion } ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail(); audit.SaveAuditTrail(trans, 8, "Save IBTEntries " + NIBTNo, "IBTEntries", this.employee.Id); } UI.ShowMessage(this, "Record Has Been Saved"); } } trans.Commit(); sqlcon.Close(); this.DialogResult = DialogResult.OK; }