protected void btn_go_OnClick(object sender, EventArgs e)
{
try
{
#region Order by
string orderby_Setting = d2.GetFunction("select value from master_Settings where settings='order_by'");
string strorder = ",len(r.roll_no)";
if (orderby_Setting == "0")
{
strorder = ",len(r.roll_no)";
}
else if (orderby_Setting == "1")
{
strorder = ",len(r.Reg_No)";
}
else if (orderby_Setting == "2")
{
strorder = ",r.Stud_Name";
}
else if (orderby_Setting == "0,1,2")
{
strorder = ",len(r.roll_no),len(r.Reg_No),r.stud_name";
}
else if (orderby_Setting == "0,1")
{
strorder = ",len(r.roll_no),len(r.Reg_No)";
}
else if (orderby_Setting == "1,2")
{
strorder = ",len(r.Reg_No),r.Stud_Name";
}
else if (orderby_Setting == "0,2")
{
strorder = ",len(r.roll_no),r.Stud_Name";
}
#endregion
//FarPoint.Web.Spread.TextCellType txt;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
string degreecode = rs.GetSelectedItemsValueAsString(cbl_degree);
string deptcode = rs.GetSelectedItemsValueAsString(cbl_branch);
string batchyear = ddl_batch.SelectedItem.Text;
//string sem = rs.GetSelectedItemsValueAsString(cbl_sem);
DateTime FromDate = new DateTime();
DateTime ToDate = new DateTime();
string[] fromdate = txtfromdate.Text.Split('/');
string[] todate = txttodate.Text.Split('/');
FromDate = Convert.ToDateTime(fromdate[1] + "/" + fromdate[0] + "/" + fromdate[2]);
ToDate = Convert.ToDateTime(todate[1] + "/" + todate[0] + "/" + todate[2]);
if (ddlCatogery.SelectedValue.ToString() == "1")
{
q1 = "select distinct R.Stud_Name ,r.Roll_no,R.Reg_No, Convert(varchar(10),R.batch_year)+' - '+ Convert(varchar(10),c.Course_name)+' - '+de.Acronym+' - '+Convert(varchar(10),R.current_semester) as Degreedet,Convert(varchar(20),re.readm_date,103) as ReadmittedDate ,Convert(varchar(10), re.newbatch_year) +' - ' + Convert(varchar(10),re.Readm_Semester) +' SEM' as ReadmittedSemester from Readmission re,REgistration R,Degree de,Department dep,Course c where R.App_No=re.App_No and c.Course_id=de.Course_id and de.college_code=c.college_code and dep.Dept_code=de.Dept_code and dep.college_code=de.college_code and R.college_code=dep.college_code and R.degree_code=de.Degree_code and c.Course_id IN ('" + degreecode + "') and R.batch_year in ('" + batchyear + "') and dep.dept_code in('" + deptcode + "') and re.Dis_Date between '" + FromDate.ToString("MM/dd/yyyy") + "' and '" + ToDate.ToString("MM/dd/yyyy") + "' and REadmitreason='2' "; //REadmitreason 1 for Prolong Absent Students
}
else if (ddlCatogery.SelectedValue.ToString() == "2")
{
q1 = "select distinct R.Stud_Name ,r.Roll_no,R.Reg_No, Convert(varchar(10),R.batch_year)+' - '+ Convert(varchar(10),c.Course_name)+' - '+de.Acronym+' - '+Convert(varchar(10),R.current_semester) as Degreedet,Convert(varchar(20),re.readm_date,103) as ReadmittedDate ,Convert(varchar(10), re.newbatch_year) +' - ' + Convert(varchar(10),re.Readm_Semester) +' SEM' as ReadmittedSemester from Readmission re,REgistration R,Degree de,Department dep,Course c where R.App_No=re.App_No and c.Course_id=de.Course_id and de.college_code=c.college_code and dep.Dept_code=de.Dept_code and dep.college_code=de.college_code and R.college_code=dep.college_code and R.degree_code=de.Degree_code and c.Course_id IN ('" + degreecode + "') and R.batch_year in ('" + batchyear + "') and dep.dept_code in('" + deptcode + "') and re.Dis_Date between '" + FromDate.ToString("MM/dd/yyyy") + "' and '" + ToDate.ToString("MM/dd/yyyy") + "' and REadmitreason='1' "; //REadmitreason 1 for Discontinued Students
}
//q1 += " order by " + strorder.TrimStart(',') + " ";
if (deptcode.Trim() != "" && degreecode.Trim() != "") //&& sem.Trim() != ""
{
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "Text");
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-130/Reg No-150/Degree Details-180/Readmitted Date-120/Semester-140/", FpSpread1, "FALSE");
rs.Fpreadheaderbindmethod("S.No/Student Name/Roll No/Reg No/Degree Details/Readmitted Date/Semester/", FpSpread1, "TRUE");
FpSpread1.Sheets[0].Rows.Count++;
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count - 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count - 1);
// FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(dr["degree_code"]);
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[4].Visible = true;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["Stud_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["Roll_no"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Degreedet"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["ReadmittedDate"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["ReadmittedSemester"]);
FarPoint.Web.Spread.TextCellType txtclType = new FarPoint.Web.Spread.TextCellType();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].CellType = txtclType;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Columns[7].Visible = false;
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
print.Visible = true;
}
else
{
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All Fields";
}
}
catch { }
}
protected void btn_go_OnClick(object sender, EventArgs e)
{
try
{
string deptcode = rs.GetSelectedItemsValueAsString(cbl_degree);
string degreecode = rs.GetSelectedItemsValueAsString(cbl_branch);
string batch = rs.GetSelectedItemsValueAsString(cbl_batch);
string housepk = rs.GetSelectedItemsValueAsString(cb1_housing);
if (deptcode.Trim() != "" && degreecode.Trim() != "" && batch.Trim() != "" && !string.IsNullOrEmpty(housepk.Trim()))
{
rs.Fpreadheaderbindmethod("S.No-50/House Name-100/Student Name-200/Roll No-150/Reg No-150/Admission No-150/Gender-90/Section-70/" + lbl_degreeT.Text + "-100/" + lbl_branchT.Text + "-200/ Semester-100", FpSpread1, "FALSE");
q1 = "select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections,hd.housename from Registration r, degree d,Department dt,Course C,applyn a inner join HousingDetails hd on a.studhouse=hd.housePK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and hd.housePK in('" + housepk + "')";
string type = string.Empty;
switch (Convert.ToUInt32(ddl_searchtype.SelectedValue))
{
case 0:
type = "r.roll_no";
break;
case 1:
type = "r.reg_no";
break;
case 2:
type = "r.Roll_Admit";
break;
case 3:
type = "r.app_no";
break;
}
if (txt_searchappno.Text.Trim() != "")
{
q1 += " and " + type + "='" + txt_searchappno.Text.Trim() + "'";
}
else
{
q1 += " and r.degree_code in('" + degreecode + "')and r.Batch_Year in('" + batch + "') and c.Course_Id in('" + deptcode + "') and r.college_code='" + Convert.ToString(ddlcollege.SelectedItem.Value) + "' ";
}
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count);
FpSpread1.Sheets[0].Columns[3].Visible = false;
FpSpread1.Sheets[0].Columns[4].Visible = false;
FpSpread1.Sheets[0].Columns[5].Visible = false;
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[4].Visible = true;
}
if (Convert.ToString(Session["Admissionflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[5].Visible = true;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["housename"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["stud_name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["roll_no"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Reg_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["Roll_Admit"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sex"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["sections"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Course_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(dr["Dept_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Text = Convert.ToString(dr["Current_Semester"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Name = "Book Antiqua";
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
rptprint.Visible = true;
}
else
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All The Fields";
}
}
catch (Exception f)
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = f.ToString();
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
string departmentcode = rs.GetSelectedItemsValueAsString(cbl_dept);
string designationcode = rs.GetSelectedItemsValueAsString(cbl_desig);
string category = rs.GetSelectedItemsValueAsString(cbl_staffc);
string stafftype = rs.GetSelectedItemsValueAsString(cbl_stype);
string collegecode = rs.GetSelectedItemsValueAsString(cblclg);
string JoiningDateF = string.Empty;
string JoiningDateT = string.Empty;
DateTime JoiningDateFDt = new DateTime();
DateTime JoiningDateTDt = new DateTime();
DateTime.TryParse(ddl_month.SelectedItem.Value + "/01/" + ddl_year.SelectedItem.Text, out JoiningDateFDt);
int totaldays = DateTime.DaysInMonth(Convert.ToInt32(ddl_year.SelectedItem.Value), Convert.ToInt32(ddl_month.SelectedItem.Value));
DateTime.TryParse(ddl_month.SelectedItem.Value + "/" + totaldays + "/" + ddl_year.SelectedItem.Text, out JoiningDateTDt);
JoiningDateF = Convert.ToString(JoiningDateFDt.ToString("MM/dd/yyyy"));
JoiningDateT = Convert.ToString(JoiningDateTDt.ToString("MM/dd/yyyy"));
string prevMonth = string.Empty;
string prevYear = string.Empty;
if (ddl_month.SelectedIndex - 1 != -1)
{
prevMonth = Convert.ToString(ddl_month.Items[ddl_month.SelectedIndex - 1].Value);
prevYear = Convert.ToString(ddl_year.SelectedValue);
}
else
{
prevMonth = Convert.ToString(ddl_month.Items[11].Value);
prevYear = Convert.ToString(Convert.ToInt32(ddl_year.SelectedValue) - 1);
}
string staffnameQ = string.Empty;
string staffcodeQ = string.Empty;
string Catagory = string.Empty;
double value = 0;
double val = 0;
if (txt_sname.Text.Trim() != "")
{
staffnameQ = " and m.staff_name='" + txt_sname.Text.Trim() + "'";
}
if (txt_scode.Text.Trim() != "")
{
staffcodeQ = " and m.staff_code='" + txt_scode.Text.Trim() + "'";
}
string Qry = "select sum(netaddact)netaddact,count(t.staff_code)staffCount, p.category_code,p.PayMonth,p.PayYear,CONVERT(varchar(10),m.join_date,103) join_date,m.join_date as join_dateD,m.relieve_date,ISNULL(m.settled,0)settled,ISNULL(m.resign,0)resign from stafftrans t,staffmaster m,hrdept_master h,desig_master g,staffcategorizer c,monthlypay p where p.staff_code=t.staff_code and p.staff_code=m.staff_code and t.staff_code = m.staff_code and t.dept_code = h.dept_code and t.desig_code = g.desig_code and t.category_code = c.category_code and m.college_code = h.college_code and m.college_code = g.collegeCode and m.college_code = c.college_code and t.latestrec = 1 and ISNULL(Discontinue,'0')='0' and ISNULL(PayYear,-1)<>-1 and ISNULL(PayMonth,-1)<>-1 and m.college_code in( '" + collegecode + "') and h.dept_code in('" + departmentcode + "') and g.desig_code in('" + designationcode + "') and c.category_code in('" + category + "') and t.stftype in('" + stafftype + "') and ((PayMonth >= '" + prevMonth + "' and PayYear = '" + prevYear + "') or (PayMonth <='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "' )) " + staffnameQ + "" + staffcodeQ + " group by p.category_code ,p.PayMonth,p.PayYear ,join_date,m.settled,m.resign,m.relieve_date";
ds = d2.select_method_wo_parameter(Qry, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
string CurrentMonthYear = Convert.ToString(ddl_month.SelectedItem.Text + " " + ddl_year.SelectedItem.Text);
string previousMonthyear = string.Empty;
if (ddl_month.SelectedIndex - 1 != -1)
{
previousMonthyear = Convert.ToString(ddl_month.Items[ddl_month.SelectedIndex - 1].Text) + " " + ddl_year.SelectedItem.Text;
}
else
{
previousMonthyear = Convert.ToString(ddl_month.Items[11].Text) + " " + Convert.ToString(Convert.ToInt32(ddl_year.SelectedValue) - 1);
}
#region SalaryBill
string headername = "S.No/Particulars";
rs.Fpreadheaderbindmethod(headername, FpSpread, "true");
bool colfirstEntry = false;
FpSpread.Sheets[0].ColumnCount++;
if (cbl_staffc.Items.Count > 0)
{
for (int i = 0; i < cbl_staffc.Items.Count; i++)
{
if (cbl_staffc.Items[i].Selected == true)
{
if (colfirstEntry)
{
FpSpread.Sheets[0].ColumnCount++;
}
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = Convert.ToString(cbl_staffc.Items[i].Text);
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(cbl_staffc.Items[i].Value);
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
colfirstEntry = true;
}
}
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Total";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Tag = "T";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread.Sheets[0].RowCount);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = "Salary Earned (Actual)";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
string categoryF = string.Empty;
for (int i = 2; i < FpSpread.Sheets[0].ColumnCount; i++)
{
Catagory = Convert.ToString(FpSpread.Sheets[0].ColumnHeader.Cells[0, i].Tag);
if (Catagory != "T")
{
categoryF = " and category_code='" + Catagory + "'";
}
else
{
categoryF = "";
}
double categorywiseSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", "PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "'" + categoryF)), out categorywiseSalary);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].Text = Convert.ToString(categorywiseSalary);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = "Deductions";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].ForeColor = Color.Maroon;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Bold = true;
DataTable deductionDt = new DataTable();
deductionDetails(collegecode, ref deductionDt);
if (deductionDt.Rows.Count > 0)
{
int k = 0;
Hashtable TotalHash = new Hashtable();
foreach (DataColumn DeductionColumnName in deductionDt.Columns)
{
if (Convert.ToString(DeductionColumnName) != "category_code")
{
k++;
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(k);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(DeductionColumnName);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
for (int i = 2; i < FpSpread.Sheets[0].ColumnCount; i++)
{
Catagory = Convert.ToString(FpSpread.Sheets[0].ColumnHeader.Cells[0, i].Tag);
if (Catagory != "T")
{
categoryF = "category_code='" + Catagory + "'";
}
else
{
categoryF = "";
}
double.TryParse(Convert.ToString(deductionDt.Compute("Sum([" + DeductionColumnName + "])", categoryF)), out value);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].Text = Convert.ToString(value);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Right;
if (!TotalHash.Contains(Catagory))
{
TotalHash.Add(Catagory, value);
}
else
{
val = 0;
double.TryParse(Convert.ToString(TotalHash[Catagory]), out val);
TotalHash.Remove(Catagory);
TotalHash.Add(Catagory, val + value);
}
}
}
}
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = "Total Deductions";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].ForeColor = Color.Maroon;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Bold = true;
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = "Net Salary";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].ForeColor = Color.Maroon;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Bold = true;
for (int i = 2; i < FpSpread.Sheets[0].ColumnCount; i++)
{
Catagory = Convert.ToString(FpSpread.Sheets[0].ColumnHeader.Cells[0, i].Tag);
double.TryParse(Convert.ToString(TotalHash[Catagory]), out val);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 2, i].Text = Convert.ToString(val);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 2, i].HorizontalAlign = HorizontalAlign.Right;
if (Catagory != "T")
{
categoryF = " and category_code='" + Catagory + "'";
}
else
{
categoryF = "";
}
double categorywiseSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", "PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "'" + categoryF)), out categorywiseSalary);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].Text = Convert.ToString(categorywiseSalary - val);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Right;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].ForeColor = Color.Maroon;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, i].Font.Bold = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 2, i].ForeColor = Color.Maroon;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 2, i].Font.Bold = true;
}
}
}
FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount;
FpSpread.Height = FpSpread.Sheets[0].RowCount * 25 + 200;
sp_div.Visible = true;
txt_sname.Text = "";
txt_scode.Text = "";
#endregion
#region Comparative Statement
headername = "S.No/Details/Previous Month/Current Month/Difference";
rs.Fpreadheaderbindmethod(headername, DeductionDetSp, "true");
DeductionDetSp.Sheets[0].RowCount++;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(DeductionDetSp.Sheets[0].RowCount);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 1].Text = "Total Salary";
double prevSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", "PayMonth ='" + prevMonth + "' and PayYear = '" + prevYear + "'")), out prevSalary);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(prevSalary);
double currentSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", "PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Value + "'")), out currentSalary);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(currentSalary);
double salaryMax = prevSalary > currentSalary ? prevSalary : currentSalary;
double salaryMin = prevSalary < currentSalary ? prevSalary : currentSalary;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(salaryMax - salaryMin);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].RowCount++;
for (int i = 0; i < cbl_staffc.Items.Count; i++)
{
if (cbl_staffc.Items[i].Selected == true)
{
DeductionDetSp.Sheets[0].RowCount++;
double StaffCount = 0;
Catagory = Convert.ToString(cbl_staffc.Items[i].Value);
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([staffCount])", " settled =0 and resign =0 and PayMonth ='" + prevMonth + "' and PayYear = '" + prevYear + "' and category_code='" + Catagory + "'")), out StaffCount);
double NewStaffCount = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([staffCount])", " settled =0 and resign =0 and PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "' and join_dateD >= '" + JoiningDateFDt + "' and join_dateD <= '" + JoiningDateTDt + "' and category_code='" + Catagory + "'")), out NewStaffCount);
double RelievedStaffCount = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([staffCount])", " settled =1 and resign =1 and PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "' and relieve_date >= '" + JoiningDateFDt + "' and relieve_date <= '" + JoiningDateTDt + "' and category_code='" + Catagory + "'")), out RelievedStaffCount);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(Convert.ToString(cbl_staffc.Items[i].Text));
string staffCountDet = Convert.ToString(StaffCount) + " + " + Convert.ToString(NewStaffCount) + " - " + Convert.ToString(RelievedStaffCount);
double currentStaffCount = StaffCount + NewStaffCount - RelievedStaffCount;
double DStaffMax = StaffCount > currentStaffCount ? StaffCount : currentStaffCount;
double DStaffMin = StaffCount < currentStaffCount ? StaffCount : currentStaffCount;
double diffStaffCount = DStaffMax - DStaffMin;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 2].Text = staffCountDet;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(currentStaffCount);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(diffStaffCount);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right;
}
}
double NewJoiningCurrentSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", " settled =0 and resign =0 and PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "' and join_dateD >= '" + JoiningDateFDt + "' and join_dateD <= '" + JoiningDateTDt + "'")), out NewJoiningCurrentSalary);
double relievedCurrentSalary = 0;
double relievedPrevSalary = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", " settled =1 and resign =1 and PayMonth ='" + ddl_month.SelectedItem.Value + "' and PayYear = '" + ddl_year.SelectedItem.Text + "' and relieve_date >= '" + JoiningDateFDt + "' and relieve_date <= '" + JoiningDateTDt + "'")), out relievedCurrentSalary);
double.TryParse(Convert.ToString(ds.Tables[0].Compute("Sum([NetAddAct])", " settled =1 and resign =1 and PayMonth ='" + prevMonth + "' and PayYear = '" + prevYear + "' and relieve_date >= '" + JoiningDateFDt.AddMonths(-1) + "' and relieve_date <= '" + JoiningDateTDt.AddMonths(-1) + "'")), out relievedPrevSalary);
double relievedStaffDifference = relievedPrevSalary - relievedCurrentSalary;
double DsalaryMax = NewJoiningCurrentSalary > relievedStaffDifference ? NewJoiningCurrentSalary : relievedStaffDifference;
double DsalaryMin = NewJoiningCurrentSalary < relievedStaffDifference ? NewJoiningCurrentSalary : relievedStaffDifference;
double difference = DsalaryMax - DsalaryMin;
DeductionDetSp.Sheets[0].RowCount++;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Text = "Newly Joined";
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(NewJoiningCurrentSalary);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].RowCount++;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Text = "Relieved Staff";
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(relievedStaffDifference);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].RowCount++;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Text = "Difference";
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].ForeColor = Color.Maroon;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 3].Font.Bold = true;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(difference);
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].ForeColor = Color.Maroon;
DeductionDetSp.Sheets[0].Cells[DeductionDetSp.Sheets[0].RowCount - 1, 4].Font.Bold = true;
DeductionDetSp.Sheets[0].PageSize = DeductionDetSp.Sheets[0].RowCount;
DeductionDetSp.Height = DeductionDetSp.Sheets[0].RowCount * 25 + 200;
sp_div.Visible = true;
Deduction.Visible = true;
#endregion
}
else
{
Deduction.Visible = false;
sp_div.Visible = false;
lbl_alert.Visible = true;
lbl_alert.Text = "No records founds";
}
}
catch (Exception ex)
{
Deduction.Visible = false;
sp_div.Visible = false;
lbl_alert.Visible = true;
lbl_alert.Text = ex.ToString();
}
}
public void Generalfeedback()
{
try
{
if (ddl_Feedbackname.Text.Trim() != "Select")
{
Printcontrol1.Visible = false; lbl_error.Visible = false;
string header = "S.No/Evaluation Name/Header Name/Questions";
rs.Fpreadheaderbindmethod(header, FpSpread1, "True");
string college_cd = rs.GetSelectedItemsValueAsString(Cbl_college);
string Batch_Year = rs.GetSelectedItemsValueAsString(cbl_batch);
string degree_code = rs.GetSelectedItemsValueAsString(cbl_branch);
string semester = rs.GetSelectedItemsValueAsString(cbl_sem);
string section = rs.GetSelectedItemsValueAsString(cbl_sec);
if (college_cd.Trim() != "" && Batch_Year.Trim() != "" && degree_code.Trim() != "" && semester.Trim() != "")
{
if (section.Trim() != "")
{
section = section + "','";
}
ds.Clear();
// query = " select FeedBackMasterPK,isnull(InclueCommon,0)as FeedBackType,IsType_Individual from CO_FeedBackMaster where FeedBackName ='" + ddl_Feedbackname.SelectedItem.Value + "'";
query = " select FeedBackMasterPK,FeedBackType,IsType_Individual from CO_FeedBackMaster where FeedBackName ='" + ddl_Feedbackname.SelectedItem.Value + "'";
// if (section.Trim() != "")
// {
// query += " and section in ('" + section + "')";
//}
ds.Clear();
ds = d2.select_method_wo_parameter(query, "text");
string FeedBackType = Convert.ToString(ds.Tables[0].Rows[0]["FeedBackType"]);
string feedbakpk = GetdatasetRowstring(ds, "FeedBackMasterPK");
string condition = ""; string condition1 = "";
//if (FeedBackType.Trim() == "0" || FeedBackType.Trim() == "False")
//{
// FeedBackType = "0";
// condition = "FeedbackUnicode";
// condition1 = " and sf.App_No is not null and isnull(sf.FeedbackUnicode,'0')=0 ";
//}
if (FeedBackType.Trim() == "2" || FeedBackType.Trim() == "False")
{
FeedBackType = "2";
condition = "App_No";
condition1 = " and sf.App_No is not null and isnull(sf.FeedbackUnicode,'0')=0 ";
}
if (FeedBackType.Trim() == "1" || FeedBackType.Trim() == "True")
{
condition = "FeedbackUnicode";
FeedBackType = "1";
condition1 = " and sf.FeedbackUnicode is not null and isnull(sf.App_No,'0')=0 ";
}
ds.Clear();
// query = " select distinct f.FeedBackName,TextVal,q.Question,q.HeaderCode,f.FeedBackMasterPK,q.QuestionMasterPK from CO_FeedBackMaster f,CO_StudFeedBack sf,CO_FeedBackQuestions fq ,CO_QuestionMaster q,TextValTable T where f.FeedBackMasterPK=sf.FeedBackMasterFK and q.QuestionMasterPK=fq.QuestionMasterFK and f.FeedBackMasterPK=fq.FeedBackMasterFK and t.TextCode=q.HeaderCode and f.Acadamic_Isgeneral='1' and f.DegreeCode in('" + degree_code + "') and f.CollegeCode in('" + college_cd + "') and f.semester in('" + semester + "') and f.FeedBackMasterPK in('" + feedbakpk + "') and FeedBackType ='" + FeedBackType + "' ";
query = " select distinct f.FeedBackName,TextVal,q.Question,q.HeaderCode,f.FeedBackMasterPK,q.QuestionMasterPK from CO_FeedBackMaster f,CO_StudFeedBack sf,CO_FeedBackQuestions fq ,CO_QuestionMaster q,TextValTable T where f.FeedBackMasterPK=sf.FeedBackMasterFK and q.QuestionMasterPK=fq.QuestionMasterFK and f.FeedBackMasterPK=fq.FeedBackMasterFK and t.TextCode=q.HeaderCode and f.CollegeCode in('" + college_cd + "') and f.FeedBackMasterPK in('" + feedbakpk + "') and FeedBackType ='" + FeedBackType + "' ";
//if (section.Trim() != "")
//{
// query += " and f.Section in('" + section + "')";
//}
query += " select distinct MarkType, MarkMasterPK from CO_MarkMaster where CollegeCode in('" + college_cd + "')";
query += " select sum(Point)Point,COUNT(sf." + condition + ") noofstud ,sf.FeedBackMasterFK,sf.QuestionMasterFK,sf.MarkMasterPK from CO_StudFeedBack sf,CO_MarkMaster m,CO_FeedBackQuestions fq where sf.MarkMasterPK=m.MarkMasterPK and fq.FeedBackMasterFK=sf.FeedBackMasterFK and fq.QuestionMasterFK=sf.QuestionMasterFK and sf.FeedBackMasterFK in('" + feedbakpk + "') " + condition1 + " group by sf.FeedBackMasterFK,sf.QuestionMasterFK,sf.MarkMasterPK ";
query += " select max(m.Point)maximum from CO_StudFeedBack sf,CO_MarkMaster m,CO_FeedBackQuestions fq where sf.MarkMasterPK=m.MarkMasterPK and fq.FeedBackMasterFK=sf.FeedBackMasterFK and fq.QuestionMasterFK=sf.QuestionMasterFK and sf.FeedBackMasterFK in('" + feedbakpk + "') ";
ds = d2.select_method_wo_parameter(query, "Text");
if (ds.Tables != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0 && ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread1.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(dr["MarkType"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(dr["MarkMasterPK"]);
FpSpread1.Sheets[0].Columns[FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Total";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Percentage";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center;
double total = 0; double point = 0; double sumofstud = 0; double totalsumofstud = 0; double maximummark = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[i, 0].Text = Convert.ToString(i + 1);
FpSpread1.Sheets[0].Cells[i, 1].Text = ds.Tables[0].Rows[i]["FeedBackName"].ToString();
FpSpread1.Sheets[0].Cells[i, 2].Text = ds.Tables[0].Rows[i]["TextVal"].ToString();
FpSpread1.Sheets[0].Cells[i, 3].Text = ds.Tables[0].Rows[i]["Question"].ToString();
total = 0; totalsumofstud = 0;
for (int r = 4; r < FpSpread1.Sheets[0].ColumnHeader.Columns.Count - 2; r++)
{
string markfk = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, r].Tag);
ds.Tables[2].DefaultView.RowFilter = " FeedBackMasterFK='" + Convert.ToString(ds.Tables[0].Rows[i]["FeedBackMasterPK"]) + "' and QuestionMasterFK='" + Convert.ToString(ds.Tables[0].Rows[i]["QuestionMasterPK"]) + "' and MarkMasterPK='" + markfk + "'";
point = 0;
DataView dv = new DataView();
ds.Tables[2].DefaultView.RowFilter = "FeedBackMasterFK='" + Convert.ToString(ds.Tables[0].Rows[i]["FeedBackMasterPK"]) + "' and QuestionMasterFK='" + Convert.ToString(ds.Tables[0].Rows[i]["QuestionMasterPK"]) + "' and MarkMasterPK='" + markfk + "' ";
dv = ds.Tables[2].DefaultView;
if (dv.Count > 0)
{
double.TryParse(Convert.ToString(dv[0]["point"]), out point);
double.TryParse(Convert.ToString(dv[0]["noofstud"]), out sumofstud);
totalsumofstud += sumofstud;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, r].Text = Convert.ToString(point);
total += point;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, r].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, r].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, r].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 2].Text = Convert.ToString(total);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 2].HorizontalAlign = HorizontalAlign.Center;
maximummark = 0;
double.TryParse(Convert.ToString(ds.Tables[3].Rows[0]["maximum"]), out maximummark);
double per = total / (totalsumofstud * maximummark) * 100;
string percent = "";
if (Convert.ToString(per).ToUpper() == "NAN")
{
percent = " - ";
}
else
{
percent = Convert.ToString(Math.Round(per));
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 1].Text = percent;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, FpSpread1.Sheets[0].ColumnCount - 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[2].VerticalAlign = VerticalAlign.Middle;
}
FpSpread1.Visible = true;
rptprint1.Visible = true;
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "No Records Found";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "No Records Found";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "Please Select All Fields";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "Please Select Feedback";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
}
catch (Exception ex)
{
lbl_error.Text = ex.ToString();
lbl_error.Visible = true;
d2.sendErrorMail(ex, collegecode1, "FeedbackReport");
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
q1 = " select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections from applyn a,Registration r, degree d,Department dt,Course C where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' ";
string type = flitertype();
string degreecode = rs.GetSelectedItemsValueAsString(cbl_branch);
string deptcode = rs.GetSelectedItemsValueAsString(cbl_degree);
string Batchyear = rs.GetSelectedItemsValueAsString(cbl_batch);
string sem = Convert.ToString(ddl_feecatagory.SelectedItem.Text).Split(' ')[0];
if (Convert.ToString(ViewState["linkName"]).ToUpper() == "TERM")
{
sem = "1";//Convert.ToString(ddl_feecatagory.SelectedItem.Text).Split(' ')[1] + " ";
}
string CertificateId = rs.GetSelectedItemsValueAsString(cbl_certificate);
if (!string.IsNullOrEmpty(degreecode) && !string.IsNullOrEmpty(deptcode) && !string.IsNullOrEmpty(Batchyear) && !string.IsNullOrEmpty(CertificateId))
{
if (txt_searchappno.Text.Trim() != "")
{
q1 += " and " + type + "='" + txt_searchappno.Text.Trim() + "'";
}
else
{
q1 += " and r.degree_code in('" + degreecode + "')and r.Batch_Year in('" + Batchyear + "') and c.Course_Id in('" + deptcode + "') and r.Current_Semester in('" + sem + "') and r.college_code='" + Convert.ToString(ddlcollege.SelectedItem.Value) + "' ";
}
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
rs.Fpreadheaderbindmethod("S.No-50/Select-50/Student Name-210/Roll No-150/Reg No-150/Admission No-150/Gender-100/Section-70/" + lbl_degree.Text + "-100/" + lbl_branch.Text + "-300/" + lbl_semT.Text + "-100", FpSpread1, "FALSE");
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cb.AutoPostBack = false;
cball.AutoPostBack = true;
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = cball;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count - 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = cb;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[3].Visible = false;
FpSpread1.Sheets[0].Columns[4].Visible = false;
FpSpread1.Sheets[0].Columns[5].Visible = false;
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[4].Visible = true;
}
if (Convert.ToString(Session["Admissionflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[5].Visible = true;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["stud_name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["roll_no"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Reg_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["Roll_Admit"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sex"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["sections"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Course_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(dr["Dept_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Text = Convert.ToString(dr["Current_Semester"]);
#region Fpspread Alignment and style
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Name = "Book Antiqua";
#endregion
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
btn_request.Visible = true;
}
else
{
btn_request.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
btn_request.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All Fields";
}
}
catch (Exception ex)
{
lbl_error.Visible = true;
lbl_error.Text = ex.ToString();
FpSpread1.Visible = false;
btn_request.Visible = false;
}
}
protected void SaveDetails()
{
try
{
string degreecode = rs.GetSelectedItemsValue(cbldepartment);
string batchyear = Convert.ToString(ddlbatch.SelectedItem.Text);
string type = Convert.ToString(ddltype.SelectedItem.Text);
string edulevel = Convert.ToString(ddledulevel.SelectedItem.Text);
string Query = " select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections,h.HostelMasterFK,hm.HostelName,isnull(a.studhouse,'')studhouse from applyn a, degree d,Department dt,Course C,Registration r left join HT_HostelRegistration h on r.App_No=h.APP_No left join hm_hostelmaster hm on h.HostelMasterFK=hm.HostelMasterPK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and c.type ='" + type + "' and c.Edu_Level ='" + edulevel + "' and a.college_code='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' and r.batch_year in('" + batchyear + "') and d.Degree_Code in ('" + degreecode + "') order by isnull(d.Dept_Priority,10000),r.Reg_No asc";//c.Course_Id,d.Degree_Code,AdmitedDate";
Query += " select HouseName+'$'+CONVERT(varchar(10), HousePK) as HouseName,Gender,GenderPriority from HousingDetails where collegecode='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' order by isnull(HousePriority,0),ISNULL(GenderPriority,0),isnull(OrderBy,0) asc";
ds.Clear();
//ds = d2.select_method_wo_parameter(Query, "Text");
Hashtable HouseDetHash = new Hashtable();
HouseDetHash.Add("stream", type);
HouseDetHash.Add("eduLevel", edulevel);
HouseDetHash.Add("collegeCode", Convert.ToString(ddl_collegename.SelectedItem.Value));
HouseDetHash.Add("degreecode", degreecode);
HouseDetHash.Add("batchYear", batchyear);
ds = d2.select_method("AutohouseGeneration", HouseDetHash, "sp");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-150/Reg No-150/Admission No-150/Gender-70/Section-70/" + lblDeg.Text + "-100/" + lblBran.Text + "-200/House Name-180", FpSpread, "FALSE");
int MaleCurrentRow = 0;
int FemaleCurrentRow = 0;
List <String> MaleHousingArr = new List <string>();
List <String> FemaleHousingArr = new List <string>();
if (ds.Tables[1].Rows.Count > 0)
{
MaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 0).Select(r => r.Field <String>("HouseName")).ToList <String>();
FemaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 1).Select(r => r.Field <String>("HouseName")).ToList <String>();
}
//if (MaleHousingArr.Contains(""))
// MaleHousingArr.IndexOf("hha");
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread.Sheets[0].Rows.Count++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread.Sheets[0].Rows.Count);
FpSpread.Sheets[0].Columns[2].Visible = false;
FpSpread.Sheets[0].Columns[3].Visible = false;
FpSpread.Sheets[0].Columns[4].Visible = false;
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread.Sheets[0].Columns[2].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Admissionflag"]) == "1")
{
FpSpread.Sheets[0].Columns[4].Visible = true;
}
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(dr["Stud_Type"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["stud_name"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["roll_no"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Roll_Admit"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["sex"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sections"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["Course_Name"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Dept_Name"]);
string studhouse = Convert.ToString(dr["HouseName"]);
string studhousePK = Convert.ToString(dr["HousePK"]);
string Hostelname = Convert.ToString(dr["HostelName"]);
string HousePk = Convert.ToString(dr["HostelMasterFK"]);
if (GenerateBool)
{
if (string.IsNullOrEmpty(Hostelname) && string.IsNullOrEmpty(HousePk) && string.IsNullOrEmpty(studhouse))
{
#region Auto Allotment
if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
{
if (MaleHousingArr.Count <= MaleCurrentRow)
{
MaleCurrentRow = 0;
string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
MaleCurrentRow++;
}
else
{
string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
MaleCurrentRow++;
}
}
if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
{
if (FemaleHousingArr.Count <= FemaleCurrentRow)
{
FemaleCurrentRow = 0;
string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
FemaleCurrentRow++;
}
else
{
string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
FemaleCurrentRow++;
}
}
#endregion
}
else
{
if (string.IsNullOrEmpty(Hostelname))
{
Hostelname = Convert.ToString(dr["HouseName"]);
HousePk = Convert.ToString(dr["HousePK"]);
string HouseName = Hostelname + '$' + HousePk;
if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
{
if (MaleHousingArr.Count <= MaleCurrentRow)
{
if (MaleHousingArr.Contains(HouseName))
{
//MaleCurrentRow = MaleHousingArr.IndexOf(HouseName);
MaleCurrentRow = 0;
}
}
else
{
if (MaleHousingArr.Contains(HouseName))
{
MaleCurrentRow = MaleHousingArr.IndexOf(HouseName);
MaleCurrentRow++;
}
}
}
if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
{
if (FemaleHousingArr.Count <= FemaleCurrentRow)
{
if (FemaleHousingArr.Contains(HouseName))
{
//FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName);
FemaleCurrentRow = 0;
}
}
else
{
if (FemaleHousingArr.Contains(HouseName))
{
FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName);
FemaleCurrentRow++;
}
}
}
//if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
//{
// if (MaleHousingArr.Count <= MaleCurrentRow)
// {
// MaleCurrentRow = 0;
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// MaleCurrentRow++;
// }
// else
// {
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// MaleCurrentRow++;
// }
//}
//if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
//{
// if (FemaleHousingArr.Count <= FemaleCurrentRow)
// {
// FemaleCurrentRow = 0;
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// FemaleCurrentRow++;
// }
// else
// {
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// FemaleCurrentRow++;
// }
//}
}
}
}
else
{
if (string.IsNullOrEmpty(Hostelname))
{
Hostelname = Convert.ToString(dr["HouseName"]);
HousePk = Convert.ToString(dr["HousePK"]);
}
}
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Text = Hostelname;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Tag = HousePk;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua";
}
FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount;
FpSpread.Visible = true;
FpSpread.SaveChanges();
lbl_error.Visible = false;
rprint.Visible = true;
}
else
{
rprint.Visible = false;
FpSpread.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
catch (Exception ex)
{
alertpopwindow.Visible = true;
lblalerterr.Text = ex.ToString();
}
}
