//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();
}
}
