protected void btn_deptpartmentsave_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("DeptCode");
dt.Columns.Add("DeptName");
DataRow dr;
if (dptgrid.Rows.Count > 0)
{
for (int ik = 0; ik < dptgrid.Rows.Count; ik++)
{
if ((dptgrid.Rows[ik].FindControl("cbcheck") as CheckBox).Checked == true)
{
dr = dt.NewRow();
dr[0] = Convert.ToString((dptgrid.Rows[ik].FindControl("lbldeptcode") as Label).Text);
dr[1] = Convert.ToString((dptgrid.Rows[ik].FindControl("lbldeptname") as Label).Text);
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
SelectdptGrid.DataSource = dt;
SelectdptGrid.DataBind();
Newdiv.Visible = false;
SelectdptGrid.Visible = true;
}
else
{
imgdiv2.Visible = true;
lbl_alert.Text = "Please Select Any Record";
}
}
}
catch
{
}
}
protected void Fpspread1_render(object sender, EventArgs e)
{
try
{
if (check == true)
{
poperrjs.Visible = true;
string activerow = "";
string activecol = "";
activerow = Fpspread1.ActiveSheetView.ActiveRow.ToString();
activecol = Fpspread1.ActiveSheetView.ActiveColumn.ToString();
collegecode = Session["collegecode"].ToString();
if (activerow.Trim() != "")
{
//year();
string storeacr = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Text);
string storename = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 2].Text);
string Store_PK = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Tag);
Session["StorePK"] = Convert.ToString(Store_PK);
string year1 = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 3].Text);
string depcode = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Tag);
txt_storename.Text = Convert.ToString(storename);
txt_storeacr.Text = Convert.ToString(storeacr);
txt_startyear.Text = year1;
//if (year1.Trim() != "")
//{
// int index = Convert.ToInt32(yearhash[Convert.ToString(year1)]);
// ddl_startyear.SelectedIndex = index;
//}
if (depcode.Trim() != "" && depcode.Trim() != null)
{
string selectquery = "select Dept_Code as DeptCode ,Dept_Name as DeptName from Department where Dept_Code in (" + depcode + ") and college_code ='" + collegecode + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(selectquery, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
SelectdptGrid.DataSource = ds;
SelectdptGrid.DataBind();
SelectdptGrid.Visible = true;
}
else
{
ds = null;
SelectdptGrid.DataSource = ds;
SelectdptGrid.DataBind();
SelectdptGrid.Visible = false;
}
}
else
{
ds = null;
SelectdptGrid.DataSource = ds;
SelectdptGrid.DataBind();
SelectdptGrid.Visible = false;
}
btn_save.Visible = false;
btn_update.Visible = true;
btn_delete.Visible = true;
}
}
}
catch
{
}
}
