private void buttonSave_Click(object sender, EventArgs e)
{
Global.branch = comboBox1.SelectedValue.ToString();
Global.finyr = comboBox2.SelectedValue.ToString();
// StatusStrip usrname = MainMenu();
// usrname.Text = "Branch: "+Global.branch;
this.Close();
//frmMain frm = new frmMain();
//frm.Show();
SqlCommand cmd = new SqlCommand();
SqlDataReader Sread;
string qry = "select DtFrom,DtTo from TblControl where BrCode='" + Global.branch + "' and FInYr='" + Global.finyr + "'";
cmd.CommandText = qry;
cmd.Connection = clsConnection.Conn;
Sread = cmd.ExecuteReader();
while (Sread.Read())
{
if (!Sread.IsDBNull(0))
{
Global.gFromDt = Convert.ToDateTime(Sread.GetValue(0));
Global.gToDt = Convert.ToDateTime(Sread.GetValue(1));
}
}
Sread.Close();
cmd.Dispose();
}
public DataTable LoadValue(string Criteria, string Value)
{
DataTable dt = new DataTable();
SqlCommand cmd12 = new SqlCommand();
SqlDataReader Sread;
if (Value != "")
{
sql = "select Finyr,BrCode,GLID,SLID,SL_L_NAME,SLADD1,SLADD2,SLCITY,SLPIN,SLFAX,SLPHONE,SLCONT_PERS,REMARKS,OP_BAL,STATUS,GSTIN from TblSLMast Where " + Criteria + " = '" + Value + "' and finyr= '" + clsVar.finYr + "' order by SL_L_Name";
}
else
{
sql = "select Finyr,BrCode,GLID,SLID,SL_L_NAME,SLADD1,SLADD2,SLCITY,SLPIN,SLFAX,SLPHONE,SLCONT_PERS,REMARKS,OP_BAL,STATUS,GSTIN from TblSLMast Where " + Criteria + " Like '" + Value + "%' '" + clsVar.finYr + "' order by SL_L_Name";
}
cmd12.CommandText = sql;
cmd12.Connection = clsConnection.ConnItem;
Sread = cmd12.ExecuteReader();
dt = (clsVar.ConvertToDataTable(Sread, 15));
Sread.Close();
cmd12.Dispose();
return(dt);
}
public DataTable LoadValue(string Criteria, string Value)
{
DataTable dt = new DataTable();
SqlCommand cmd12 = new SqlCommand();
SqlDataReader Sread;
if (Value != "")
{
sql = "select finyr,BrCode,GLID,GL_L_Name,PL_BS_ID, ANYSL,op_bal from TblGLMast Where " + Criteria + " = '" + Value + "' and finyr= '" + clsVar.finYr + "' order by GL_L_Name";
}
else
{
sql = "select finyr,BrCode,GLID,GL_L_Name,PL_BS_ID, ANYSL,op_bal from TblGLMast Where " + Criteria + " Like '" + Value + "%' '" + clsVar.finYr + "' order by GL_L_Name";
}
cmd12.CommandText = sql;
cmd12.Connection = clsConnection.ConnItem;
Sread = cmd12.ExecuteReader();
dt = (clsVar.ConvertToDataTable(Sread, 7));
Sread.Close();
cmd12.Dispose();
return(dt);
}
public DataTable GetSL(string vGLID)
{
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
SqlDataReader Sread;
cmd.CommandText = "select SLID,SL_L_NAME from TblSLMast Where GLID = '" + vGLID + "' and finyr='" + Global.finyr + "' and BrCode='" + Global.branch + "' order by GL_L_Name";
cmd.Connection = clsConnection.Conn;
Sread = cmd.ExecuteReader();
dt = (clsVar.ConvertToDataTable(Sread, 2));
Sread.Close();
cmd.Dispose();
return(dt);
}
public clsGLBO GetValue(string vGLID)
{
clsGLBO GlBO = new clsGLBO();
SqlCommand cmd = new SqlCommand();
SqlDataReader Sread;
cmd.CommandText = "select finyr,BrCode,GLID,GL_L_Name,PL_BS_ID, ANYSL,op_bal,Narration from TblGLMast Where GLID = '" + vGLID + "' and finyr='" + Global.finyr + "' order by GL_L_Name";
cmd.Connection = clsConnection.Conn;
Sread = cmd.ExecuteReader();
while (Sread.Read())
{
if (!Sread.IsDBNull(0))
{
GlBO.SetValue(Convert.ToString(Sread.GetValue(0)), Convert.ToString(Sread.GetValue(1)), Convert.ToString(Sread.GetValue(2)), Convert.ToString(Sread.GetValue(3)), Convert.ToInt32(Sread.GetValue(4)), Convert.ToInt32(Sread.GetValue(5)), Convert.ToDouble(Sread.GetValue(6)), Convert.ToString(Sread.GetValue(7)));
}
}
Sread.Close();
cmd.Dispose();
return(GlBO);
}
public clsSLBO GetValue(string vSLID)
{
clsSLBO SlBO = new clsSLBO();
SqlCommand cmd = new SqlCommand();
SqlDataReader Sread;
//Double tmp_op_bal = 0;
cmd.CommandText = "select Finyr,BrCode,GLID,SLID,SL_L_NAME,SLADD1,SLADD2,SLCITY,SLPIN,SLFAX,SLPHONE,SLCONT_PERS,REMARKS,OP_BAL,STATUS,GSTIN from TblSLMast Where SLID = '" + vSLID + "' and finyr='" + Global.finyr + "' and BrCode='" + Global.branch + "' order by SL_L_Name";
cmd.Connection = clsConnection.Conn;
Sread = cmd.ExecuteReader();
while (Sread.Read())
{
if (!Sread.IsDBNull(0))
{
//tmp_op_bal = Convert.ToDouble(string.IsNullOrEmpty(Sread.GetValue(13).ToString()) ? 0 : Sread.GetValue(13));
SlBO.SetValue(Convert.ToString(Sread.GetValue(0)), Convert.ToString(Sread.GetValue(1)), Convert.ToString(Sread.GetValue(2)), Convert.ToString(Sread.GetValue(3)), Convert.ToString(Sread.GetValue(4)), Convert.ToString(Sread.GetValue(5)), Convert.ToString(Sread.GetValue(6)), Convert.ToString(Sread.GetValue(7)), Convert.ToString(Sread.GetValue(8)), Convert.ToString(Sread.GetValue(9)), Convert.ToString(Sread.GetValue(10)), Convert.ToString(Sread.GetValue(11)), Convert.ToString(Sread.GetValue(12)), Convert.ToDouble(string.IsNullOrEmpty(Sread.GetValue(13).ToString()) ? 0 : Sread.GetValue(13)), Convert.ToString(Sread.GetValue(14)), Convert.ToString(Sread.GetValue(15)));
}
}
Sread.Close();
cmd.Dispose();
return(SlBO);
}
