//Added by Idhris 16-02-2017 protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } collegeCode = Session["collegecode"].ToString(); userCode = Session["usercode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!Page.IsPostBack) { try { bindCollege(); cb_College_CheckedChanged(sender, e); } catch { } } else { clearGrid(); } collegeCode = reUse.GetSelectedItemsValue(cbl_College); }
public void BindStaffCategory() { try { cbl_Category.Items.Clear(); string Collcode = rs.GetSelectedItemsValue(cbl_college); string Query = string.Empty; if (Collcode.Trim() != "") { Query = "select distinct Category_name from staffcategorizer where college_Code in (" + Collcode + ")"; } else { Query = "select distinct Category_name from staffcategorizer"; } ds.Clear(); ds = d2.select_method_wo_parameter(Query, "Text"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { cbl_Category.DataSource = ds; cbl_Category.DataTextField = "Category_name"; cbl_Category.DataValueField = "Category_name"; cbl_Category.DataBind(); cb_Category.Checked = true; CallCheckBoxChangedEvent(cbl_Category, cb_Category, txt_Category, "Category"); } } catch { } }
//Added by Idhris 16-02-2017 protected void Page_Load(object sender, EventArgs e) { try { //****************************************************// if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } if (!Request.FilePath.Contains("CoeHome")) { string strPreviousPage = ""; if (Request.UrlReferrer != null) { strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1]; } if (strPreviousPage == "") { Response.Redirect("~/CoeMod/CoeHome.aspx"); return; } } //****************************************************// collegeCode = Session["collegecode"].ToString(); userCode = Session["usercode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!Page.IsPostBack) { try { bindCollege(); cb_College_CheckedChanged(sender, e); } catch { } } else { clearGrid(); } collegeCode = reUse.GetSelectedItemsValue(cbl_College); } catch (Exception ex) { } }
public void bindsec() { try { //ddl_sec.Items.Clear(); cbl_sec.Items.Clear(); cb_sec.Checked = true; txt_sec.Text = "Section"; ListItem item = new ListItem("Empty", " "); string batch = ""; batch = ddl_batch.Items.Count > 0 ? ddl_batch.SelectedValue : "0"; string branch = ""; branch = reUse.GetSelectedItemsValue(cbl_branch);//ddl_branch.Items.Count > 0 ? ddl_branch.SelectedValue : "0"; DataSet dsSec = DA.BindSectionDetail(batch, branch); if (dsSec.Tables.Count > 0 && dsSec.Tables[0].Rows.Count > 0) { //ddl_sec.DataSource = dsSec; //ddl_sec.DataTextField = "sections"; //ddl_sec.DataValueField = "sections"; //ddl_sec.DataBind(); cbl_sec.DataSource = dsSec; cbl_sec.DataTextField = "sections"; cbl_sec.DataValueField = "sections"; cbl_sec.DataBind(); reUse.CallCheckBoxChangedEvent(cbl_sec, cb_sec, txt_sec, "Section"); } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } collegeCode = Session["collegecode"].ToString(); userCode = Session["usercode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!Page.IsPostBack) { try { bindCollege(); cb_College_CheckedChanged(sender, e); string StreamShift = string.Empty; try { StreamShift = Convert.ToString(Session["streamcode"]); if (StreamShift.Trim() == "") { StreamShift = "Stream"; } } catch { StreamShift = "Stream"; } lbl_stream.Text = StreamShift; } catch { } } else { clearSpread(); } collegeCode = reUse.GetSelectedItemsValue(cbl_College); }
//Base screen save protected void btnDaySlotSave_OnClick(object sender, EventArgs e) { try { string collegeCode = Convert.ToString(ddlCollege.SelectedValue); string batchYear = Convert.ToString(ddlbatch.SelectedValue); string eduLevel = Convert.ToString(ddlEduLev.SelectedValue); //string courseCode = Convert.ToString(ddlcourse.SelectedValue); string courseCode = rs.GetSelectedItemsValue(cbl_Session); string streamCode = Convert.ToString(ddlStream.SelectedValue); string criteriaCode = Convert.ToString(ddlCategory.SelectedValue); string includebatch = "0"; if (cb_includebatch.Checked) { includebatch = "1"; } if (collegeCode != string.Empty && batchYear != string.Empty && eduLevel != string.Empty && courseCode != string.Empty && streamCode != string.Empty) { string saveVal = collegeCode + "$" + batchYear + "$" + eduLevel + "$" + courseCode + "$" + streamCode + "$" + criteriaCode; string insUpdQ = " IF EXISTS (SELECT LinkValue FROM New_InsSettings WHERE LinkName='ADMISSIONCOURSESELECTIONSETTINGS' AND college_code='" + collegeCode + "') UPDATE New_InsSettings SET LinkValue='" + saveVal + "' WHERE LinkName='ADMISSIONCOURSESELECTIONSETTINGS' AND college_code='" + collegeCode + "' INSERT INTO New_InsSettings (LinkName,LinkValue,college_code) VALUES ('ADMISSIONCOURSESELECTIONSETTINGS','" + saveVal + "','" + collegeCode + "') "; insUpdQ += " if exists (select linkname from New_InsSettings where user_code='" + UserCode + "' and college_code='" + collegeCode + "' and LinkName='RoomDetailIncludebatch') update New_InsSettings set LinkValue='" + includebatch + "' where user_code='" + UserCode + "' and college_code='" + collegeCode + "' and LinkName='RoomDetailIncludebatch' else insert into New_InsSettings (LinkName,LinkValue,user_code,college_code) values('RoomDetailIncludebatch','" + includebatch + "','" + UserCode + "','" + collegeCode + "') "; string commDate = txtCommDate.Text; string commTime = ddlComHrs.SelectedValue + ":" + ddlCommMin.SelectedValue + " " + ddlCommAmPm.SelectedValue; insUpdQ += " if exists (select linkname from New_InsSettings where college_code='" + collegeCode + "' and LinkName='CommenceDateAndTime') update New_InsSettings set LinkValue='" + (commDate + "," + commTime) + "' where college_code='" + collegeCode + "' and LinkName='CommenceDateAndTime' else insert into New_InsSettings (LinkName,LinkValue,user_code,college_code) values('CommenceDateAndTime','" + (commDate + "," + commTime) + "','" + UserCode + "','" + collegeCode + "') "; string hosteltransportvalue = (cb_hostelfees.Checked == true) ? "1" : "0"; hosteltransportvalue += (cb_transportfees.Checked == true) ? ",1" : ",0"; insUpdQ += " if exists (SELECT * FROM New_InsSettings WHERE LinkName='ONLY HOSTELFEE OR TRANSPORTFEE' AND college_code='" + collegeCode + "' and user_code='" + UserCode + "')UPDATE New_InsSettings SET LinkValue='" + hosteltransportvalue + "' WHERE LinkName='ONLY HOSTELFEE OR TRANSPORTFEE' AND college_code='" + collegeCode + "' and user_code='" + UserCode + "' ELSE INSERT INTO New_InsSettings (LinkName,LinkValue,user_code,college_code)VALUES('ONLY HOSTELFEE OR TRANSPORTFEE','" + hosteltransportvalue + "','" + UserCode + "','" + collegeCode + "')"; string ShwolistRigester = (cb_ListRegister.Checked == true) ? "1" : "0"; insUpdQ += " if exists (SELECT * FROM New_InsSettings WHERE LinkName='ShowListRegistration' AND college_code='" + collegeCode + "' and user_code='" + UserCode + "')UPDATE New_InsSettings SET LinkValue='" + ShwolistRigester + "' WHERE LinkName='ShowListRegistration' AND college_code='" + collegeCode + "' and user_code='" + UserCode + "' ELSE INSERT INTO New_InsSettings (LinkName,LinkValue,user_code,college_code)VALUES('ShowListRegistration','" + ShwolistRigester + "','" + UserCode + "','" + collegeCode + "')"; dirAcc.updateData(insUpdQ); lbl_alert.Text = "Saved Successfully"; } else { lbl_alert.Text = "Please check inputs"; } } catch { lbl_alert.Text = "Please try later"; } imgdiv2.Visible = true; }
private void loadspreadCount(DataSet ds) { try { int chk = 0; bool forenoon = false; DataTable dt = new DataTable(); dt.Columns.Add("date"); dt.Columns.Add("hall"); dt.Columns.Add("testno"); dt.Columns.Add("fn"); dt.Columns.Add("an"); int sno = 0; DataTable dtnew = new DataTable(); DateTime examinttime = new DateTime(); DateTime an = new DateTime(); DateTime fn = new DateTime(); string examtime = string.Empty; string Antime = string.Empty; string Fntime = string.Empty; if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int row = 0; row < ds.Tables[0].Rows.Count; row++) { string date = Convert.ToString(ds.Tables[0].Rows[row]["ExamDate"]).Trim(); string hallno = Convert.ToString(ds.Tables[0].Rows[row]["hallNo"]).Trim(); string testno = Convert.ToString(ds.Tables[0].Rows[row]["criteriaNo"]).Trim(); examinttime = Convert.ToDateTime(ds.Tables[0].Rows[row]["ExamInTime"]); an = Convert.ToDateTime("09:00:00"); fn = Convert.ToDateTime("12:00:00"); examtime = Convert.ToString(examinttime); Antime = Convert.ToString(an); Fntime = Convert.ToString(fn); dr = dt.NewRow(); dr["date"] = date; dr["hall"] = hallno; dr["testno"] = testno; if ((!string.IsNullOrEmpty(examtime) && !string.IsNullOrEmpty(Antime)) || (!string.IsNullOrEmpty(examtime) && !string.IsNullOrEmpty(Fntime))) { string[] split = examtime.Split(' '); string[] split1 = Antime.Split(' '); string[] split2 = Fntime.Split(' '); if ((split.Length > 0 && split1.Length > 0) || (split.Length > 0 && split2.Length > 0)) { string ExamInTime = split[1]; string AnTime = split1[1]; string FnTime = split2[1]; if (Convert.ToDateTime(ExamInTime) < Convert.ToDateTime(AnTime)) { chk = 1; forenoon = false; anoon = true; } else if (Convert.ToDateTime(ExamInTime) <= Convert.ToDateTime(FnTime)) { chk = 1; forenoon = true; fnoon = true; } } } dt.Rows.Add(dr); } GridView1.DataSource = dt; GridView1.DataBind(); GridView1.Visible = true; DataSet dssave = new DataSet(); string StaffTestexists = string.Empty; string TestNo = string.Empty; string CriteriaNumber = string.Empty; if (cbl_cycletest.Items.Count > 0) { TestNo = Convert.ToString(rs.GetSelectedItemsValue(cbl_cycletest)); } staff_code = (string)Session["Staff_Code"]; if (!string.IsNullOrEmpty(staff_code) && !string.IsNullOrEmpty(TestNo)) { StaffTestexists = "select distinct isa.hallNo,isa.criteriaNo,isa.examDate,isa.examSession,isa.examCode,isa.staff_code from internalSeatingArragement isa where staff_code='" + staff_code + "'"; //and criteriaNo in('" + CycleTestno + "') dssave.Clear(); dssave = d2.select_method_wo_parameter(StaffTestexists, "Text"); if (dssave.Tables.Count > 0 && dssave.Tables[0].Rows.Count > 0) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int noofrecord = 0; noofrecord < ds.Tables[0].Rows.Count; noofrecord++) { string totalcriteriaNo = Convert.ToString(ds.Tables[0].Rows[noofrecord]["criteriaNo"]).Trim(); for (int saverecord = 0; saverecord < dssave.Tables[0].Rows.Count; saverecord++) { string savecriteriaNo = Convert.ToString(dssave.Tables[0].Rows[saverecord]["criteriaNo"]).Trim(); if (totalcriteriaNo == savecriteriaNo) { for (int k = 0; k < GridView1.Rows.Count; k++) { checkbx = true; if (forenoon == true) { dt.Rows[noofrecord]["fn"] = 1; dt.Rows[noofrecord]["an"] = 0; } else { dt.Rows[noofrecord]["fn"] = 0; dt.Rows[noofrecord]["an"] = 1; } } } } } } } } GridView1.DataSource = dt; GridView1.DataBind(); showreport1.Visible = true; btn_save.Visible = true; } } catch (Exception ex) { d2.sendErrorMail(ex, collegecode, "InvigilationSelection"); } }
protected void SaveDetails() { try { string degreecode = rs.GetSelectedItemsValue(cbldepartment); string batchyear = Convert.ToString(ddlbatch.SelectedItem.Text); string type = Convert.ToString(ddltype.SelectedItem.Text); string edulevel = Convert.ToString(ddledulevel.SelectedItem.Text); string Query = " select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections,h.HostelMasterFK,hm.HostelName,isnull(a.studhouse,'')studhouse from applyn a, degree d,Department dt,Course C,Registration r left join HT_HostelRegistration h on r.App_No=h.APP_No left join hm_hostelmaster hm on h.HostelMasterFK=hm.HostelMasterPK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and c.type ='" + type + "' and c.Edu_Level ='" + edulevel + "' and a.college_code='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' and r.batch_year in('" + batchyear + "') and d.Degree_Code in ('" + degreecode + "') order by isnull(d.Dept_Priority,10000),r.Reg_No asc";//c.Course_Id,d.Degree_Code,AdmitedDate"; Query += " select HouseName+'$'+CONVERT(varchar(10), HousePK) as HouseName,Gender,GenderPriority from HousingDetails where collegecode='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' order by isnull(HousePriority,0),ISNULL(GenderPriority,0),isnull(OrderBy,0) asc"; ds.Clear(); //ds = d2.select_method_wo_parameter(Query, "Text"); Hashtable HouseDetHash = new Hashtable(); HouseDetHash.Add("stream", type); HouseDetHash.Add("eduLevel", edulevel); HouseDetHash.Add("collegeCode", Convert.ToString(ddl_collegename.SelectedItem.Value)); HouseDetHash.Add("degreecode", degreecode); HouseDetHash.Add("batchYear", batchyear); ds = d2.select_method("AutohouseGeneration", HouseDetHash, "sp"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-150/Reg No-150/Admission No-150/Gender-70/Section-70/" + lblDeg.Text + "-100/" + lblBran.Text + "-200/House Name-180", FpSpread, "FALSE"); int MaleCurrentRow = 0; int FemaleCurrentRow = 0; List <String> MaleHousingArr = new List <string>(); List <String> FemaleHousingArr = new List <string>(); if (ds.Tables[1].Rows.Count > 0) { MaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 0).Select(r => r.Field <String>("HouseName")).ToList <String>(); FemaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 1).Select(r => r.Field <String>("HouseName")).ToList <String>(); } //if (MaleHousingArr.Contains("")) // MaleHousingArr.IndexOf("hha"); foreach (DataRow dr in ds.Tables[0].Rows) { FpSpread.Sheets[0].Rows.Count++; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread.Sheets[0].Rows.Count); FpSpread.Sheets[0].Columns[2].Visible = false; FpSpread.Sheets[0].Columns[3].Visible = false; FpSpread.Sheets[0].Columns[4].Visible = false; if (Convert.ToString(Session["Rollflag"]) == "1") { FpSpread.Sheets[0].Columns[2].Visible = true; } if (Convert.ToString(Session["Regflag"]) == "1") { FpSpread.Sheets[0].Columns[3].Visible = true; } if (Convert.ToString(Session["Admissionflag"]) == "1") { FpSpread.Sheets[0].Columns[4].Visible = true; } FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType(); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(dr["Stud_Type"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["stud_name"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["roll_no"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Roll_Admit"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["sex"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sections"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["Course_Name"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Dept_Name"]); string studhouse = Convert.ToString(dr["HouseName"]); string studhousePK = Convert.ToString(dr["HousePK"]); string Hostelname = Convert.ToString(dr["HostelName"]); string HousePk = Convert.ToString(dr["HostelMasterFK"]); if (GenerateBool) { if (string.IsNullOrEmpty(Hostelname) && string.IsNullOrEmpty(HousePk) && string.IsNullOrEmpty(studhouse)) { #region Auto Allotment if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") { if (MaleHousingArr.Count <= MaleCurrentRow) { MaleCurrentRow = 0; string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); MaleCurrentRow++; } else { string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); MaleCurrentRow++; } } if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") { if (FemaleHousingArr.Count <= FemaleCurrentRow) { FemaleCurrentRow = 0; string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); FemaleCurrentRow++; } else { string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); FemaleCurrentRow++; } } #endregion } else { if (string.IsNullOrEmpty(Hostelname)) { Hostelname = Convert.ToString(dr["HouseName"]); HousePk = Convert.ToString(dr["HousePK"]); string HouseName = Hostelname + '$' + HousePk; if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") { if (MaleHousingArr.Count <= MaleCurrentRow) { if (MaleHousingArr.Contains(HouseName)) { //MaleCurrentRow = MaleHousingArr.IndexOf(HouseName); MaleCurrentRow = 0; } } else { if (MaleHousingArr.Contains(HouseName)) { MaleCurrentRow = MaleHousingArr.IndexOf(HouseName); MaleCurrentRow++; } } } if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") { if (FemaleHousingArr.Count <= FemaleCurrentRow) { if (FemaleHousingArr.Contains(HouseName)) { //FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName); FemaleCurrentRow = 0; } } else { if (FemaleHousingArr.Contains(HouseName)) { FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName); FemaleCurrentRow++; } } } //if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") //{ // if (MaleHousingArr.Count <= MaleCurrentRow) // { // MaleCurrentRow = 0; // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // MaleCurrentRow++; // } // else // { // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // MaleCurrentRow++; // } //} //if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") //{ // if (FemaleHousingArr.Count <= FemaleCurrentRow) // { // FemaleCurrentRow = 0; // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // FemaleCurrentRow++; // } // else // { // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // FemaleCurrentRow++; // } //} } } } else { if (string.IsNullOrEmpty(Hostelname)) { Hostelname = Convert.ToString(dr["HouseName"]); HousePk = Convert.ToString(dr["HousePK"]); } } FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Text = Hostelname; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Tag = HousePk; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua"; } FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount; FpSpread.Visible = true; FpSpread.SaveChanges(); lbl_error.Visible = false; rprint.Visible = true; } else { rprint.Visible = false; FpSpread.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Record Founds"; } } catch (Exception ex) { alertpopwindow.Visible = true; lblalerterr.Text = ex.ToString(); } }