public void GetGRNNo() { List <GRNEntity> lstGRNNo = new List <GRNEntity>(); Execute objExecute = new Execute(); string Query = "[dbo].[spGetGRNNo]"; SqlParameter[] para = new SqlParameter[] { Execute.AddParameter("@intSupplierID", Convert.ToInt32(cmbSupplier.SelectedValue)), }; DataTable dt = (DataTable)objExecute.Executes(Query, ReturnType.DataTable, para, CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { objGRNEntity = new GRNEntity { intGRNHeaderID = Convert.ToInt32(dr["intGRNHeaderID"]), vcGRNNo = dr["vcGRNNo"].ToString() }; lstGRNNo.Add(objGRNEntity); } cmbGRNNo.DataSource = lstGRNNo; cmbGRNNo.DisplayMember = "vcGRNNo"; cmbGRNNo.ValueMember = "intGRNHeaderID"; cmbGRNNo.SelectedIndex = -1; }
private void btnSave_Click(object sender, EventArgs e) { try { if (cmbSupplier.SelectedIndex == -1) { MessageBox.Show("Please select the Supplier"); return; } //else if (cmbBrand.SelectedIndex == -1) //{ // MessageBox.Show("Please select the Brand"); // return; //} //else if (cmbMainCategory.SelectedIndex == -1) //{ // MessageBox.Show("Please select the Main Category"); // return; //} //else if (cmbSubCat.SelectedIndex == -1) //{ // MessageBox.Show("Please select the Sub Category"); // return; //} if (dgvGRN.Rows.Count == 0) { MessageBox.Show("Please Item Add to Grid"); return; } foreach (DataGridViewRow row in dgvGRN.Rows) { if (Convert.ToBoolean(row.Cells[dgvGRN.Columns[clmGRNQty.Name].Index].Value == null) || (Convert.ToInt32(row.Cells[dgvGRN.Columns[clmGRNQty.Name].Index].Value) == 0)) { MessageBox.Show("Please Enter GRN Qty"); return; } if (Convert.ToBoolean(row.Cells[dgvGRN.Columns[clmUnitPrice.Name].Index].Value == null) || (Convert.ToInt32(row.Cells[dgvGRN.Columns[clmUnitPrice.Name].Index].Value) == 0)) { MessageBox.Show("Please Enter Unit Price Qty"); return; } } DialogResult drs = MessageBox.Show("Are You Sure All Infromation Correct?", "CONFIRM", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information); if (drs == DialogResult.Yes) { using (TransactionScope ts = new TransactionScope()) { intGRNHeaderID = 0; List <GRNEntity> lstGRNSave = new List <GRNEntity>(); Execute objExecute = new Execute(); SqlParameter[] param = new SqlParameter[] { Execute.AddParameter("@intSupplierID", Convert.ToInt32(cmbSupplier.SelectedValue)) }; intGRNHeaderID = objExecute.ExecuteIdentity("spSaveGRNHeader", param, CommandType.StoredProcedure); foreach (DataGridViewRow dr in dgvGRN.Rows) { GRNEntity objGRNEntity = new GRNEntity { intGRNHeaderID = intGRNHeaderID, intItemID = Convert.ToInt32(dr.Cells[clmItemID1.Name].Value.ToString()), decGRNQty = Convert.ToDecimal(dr.Cells[clmGRNQty.Name].Value.ToString()), decUnitPrice = Convert.ToDecimal(dr.Cells[clmUnitPrice.Name].Value.ToString()), decDiscountedValue = Convert.ToDecimal(dr.Cells[clmDiscountedValue.Name].Value.ToString()), }; lstGRNSave.Add(objGRNEntity); } foreach (GRNEntity item in lstGRNSave) { Execute objExecuteX = new Execute(); SqlParameter[] paramX = new SqlParameter[] { Execute.AddParameter("@intGRNHeaderID", item.intGRNHeaderID), Execute.AddParameter("@intItemID", item.intItemID), Execute.AddParameter("@decGRNQty", item.decGRNQty), Execute.AddParameter("@decUnitPrice", item.decUnitPrice), Execute.AddParameter("@decDiscountedValue", item.decDiscountedValue), }; objExecuteX.Executes("spSaveGRNDetails", paramX, CommandType.StoredProcedure); } ts.Complete(); } MessageBox.Show("Save.."); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; ///Report/////////////////////////////////////////////////// /// rptGRN rpt = new rptGRN(); ReportDocument rptDoc = new ReportDocument(); rptDoc = rpt; Execute objExecuteXX = new Execute(); string Query = "[dbo].[spGetGRNReportDetails]"; SqlParameter[] para = new SqlParameter[] { Execute.AddParameter("@intGRNHeaderID", intGRNHeaderID) }; DataTable dt = (DataTable)objExecuteXX.Executes(Query, ReturnType.DataTable, para, CommandType.StoredProcedure); rpt.SetDataSource(dt); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; frmReportViewer objfrmReportViewer = new frmReportViewer(rptDoc); objfrmReportViewer.Show(); //rptDoc.PrintToPrinter(1, true, 0, 0); clear(); //////////////////////////////b } } catch (Exception ex) { MessageBox.Show("Data Saving Error"); Logger.LoggError(ex, "btnSave_Click"); } }