private void LoadProductList() { this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None) }); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode"; this.repositoryItemLookUpEdit1.ValueMember = "strItemCode"; this.repositoryItemLookUpEdit1.NullText = "Select Product"; LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns; //a column to display values of the ProductID field //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("Id","Product Code",20)); col2.Add(new LookUpColumnInfo("strBrand", "Brand", 50)); col2.Add(new LookUpColumnInfo("strDescription", "Description", 50)); col2.Add(new LookUpColumnInfo("strStyle", "Style", 50)); col2.Add(new LookUpColumnInfo("strColor", "Color", 50)); col2.Add(new LookUpColumnInfo("strSize", "Size", 50)); col2.Add(new LookUpColumnInfo("nQuantity", "Quantity", 50)); lkBranchTo.Properties.AutoSearchColumnIndex = 0; repositoryItemLookUpEdit1.BestFit(); repositoryItemLookUpEdit1.PopupWidth = 600; }
public void LoadStockRequestDetail_Edit() { // Rp.StockRequestRepository srp = new Rp.StockRequestRepository(); // Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); // this.sr=sr; // // this.txtBranchFrom.Text = sr.BranchFrom.Id; ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); if (dt != null) { this.GetStockRequestDetail(); this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString(); this.txtBranchFrom.Text = dt.Rows[0]["strBranchCodeTo"].ToString(); this.txtStockRequestNo.Enabled = false; this.txtBranchFrom.Enabled = false; } GetStockRequestDetail(); }
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { if (!isEdit) { if (CheckDuplicate()) { DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row["strItemCode"].ToString().Length > 0 && row["strItemCode"].ToString() != "Select Product") { string strProductCode = row["strItemCode"].ToString(); int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString()); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); if (!stockRequest.GetAvailableQuantity(strProductCode, this.lkBranchTo.EditValue.ToString(), quantityRequest)) { UI.ShowErrorMessage(this, "Quantity request exceeded Balance", "Error"); this.canSave = false; this.canAdd = false; inValidQuantityRow = gridView1.FocusedRowHandle; } else { this.canSave = true; this.canAdd = true; return; } } } } this.canSave = false; }
private void lk_Product_Init() { //DataSet _ds = new DataSet(); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); //string strSQL = "select * from tblproduct"; //SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) ); //_ds.Tables[0]; DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); lk_Product.BestFit(); DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6]; col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Item Code", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle", "Style", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor", "Color", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize", "Size", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity", "Quantity", 10, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); try { new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product, dt, col, "strItemCode", "strItemCode", "Item Code"); } catch (Exception ex) { return; } }
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 BindPage() { this.dateEdit1.Properties.Enabled = false; this.dateEdit1.EditValue = DateTime.Today.ToShortDateString(); //Rp.StockRequestRepository srr = new Rp.StockRequestRepository(); //IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id); //this.lkBranchTo.Properties.DataSource = listBranchTo; //this.lkBranchTo.Properties.ValueMember = "Id"; //this.lkBranchTo.Properties.DisplayMember = "StrBranchName"; this.lkBranchTo.Properties.ValueMember = "strBranchCode"; this.lkBranchTo.Properties.DisplayMember = "strBranchName"; this.lkBranchTo.EditValue = "Select Branch"; this.lkBranchTo.Text = "Select Branch"; //add two columns in the dropdown LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field // coll.Add(new LookUpColumnInfo("Id","Branch Code",2)); // //a column to display values of the ProductName field // coll.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50)); coll.Add(new LookUpColumnInfo("strBranchCode", "Branch Code", 2)); //a column to display values of the ProductName field coll.Add(new LookUpColumnInfo("strBranchName", "Branch Name", 50)); //set column widths according to their contents lkBranchTo.Properties.BestFit(); //specify the total dropdown width lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search lkBranchTo.Properties.AutoSearchColumnIndex = 0; if (this.gridView1.DataRowCount == 0) { DataRow dr = dt.NewRow(); dr["strItemCode"] = "Select Product"; dr["nQuantity"] = "0"; dt.Rows.Add(dr); this.gridControl1.DataSource = dt; } }
private void GetStockRequestDetail() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo)); if (dt != null) { this.gridControl1.DataSource = dt; } }
private void GetStockRequestDetail() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo)); if (dt != null) { this.gridControl1.DataSource = dt; this.gridView1.Columns[0].OptionsColumn.AllowEdit = false; } this.simpleButton4.Visible = false; }
public void LoadStockRequestEdit() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); if (dt != null) { this.GetStockRequestDetail(); this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString(); this.lkBranchTo.EditValue = dt.Rows[0]["strBranchCodeTo"].ToString(); this.txtRequestedBy.Text = dt.Rows[0]["strRemarks"].ToString(); } this.btn_Save.Text = "Update"; this.btn_Add.Text = "Cancel"; this.btn_Add.Width = 75; this.simpleButton3.Visible = false; //Rp.StockRequestRepository srp = new Rp.StockRequestRepository(); //Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); }
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { if (!isEdit) { DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row["strItemCode"] != null) { if (row["strItemCode"].ToString() != "Select Product") { string strProductCode = row["strItemCode"].ToString(); int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString()); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); if (!stockRequest.GetAvailableQuantity(strProductCode, this.terminalUser.Branch.Id, quantityRequest)) { UI.ShowErrorMessage(this, "Invalid Operation. Please change valid product quantity", "Error"); this.canSave = false; this.canAdd = false; inValidQuantityRow = gridView1.FocusedRowHandle; } else { this.canSave = true; this.canAdd = true; } } else { this.canSave = false; } } else { this.canSave = false; } } }
private void BindPage() { this.dateEdit1.Text = DateTime.Today.ToShortDateString(); //Rp.StockRequestRepository srr = new Rp.StockRequestRepository(); //IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id); this.lkBranchTo.Properties.ValueMember = "strBranchCode"; this.lkBranchTo.Properties.DisplayMember = "strBranchName"; this.lkBranchTo.EditValue="Select Branch"; this.lkBranchTo.Text="Select Branch"; //add two columns in the dropdown LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field coll.Add(new LookUpColumnInfo("strBranchCode","Branch Code",2)); //a column to display values of the ProductName field coll.Add(new LookUpColumnInfo("strBranchName","Branch Name",50)); //set column widths according to their contents lkBranchTo.Properties.BestFit(); //specify the total dropdown width lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search lkBranchTo.Properties.AutoSearchColumnIndex = 0; if(this.gridView1.DataRowCount==0) { DataRow dr = dt.NewRow(); dr["strItemCode"]="Select Product"; dr["nQuantity"]="0"; dt.Rows.Add(dr); this.gridControl1.DataSource = dt; } #region Disable Code //TODO:Check Current Branch //IList listBranchTo = srr.GetListByRange(typeof(Branch),"SP"); //this.lkBranchTo.Properties.DataSource = listBranchTo; //this.lkBranchTo.Properties.ValueMember = "Id"; //this.lkBranchTo.Properties.DisplayMember = "StrBranchName"; //add two columns in the dropdown //LookUpColumnInfoCollection col2 = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field //col2.Add(new LookUpColumnInfo("Id","Id",2)); //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50)); //set column widths according to their contents //lkBranchTo.Properties.BestFit(); //specify the total dropdown width //lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkBranchTo.Properties.AutoSearchColumnIndex = 1; //IList listEmployee = srr.GetListByDomain(typeof(Employee)); //this.lkRequestedBy.Properties.DataSource = listEmployee; //this.lkRequestedBy.Properties.DisplayMember = "StrEmployeeName"; //this.lkRequestedBy.Properties.ValueMember = "Id"; //add two columns in the dropdown //LookUpColumnInfoCollection col3 = lkRequestedBy.Properties.Columns; //a column to display values of the ProductID field //col3.Add(new LookUpColumnInfo("Id","Id",4)); //a column to display values of the ProductName field //col3.Add(new LookUpColumnInfo("StrEmployeeName","Employee Name",50)); //set column widths according to their contents //lkRequestedBy.Properties.BestFit(); //specify the total dropdown width //lkRequestedBy.Properties.PopupWidth = 300; //enable auto completion search mode //lkRequestedBy.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkRequestedBy.Properties.AutoSearchColumnIndex = 1; //IList listIBT = srr.GetListByDomain(typeof(IBT)); //this.lkIBT.Properties.DataSource = listIBT; //this.lkIBT.Properties.DisplayMember = "Id"; //this.lkIBT.Properties.ValueMember = "Id"; //add two columns in the dropdown //LookUpColumnInfoCollection col4 = lkIBT.Properties.Columns; //a column to display values of the ProductID field //col4.Add(new LookUpColumnInfo("Id")); //set column widths according to their contents //lkIBT.Properties.BestFit(); //enable auto completion search mode //lkIBT.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkIBT.Properties.AutoSearchColumnIndex = 1; //ArrayList _stockRequestStatus = new ArrayList(); //ACMS.Util.StockRequestStatus[] srs = (ACMS.Util.StockRequestStatus[])Enum.GetValues(typeof(ACMS.Util.StockRequestStatus)); //this.lkStatus.Properties.DataSource = srs; #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(); } }
public void LoadStockRequestEdit() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); if(dt!=null) { this.GetStockRequestDetail(); this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString(); this.lkBranchTo.EditValue = dt.Rows[0]["strBranchCodeTo"].ToString(); this.txtRequestedBy.Text = dt.Rows[0]["strRemarks"].ToString(); } this.btn_Save.Text="Update"; this.btn_Add.Text="Cancel"; this.btn_Add.Width = 75; this.simpleButton3.Visible=false; //Rp.StockRequestRepository srp = new Rp.StockRequestRepository(); //Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); }
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { if(!isEdit) { DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle); if(row["strItemCode"]!=null) { if(row["strItemCode"].ToString()!="Select Product") { string strProductCode = row["strItemCode"].ToString(); int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString()); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); if(!stockRequest.GetAvailableQuantity(strProductCode,this.terminalUser.Branch.Id,quantityRequest)) { UI.ShowErrorMessage(this,"Invalid Operation. Please change valid product quantity","Error"); this.canSave=false; this.canAdd=false; inValidQuantityRow=gridView1.FocusedRowHandle; } else { this.canSave=true; this.canAdd=true; } } else { this.canSave=false; } } else { this.canSave=false; } } }
private void LoadProductList() { this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)}); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id);//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode"; this.repositoryItemLookUpEdit1.ValueMember="strItemCode"; this.repositoryItemLookUpEdit1.NullText="Select Product"; LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns; //a column to display values of the ProductID field //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("Id","Product Code",20)); col2.Add(new LookUpColumnInfo("strBrand","Brand",50)); col2.Add(new LookUpColumnInfo("strDescription","Description",50)); col2.Add(new LookUpColumnInfo("strStyle","Style",50)); col2.Add(new LookUpColumnInfo("strColor","Color",50)); col2.Add(new LookUpColumnInfo("strSize","Size",50)); col2.Add(new LookUpColumnInfo("nQuantity","Quantity",50)); lkBranchTo.Properties.AutoSearchColumnIndex = 0; repositoryItemLookUpEdit1.BestFit(); repositoryItemLookUpEdit1.PopupWidth = 600; }
private void simpleButton3_Click(object sender, System.EventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text,this.txtSearchProduct.Text,this.txtSearchProductDesc.Text,this.strBranchCode); }
private void BindPage() { this.dateEdit1.Properties.Enabled=false; this.dateEdit1.EditValue = DateTime.Today.ToShortDateString(); //Rp.StockRequestRepository srr = new Rp.StockRequestRepository(); //IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id); //this.lkBranchTo.Properties.DataSource = listBranchTo; //this.lkBranchTo.Properties.ValueMember = "Id"; //this.lkBranchTo.Properties.DisplayMember = "StrBranchName"; this.lkBranchTo.Properties.ValueMember = "strBranchCode"; this.lkBranchTo.Properties.DisplayMember = "strBranchName"; this.lkBranchTo.EditValue="Select Branch"; this.lkBranchTo.Text="Select Branch"; //add two columns in the dropdown LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field // coll.Add(new LookUpColumnInfo("Id","Branch Code",2)); // //a column to display values of the ProductName field // coll.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50)); coll.Add(new LookUpColumnInfo("strBranchCode","Branch Code",2)); //a column to display values of the ProductName field coll.Add(new LookUpColumnInfo("strBranchName","Branch Name",50)); //set column widths according to their contents lkBranchTo.Properties.BestFit(); //specify the total dropdown width lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search lkBranchTo.Properties.AutoSearchColumnIndex = 0; if(this.gridView1.DataRowCount==0) { DataRow dr = dt.NewRow(); dr["strItemCode"]="Select Product"; dr["nQuantity"]="0"; dt.Rows.Add(dr); this.gridControl1.DataSource = dt; } }
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 GetStockRequestDetail() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo)); if(dt!=null) { this.gridControl1.DataSource = dt; } }
private void SerachProduct(object sender, System.Windows.Forms.KeyEventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text,this.txtSearchProduct.Text,this.txtSearchProductDesc.Text,this.strBranchCode); }
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 GetStockRequestDetail() { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo)); if(dt!=null) { this.gridControl1.DataSource = dt; this.gridView1.Columns[0].OptionsColumn.AllowEdit=false; } this.simpleButton4.Visible=false; }
private void SerachProduct(object sender, System.Windows.Forms.KeyEventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text, this.txtSearchProduct.Text, this.txtSearchProductDesc.Text, this.strBranchCode); }
private void simpleButton3_Click(object sender, System.EventArgs e) { ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text, this.txtSearchProduct.Text, this.txtSearchProductDesc.Text, this.strBranchCode); }
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 } }
public void LoadStockRequestDetail_Edit() { // Rp.StockRequestRepository srp = new Rp.StockRequestRepository(); // Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); // this.sr=sr; // // this.txtBranchFrom.Text = sr.BranchFrom.Id; ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo)); if(dt!=null) { this.GetStockRequestDetail(); this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString(); this.txtBranchFrom.Text = dt.Rows[0]["strBranchCodeTo"].ToString(); this.txtStockRequestNo.Enabled=false; this.txtBranchFrom.Enabled=false; } GetStockRequestDetail(); }
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { if(!isEdit) { if(CheckDuplicate()) { DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle); if(row["strItemCode"].ToString().Length>0 && row["strItemCode"].ToString()!="Select Product") { string strProductCode = row["strItemCode"].ToString(); int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString()); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); if(!stockRequest.GetAvailableQuantity(strProductCode,this.lkBranchTo.EditValue.ToString(),quantityRequest)) { UI.ShowErrorMessage(this,"Quantity request exceeded Balance","Error"); this.canSave=false; this.canAdd=false; inValidQuantityRow=gridView1.FocusedRowHandle; } else { this.canSave=true; this.canAdd=true; return; } } } } this.canSave=false; }
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 lk_Product_Init() { //DataSet _ds = new DataSet(); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); //string strSQL = "select * from tblproduct"; //SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) ); //_ds.Tables[0]; DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString());//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); lk_Product.BestFit(); DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6]; col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode","Item Code",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle","Style",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor","Color",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize","Size",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity","Quantity",10,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); try { new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product,dt,col,"strItemCode","strItemCode","Item Code"); } catch(Exception ex) { return; } }
private void BindPage() { this.dateEdit1.Text = DateTime.Today.ToShortDateString(); //Rp.StockRequestRepository srr = new Rp.StockRequestRepository(); //IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id); this.lkBranchTo.Properties.ValueMember = "strBranchCode"; this.lkBranchTo.Properties.DisplayMember = "strBranchName"; this.lkBranchTo.EditValue = "Select Branch"; this.lkBranchTo.Text = "Select Branch"; //add two columns in the dropdown LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field coll.Add(new LookUpColumnInfo("strBranchCode", "Branch Code", 2)); //a column to display values of the ProductName field coll.Add(new LookUpColumnInfo("strBranchName", "Branch Name", 50)); //set column widths according to their contents lkBranchTo.Properties.BestFit(); //specify the total dropdown width lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search lkBranchTo.Properties.AutoSearchColumnIndex = 0; if (this.gridView1.DataRowCount == 0) { DataRow dr = dt.NewRow(); dr["strItemCode"] = "Select Product"; dr["nQuantity"] = "0"; dt.Rows.Add(dr); this.gridControl1.DataSource = dt; } #region Disable Code //TODO:Check Current Branch //IList listBranchTo = srr.GetListByRange(typeof(Branch),"SP"); //this.lkBranchTo.Properties.DataSource = listBranchTo; //this.lkBranchTo.Properties.ValueMember = "Id"; //this.lkBranchTo.Properties.DisplayMember = "StrBranchName"; //add two columns in the dropdown //LookUpColumnInfoCollection col2 = lkBranchTo.Properties.Columns; //a column to display values of the ProductID field //col2.Add(new LookUpColumnInfo("Id","Id",2)); //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50)); //set column widths according to their contents //lkBranchTo.Properties.BestFit(); //specify the total dropdown width //lkBranchTo.Properties.PopupWidth = 300; //enable auto completion search mode //lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkBranchTo.Properties.AutoSearchColumnIndex = 1; //IList listEmployee = srr.GetListByDomain(typeof(Employee)); //this.lkRequestedBy.Properties.DataSource = listEmployee; //this.lkRequestedBy.Properties.DisplayMember = "StrEmployeeName"; //this.lkRequestedBy.Properties.ValueMember = "Id"; //add two columns in the dropdown //LookUpColumnInfoCollection col3 = lkRequestedBy.Properties.Columns; //a column to display values of the ProductID field //col3.Add(new LookUpColumnInfo("Id","Id",4)); //a column to display values of the ProductName field //col3.Add(new LookUpColumnInfo("StrEmployeeName","Employee Name",50)); //set column widths according to their contents //lkRequestedBy.Properties.BestFit(); //specify the total dropdown width //lkRequestedBy.Properties.PopupWidth = 300; //enable auto completion search mode //lkRequestedBy.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkRequestedBy.Properties.AutoSearchColumnIndex = 1; //IList listIBT = srr.GetListByDomain(typeof(IBT)); //this.lkIBT.Properties.DataSource = listIBT; //this.lkIBT.Properties.DisplayMember = "Id"; //this.lkIBT.Properties.ValueMember = "Id"; //add two columns in the dropdown //LookUpColumnInfoCollection col4 = lkIBT.Properties.Columns; //a column to display values of the ProductID field //col4.Add(new LookUpColumnInfo("Id")); //set column widths according to their contents //lkIBT.Properties.BestFit(); //enable auto completion search mode //lkIBT.Properties.SearchMode = SearchMode.AutoComplete; //the column against which to perform the search //lkIBT.Properties.AutoSearchColumnIndex = 1; //ArrayList _stockRequestStatus = new ArrayList(); //ACMS.Util.StockRequestStatus[] srs = (ACMS.Util.StockRequestStatus[])Enum.GetValues(typeof(ACMS.Util.StockRequestStatus)); //this.lkStatus.Properties.DataSource = srs; #endregion }