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"];
}
}
}
}
