public void binddegree()
{
try
{
ds.Clear();
//txtDegree.Text = "---Select---";
string batchCode = string.Empty;
//chkDegree.Checked = false;
//cblDegree.Items.Clear();
//userCode = Session["usercode"].ToString();
//singleUser = Session["single_user"].ToString();
//groupUserCode = Session["group_code"].ToString();
collegeCode = string.Empty;
if (ddlCollege.Items.Count > 0)
{
collegeCode = ddlCollege.SelectedValue.ToString().Trim();
}
string columnfield = string.Empty;
string group_user = ((Session["group_code"] != null) ? Convert.ToString(Session["group_code"]) : string.Empty);
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = Convert.ToString(group_semi[0]);
}
if ((Convert.ToString(group_user).Trim() != "") && Session["single_user"] != null && (Convert.ToString(Session["single_user"]) != "1" && Convert.ToString(Session["single_user"]) != "true" && Convert.ToString(Session["single_user"]) != "TRUE" && Convert.ToString(Session["single_user"]) != "True"))
{
columnfield = " and group_code='" + group_user + "'";
}
else if (Session["usercode"] != null)
{
columnfield = " and user_code='" + Convert.ToString(Session["usercode"]).Trim() + "'";
}
string valBatch = string.Empty;
if (cblBatch.Items.Count > 0)
{
valBatch = rs.GetSelectedItemsValueAsString(cblBatch);
}
if (!string.IsNullOrEmpty(collegeCode) && !string.IsNullOrEmpty(valBatch))
{
string selDegree = "SELECT DISTINCT c.Edu_Level FROM Degree dg,Course c,Department dt,DeptPrivilages dp,Registration r WHERE r.degree_code = dg.Degree_Code AND dp.degree_code = dg.Degree_Code AND dg.Course_Id = c.Course_Id AND dg.Dept_Code = dt.Dept_Code AND r.college_code = c.college_code AND r.college_code = dg.college_code AND dt.college_code = r.college_code AND c.college_code = dg.college_code and r.Exam_Flag<>'debar' AND r.college_code in('" + collegeCode + "') AND r.Batch_Year in('" + valBatch + "') " + columnfield + " ORDER BY c.Edu_Level ";
ds = da.select_method_wo_parameter(selDegree, "Text");
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ddlEdulevl.DataSource = ds;
ddlEdulevl.DataTextField = "Edu_Level";
ddlEdulevl.DataValueField = "Edu_Level";
ddlEdulevl.DataBind();
//checkBoxListselectOrDeselect(cblDegree, true);
//CallCheckboxListChange(chkDegree, cblDegree, txtDegree, lblDegree.Text, "--Select--");
}
}
catch (Exception ex)
{
}
}
public void bindbranch()
{
try
{
string rights = "";
txt_branch.Text = "--Select--";
if (group_user.Contains(";"))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
if ((group_user.ToString().Trim() != "") && (group_user.Trim() != "0") && (group_user.ToString().Trim() != "-1"))
{
rights = "and group_code='" + group_user + "'";
}
else
{
rights = " and user_code='" + usercode + "'";
}
cbl_branch.Items.Clear();
string commname = "";
string branch = rs.GetSelectedItemsValueAsString(cbl_degree);
if (branch != "")
{
commname = "select distinct degree.degree_code,department.dept_name,degree.Acronym from degree,department,course,deptprivilages where course.course_id=degree.course_id and department.dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and degree.course_id in('" + branch + "') and deptprivilages.Degree_code=degree.Degree_code and degree.college_code='" + ddlcollege.SelectedItem.Value + "' " + rights + " ";
ds = d2.select_method(commname, hat, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_branch.DataSource = ds;
cbl_branch.DataTextField = "dept_name";
cbl_branch.DataValueField = "degree_code";
cbl_branch.DataBind();
if (cbl_branch.Items.Count > 0)
{
//for (int i = 0; i < cbl_branch.Items.Count; i++)
//{
cbl_branch.Items[0].Selected = true;
//}
txt_branch.Text = lbl_branchT.Text + "(" + 1 + ")";
}
}
}
}
catch (Exception ex)
{
}
}
protected void binddept()
{
try
{
ds.Clear();
cbl_dept.Items.Clear();
string getcolcode = rs.GetSelectedItemsValueAsString(cbl_clg);
string item = "select distinct dept_code,dept_name from hrdept_master where college_code in('" + getcolcode + "') order by dept_name";
ds = d2.select_method_wo_parameter(item, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_dept.DataSource = ds;
cbl_dept.DataTextField = "dept_name";
cbl_dept.DataValueField = "dept_code";
cbl_dept.DataBind();
if (cbl_dept.Items.Count > 0)
{
for (int i = 0; i < cbl_dept.Items.Count; i++)
{
cbl_dept.Items[i].Selected = true;
}
txt_dept.Text = "Department (" + cbl_dept.Items.Count + ")";
cb_dept.Checked = true;
}
}
else
{
txt_dept.Text = "--Select--";
cb_dept.Checked = false;
}
}
catch { }
}
protected void bind_district()//delsi2701
{
try
{
q1 = "";
//q1 = " select distinct textval,a.Districtp from textvaltable t,applyn a,Registration r where r.App_No=a.app_no and a.Districtp= convert(nvarchar(100),t.TextCode) and textcriteria='dis' ";
string clg_code = Convert.ToString(ddl_college.SelectedItem.Value);
string batch_year = Convert.ToString(ddl_batch.SelectedItem.Value);
string branch_code = rs.GetSelectedItemsValueAsString(cbl_branch);
if (clg_code != "" && batch_year != "" && branch_code != "")
{
// q1 = "select distinct textval,a.Districtp from textvaltable t,applyn a,Registration r where r.App_No=a.app_no and a.Districtp= convert(nvarchar(100),t.TextCode) and textcriteria='dis' and r.college_code='" + clg_code + "' and r.Batch_Year='" + batch_year + "' and r.degree_code in('" + branch_code + "')";
q1 = "select distinct textval,a.cityp from textvaltable t,applyn a,Registration r where r.App_No=a.app_no and a.cityp= convert(nvarchar(100),t.TextCode) and textcriteria='city' and r.college_code='" + clg_code + "' and r.Batch_Year='" + batch_year + "' and r.degree_code in('" + branch_code + "')";//modified
}
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
cbl_comm.Items.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_comm.DataSource = ds;
cbl_comm.DataTextField = "textval";
cbl_comm.DataValueField = "cityp";//modified
cbl_comm.DataBind();
if (cbl_comm.Items.Count > 0)
{
for (int i = 0; i < cbl_comm.Items.Count; i++)
{
cbl_comm.Items[i].Selected = true;
}
txt_comm.Text = "District (" + cbl_comm.Items.Count + ")";
cb_comm.Checked = true;
}
}
else
{
txt_comm.Text = "--Select--";
}
}
catch
{ }
}
public void binddept()
{
try
{
cbldepartment.Items.Clear();
string build = "";
string build2 = "";
build = Convert.ToString(ddledulevel.SelectedItem.Value);
build2 = rs.GetSelectedItemsValueAsString(cbldegree);
if (build != "" && build2 != "")
{
string deptquery = "select distinct degree.degree_code,department.dept_name,department.dept_code from degree,department,course,deptprivilages where course.course_id=degree.course_id and department .dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and degree.course_id in('" + build2 + "') and degree.college_code in ('" + clgcode + "') and deptprivilages.Degree_code=degree.Degree_code and user_code in ('" + usercode + "') and course.Edu_Level in ('" + build + "')";
ds.Clear();
ds = d2.select_method_wo_parameter(deptquery, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbldepartment.DataSource = ds;
cbldepartment.DataTextField = "dept_name";
cbldepartment.DataValueField = "degree_code";
cbldepartment.DataBind();
if (cbldepartment.Items.Count > 0)
{
for (i = 0; i < cbldepartment.Items.Count; i++)
{
cbldepartment.Items[i].Selected = true;
}
cbdepartment1.Checked = true;
txt_department.Text = lblBran.Text + "(" + cbldepartment.Items.Count + ")";
}
}
}
else
{
cbdepartment1.Checked = false;
txt_department.Text = "--Select--";
}
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["collegecode"] == null)
{
Response.Redirect("~/Default.aspx");
}
usercode = Session["usercode"].ToString();
singleuser = Session["single_user"].ToString();
group_user = Session["group_code"].ToString();
if (!IsPostBack)
{
bindcollege();
collegecode = rs.GetSelectedItemsValueAsString(cblclg);
binddept();
designation();
category();
stafftype();
staffstatus();
bindyear();
bindmonth();
}
lbl_alert.Visible = false;
lblerror.Text = "";
}
private void bindStaff()
{
try
{
string DeptCode = Rs.GetSelectedItemsValueAsString(cbl_dept);
string DesigCode = Rs.GetSelectedItemsValueAsString(cblDesig);
string staffType = Rs.GetSelectedItemsValueAsString(cblStfType);
ds.Clear();
ddlStfName.Items.Clear();
string SelQ = "select sm.staff_code,(sm.staff_code+' - '+sm.staff_name) as Staff_Name from staffmaster sm,stafftrans st,staff_appl_master sa where sm.staff_code=st.staff_code and sm.appl_no=sa.appl_no and sm.resign='0' and sm.settled='0' and ISNULL(sm.Discontinue,'0')='0' and st.latestrec='1' and sm.college_code='" + collegecode + "' ";
if (DeptCode.Trim() != "")
{
SelQ += " and st.dept_code in ('" + DeptCode + "')";
}
if (DesigCode.Trim() != "")
{
SelQ += " and st.desig_code in ('" + DesigCode + "')";
}
if (staffType.Trim() != "")
{
SelQ += " and st.stftype in ('" + staffType + "')";
}
SelQ += " order by len(sm.staff_code),sm.staff_Code";
ds = d2.select_method_wo_parameter(SelQ, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ddlStfName.DataSource = ds;
ddlStfName.DataTextField = "Staff_Name";
ddlStfName.DataValueField = "staff_code";
ddlStfName.DataBind();
ddlStfName.Items.Insert(0, "All");
}
else
{
ddlStfName.Items.Insert(0, "All");
}
}
catch { }
}
public void bindbranch()
{
try
{
//ddl_branch.Items.Clear();
cbl_branch.Items.Clear();
txt_branch.Text = lbl_branch.Text;
cb_branch.Checked = true;
string degree = "";
degree = reUse.GetSelectedItemsValueAsString(cbl_degree);//ddl_degree.Items.Count > 0 ? ddl_degree.SelectedValue : "";
string commname = "";
if (degree != "")
{
commname = "select distinct degree.degree_code,department.dept_name,degree.Acronym,department.dept_code from degree,department,course,deptprivilages where course.course_id=degree.course_id and department.dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and degree.course_id in('" + degree + "') and deptprivilages.Degree_code=degree.Degree_code ";
}
else
{
commname = " select distinct degree.degree_code,department.dept_name,degree.Acronym,department.dept_code from degree,department,course,deptprivilages where course.course_id=degree.course_id and department.dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and deptprivilages.Degree_code=degree.Degree_code";
}
DataSet ds = DA.select_method_wo_parameter(commname, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
//ddl_branch.DataSource = ds;
//ddl_branch.DataTextField = "dept_name";
//ddl_branch.DataValueField = "degree_code";
//ddl_branch.DataBind();
cbl_branch.DataSource = ds;
cbl_branch.DataTextField = "dept_name";
cbl_branch.DataValueField = "degree_code";
cbl_branch.DataBind();
reUse.CallCheckBoxChangedEvent(cbl_branch, cb_branch, txt_branch, lbl_branch.Text);
}
}
catch (Exception ex) { }
}
protected void btngo_Click(object sender, EventArgs e)
{
try
{
string valCollege = string.Empty;
int exMonthName = 0;
int colspanbranch = 0;
int colspansubj = 0;
int coldeg = 0;
int coldegr = 0;
int dsrow = 0;
int inrow = 0;
string sess = string.Empty;
string collegeCode1 = string.Empty;
int total = 0;
bool colspanBool = false;
string BranchCodeReplication = string.Empty;
string degree = string.Empty;
string subjcode = string.Empty;
DataView colSpanDV = new DataView();
DataView colSpansub = new DataView();
DataSet dsCollege = new DataSet();
Fpspread.Sheets[0].Visible = true;
Fpspread.Sheets[0].AutoPostBack = true;
Fpspread.Sheets[0].RowHeader.Visible = false;
Fpspread.Sheets[0].ColumnHeader.Visible = true;
MyStyle.Font.Size = FontUnit.Medium;
MyStyle.Font.Name = "Book Antiqua";
MyStyle.Font.Bold = true;
MyStyle.HorizontalAlign = HorizontalAlign.Center;
MyStyle.ForeColor = Color.White;
MyStyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
Fpspread.Sheets[0].ColumnHeader.DefaultStyle = MyStyle;
Fpspread.CommandBar.Visible = false;
Fpspread.Sheets[0].ColumnCount = 8;
Fpspread.Sheets[0].RowCount = 2;
Fpspread.BorderWidth = 2;
valCollege = rs.GetSelectedItemsValueAsString(cblCollege);
btn_directprint.Visible = true;
if (valCollege.ToString() != "")
{
if (ddlDate.SelectedValue != "" && ddlSession.SelectedValue != "")
{
lblerror.Visible = false;
Fpspread.Visible = true;
int.TryParse(Convert.ToString(ddlMonth.SelectedValue).Trim(), out exMonthName);
string exdate = Convert.ToString(ddlDate.SelectedValue).Trim();
string[] spl1 = exdate.Split('-');
DateTime dtl1 = Convert.ToDateTime(spl1[1] + '-' + spl1[0] + '-' + spl1[2]);
string exmdate = dtl1.ToString("dd");
string exmmonth = dtl1.ToString("MM");
string exmmonthful = dtl1.ToString("MMMM");
string exmyear = dtl1.ToString("yyyy");
string examdate = exmyear + '-' + exmmonth + '-' + exmdate;
string prmonthyea = exmmonthful + '-' + exmyear;
// string sql ="select distinct s.subject_code, de.Dept_Name,c.Course_Name,d.Degree_Code,s.subject_name,d.Acronym,et.exam_date,et.exam_session from exmtt e,exmtt_det et,course c,Degree d,Department de,subject s where e.degree_code=d.Degree_Code and c.Course_Id=d.Course_Id and d.Dept_Code=de.Dept_Code and et.exam_date='" + examdate + "' and e.exam_Month='" + exMonthName + "' and e.Exam_Year='" + ddlYear.SelectedItem.Text + "' and et.exam_session='" + ddlSession.SelectedItem.Text + "' and et.coll_code in('" + valCollege + "')and e.exam_code=et.exam_code and et.subject_no=s.subject_no group by c.Course_Name, de.Dept_Name,d.Degree_Code,s.subject_name,d.Acronym,et.exam_date,et.exam_session,s.subject_code order by de.Dept_Name";
//string sql = "select distinct s.subject_code,de.Dept_Name,c.Course_Name,s.subject_name,et.exam_date,et.exam_session,d.Acronym,COUNT(ea.roll_no) as stucount from Exam_Details e,exam_application ea,exam_appl_details ed,subject s,exmtt_det et, Registration r,Degree d,course c,Department de where e.exam_code=ea.exam_code and ea.appl_no=ed.appl_no and ed.subject_no=s.subject_no and s.subject_no=et.subject_no and ea.roll_no =r.Roll_No and r.degree_code=d.Degree_Code and d.Dept_Code=de.Dept_Code and d.Course_Id=c.Course_Id and e.Exam_Month='" + exMonthName + "'and et.coll_code in('" + valCollege + "') and e.Exam_year='" + ddlYear.SelectedItem.Text + "' and et.exam_date='" + examdate + "' and et.exam_session='" + ddlSession.SelectedItem.Text + "' group by s.subject_code,de.Dept_Name,c.Course_Name,s.subject_name,et.exam_date,et.exam_session,d.Acronym,c.type order by de.Dept_Name";
string sql = "select s.subject_code,(c.Course_Name+'-'+de.Dept_Name) as course,c.Edu_Level,s.subject_name,et.exam_date,et.exam_session,d.Acronym,COUNT(ea.roll_no) as stucount from Exam_Details e,exam_application ea,exam_appl_details ed,subject s,exmtt_det et, Registration r,Degree d,course c,Department de where e.exam_code=ea.exam_code and ea.appl_no=ed.appl_no and ed.subject_no=s.subject_no and s.subject_no=et.subject_no and ea.roll_no =r.Roll_No and r.degree_code=d.Degree_Code and d.Dept_Code=de.Dept_Code and d.Course_Id=c.Course_Id and e.Exam_Month='" + exMonthName + "' and et.coll_code in('" + valCollege + "') and e.Exam_year='" + ddlYear.SelectedItem.Text + "' and et.exam_date='" + examdate + "' and et.exam_session='" + ddlSession.SelectedItem.Text + "' group by s.subject_code,de.Dept_Name,c.Course_Name,s.subject_name,et.exam_date,et.exam_session,d.Acronym,c.Edu_Level,c.type order by s.subject_code";
ds = dt.select_method_wo_parameter(sql, "text");
int tabrow = ds.Tables[0].Rows.Count;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Fpspread.Sheets[0].RowCount = 0;
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
Fpspread.Sheets[0].RowCount++;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Date of Exam";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[0].Width = 50;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Session";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Subject Code";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
string subj = Convert.ToString(ds.Tables[0].Rows[j]["subject_code"]).Trim();
string subjname = Convert.ToString(ds.Tables[0].Rows[j]["subject_name"]).Trim();
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Branch";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
string edulevel = Convert.ToString(ds.Tables[0].Rows[j]["Edu_Level"]).Trim();
ds.Tables[0].DefaultView.RowFilter = " Edu_Level='" + Convert.ToString(ds.Tables[0].Rows[j]["Edu_Level"]) + "' ";
if (!hat.ContainsKey(edulevel))
{
hat.Add(edulevel, subjname);
Spdegree.InnerHtml = "DEGREE: " + edulevel + "";
}
string bran = Convert.ToString(ds.Tables[0].Rows[j]["course"]).Trim();
ds.Tables[0].DefaultView.RowFilter = " course='" + Convert.ToString(ds.Tables[0].Rows[j]["course"]) + "' ";
colSpanDV = ds.Tables[0].DefaultView;
if (BranchCodeReplication != Convert.ToString(ds.Tables[0].Rows[j]["course"]))
{
Fpspread.Sheets[0].Cells[j, 3].Text = Convert.ToString(bran).Trim();
Fpspread.Sheets[0].Cells[j, 3].VerticalAlign = VerticalAlign.Middle;
Fpspread.Sheets[0].Cells[j, 3].HorizontalAlign = HorizontalAlign.Left;
if (BranchCodeReplication != "")
{
if (colSpanDV.Count > 0)
{
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - colspanbranch - 1, 3, colspanbranch, 1);
}
}
colspanbranch = 0;
}
colspanbranch++;
BranchCodeReplication = Convert.ToString(ds.Tables[0].Rows[j]["course"]).Trim();
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Q.P Code/Booklet code";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Answer Paper Packet Number Alloted by College";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Subject";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 6].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 6].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Total Answer scripts";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 7].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 7].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 7].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 7].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Columns[1].Width = 50;
string strquery = "select *,district+' - '+pincode as districtpin from collinfo where college_code='" + Convert.ToString(Session["collegecode"]).Trim() + "'";
DataSet ds1 = new DataSet();
ds1.Dispose();
ds1.Reset();
ds1 = dt.select_method_wo_parameter(strquery, "Text");
spF1College.InnerText = ds1.Tables[0].Rows[0]["Collname"].ToString();
string catagor = ds1.Tables[0].Rows[0]["category"].ToString();
// string[] strpa = Convert.ToString(ds1.Tables[0].Rows[0]["affliatedby"]).Trim().Split(',');
spcategory.InnerHtml = "(" + Convert.ToString(catagor).Trim() + " & " + Convert.ToString(ds1.Tables[0].Rows[0]["university"]).Trim() + ")";
spF1Date.InnerText = "Month & year of Exam: " + Convert.ToString(prmonthyea).Trim() + "";
spHead.InnerText = "DESPATCH OF ANSWER PACKETS ";
dateoedel.InnerHtml = "Date of Delvery:" + Convert.ToString(ddlDate.SelectedValue).Trim() + "";
spsign.InnerHtml = "Signature of the Anna University Representative";
spsignchif.InnerHtml = "Signature of the Chief Superintendent";
spsig.InnerHtml = "Authorized Signatory office of COE";
spnbun.InnerHtml = "Received " + ds.Tables[0].Rows.Count + " bundles from exam cell";
ds.Tables[0].DefaultView.RowFilter = " subject_code='" + Convert.ToString(ds.Tables[0].Rows[j]["subject_code"]) + "' ";
colSpansub = ds.Tables[0].DefaultView;
if (subjcode != Convert.ToString(ds.Tables[0].Rows[j]["subject_code"]))
{
if (subjcode != "")
{
if (colSpansub.Count > 0)
{
dsrow = j;
inrow = j;
dsrow = ds.Tables[0].Rows.Count - 1;
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - colspansubj - 1, 2, colspansubj, 1);
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - colspansubj - 1, 6, colspansubj, 1);
}
}
colspansubj = 0;
}
colspansubj++;
if (dsrow == 0 && j == ds.Tables[0].Rows.Count - 1)
{
Fpspread.Sheets[0].SpanModel.Add(0, 2, ds.Tables[0].Rows.Count, 1);
Fpspread.Sheets[0].SpanModel.Add(0, 6, ds.Tables[0].Rows.Count, 1);
}
if (dsrow == j)
{
Fpspread.Sheets[0].SpanModel.Add(inrow, 2, colspansubj, 1);
Fpspread.Sheets[0].SpanModel.Add(inrow, 6, colspansubj, 1);
}
subjcode = Convert.ToString(ds.Tables[0].Rows[j]["subject_code"]).Trim();
if (!hat.ContainsKey(subj))
{
hat.Add(subj, bran);
Fpspread.Sheets[0].Cells[j, 2].Text = Convert.ToString(subj).Trim();
Fpspread.Sheets[0].Cells[j, 2].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[j, 2].VerticalAlign = VerticalAlign.Middle;
Fpspread.Sheets[0].Cells[j, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[j, 6].Text = Convert.ToString(subjname).Trim();
Fpspread.Sheets[0].Cells[j, 6].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[j, 6].VerticalAlign = VerticalAlign.Middle;
Fpspread.Sheets[0].Cells[j, 6].HorizontalAlign = HorizontalAlign.Left;
}
Fpspread.Sheets[0].Cells[j, 7].Text = Convert.ToString(ds.Tables[0].Rows[j]["stucount"]).Trim();
Fpspread.Sheets[0].Cells[j, 7].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[j, 7].Font.Size = FontUnit.Medium;
total += Convert.ToInt32(ds.Tables[0].Rows[j]["stucount"].ToString());
}
Fpspread.Sheets[0].SpanModel.Add(0, 0, Fpspread.Sheets[0].RowCount, 1);
Fpspread.Sheets[0].Cells[0, 0].Text = Convert.ToString(exdate).Trim();
Fpspread.Sheets[0].Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[0, 0].VerticalAlign = VerticalAlign.Middle;
Fpspread.Sheets[0].Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].SpanModel.Add(0, 1, Fpspread.Sheets[0].RowCount, 1);
Fpspread.Sheets[0].Cells[0, 1].Text = Convert.ToString(ddlSession.SelectedValue).Trim();
Fpspread.Sheets[0].Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[0, 1].VerticalAlign = VerticalAlign.Middle;
Fpspread.Sheets[0].Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].RowCount++;
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - 1, 0, 1, 5);
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].Text = "Total";
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(total).Trim();
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Right;
Fpspread.Sheets[0].RowCount++;
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - 1, 0, 1, Fpspread.Sheets[0].Columns.Count);
if (ddlSession.SelectedValue.Trim() == "A.N")
{
sess = "Afternoon";
}
else
{
sess = "Forenoon";
}
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].Text = "1.Certificate of opening of sessionwise package of Q.P for " + sess + "";
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
Fpspread.Sheets[0].RowCount++;
Fpspread.Sheets[0].SpanModel.Add(Fpspread.Sheets[0].RowCount - 1, 0, 1, Fpspread.Sheets[0].Columns.Count);
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].Text = "2.Student Attendance Sheet original copies for " + sess + "";
Fpspread.Sheets[0].Cells[Fpspread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
Fpspread.Sheets[0].PageSize = Fpspread.Sheets[0].RowCount;
Fpspread.Width = 900;
Fpspread.Height = 900;
Fpspread.SaveChanges();
}
else
{
lblerror.Text = "No Records Found";
lblerror.Visible = true;
}
}
else
{
lblerror.Text = "Please select the date and session";
Fpspread.Visible = false;
lblerror.Visible = true;
btn_directprint.Visible = false;
}
}
else
{
lblerror.Text = "Please select all field";
Fpspread.Visible = false;
lblerror.Visible = true;
btn_directprint.Visible = false;
}
}
catch (Exception ex)
{ da.sendErrorMail(ex, collegeCode, "DespatchOfAnswerPackets"); }
}
private void loadheaderstaffwise(string DeptCode, string DesigCode) /* poomalar 16.10.17 */
{
try
{
Fpspread1.Visible = false;
rprint.Visible = false;
lblMainErr.Visible = false;
string collCode = Convert.ToString(ddlcollege.SelectedItem.Value);
Fpspread1.Sheets[0].AutoPostBack = false;
Fpspread1.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread1.Sheets[0].RowCount = 0;
Fpspread1.Sheets[0].ColumnCount = 7;
Fpspread1.Sheets[0].RowHeader.Visible = false;
Fpspread1.CommandBar.Visible = false;
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Bold = true;
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.HorizontalAlign = HorizontalAlign.Center;
darkstyle.ForeColor = Color.Black;
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
Fpspread1.Sheets[0].ColumnHeader.DefaultStyle = darkstyle;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No.";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Select";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Name";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Staff Code";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Designation";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Total Hours";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Amount/Hrs";
Fpspread1.Columns[0].Width = 50;
Fpspread1.Columns[1].Width = 50;
Fpspread1.Columns[2].Width = 200;
Fpspread1.Columns[3].Width = 100;
Fpspread1.Columns[4].Width = 200;
Fpspread1.Columns[5].Width = 100;
Fpspread1.Columns[6].Width = 100;
Fpspread1.Columns[0].Locked = true;
Fpspread1.Columns[2].Locked = true;
Fpspread1.Columns[3].Locked = true;
Fpspread1.Columns[4].Locked = true;
CheckAll.AutoPostBack = true;
CheckInd.AutoPostBack = false;
DoubleHrs.MaximumValue = 70;
DoubleHrs.ErrorMessage = "Allow only Numerics & Max Hours is 70!";
DoubleAmnt.ErrorMessage = "Allow only Numerics!";
string query = "";
ReuasableMethods rs = new ReuasableMethods();
string deptcodesel = rs.GetSelectedItemsValueAsString(cbl_dept);
string desigcodesel = rs.GetSelectedItemsValueAsString(cblDesig);
query = "select sm.staff_code,sm.staff_name,h.dept_name,desig.desig_name,st.stftype,sc.category_name,h.dept_code,desig.desig_code,sm.college_Code,sm.appl_no,isnull(Tot_Hrs,0) Tot_Hrs,isnull(Amnt_Per_Hrs,0) Amnt_Per_Hrs from staffmaster sm,hrdept_master h,desig_master desig,staffcategorizer sc,stafftrans st LEFT JOIN HourWise_PaySettings HW ON st.staff_code=hw.StaffCode and hw.dept_code=st.dept_code and hw.desig_code=hw.desig_code where sm.staff_code=st.staff_code and sm.college_code=h.college_code and sm.college_code=desig.collegeCode and sm.college_code=sc.college_code and (isnull(st.stfnature,0)='1' or isnull(st.stfnature,'')='part') and st.dept_code=h.dept_code and st.desig_code=desig.desig_code and st.category_code=sc.category_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code='" + collCode + "' and h.dept_code in('" + deptcodesel + "') and desig.desig_code in('" + desigcodesel + "')";// and isnull(hw.PayType,0)='"+paytype+"'";
DataSet dquery = new DataSet();
dquery = d2.select_method_wo_parameter(query, "Text");
int sno = 1;
int rowcount = 0;
if (dquery.Tables.Count > 0 && dquery.Tables[0].Rows.Count > 0)
{
if (cbl_dept.Items.Count > 0 && txt_dept.Text.Trim() != "--Select--")
{
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].CellType = CheckAll;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Bold = true;
for (int st = 0; st < cbl_dept.Items.Count; st++)
{
if (cbl_dept.Items[st].Selected == true)
{
rowcount = 0;
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(cbl_dept.Items[st].Text);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Bold = true;
Fpspread1.Sheets[0].SpanModel.Add(Fpspread1.Sheets[0].RowCount - 1, 0, 1, 7);
DataView dv = new DataView();
dquery.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dept.Items[st].Value) + "'";
dv = dquery.Tables[0].DefaultView;
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
rowcount++;
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno++);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].CellType = CheckInd;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dv[i]["staff_name"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dv[i]["staff_code"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dv[i]["desig_name"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Tag = Convert.ToString(dv[i]["desig_code"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Note = Convert.ToString(dv[i]["dept_code"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].CellType = DoubleHrs;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dv[i]["Tot_Hrs"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dv[i]["Amnt_Per_Hrs"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
}
}
else
{
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove();
}
}
}
}
}
else
{
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove();
}
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
Fpspread1.Visible = true;
rprint.Visible = true;
btnSave.Visible = true;
lblMainErr.Visible = false;
}
catch (Exception e)
{
e.ToString();
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
Printcontrol.Visible = false;
Hashtable DeductionHash = new Hashtable();
int sno = 0;
string query = "";
string deptcode = rs.GetSelectedItemsValueAsString(cbl_dept);
string designation = rs.GetSelectedItemsValueAsString(cbl_desig);
string stafftype = rs.GetSelectedItemsValueAsString(cbl_staffc);
Fpspread1.Sheets[0].Visible = true;
Fpspread1.Sheets[0].RowHeader.Visible = false;
Fpspread1.CommandBar.Visible = false;
Fpspread1.Sheets[0].AutoPostBack = false;
Fpspread1.Sheets[0].RowCount = 0;
Fpspread1.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread1.Sheets[0].ColumnCount = 13;
FarPoint.Web.Spread.StyleInfo darkstyle2 = new FarPoint.Web.Spread.StyleInfo();
darkstyle2.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle2.ForeColor = Color.Black;
darkstyle2.HorizontalAlign = HorizontalAlign.Center;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle2;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
// string deductiondates = Convert.ToString(txt_deduction.Text);
//string[] deductiondates = txt_deduction.Text.Split('/');
//string month = Convert.ToString(deductiondates[1].ToString());
string frommonth = "";
string tomonth = "";
string fromyear = "";
string toyear = "";
frommonth = Convert.ToString(ddl_frommonth.SelectedItem.Value);
tomonth = Convert.ToString(ddl_tomonth.SelectedItem.Value);
fromyear = Convert.ToString(ddl_fromyear.SelectedItem.Value);
toyear = Convert.ToString(ddl_toyear.SelectedItem.Value);
query = "select s.staff_code,s.staff_name,appl_id,h.dept_name,d.desig_name,pangirnumber,m.netadd,convert(varchar(max),m.deductions)deductions,m.paymonth,m.payyear from staffmaster s,hrdept_master h,desig_master d,stafftrans st,staff_appl_master sm,monthlypay m where m.staff_code=s.staff_code and m.staff_code=st.staff_code and s.staff_code=st.staff_code and st.Dept_Code = h.Dept_Code and d.desig_code=st.desig_code and s.college_code = h.college_code and s.college_code = d.collegecode and s.appl_no=sm.appl_no and h.dept_code in('" + deptcode + "') and s.college_code='" + ddlcollege.SelectedItem.Value + "' and resign = 0 and settled = 0 and ISNULL(Discontinue,'0')='0' and st.latestrec=1 and CAST(CONVERT(varchar(20),m.PayMonth)+'/01/'+CONVERT(varchar(20),m.PayYear) as Datetime) between CAST(CONVERT(varchar(20),'" + frommonth + "')+'/01/'+CONVERT(varchar(20),'" + fromyear + "') as Datetime) and CAST(CONVERT(varchar(20),'" + tomonth + "')+'/01/'+CONVERT(varchar(20),'" + toyear + "') as Datetime) group by m.payyear,m.paymonth, LEN(s.staff_code),s.staff_code,s.staff_name,appl_id,h.dept_name,d.desig_name,pangirnumber,m.netadd,convert(varchar(max),m.deductions)order by year(m.payyear),month(m.paymonth)";
ds.Clear();
ds = d2.select_method_wo_parameter(query, "text");
DataSet data = new DataSet();
string collegecode = ddlcollege.SelectedItem.Value;
string query1 = "select MasterCriteria1,MasterValue from CO_MasterValues where MasterCriteria='Quarterly Report Date' and collegecode='" + collegecode + "'";
query1 += " select MasterCriteria1,MasterCriteriaValue1,MasterCriteriaValue2,MasterValue from CO_MasterValues where MasterCriteria='Quarterly Report DepositDate' and collegecode='" + collegecode + "'";
data = d2.select_method_wo_parameter(query1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
ermsg.Visible = false;
Fpspread1.Visible = true;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
//Fpspread1.Sheets[0].ColumnHeader.Columns[0].Label = "Month";
Fpspread1.Sheets[0].ColumnHeader.Columns[0].Label = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Columns[1].Label = "Employee No";
Fpspread1.Sheets[0].ColumnHeader.Columns[2].Label = "PAN No";
Fpspread1.Sheets[0].ColumnHeader.Columns[3].Label = "Name of the Employee";
Fpspread1.Sheets[0].ColumnHeader.Columns[4].Label = "Date of the payment/ credited";
Fpspread1.Sheets[0].ColumnHeader.Columns[5].Label = "Taxable amount on which tax Deducted";
Fpspread1.Sheets[0].ColumnHeader.Columns[6].Label = "TDS";
Fpspread1.Sheets[0].ColumnHeader.Columns[7].Label = "Education CESS";
Fpspread1.Sheets[0].ColumnHeader.Columns[8].Label = "Total Tax Deducted";
Fpspread1.Sheets[0].ColumnHeader.Columns[9].Label = "Total Tax Deposited";
Fpspread1.Sheets[0].ColumnHeader.Columns[10].Label = "Date of Deduction";
Fpspread1.Sheets[0].ColumnHeader.Columns[11].Label = "Date of Deposit";
Fpspread1.Sheets[0].ColumnHeader.Columns[12].Label = "CHALLAN No";
// Fpspread1.Sheets[0].Columns[0].Width = 100;
Fpspread1.Sheets[0].Columns[0].Width = 80;
Fpspread1.Sheets[0].Columns[1].Width = 100;
Fpspread1.Sheets[0].Columns[2].Width = 150;
Fpspread1.Sheets[0].Columns[3].Width = 250;
Fpspread1.Sheets[0].Columns[0].Locked = true;
Fpspread1.Sheets[0].Columns[1].Locked = true;
Fpspread1.Sheets[0].Columns[2].Locked = true;
Fpspread1.Sheets[0].Columns[3].Locked = true;
Fpspread1.Sheets[0].Columns[4].Locked = true;
Fpspread1.Sheets[0].Columns[5].Locked = true;
Fpspread1.Sheets[0].Columns[6].Locked = true;
Fpspread1.Sheets[0].Columns[7].Locked = true;
Fpspread1.Sheets[0].Columns[8].Locked = true;
Fpspread1.Sheets[0].Columns[9].Locked = true;
Fpspread1.Sheets[0].Columns[10].Locked = true;
Fpspread1.Sheets[0].Columns[11].Locked = true;
Fpspread1.Sheets[0].Columns[12].Locked = true;
ArrayList arrPayMonthYear = new ArrayList();
string Amt = string.Empty;
string preMon = string.Empty;
for (int rolcount = 0; rolcount < ds.Tables[0].Rows.Count; rolcount++)
{
string paymonth = ds.Tables[0].Rows[rolcount]["paymonth"].ToString();
string payYear = ds.Tables[0].Rows[rolcount]["payyear"].ToString();
int months = Convert.ToInt32(paymonth);
string monthyear = Convert.ToString(months) + "/" + payYear;
if (monthyear != preMon)//barath 17.01.18
{
sno = 0;
}
preMon = monthyear;
paymonth = getmonth(months);
string datemon = string.Empty;
string deductdate = string.Empty;
//int year = Convert.ToInt32(payYear);
DataView dv = new DataView();
data.Tables[0].DefaultView.RowFilter = " MasterValue='" + monthyear + "'";
dv = data.Tables[0].DefaultView;
if (dv.Count > 0)
{
datemon = Convert.ToString(dv[0]["MasterCriteria1"]);
deductdate = datemon + "/" + monthyear;
}
else
{
deductdate = string.Empty;
}
if (!arrPayMonthYear.Contains(Convert.ToString(paymonth + "@" + payYear).Trim().ToLower()))
{
if (arrPayMonthYear.Count > 0)
{
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].BackColor = Color.Bisque;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].ForeColor = Color.DarkRed;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = "Total";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
for (int Totalcol = 5; Totalcol < 10; Totalcol++)
{
Amt = string.Empty;
if (DeductionHash.ContainsKey(Totalcol))
{
Amt = Convert.ToString(DeductionHash[Totalcol]);
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Totalcol].Text = Amt;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Totalcol].HorizontalAlign = HorizontalAlign.Right;
}
DeductionHash.Clear();
}
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(paymonth) + "-" + payYear;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].SpanModel.Add(Fpspread1.Sheets[0].RowCount - 1, 0, 1, 12);
arrPayMonthYear.Add(Convert.ToString(paymonth + "@" + payYear).Trim().ToLower());
}
sno++;
string name = ds.Tables[0].Rows[rolcount]["staff_name"].ToString();
string code = ds.Tables[0].Rows[rolcount]["staff_code"].ToString();
string panno = ds.Tables[0].Rows[rolcount]["pangirnumber"].ToString();
double gross = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Rows[rolcount]["netadd"]), out gross);
string tds = ds.Tables[0].Rows[rolcount]["deductions"].ToString();
string incTax = "";
string deductions = Convert.ToString(ds.Tables[0].Rows[rolcount]["deductions"]);
string[] deductionlist = deductions.Split('\\');
for (int k = 0; k < deductionlist.GetUpperBound(0); k++)
{
string getactal = deductionlist[k];
if (getactal.Trim() != "" && getactal != null)
{
string[] actallspv = getactal.Split(';');
if (actallspv.GetUpperBound(0) >= 3)
{
if (actallspv[0].ToString().Trim().ToLower() == "inc tax" || actallspv[0].ToString().Trim().ToLower() == "income tax")
{
string de = actallspv[0];
string de1 = actallspv[1];
string de2 = actallspv[2];
string[] dedspl = de2.Split('-');
if (dedspl.Length == 2)
{
if (de1.Trim().ToUpper() == "PERCENT")
{
incTax = Convert.ToString(dedspl[1]);
}
else if (de1.Trim().ToUpper() == "SLAB")
{
incTax = Convert.ToString(dedspl[1]);
}
else
{
incTax = Convert.ToString(dedspl[0]);
}
}
else
{
incTax = Convert.ToString(actallspv[3]);
}
//double InctaxAmt = 0;
//double.TryParse(incTax, out InctaxAmt);
// TotalTaxAmt = InctaxAmt;
}
}
}
}
string date = "";
double educationcess = 0;
double tax = 0;
double.TryParse(incTax, out tax);
educationcess = Math.Round(tax / 100 * 3);
double totaltaxdeduct = Math.Round(tax + educationcess);
//string challan = "";
Fpspread1.Sheets[0].RowCount = Fpspread1.Sheets[0].RowCount + 1;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Font.Bold = false;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = code;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = panno;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = name;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = date;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(gross);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Right;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = incTax;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Right;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(educationcess);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Right;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(totaltaxdeduct);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Right;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(totaltaxdeduct);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Right;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 10].CellType = txt;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 10].Text = deductdate;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 10].HorizontalAlign = HorizontalAlign.Left;
//barath 18.12.17
for (int Totalcol = 5; Totalcol < 10; Totalcol++)
{
double PrevAmt = 0;
double Amount = 0;
double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Totalcol].Text), out Amount);
if (!DeductionHash.ContainsKey(Totalcol))
{
DeductionHash.Add(Totalcol, Amount);
}
else
{
PrevAmt = 0;
double.TryParse(Convert.ToString(DeductionHash[Totalcol]), out PrevAmt);
Amount += PrevAmt;
DeductionHash[Totalcol] = Amount;
}
}
string depositDate = string.Empty;
string challanNo = string.Empty;
string monyears = string.Empty;
DataView dv1 = new DataView();
data.Tables[1].DefaultView.RowFilter = " MasterValue='" + monthyear + "'";
dv1 = data.Tables[1].DefaultView;
if (dv1.Count > 0)
{
monyears = Convert.ToString(dv1[0]["MasterCriteriavalue2"]);
challanNo = Convert.ToString(dv1[0]["MasterCriteriavalue1"]);
datemon = Convert.ToString(dv1[0]["MasterCriteria1"]);
// depositDate = datemon + "/" + monthyear;
depositDate = datemon + "/" + monyears;
}
else
{
depositDate = string.Empty;
challanNo = string.Empty;
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 11].CellType = txt;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 11].Text = depositDate;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 11].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 12].CellType = txt;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 12].Text = challanNo;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 12].HorizontalAlign = HorizontalAlign.Left;
}
//barath 18.12.17
Amt = string.Empty;
if (DeductionHash.Count > 0)
{
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].BackColor = Color.Bisque;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].ForeColor = Color.DarkRed;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = "Total";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
for (int Totalcol = 5; Totalcol < 10; Totalcol++)
{
Amt = string.Empty;
if (DeductionHash.ContainsKey(Totalcol))
{
Amt = Convert.ToString(DeductionHash[Totalcol]);
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Totalcol].Text = Amt;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Totalcol].HorizontalAlign = HorizontalAlign.Right;
}
}
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.Width = 1000;
Fpspread1.Height = 500;
rptprint.Visible = true;
}
else
{
if ((txt_dept.Text == "--Select--") || (txt_desig.Text == "--Select--") || (txt_staffc.Text == "--Select--"))
{
ermsg.Visible = true;
ermsg.Text = "Please Select Atleast One Item";
}
else
{
Fpspread1.Visible = false;
ermsg.Visible = true;
ermsg.Text = "No Records Found";
rptprint.Visible = false;
//btnprintmaster.Visible = false;
}
}
}
catch (Exception ex)
{
alertmessage.Visible = true;
lbl_alerterror.Visible = true;
lbl_alerterror.Text = ex.ToString();
}
}
void binddegree()
{
try
{
string query = "";
cbl_degree.Items.Clear();
txt_degree.Text = "--Select--";
if (ddlcollege.Items.Count > 0)
{
string educationlevel = rs.GetSelectedItemsValueAsString(cbl_edu);
if (educationlevel == "")
{
query = "select distinct d.Course_Id,c.Course_Name from Degree d,course c where d.Course_Id=c.Course_Id and d.college_code=c.college_code and d.college_code='" + ddlcollege.SelectedItem.Value + "' order by d.Course_Id";
}
else
{
query = "select distinct d.Course_Id,c.Course_Name from Degree d,course c where d.Course_Id=c.Course_Id and d.college_code=c.college_code and d.college_code='" + ddlcollege.SelectedItem.Value + "' and Edu_Level in('" + educationlevel + "') order by d.Course_Id";
}
ds.Clear();
ds = d2.select_method_wo_parameter(query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_degree.DataSource = ds;
cbl_degree.DataTextField = "course_name";
cbl_degree.DataValueField = "course_id";
cbl_degree.DataBind();
//for (int i = 0; i < cbl_degree.Items.Count; i++)
//{
cbl_degree.Items[0].Selected = true;
txt_degree.Text = lbl_degree.Text + "(1)";
cb_degree.Checked = true;
//}
}
else
{
txt_degree.Text = "--Select--";
}
}
}
catch (Exception ex)
{
}
}
public void BindBatch()
{
try
{
cbl_batch.Items.Clear();
cb_batch.Checked = false;
txt_batch.Text = "--Select--";
string college_cd = rs.GetSelectedItemsValueAsString(Cbl_college);
if (college_cd != "")
{
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
}
if (cbl_batch.Items.Count > 0)
{
//for (int row = 0; row < cbl_batch.Items.Count; row++)
//{
cbl_batch.Items[0].Selected = true;
//cb_batch.Checked = true;
//}
txt_batch.Text = "Batch(1)";
}
else
{
txt_batch.Text = "--Select--";
}
}
BindDegree();
}
catch (Exception ex)
{
d2.sendErrorMail(ex, collegecode1, "Feedback_anonymousisgender");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//****************************************************//
//string PageLogOut = "";
//string sess = Convert.ToString(Session["IsLogin"]);
//PageLogOut = Convert.ToString(Session["PageLogout"]);
//if (sess == "")
//{
//}
//else
//{
// if (!Request.FilePath.Contains("HRM"))
// {
// string strPreviousPage = "";
// if (Request.UrlReferrer != null)
// {
// strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
// }
// if (strPreviousPage == "")
// {
// string redrURI = ConfigurationManager.AppSettings["HR"].Trim();
// Response.Redirect(redrURI, false);
// return;
// }
// }
//}
//if (Session["collegecode"] == null)
//{
// string redrURI = ConfigurationManager.AppSettings["Logout"].Trim();
// Response.Redirect(redrURI, false);
// return;
//}
if (Session["collegecode"] == null)
{
Response.Redirect("~/Default.aspx");
}
if (!Request.FilePath.Contains("HRMenuIndex"))
{
string strPreviousPage = "";
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/HRMOD/HRMenuIndex.aspx");
return;
}
}
//****************************************************//
usercode = Session["usercode"].ToString();
singleuser = Session["single_user"].ToString();
group_user = Session["group_code"].ToString();
if (!IsPostBack)
{
bindcollege();
collegecode = rs.GetSelectedItemsValueAsString(cblclg);
binddept();
designation();
category();
stafftype();
staffstatus();
bindyear();
bindmonth();
}
lbl_alert.Visible = false;
lblerror.Text = "";
}
catch (Exception ex) { }
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
Printcontrol.Visible = false;
Hashtable totalvalue_dic = new Hashtable();
if (txt_degree.Text != "--Select--" && txt_branch.Text != "--Select--" && txt_batch.Text != "--Select--")
{
Fpspread1.Sheets[0].RowCount = 0;
Fpspread1.Sheets[0].ColumnCount = 0;
Fpspread1.CommandBar.Visible = false;
Fpspread1.Sheets[0].AutoPostBack = true;
Fpspread1.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread1.Sheets[0].RowHeader.Visible = false;
Fpspread1.Sheets[0].Columns.Count = 2;
string firstdate = Convert.ToString(txt_fromdate.Text);
string seconddate = Convert.ToString(txt_todate.Text);
string[] split = firstdate.Split('/');
dt = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]);
string[] split1 = seconddate.Split('/');
dt1 = Convert.ToDateTime(split1[1] + "/" + split1[0] + "/" + split1[2]);
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[0].Width = 50;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Institution Name";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].ColumnCount++;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = lbl_branch.Text;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 200;
Fpspread1.Sheets[0].ColumnCount++;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = "Enquiry";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 160;
Fpspread1.Sheets[0].ColumnCount++;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = "Applied";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 160;
Fpspread1.Sheets[0].ColumnCount++;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = "Admitted";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 160;
Fpspread1.Sheets[0].ColumnCount++;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = "Total";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 150;
if (cb_onlyadmission.Checked)
{
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 4].Visible = false;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 3].Visible = false;
Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Visible = false;
}
double totalvalue = 0; double totalval = 0;
if (cbl_branch.Items.Count > 0)//delsi Modified IsEnquiry Instead is confirm ISNULL(Admission_Status,0)=1
{
string batchyear = rs.GetSelectedItemsValueAsString(cbl_batch);
string degreecode = GetSelectedItemsValueAsString(cbl_branch, 1);
string clgcode = rs.GetSelectedItemsValueAsString(cbl_clgname);
q1 = "";
q1 = " select count(app_no)Enquiry,degree_code,c.Coll_acronymn from applyn a,collinfo c where a.college_code=c.college_code and ISNULL(IsEnquiry,0)=1 and ISNULL(IsConfirm,0)=0 and ISNULL(Admission_Status,0)=0 and degree_code in('" + degreecode + "') and batch_year in('" + batchyear + "') and date_applied between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' and a.college_code in('" + clgcode + "') group by degree_code ,c.Coll_acronymn ";
q1 += " select count(app_no)Applied,degree_code,c.Coll_acronymn from applyn a,collinfo c where a.college_code=c.college_code and ISNULL(IsConfirm,0)=1 and ISNULL(Admission_Status,0)=0 and degree_code in('" + degreecode + "') and batch_year in('" + batchyear + "') and date_applied between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' and a.college_code in('" + clgcode + "') group by degree_code ,c.Coll_acronymn ";
q1 += " select COUNT(r.app_no)Admitted,r.degree_code,c.Coll_acronymn from applyn a,Registration r,collinfo c where r.college_code=c.college_code and a.app_no=r.App_No and cc=0 and DelFlag=0 and Exam_Flag<>'debar' and r.degree_code in('" + degreecode + "') and r.batch_year in('" + batchyear + "') and r.adm_date between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' and r.college_code in('" + clgcode + "') group by r.degree_code,c.Coll_acronymn ";
//q1 = " select count(app_no)Enquiry,degree_code from applyn where ISNULL(IsConfirm,0)=0 and ISNULL(Admission_Status,0)=0 and degree_code in('" + degreecode + "') and batch_year in('" + batchyear + "') and date_applied between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' and college_code in('" + clgcode + "') group by degree_code ";
//q1 += " select count(app_no)Applied,degree_code from applyn where ISNULL(IsConfirm,0)=1 and ISNULL(Admission_Status,0)=1 and degree_code in('" + degreecode + "') and batch_year in('" + batchyear + "') and date_applied between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' and college_code in('" + clgcode + "') group by degree_code ";
//q1 += " select COUNT(r.app_no)Admitted,r.degree_code from applyn a,Registration r where a.app_no=r.App_No and cc=0 and DelFlag=0 and Exam_Flag<>'debar' and r.degree_code in('" + degreecode + "') and r.batch_year in('" + batchyear + "') and r.adm_date between '" + Convert.ToString(dt.ToString("MM/dd/yyyy")) + "' and '" + Convert.ToString(dt1.ToString("MM/dd/yyyy")) + "' r.college_code in('" + clgcode + "') group by r.degree_code";
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
int r = 1; string collegename = "";
for (i = 0; i < cbl_branch.Items.Count; i++)
{
if (cbl_branch.Items[i].Selected == true)
{
#region branch wise Bindvalue
totalvalue = 0; totalval = 0;
if (Convert.ToString(cbl_branch.Items[i].Value.Split('$')[0]) != collegename)
{
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(cbl_branch.Items[i].Value.Split('$')[2]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
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].Rows[Fpspread1.Sheets[0].RowCount - 1].BackColor = Color.Bisque;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].ForeColor = Color.Brown;
collegename = Convert.ToString(cbl_branch.Items[i].Value.Split('$')[0]);
Fpspread1.Sheets[0].SpanModel.Add(Fpspread1.Sheets[0].RowCount - 1, 0, 1, 7);
}
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(r++);
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].Text = Convert.ToString(cbl_branch.Items[i].Value.Split('$')[0]);
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].Text = Convert.ToString(cbl_branch.Items[i].Text);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(cbl_branch.Items[i].Value.Split('$')[1]);
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";
string headervalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text);
if (headervalue.Trim().ToLower() == "enquiry")
{
ds.Tables[0].DefaultView.RowFilter = " degree_code=" + Convert.ToString(cbl_branch.Items[i].Value.Split('$')[1]);
DataView dv = ds.Tables[0].DefaultView;
if (dv.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dv[0]["Enquiry"]);
if (totalvalue_dic.Contains(headervalue))
{
string value = totalvalue_dic[headervalue].ToString();
totalvalue_dic.Remove(headervalue);
int total = Convert.ToInt32(value) + Convert.ToInt32(dv[0]["Enquiry"]);
totalvalue_dic.Add(headervalue, total);
}
else
{
totalvalue_dic.Add(headervalue, Convert.ToInt32(dv[0]["Enquiry"]));
}
double.TryParse(Convert.ToString(dv[0]["Enquiry"]), out totalval);
totalvalue += totalval;
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = " - ";
}
}
headervalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text);
if (headervalue.Trim().ToLower() == "applied")
{
ds.Tables[1].DefaultView.RowFilter = " degree_code=" + Convert.ToString(cbl_branch.Items[i].Value.Split('$')[1]);
DataView dv = ds.Tables[1].DefaultView;
if (dv.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dv[0]["Applied"]);
if (totalvalue_dic.Contains(headervalue))
{
string value = totalvalue_dic[headervalue].ToString();
totalvalue_dic.Remove(headervalue);
int total = Convert.ToInt32(value) + Convert.ToInt32(dv[0]["Applied"]);
totalvalue_dic.Add(headervalue, total);
}
else
{
totalvalue_dic.Add(headervalue, Convert.ToInt32(dv[0]["Applied"]));
}
double.TryParse(Convert.ToString(dv[0]["Applied"]), out totalval);
totalvalue += totalval;
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = " - ";
}
}
headervalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text);
if (headervalue.Trim().ToLower() == "admitted")
{
ds.Tables[2].DefaultView.RowFilter = " degree_code=" + Convert.ToString(cbl_branch.Items[i].Value.Split('$')[1]);
DataView dv = ds.Tables[2].DefaultView;
if (dv.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dv[0]["Admitted"]);
if (totalvalue_dic.Contains(headervalue))
{
string value = totalvalue_dic[headervalue].ToString();
totalvalue_dic.Remove(headervalue);
int total = Convert.ToInt32(value) + Convert.ToInt32(dv[0]["Admitted"]);
totalvalue_dic.Add(headervalue, total);
}
else
{
totalvalue_dic.Add(headervalue, Convert.ToInt32(dv[0]["Admitted"]));
}
double.TryParse(Convert.ToString(dv[0]["Admitted"]), out totalval);
totalvalue += totalval;
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = " - ";
}
}
headervalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Text);
if (headervalue.Trim().ToLower() == "total")
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(totalvalue);
if (totalvalue_dic.Contains(headervalue))
{
string value = totalvalue_dic[headervalue].ToString();
totalvalue_dic.Remove(headervalue);
int total = Convert.ToInt32(value) + Convert.ToInt32(totalvalue);
totalvalue_dic.Add(headervalue, total);
}
else
{
totalvalue_dic.Add(headervalue, Convert.ToInt32(totalvalue));
}
}
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.Center;
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.Center;
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.Center;
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.Center;
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, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Name = "Book Antiqua";
#endregion
}
}
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "Grant Total";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
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";
for (int k = 3; k < Fpspread1.Sheets[0].ColumnHeader.Columns.Count; k++)
{
string seattypevalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, k].Text);
if (totalvalue_dic.Count > 0)
{
string value = "";
if (totalvalue_dic.Contains(seattypevalue))
{
value = totalvalue_dic[seattypevalue].ToString();
}
else
{
value = "0";
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Text = value;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Name = "Book Antiqua";
}
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].BackColor = Color.Bisque;
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].ForeColor = Color.IndianRed;
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.Visible = true;
rptprint.Visible = true;
lbl_error.Visible = false;
}
}
else
{
lbl_error.Visible = true;
lbl_error.Text = "Please select All Fields";
Fpspread1.Visible = false;
rptprint.Visible = false;
}
}
catch (Exception ex)
{
lbl_error.Visible = true;
lbl_error.Text = ex.ToString();
d2.sendErrorMail(ex, collegecode1, "AdmisstionDetails_report");
}
}
protected void BindQuestion()
{
try
{
if (ddl_college.Items.Count > 0 && ddl_header.Items.Count > 0 && ddl_feedback.Items.Count > 0)
{
string headercode = ""; cbl_question.Items.Clear(); txt_question.Text = "--Select--";
cbl_question1.Items.Clear(); txt_question1.Text = "--Select--";
string headercode1 = rs.GetSelectedItemsValueAsString(cbl_header1);
headercode = Convert.ToString(ddl_header.SelectedItem.Value);
if (headercode.Trim() != "")
{
string q1 = " select FeedBackMasterPK from CO_FeedBackMaster where FeedBackName='" + ddl_feedback.SelectedItem.Value + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
string FeedBackMasterPK = GetdatasetRowstring(ds, "FeedBackMasterPK");
string selqry = " select distinct Question,QuestionMasterPK from CO_QuestionMaster q, CO_FeedBackQuestions fq where q.QuestionMasterPK=fq.QuestionMasterFK and CollegeCode='" + ddl_college.SelectedItem.Value + "' and HeaderCode in('" + headercode + "') and fq.FeedBackMasterFK in('" + FeedBackMasterPK + "') order by question";
selqry += " select distinct Question,QuestionMasterPK from CO_QuestionMaster where CollegeCode='" + ddl_college1.SelectedItem.Value + "' and HeaderCode in('" + headercode1 + "') order by question";
ds = d2.select_method_wo_parameter(selqry, "Text");
cbl_question.Items.Clear();
txt_question.Text = "--Select--";
cb_question.Checked = false;
if (ds.Tables[0].Rows.Count > 0)
{
cbl_question.DataSource = ds.Tables[0];
cbl_question.DataTextField = "Question";
cbl_question.DataValueField = "QuestionMasterPK";
cbl_question.DataBind();
if (cbl_question.Items.Count > 0)
{
for (int row = 0; row < cbl_question.Items.Count; row++)
{
cbl_question.Items[row].Selected = true;
cb_question.Checked = true;
}
txt_question.Text = "Question(" + cbl_question.Items.Count + ")";
}
}
else
{
cb_question.Checked = false;
txt_question.Text = "--Select--";
}
if (ds.Tables[1].Rows.Count > 0)
{
cbl_question1.DataSource = ds.Tables[1];
cbl_question1.DataTextField = "Question";
cbl_question1.DataValueField = "QuestionMasterPK";
cbl_question1.DataBind();
if (cbl_question1.Items.Count > 0)
{
for (int row = 0; row < cbl_question1.Items.Count; row++)
{
cbl_question1.Items[row].Selected = true;
cb_question1.Checked = true;
}
txt_question1.Text = "Question(" + cbl_question1.Items.Count + ")";
}
}
else
{
cb_question1.Checked = false;
txt_question1.Text = "--Select--";
}
}
}
}
catch { }
}
public void btn_go_Click(object sender, EventArgs e)
{
try
{
string colno = "";
string hostelFk = rs.GetSelectedItemsValueAsString(cbl_hostelname);
string sessionFk = rs.GetSelectedItemsValueAsString(cbl_sessionname);
string ItemFk = rs.GetSelectedItemsValueAsString(cbl_itemname);
string menumasterFk = rs.GetSelectedItemsValueAsString(cbl_menuname);
if (ItemList.Count == 0)
{
ItemList.Add("MessName");
ItemList.Add("SessionName");
ItemList.Add("MenuName");
ItemList.Add("ItemCode");
ItemList.Add("itemname");
ItemList.Add("RPU");
ItemList.Add("Consumption_Date");
ItemList.Add("qut");
ItemList.Add("value");
ItemList.Add("Total_Present");
//ItemList.Add("VegCount");
//ItemList.Add("NonVegCount");
}
Hashtable columnhash = new Hashtable();
columnhash.Clear();
int colinc = 0;
columnhash.Add("MessName", "Mess Name");
columnhash.Add("SessionName", "Session Name");
columnhash.Add("MenuName", "Menu Name");
columnhash.Add("ItemCode", "Item Code");
columnhash.Add("itemname", "Item Name");
columnhash.Add("RPU", "RPU");
columnhash.Add("Consumption_Date", "Consumption Date");
columnhash.Add("qut", "Consumption QTY");
columnhash.Add("value", "Consumption Value");
columnhash.Add("Total_Present", "Strength");
columnhash.Add("VegStrength", "VegCount");
columnhash.Add("NonvegStrength", "NonVegCount");
string getday = "";
string gettoday = "";
string from = "";
string to = "";
from = Convert.ToString(txt_fromdate.Text);
string[] splitdate = from.Split('-');
splitdate = splitdate[0].Split('/');
DateTime dt = new DateTime();
if (splitdate.Length > 0)
{
dt = Convert.ToDateTime(splitdate[1] + "/" + splitdate[0] + "/" + splitdate[2]);
}
getday = dt.ToString("MM/dd/yyyy");
to = Convert.ToString(txt_todate.Text);
string[] splitdate1 = to.Split('-');
splitdate1 = splitdate1[0].Split('/');
DateTime dt1 = new DateTime();
if (splitdate1.Length > 0)
{
dt1 = Convert.ToDateTime(splitdate1[1] + "/" + splitdate1[0] + "/" + splitdate1[2]);
}
gettoday = dt1.ToString("MM/dd/yyyy");
if (hostelFk != "" && ItemFk != "" && sessionFk.Trim() != "" && menumasterFk.Trim() != "")
{
string selectquery = " select me.MessName,s.SessionName,i.ItemCode,i.itemname,MenuName,RPU,CONVERT(varchar(10), DailyConsDate,103) as Consumption_Date,SUM( ConsumptionQty)qut,SUM( ConsumptionQty*RPU)value,dm.Total_Present,dm.VegStrength,dm.NonvegStrength from HM_MenuMaster Ma ,HT_DailyConsumptionMaster dm ,HT_DailyConsumptionDetail dd,HM_SessionMaster s,IM_ItemMaster i,HM_MessMaster me where dd.DailyConsumptionMasterFK =dm.DailyConsumptionMasterPK and s.SessionMasterPK=dm.SessionFK and i.ItemPK=dd.ItemFK and dm.SessionFK=s.SessionMasterPK and dm.MessMasterFK=me.MessMasterPK and dm.MessMasterFK in ('" + hostelFk + "') and s.SessionMasterPK in ('" + sessionFk + "') and dd.ItemFK in ('" + ItemFk + "') and DailyConsDate between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' and dm.MenumasterFK in('" + menumasterFk + "') and dm.MenumasterFK=ma.MenuMasterPK group by DailyConsDate , dd.ItemFK , s.SessionName,MenuName, i.itemname, me.MessName ,RPU,dm.Total_Present,ItemCode,dm.VegStrength,dm.NonvegStrength order by DailyConsDate ";
ds.Clear();
ds = d2.select_method_wo_parameter(selectquery, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
pcolumnorder.Visible = true;
Fpspread1.Sheets[0].RowHeader.Visible = false;
//Fpspread1.Sheets[0].ColumnCount = 11;
Fpspread1.CommandBar.Visible = false;
Fpspread1.Sheets[0].RowCount = 0;
Fpspread1.SheetCorner.ColumnCount = 0;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread1.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread1.Sheets[0].RowHeader.Visible = false;
Fpspread1.Sheets[0].ColumnCount = ItemList.Count + 1;
Fpspread1.Sheets[0].RowCount = ds.Tables[0].Rows.Count;
Fpspread1.Sheets[0].AutoPostBack = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
colno = Convert.ToString(ds.Tables[0].Columns[j]);
if (ItemList.Contains(Convert.ToString(colno)))
{
int index = ItemList.IndexOf(Convert.ToString(colno));
Fpspread1.Sheets[0].ColumnHeader.Cells[0, index + 1].Text = Convert.ToString(columnhash[colno]);
Fpspread1.Sheets[0].ColumnHeader.Cells[0, index + 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, index + 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, index + 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, index + 1].HorizontalAlign = HorizontalAlign.Center;
}
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Fpspread1.Sheets[0].Cells[i, 0].Text = Convert.ToString(i + 1);
Fpspread1.Sheets[0].Cells[i, 0].HorizontalAlign = HorizontalAlign.Center;
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
if (ItemList.Contains(Convert.ToString(ds.Tables[0].Columns[j].ToString())))
{
int index = ItemList.IndexOf(Convert.ToString(ds.Tables[0].Columns[j].ToString()));
Fpspread1.Sheets[0].Columns[index + 1].Width = 150;
Fpspread1.Sheets[0].Columns[index + 1].Locked = true;
Fpspread1.Sheets[0].Cells[i, index + 1].CellType = txt;
Fpspread1.Sheets[0].Cells[i, index + 1].Text = ds.Tables[0].Rows[i][j].ToString();
Fpspread1.Sheets[0].Cells[i, index + 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[i, index + 1].Font.Size = FontUnit.Medium;
if (ds.Tables[0].Columns[j].ToString() == "qut")
{
Fpspread1.Sheets[0].Cells[i, index + 1].HorizontalAlign = HorizontalAlign.Center;
}
if (ds.Tables[0].Columns[j].ToString() == "value")
{
Fpspread1.Sheets[0].Cells[i, index + 1].HorizontalAlign = HorizontalAlign.Right;
}
if (ds.Tables[0].Columns[j].ToString() == "Total_Present" || ds.Tables[0].Columns[j].ToString() == "VegStrength" || ds.Tables[0].Columns[j].ToString() == "NonvegStrength")
{
Fpspread1.Sheets[0].Cells[i, index + 1].HorizontalAlign = HorizontalAlign.Right;
}
}
}
}
rptprint.Visible = true;
Fpspread1.Visible = true;
div1.Visible = true;
lbl_error.Visible = false;
pheaderfilter.Visible = true;
pcolumnorder.Visible = true;
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].SetColumnMerge(3, FarPoint.Web.Spread.Model.MergePolicy.Always);
Fpspread1.Sheets[0].SetColumnMerge(4, FarPoint.Web.Spread.Model.MergePolicy.Always);
Fpspread1.Sheets[0].SetColumnMerge(5, FarPoint.Web.Spread.Model.MergePolicy.Always);
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
}
else
{
rptprint.Visible = false;
// imgdiv2.Visible = true;
//lbl_alert.Text = "No records found";
lbl_error.Text = "No records found";
pheaderfilter.Visible = false;
pcolumnorder.Visible = false;
div1.Visible = false;
Fpspread1.Visible = false;
}
}
else
{
rptprint.Visible = false;
// imgdiv2.Visible = true;
//lbl_alert.Text = "No records found";
lbl_error.Visible = true;
lbl_error.Text = "Please Select Any One Record";
pheaderfilter.Visible = false;
pcolumnorder.Visible = false;
div1.Visible = false;
Fpspread1.Visible = false;
}
}
catch (Exception ex)
{
}
}
protected void btngo_Click(object sender, EventArgs e)
{
try
{
//divfpspread.Visible = true;
btnxl.Visible = true;
lblrptname.Visible = true;
txtexcelname.Visible = true;
Printcontrol.Visible = false;
btnprintmaster.Visible = true;
pnlContent1.Visible = true;
Fpspread.Sheets[0].Visible = true;
string valCollege = string.Empty;
lblnorec.Visible = false;
string sumpart = string.Empty;
int value = 0;
int sno = 0;
valCollege = rs.GetSelectedItemsValueAsString(cblCollege);
if (valCollege != "")
{
if (txtfromDate.Text != "" && txttoDate.Text != "")
{
frdate = txtfromDate.Text;
todate = txttoDate.Text;
string dt = frdate;
string[] dsplit = dt.Split(new Char[] { '-' });
frdate = dsplit[2].ToString() + "-" + dsplit[1].ToString() + "-" + dsplit[0].ToString();
demfcal = int.Parse(dsplit[2].ToString());
demfcal = demfcal * 12;
cal_from_date = demfcal + int.Parse(dsplit[1].ToString());
cal_from_attdate_tmp = demfcal + int.Parse(dsplit[1].ToString());
monthcal = cal_from_date.ToString();
dt = todate;
dsplit = dt.Split(new Char[] { '-' });
spltodate = dsplit[1].ToString() + "/" + dsplit[0].ToString() + "/" + dsplit[2].ToString();
todate = dsplit[2].ToString() + "-" + dsplit[1].ToString() + "-" + dsplit[0].ToString();
demtcal = int.Parse(dsplit[2].ToString());
demtcal = demtcal * 12;
cal_to_date = demtcal + int.Parse(dsplit[1].ToString());
cal_to_attdate_tmp = demtcal + int.Parse(dsplit[1].ToString());
per_from_attdate = Convert.ToDateTime(frdate);
per_to_attdate = Convert.ToDateTime(todate);
if (per_from_attdate <= per_to_attdate)
{
#region colbinding
Fpspread.Sheets[0].AutoPostBack = true;
Fpspread.Sheets[0].RowHeader.Visible = false;
Fpspread.Sheets[0].ColumnHeader.Visible = true;
MyStyle.Font.Size = FontUnit.Medium;
MyStyle.Font.Name = "Book Antiqua";
MyStyle.Font.Bold = true;
MyStyle.HorizontalAlign = HorizontalAlign.Center;
MyStyle.ForeColor = Color.White;
MyStyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
Fpspread.Sheets[0].ColumnHeader.DefaultStyle = MyStyle;
Fpspread.CommandBar.Visible = false;
Fpspread.Sheets[0].ColumnCount = 5;
Fpspread.Sheets[0].RowCount = 0;
Fpspread.BorderWidth = 2;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "College Name";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Total Strenth";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Present %";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Absent %";
Fpspread.Columns[4].Width = 25;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
#endregion
// // string sql = "select * from Registration r,attendance a where r.Roll_No=a.roll_no and r.App_No=a.Att_App_no and a.Att_CollegeCode= r.college_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and a.month_year between '" + cal_from_attdate_tmp + "' and '" + cal_to_attdate_tmp + "' and r.college_code in('" + valCollege + "')";
string sql = "select * from Registration r,attendance a where r.Roll_No=a.roll_no and r.App_No=a.Att_App_no and a.Att_CollegeCode= r.college_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and a.month_year between '" + cal_from_attdate_tmp + "' and '" + cal_to_attdate_tmp + "' and r.college_code in('" + valCollege + "') order by r.degree_code,r.Roll_No";
ds = da.select_method_wo_parameter(sql, "text");
int fprow = 0;
for (int clg = 0; clg < cblCollege.Items.Count; clg++)
{
if (cblCollege.Items[clg].Selected == true)
{
double present = 0;
double absent = 0;
int hour = 0;
double tolhour_perclg = 0;
int cunstu = 0;
//int tolhour_perclg = 0;
Fpspread.Sheets[0].RowCount++;
sno++;
string stucon = da.GetFunction("select count(distinct r.app_no) from Registration r where r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and r.college_code='" + cblCollege.Items[clg].Value + "' and Adm_Date<='" + spltodate + "'");
//string stucon = da.GetFunction("select count(distinct r.roll_no) from Registration r,attendance a where r.Roll_No=a.roll_no and r.App_No=a.Att_App_no and a.Att_CollegeCode= r.college_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and a.month_year between '" + cal_from_attdate_tmp + "' and '" + cal_to_attdate_tmp + "' and r.college_code in('" + cblCollege.Items[clg].Value + "')");
//ds = da.select_method("bind_branch", has, "sp");
//string gendegree = "select distinct r.degree_code from Registration r,attendance a where r.Roll_No=a.roll_no and r.App_No=a.Att_App_no and a.Att_CollegeCode= r.college_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and a.month_year between '" + cal_from_attdate_tmp + "' and '" + cal_to_attdate_tmp + "' and r.college_code='" + cblCollege.Items[clg].Value +"' order by r.degree_code";
string valcolle_code = Convert.ToString(cblCollege.Items[clg].Value).Trim();
int valcoll_code;
int.TryParse(valcolle_code, out valcoll_code);
has.Clear();
has.Add("valcoll_code", valcoll_code);
has.Add("cal_from_attdate_tmp", cal_from_attdate_tmp);
has.Add("cal_to_attdate_tmp", cal_to_attdate_tmp);
DataSet degreegener = da.select_method("attoverallclg_coll", has, "sp");
//DataSet degreegener = da.select_method_wo_parameter(gendegree, "text");
for (int degrow = 0; degrow < degreegener.Tables[0].Rows.Count; degrow++)
{
int tolhour_perdeg = 0;
string hrs = da.GetFunction("select No_of_hrs_per_day from PeriodAttndSchedule where degree_code='" + degreegener.Tables[0].Rows[degrow]["degree_code"] + "'");
int.TryParse(hrs, out hour);
//string stud =da.GetFunction(" select count(distinct r.roll_no) from Registration r,attendance a where r.Roll_No=a.roll_no and r.App_No=a.Att_App_no and a.Att_CollegeCode= r.college_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag <>'debar' and a.month_year between '" + cal_from_attdate_tmp + "' and '" + cal_to_attdate_tmp + "'and r.degree_code='" + degreegener.Tables[0].Rows[degrow]["degree_code"] + "' and r.college_code='" + cblCollege.Items[clg].Value + "'");
ds.Tables[0].DefaultView.RowFilter = "college_code='" + cblCollege.Items[clg].Value + "' and degree_code='" + degreegener.Tables[0].Rows[degrow]["degree_code"] + "'";
DataView clgfilter = ds.Tables[0].DefaultView;
for (DateTime dtt = per_from_attdate; dtt <= per_to_attdate; dtt = dtt.AddDays(1))
{
//for (int degrow = 0; degrow < clgfilter.Count; degrow++)
// {
//ds.Tables[0].DefaultView.RowFilter = "month_year='" + cal_from_date + "'";
for (int i = 1; i <= hour; i++)
{
for (int sturow = 0; sturow < clgfilter.Count; sturow++)
{
date = "d" + dtt.Day.ToString("") + "d" + i.ToString();
string maxval = Convert.ToString(clgfilter[sturow][date]).Trim();
if (maxval != "" && maxval != "0" && maxval != "NULL" && maxval != "Null" && maxval != "null" && maxval != "H" && maxval != "NJ" && maxval != "Null")
{
int.TryParse(maxval, out value);
string valqu = da.GetFunction("select CalcFlag from AttMasterSetting where collegecode=13 and LeaveCode='" + value + "' group by CalcFlag");
int.TryParse(valqu, out value);
if (value == 0)
{
present = present + 1;
}
else
{
absent = absent + 1;
}
}
else
{
}
}
}
tolhour_perdeg += hour;
}
//int.TryParse(stud, out cunstu);
//tolhour_perdeg *= cunstu;
//tolhour_perclg += tolhour_perdeg;
tolhour_perclg = present + absent;
}
if (present != 0)
{
present = (present / tolhour_perclg);
present = Math.Round(present, 3);
present = present * 100;
sumpart = String.Format("{0:0.00}", present);
}
if (absent != 0)
{
absent = (absent / tolhour_perclg);
absent = Math.Round(absent, 3);
absent = absent * 100;
sumpart = String.Format("{0:0.00}", absent);
}
Fpspread.Sheets[0].Cells[fprow, 0].Text = sno.ToString();
Fpspread.Columns[0].Width = 10;
Fpspread.Sheets[0].Cells[fprow, 0].Font.Bold = true;
Fpspread.Sheets[0].Cells[fprow, 0].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].Cells[fprow, 0].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[fprow, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[fprow, 1].Text = cblCollege.Items[clg].ToString();
Fpspread.Columns[1].Width = 100;
Fpspread.Sheets[0].Cells[fprow, 1].Font.Bold = true;
Fpspread.Sheets[0].Cells[fprow, 1].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].Cells[fprow, 1].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[fprow, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread.Sheets[0].Cells[fprow, 2].Text = stucon.ToString();
Fpspread.Columns[2].Width = 25;
Fpspread.Sheets[0].Cells[fprow, 2].Font.Bold = true;
Fpspread.Sheets[0].Cells[fprow, 2].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].Cells[fprow, 2].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[fprow, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[fprow, 3].Text = present.ToString();
Fpspread.Columns[3].Width = 25;
Fpspread.Sheets[0].Cells[fprow, 3].Font.Bold = true;
Fpspread.Sheets[0].Cells[fprow, 3].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].Cells[fprow, 3].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[fprow, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].Cells[fprow, 4].Text = absent.ToString();
Fpspread.Sheets[0].Cells[fprow, 4].Font.Bold = true;
Fpspread.Sheets[0].Cells[fprow, 4].Font.Name = "Book Antiqua";
Fpspread.Sheets[0].Cells[fprow, 4].Font.Size = FontUnit.Medium;
Fpspread.Sheets[0].Cells[fprow, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread.Sheets[0].PageSize = Fpspread.Sheets[0].RowCount;
Fpspread.Width = 900;
Fpspread.Height = 700;
Fpspread.SaveChanges();
fprow++;
}
}
}
else
{
Fpspread.Visible = false;
btnxl.Visible = false;
lblrptname.Visible = false;
txtexcelname.Visible = false;
Printcontrol.Visible = false;
btnprintmaster.Visible = false;
lblnorec.Visible = true;
lblnorec.Text = "Please select the To date is greater then From date";
}
}
else
{
Fpspread.Visible = false;
btnxl.Visible = false;
lblrptname.Visible = false;
txtexcelname.Visible = false;
Printcontrol.Visible = false;
btnprintmaster.Visible = false;
lblnorec.Visible = true;
lblnorec.Text = "Please select the From date and To date";
}
}
else
{
btnxl.Visible = false;
lblrptname.Visible = false;
txtexcelname.Visible = false;
Printcontrol.Visible = false;
btnprintmaster.Visible = false;
Printcontrol.Visible = false;
Fpspread.Visible = false;
lblnorec.Visible = true;
lblnorec.Text = "Please select the College";
}
}
catch (Exception ex)
{
da.sendErrorMail(ex, collegeCode, "OverallcollegeAttendancepercentage");
}
}
protected void btngo_click(object sender, EventArgs e)
{
try
{
// btnresetpriority_click(sender, e);
string degreecode = rs.GetSelectedItemsValueAsString(cbl_degree);
string collegecode = Convert.ToString(ddlcolhouse.SelectedItem.Value);
if (!string.IsNullOrEmpty(degreecode) && ddlcolhouse.Items.Count > 0)
{
string selectquery = "select Degree_Code,isnull(c.type,'')+'-'+c.Course_Name+'-'+dt.Dept_Name as Dept_Name,Dept_Priority,Acronym from Degree d,Department dt,course c where d.Dept_Code=dt.Dept_Code and c.Course_Id =d.Course_Id and d.college_code in ('" + collegecode + "') and d.Degree_Code in('" + degreecode + "') order by ISNULL(c.Priority,0)";
ds.Clear();
ds = d2.select_method_wo_parameter(selectquery, "Text");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Fpspreadpophouse.Sheets[0].RowCount = 0;
Fpspreadpophouse.Sheets[0].ColumnCount = 0;
Fpspreadpophouse.CommandBar.Visible = false;
Fpspreadpophouse.Sheets[0].AutoPostBack = false;
Fpspreadpophouse.Sheets[0].ColumnHeader.RowCount = 1;
Fpspreadpophouse.Sheets[0].RowHeader.Visible = false;
Fpspreadpophouse.Sheets[0].ColumnCount = 5;
FarPoint.Web.Spread.CheckBoxCellType cbhousepriority = new FarPoint.Web.Spread.CheckBoxCellType();
cbhousepriority.AutoPostBack = true;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.Font.Bold = true;
darkstyle.Border.BorderSize = 1;
darkstyle.HorizontalAlign = HorizontalAlign.Center;
darkstyle.VerticalAlign = VerticalAlign.Middle;
darkstyle.Border.BorderColor = System.Drawing.Color.Transparent;
Fpspreadpophouse.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[0].Locked = true;
Fpspreadpophouse.Columns[0].Width = 50;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Degree";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[1].Locked = true;
Fpspreadpophouse.Columns[1].Width = 400;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Degree Acronym";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[2].Locked = true;
Fpspreadpophouse.Columns[2].Width = 150;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Set Priority";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[3].Locked = false;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Degree Priority";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[4].Locked = true;
Fpspreadpophouse.Columns[4].Width = 85;
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
Fpspreadpophouse.Sheets[0].RowCount++;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[row]["Dept_Name"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["Degree_Code"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["Acronym"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].CellType = cbhousepriority;
if (Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]).Trim() != "" && Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]).Trim() != "0")
{
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Value = 1;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Locked = true;
}
else
{
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Value = 0;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Locked = false;
}
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 4].Text = (Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]) == "0") ? "" : Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
}
spreadDiv.Visible = true;
Fpspreadpophouse.Sheets[0].PageSize = Fpspreadpophouse.Sheets[0].RowCount;
}
else
{
spreadDiv.Visible = false;
}
}
else
{
spreadDiv.Visible = false;
}
Fpspreadpophouse.SaveChanges();
}
else
{
spreadDiv.Visible = false;
alertpop.Visible = true;
lbl_alert.Visible = true;
lbl_alert.Text = "Please Select All Fields";
}
}
catch { }
}
public void Gofuncation()
{
try
{
string Branch = Rs.GetSelectedItemsValueAsString(cbl_branch);
string batch = Convert.ToString(ddl_batch.SelectedItem.Text);
string college = Convert.ToString(ddlcollege.SelectedValue);
string[] fromDate = txtFromDate.Text.Split('/');
string[] toDate = txtToDate.Text.Split('/');
string fromDt = fromDate[1] + "/" + fromDate[0] + "/" + fromDate[2];
string toDt = toDate[1] + "/" + toDate[0] + "/" + toDate[2];
string Stream = string.Empty;
string Category = string.Empty;
if (ddlStream.SelectedItem.Text != "All")
{
Stream = ddlStream.SelectedValue;
}
if (ddlSession.SelectedItem.Text != "All")
{
Category = ddlSession.SelectedValue;
}
DataTable data = new DataTable();
DataView Dsview = new DataView();
DataView DvRank = new DataView();
string Query = "select r.app_no,r.Roll_Admit,r.Stud_Name,CONVERT(varchar(10),r.Adm_Date,103) as AdmitDate,(select Mastervalue from CO_MasterValues where MasterCode=a.quota) as Categroy,a.quota,a.StreamAdmission,(select TextVal from TextValTable where TextCode= a.StreamAdmission) as Stream,r.degree_code,st.HSCMarkSec,st.CombinedScore,st.CombinedScoreSII,enrollment_card_date,(c.Course_Name +''+dt.Dept_Name) as Departmet from applyn a,Registration r,ST_Student_Mark_Detail st ,Degree d,Department dt,Course c where d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and a.app_no =r.App_No and a.app_no =st.ST_AppNo and r.App_No =st.ST_AppNo and CC=0 and DelFlag =0 and Exam_Flag <>'Debar' and r.college_code ='" + college + "' and r.Batch_Year ='" + batch + "' and r.degree_code in ('" + Branch + "') and Adm_Date between '" + fromDt + "' and '" + toDt + "' ";
if (Stream.Trim() != "")
{
Query += " and a.StreamAdmission ='" + Stream + "'";
}
if (Category.Trim() != "")
{
Query += " and a.quota ='" + Category + "'";
}
Query += " select ST_Rank,ST_RankCriteria,ST_Stream,ST_AppNo from ST_RankTable St,Registration r where st.ST_AppNo =r.App_No and r.degree_code in ('" + Branch + "') and r.college_code ='" + college + "' and r.Batch_Year ='" + batch + "'";
if (Stream.Trim() != "")
{
Query += " and ST_Stream ='" + Stream + "'";
}
if (Category.Trim() != "")
{
Query += " and ST_RankCriteria ='" + Category + "'";
}
ds.Clear();
ds = d2.select_method_wo_parameter(Query, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int SNo = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Columns[FpSpread1.Sheets[0].ColumnCount - 1].Width = 25;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Admission / Application No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Student Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Date of Admit";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Combined Score";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Percentile";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Rank";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
FarPoint.Web.Spread.TextCellType db = new FarPoint.Web.Spread.TextCellType();
data = ds.Tables[0].DefaultView.ToTable(true, "degree_code", "StreamAdmission", "quota");
DataView Dsort = data.DefaultView;
Dsort.Sort = "degree_code,StreamAdmission,quota";
for (int intds = 0; intds < Dsort.Count; intds++)
{
ds.Tables[0].DefaultView.RowFilter = "degree_code='" + Convert.ToString(Dsort[intds]["degree_code"]) + "' and StreamAdmission='" + Convert.ToString(Dsort[intds]["StreamAdmission"]) + "' and quota='" + Convert.ToString(Dsort[intds]["quota"]) + "'";
Dsview = ds.Tables[0].DefaultView;
string Strm = Convert.ToString(Dsview[0]["Stream"]);
if (Strm.Trim() != "Stream II")
{
Dsview.Sort = " CombinedScore desc";
}
else
{
Dsview.Sort = " CombinedScoreSII desc,stud_name asc";
}
if (Dsview.Count > 0)
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = (Convert.ToString(Dsview[0]["Departmet"]) + " " + Convert.ToString(Dsview[0]["Stream"]) + " " + Convert.ToString(Dsview[0]["Categroy"]));
FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, FpSpread1.Sheets[0].ColumnCount);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Bold = true;
for (int intdv = 0; intdv < Dsview.Count; intdv++)
{
SNo++;
string AppNo = Convert.ToString(Dsview[intdv]["app_no"]);
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(SNo);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(Dsview[intdv]["Roll_Admit"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(Dsview[intdv]["stud_name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(Dsview[intdv]["AdmitDate"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
double comI = 0;
string ComIIval = Convert.ToString(Dsview[intdv]["CombinedScore"]);
double.TryParse(ComIIval, out comI);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = db;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(Math.Round(comI, 4));
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
double comII = 0;
string ComIIvalue = Convert.ToString(Dsview[intdv]["CombinedScoreSII"]);
double.TryParse(ComIIvalue, out comII);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].CellType = db;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(Math.Round(comII, 4));
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
ds.Tables[1].DefaultView.RowFilter = "ST_RankCriteria='" + Convert.ToString(Dsort[intds]["quota"]) + "' and ST_Stream ='" + Convert.ToString(Dsort[intds]["StreamAdmission"]) + "' and ST_AppNo ='" + AppNo + "'";
DvRank = ds.Tables[1].DefaultView;
if (DvRank.Count > 0)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(DvRank[0]["ST_Rank"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
}
}
}
}
if (FpSpread1.Sheets[0].RowCount > 0)
{
FpSpread1.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
div_report.Visible = true;
}
}
else
{
lblAlertMsg.Text = "No Record(s) Found";
lblAlertMsg.Visible = true;
divPopupAlert.Visible = true;
return;
}
}
catch
{
}
}
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 { }
}
public void BindBatch()
{
try
{
cbl_batch.Items.Clear();
cb_batch.Checked = false;
txt_batch.Text = "--Select--";
string college_cd = rs.GetSelectedItemsValueAsString(Cbl_college);
if (college_cd != "")
{
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
}
if (cbl_batch.Items.Count > 0)
{
cbl_batch.Items[0].Selected = true;
txt_batch.Text = "Batch(1)";
}
else
{
txt_batch.Text = "--Select--";
}
}
BindDegree();
}
catch (Exception ex)
{
}
}
