protected void btn_Cat_Click(object sender, EventArgs e)
{
try {
SqlCommand cmd = new SqlCommand("select * from tbl_BookCategory where cat_name='" + txt_cat.Text + "' and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", conn);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adpt.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{
ShowMessage("This category is already exists.");
ds.Clear();
}
else
{
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into tbl_BookCategory " +
"(cat_id,cat_name,cat_val,entry_dt,entry_by,mac_id,school_code,branch) " +
"values('" + Global_Class.GenerateID("select count(*) from tbl_BookCategory where " +
"school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CAT/").ToString() + "'," +
"'" + txt_cat.Text + "','" + Global_Class.Drp_val_gen("select count(*) from tbl_BookCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", 0).ToString() + "','" + DateTime.Now.ToString("dd/MM/yyyy") + "','" + Session["uname"] + "','" + Global_Class.getFormatMac(Global_Class.GetMACAddress()) + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "') ";
cmd.Connection = conn;
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
cmd.ExecuteNonQuery();
ShowMessage("Category saved.");
txt_id.Text = Global_Class.GenerateID("select count(*) from tbl_BookCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CAT/");
txt_sub_id.Text = Global_Class.GenerateID("select count(*) from tbl_BookSubCategory where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/SUBCAT/");
fillcategory();
FillCatGrid();
FillSubCatGrid();
txt_cat.Text = String.Empty;
txt_sub_cat.Text = String.Empty;
}
}
catch (Exception ex) { ex.ToString(); }
}
protected void btn_class_add_Click(object sender, EventArgs e)
{
try {
SqlCommand CheckSub = new SqlCommand();
CheckSub.Connection = conn;
CheckSub.CommandType = CommandType.Text;
CheckSub.CommandText = "SELECT COUNT(*) FROM CLASSFILE WHERE CLASSNAME = '" + txt_class_name.Text + "' and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "' ";
int SubExists = (int)CheckSub.ExecuteScalar();
if (SubExists > 0)
{
ShowMessage("This class is already exists.");
}
else
{
if (int.Parse(txt_class_name.Text) > 12)
{
ShowMessage("This class is not valid.");
txt_class_name.Text = "";
}
else
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into CLASSFILE" +
" (CLASSCODE,CLASSNAME,CLASS_VAL,school_code,branch)" +
" VALUES('" + txt_class_code.Text + "','" + txt_class_name.Text + "','" + Global_Class.Drp_val_gen("select count(*) from CLASSFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", 0).ToString() + "','" + Session["schoolcode"].ToString() + "','" + Session["Branch"].ToString() + "')";
cmd.ExecuteNonQuery();
ShowMessage("Recorded To The System Successfully");
txt_class_code.Text = Global_Class.GenerateID("select count(*) from CLASSFILE where school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "'", Session["schoolcode"] + "/CLS/");
txt_class_name.Text = "";
}
}
}
catch (Exception ex) { ex.ToString(); }
}