private void BtnEdit_Click(object sender, EventArgs e) { if (btnEdit.Enabled) { try { var row = ReplGridView.GetDataRow(ReplGridView.FocusedRowHandle); var ds = ProjectFunctions.GetDataSet(string.Format("select * from ExMst Where ExId='" + row["ExId"].ToString() + "'")); if (ds.Tables[0].Rows[0]["ExLoadTag"].ToString() == string.Empty) { var frm = new Forms_Transaction.FrmAdvanceAddEdit() { S1 = btnEdit.Text }; var P = ProjectFunctions.GetPositionInForm(this); frm.Location = new Point(P.X + (ClientSize.Width / 2 - frm.Size.Width / 2), P.Y + (ClientSize.Height / 2 - frm.Size.Height / 2)); frm.Text = "Time Office Payment Editing"; frm.ExId = row["ExId"].ToString(); frm.ShowDialog(); } else { XtraMessageBox.Show("Entry Has been Loaded"); } FillGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void BtnDelete_Click(object sender, EventArgs e) { if (GlobalVariables.ProgCode == "PROG152") { var confirmResult = XtraMessageBox.Show("Are you sure to delete this item ??", "Confirm Delete!!", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { var row = ReplGridView.GetDataRow(ReplGridView.FocusedRowHandle); ProjectFunctions.GetDataSet("Delete from ExMst Where ExNo ='" + row["ExNo"].ToString() + "'"); FillGrid(); } } }
private void FillGrid() { var ds = ProjectFunctions.GetDataSet(" SELECT DISTINCT ActMst.AccCode, ActMst.AccName FROM InvoiceMst left outer join ActMst ON InvoiceMst.ImPartyCode = ActMst.AccCode WHERE (InvoiceMst.ImType = 'S') and Imdate between '"+ Convert.ToDateTime(DtStartDate.Text).ToString("yyyy-MM-dd") + "' and '" + Convert.ToDateTime(DtEndDate.Text).ToString("yyyy-MM-dd") + "'"); ds.Tables[0].Columns.Add("Select", typeof(bool)); foreach (DataRow dr in ds.Tables[0].Rows) { dr["Select"] = false; } if (ds.Tables[0].Rows.Count > 0) { ReplGrid.DataSource = ds.Tables[0]; ReplGridView.BestFitColumns(); } }
private void BtnSelectALL_CheckedChanged(object sender, EventArgs e) { var MaxRow = ((ReplGrid.FocusedView as GridView).RowCount); if (btnSelectALL.Checked == true) { for (var i = 0; i < MaxRow; i++) { ReplGridView.SetRowCellValue(i, "Select", "True"); } } if (btnSelectALL.Checked == false) { for (var i = 0; i < MaxRow; i++) { ReplGridView.SetRowCellValue(i, "Select", "False"); } } }
private void FillGrid() { //DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); //SplashScreenManager.Default.SetWaitFormDescription("Fetching Data"); var qr = " sp_LoadAdvanceMst '" + Convert.ToDateTime(DtStartDate.Text).ToString("yyyy-MM-dd") + "', '" + Convert.ToDateTime(DtEndDate.Text).ToString("yyyy-MM-dd") + "'"; var ds = ProjectFunctions.GetDataSet(qr); if (ds.Tables[0].Rows.Count > 0) { ReplGrid.DataSource = ds.Tables[0]; ReplGridView.BestFitColumns(); btnEdit.Enabled = true; } else { ReplGrid.DataSource = null; btnEdit.Enabled = false; } //SplashScreenManager.CloseForm(); }