public void LoadDepartmentSpread()
{
try
{
FpDeptment.Visible = false;
btnSave.Visible = false;
string dayorder = "";
string sel_edu_level = "";
if (ddlBatch.Items.Count > 0)
{
batchyear = Convert.ToString(ddlBatch.SelectedItem.Text);
}
if (rblCourse.Items.Count == 0)
{
lbl_popuperr.Text = "No Records Found";
imgdiv2.Visible = true;
return;
}
else if (ddlDays.Items.Count == 0)
{
lbl_popuperr.Text = "No Days are Found";
imgdiv2.Visible = true;
return;
}
else
{
if (ddlDays.SelectedValue.ToString() == "0" || ddlDays.SelectedValue.ToString() == "-1")
{
lbl_popuperr.Text = "Please Select Other Than Sunday and Empty";
imgdiv2.Visible = true;
return;
}
dayorder = Convert.ToString(ddlDays.SelectedValue);
sel_edu_level = Convert.ToString(rblCourse.SelectedItem.Text);
//and r.degree_code=45
//select distinct (c.Course_Name+'-'+ dpt.dept_acronym) as dept,dg.Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration,r.Current_Semester,r.Sections from Degree dg,course c,Department dpt,Registration r where r.college_code=dg.college_code and r.degree_code=dg.Degree_Code and c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and r.delflag=0 and r.cc=0 and r.exam_flag<>'debar' and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' and Batch_Year="'+batchyear+'" order by r.batch_year desc,current_semester asc, dg.degree_code,r.Sections asc;
//qry = "select distinct Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration from Degree dg,course c,Department dpt where c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' order by Course_Name; select * from PeriodAttndScheduleNew where DayOrder='" + dayorder + "'";
qry = "select distinct (c.Course_Name+'-'+ dpt.dept_acronym) as dept,r.batch_year,dg.Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration,r.Current_Semester,r.Sections from Degree dg,course c,Department dpt,Registration r where r.college_code=dg.college_code and r.degree_code=dg.Degree_Code and c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and r.delflag=0 and r.cc=0 and r.exam_flag<>'debar' and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' and Batch_Year='" + batchyear + "' order by r.batch_year desc,r.current_semester asc, dg.degree_code,r.Sections asc; select * from PeriodAttndScheduleNew where DayOrder='" + dayorder + "' and batch_year='" + batchyear + "'";
ds = d2.select_method_wo_parameter(qry, sptype);
if (ds.Tables[0].Rows.Count > 0)
{
FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo();
style2.Font.Size = FontUnit.Medium;
style2.Font.Name = "Book Antiqua";
style2.Font.Bold = false;
style2.HorizontalAlign = HorizontalAlign.Center;
style2.VerticalAlign = VerticalAlign.Middle;
style2.ForeColor = System.Drawing.Color.Black;
FarPoint.Web.Spread.DoubleCellType dblcell = new FarPoint.Web.Spread.DoubleCellType();
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType chkeach = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.IntegerCellType intgrcell = new FarPoint.Web.Spread.IntegerCellType();
intgrcell.ErrorMessage = "Enter Positive Integer Values Only";
intgrcell.MinimumValue = 0;
chkall.AutoPostBack = true;
FpDeptment.Sheets[0].RowCount = 0;
FpDeptment.Sheets[0].AutoPostBack = false;
FpDeptment.Sheets[0].RowCount++;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 1].CellType = chkall;
FpDeptment.Sheets[0].SpanModel.Add(FpDeptment.Sheets[0].RowCount - 1, 2, 1, 12);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].Locked = true;
FpDeptment.Sheets[0].FrozenRowCount = 1;
FpDeptment.Sheets[0].FrozenColumnCount = 7;
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
FpDeptment.Sheets[0].RowCount++;
//int noofsec = 0;
//int.TryParse(Convert.ToString(ds.Tables[0].Rows[row]["NoofSections"]), out noofsec);
string degree_code = Convert.ToString(ds.Tables[0].Rows[row]["Degree_Code"]);
string sem = Convert.ToString(ds.Tables[0].Rows[row]["Current_Semester"]);
string sec = Convert.ToString(ds.Tables[0].Rows[row]["Sections"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 1].CellType = chkeach;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 2].Text = batchyear;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["Course_Name"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].Tag = Convert.ToString(degree_code);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[row]["Dept_Name"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(ds.Tables[0].Rows[row]["Current_Semester"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(ds.Tables[0].Rows[row]["Sections"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].CellType = intgrcell;
if (ds.Tables.Count == 2)
{
if (ds.Tables[1].Rows.Count > 0)
{
ds.Tables[1].DefaultView.RowFilter = "Degree_Code='" + degree_code + "' and semester='" + sem + "' and section='" + sec + "'";
DataView dv = new DataView();
dv = ds.Tables[1].DefaultView;
if (dv.Count > 0)
{
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dv[0]["No_of_hrs_per_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dv[0]["no_of_hrs_I_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(dv[0]["no_of_hrs_II_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].Text = Convert.ToString(dv[0]["min_pres_I_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].Text = Convert.ToString(dv[0]["min_pres_II_half_day"]);
}
}
}
//if (noofsec == 0)
//{
// FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = "";
//}
//else if (noofsec == 1)
//{
// FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = "A";
//}
//else if (noofsec > 1)
//{
//}
}
FpDeptment.Visible = true;
btnSave.Visible = true;
}
else
{
FpDeptment.Visible = false;
btnSave.Visible = false;
lbl_popuperr.Text = "No Departments were Found for " + sel_edu_level;
imgdiv2.Visible = true;
return;
}
}
FpDeptment.Sheets[0].PageSize = FpDeptment.Sheets[0].RowCount;
FpDeptment.Height = (FpDeptment.Sheets[0].RowCount * 28) + 120;
FpDeptment.SaveChanges();
}
catch (Exception ex)
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
int val = 0;
int selcount = 0;
string degreecode = "";
string dayorder = "", batchyear = "", sem = "", sec = "";
qry = "";
FpDeptment.SaveChanges();
string nofHours = "", totfHalf = "", totSHalf = "", minFHalf = "", minSHalf = "";
int noofhours1 = 0, totfHalf1 = 0, totSHalf1 = 0, minFHalf1 = 0, minSHalf1 = 0;
if (ddlDays.Items.Count == 0)
{
lbl_popuperr.Text = "No Days are Found";
imgdiv2.Visible = true;
return;
}
else if (ddlDays.Items.Count > 0 && rblCourse.Items.Count > 0)
{
//rblCourse.Items.Count == 0
if (ddlDays.SelectedValue.ToString() == "0" || ddlDays.SelectedValue.ToString() == "-1")
{
lbl_popuperr.Text = "Please Select Other Than Sunday and Empty";
imgdiv2.Visible = true;
return;
}
if (FpDeptment.Sheets[0].RowCount > 0)
{
FpDeptment.SaveChanges();
dayorder = Convert.ToString(ddlDays.SelectedValue);
for (int row = 1; row < FpDeptment.Sheets[0].RowCount; row++)
{
val = Convert.ToInt32(FpDeptment.Sheets[0].Cells[row, 1].Value);
if (val == 1)
{
selcount++;
batchyear = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 2].Text);
degreecode = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 3].Tag);
sem = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 5].Text);
sec = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 6].Text);
nofHours = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 7].Text);
totfHalf = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 8].Text);
totSHalf = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 9].Text);
minFHalf = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 10].Text);
minSHalf = Convert.ToString(FpDeptment.Sheets[0].Cells[row, 11].Text);
qry += "if exists(select * from PeriodAttndScheduleNew where degree_code='" + degreecode + "' and DayOrder='" + dayorder + "' and batch_year='" + batchyear + "' and semester='" + sem + "' and section='" + sec + "') update PeriodAttndScheduleNew set DayOrder='" + dayorder + "',No_of_hrs_per_day='" + nofHours + "',no_of_hrs_I_half_day='" + totfHalf + "',no_of_hrs_II_half_day='" + totSHalf + "',min_pres_I_half_day='" + minFHalf + "',min_pres_II_half_day='" + minSHalf + "', batch_year='" + batchyear + "' , semester='" + sem + "' , section='" + sec + "' where degree_code='" + degreecode + "' and DayOrder='" + dayorder + "' and batch_year='" + batchyear + "' and semester='" + sem + "' and section='" + sec + "' else insert into PeriodAttndScheduleNew (degree_code,DayOrder,No_of_hrs_per_day,no_of_hrs_I_half_day,no_of_hrs_II_half_day,min_pres_I_half_day,min_pres_II_half_day,batch_year,semester,section) values ('" + degreecode + "','" + dayorder + "','" + nofHours + "','" + totfHalf + "','" + totSHalf + "','" + minFHalf + "','" + minSHalf + "','" + batchyear + "','" + sem + "','" + sec + "')";
}
}
int inserted = 0;
if (selcount > 0)
{
inserted = d2.update_method_wo_parameter(qry, sptype);
}
if (selcount == 0)
{
lbl_popuperr.Text = "Please Select Atleast one Record";
imgdiv2.Visible = true;
return;
}
else if (inserted > 0)
{
lbl_popuperr.Text = "Saved Successfully";
imgdiv2.Visible = true;
}
else
{
lbl_popuperr.Text = "Not Saved Successfully";
imgdiv2.Visible = true;
return;
}
}
}
LoadDepartmentSpread();
}
catch (Exception ex)
{
}
}
