private bool Click_Save() { if (txtSeries.Text != "") { DataSet ds = objdblayer.dsquery("select sr_id,tran_sr,compid from Series where sr_id=" + objBASEFILEDS.Tran_id + " and tran_sr ='" + txtSeries.Text + "' and compid='" + objBASEFILEDS.ObjCompany.Compid + "'"); if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0) { AutoClosingMessageBox.Show("Series already exists", "Validation", 3000); return(false); } else { objBASEFILEDS.HTMAIN["sr_id"] = objBASEFILEDS.Tran_id; objBASEFILEDS.HTMAIN["tran_sr"] = txtSeries.Text; objBASEFILEDS.HTMAIN["prefix"] = txtPrefix.Text; objBASEFILEDS.HTMAIN["suffix"] = txtSuffix.Text; objBASEFILEDS.HTMAIN["validity"] = txtValid.Text; objBASEFILEDS.HTMAIN["compid"] = objBASEFILEDS.ObjCompany.Compid; objBASEFILEDS.HTMAIN["fin_yr"] = objBASEFILEDS.ObjCompany.Fin_yr; objBASEFILEDS.HTMAIN["isdeactive"] = chkDeactivate.Checked; objBASEFILEDS.HTMAIN["deactfrm"] = dtpDate.DtValue.ToString("yyyy/MM/dd"); } } else { AutoClosingMessageBox.Show("Enter Series Name", "Validation", 3000); return(false); } return(true); }
private void LoadView() { DataSet ds = objdblayer.dsquery("select * from OBMAIN where tran_id='" + objBASEFILEDS.Tran_id + "' and compid='" + objBASEFILEDS.ObjCompany.Compid + "' "); if (objBASEFILEDS.Tran_mode == "view_mode") { foreach (DataGridViewRow row in dgvOpenDuties.Rows) { if (row.Cells["row_col"].Value.ToString() == "RG23A") { objBASEFILEDS.HTMAIN["ob_rg23a_ex_amt"] = ds.Tables[0].Rows[0]["ob_rg23a_ex_amt"]; objBASEFILEDS.HTMAIN["ob_rg23a_cess_amt"] = ds.Tables[0].Rows[0]["ob_rg23a_cess_amt"]; objBASEFILEDS.HTMAIN["ob_rg23a_hcess_amt"] = ds.Tables[0].Rows[0]["ob_rg23a_hcess_amt"]; objBASEFILEDS.HTMAIN["ob_rg23a_add_amt"] = ds.Tables[0].Rows[0]["ob_rg23a_add_amt"]; } if (row.Cells["row_col"].Value.ToString() == "RG23C") { objBASEFILEDS.HTMAIN["ob_rg23c_ex_amt"] = ds.Tables[0].Rows[0]["ob_rg23c_ex_amt"]; objBASEFILEDS.HTMAIN["ob_rg23c_cess_amt"] = ds.Tables[0].Rows[0]["ob_rg23c_cess_amt"]; objBASEFILEDS.HTMAIN["ob_rg23c_hcess_amt"] = ds.Tables[0].Rows[0]["ob_rg23c_hcess_amt"]; objBASEFILEDS.HTMAIN["ob_rg23c_add_amt"] = ds.Tables[0].Rows[0]["ob_rg23c_add_amt"]; } if (row.Cells["row_col"].Value.ToString() == "ST") { objBASEFILEDS.HTMAIN["ob_st_ex_amt"] = ds.Tables[0].Rows[0]["ob_st_ex_amt"]; objBASEFILEDS.HTMAIN["ob_st_cess_amt"] = ds.Tables[0].Rows[0]["ob_st_cess_amt"]; objBASEFILEDS.HTMAIN["ob_st_hcess_amt"] = ds.Tables[0].Rows[0]["ob_st_hcess_amt"]; objBASEFILEDS.HTMAIN["ob_st_add_amt"] = ds.Tables[0].Rows[0]["ob_st_add_amt"]; } if (row.Cells["row_col"].Value.ToString() == "PLA") { objBASEFILEDS.HTMAIN["ob_pla_ex_amt"] = ds.Tables[0].Rows[0]["ob_pla_ex_amt"]; objBASEFILEDS.HTMAIN["ob_pla_cess_amt"] = ds.Tables[0].Rows[0]["ob_pla_cess_amt"]; objBASEFILEDS.HTMAIN["ob_pla_hcess_amt"] = ds.Tables[0].Rows[0]["ob_pla_hcess_amt"]; objBASEFILEDS.HTMAIN["ob_pla_add_amt"] = ds.Tables[0].Rows[0]["ob_pla_add_amt"]; } } } }