private bool CheckedStr(ref string MyErr)
{
bool MyFlag = true;
try
{
FpSpread.SaveChanges();
for (int s = 1; s < FpSpread.Sheets[0].RowCount; s++)
{
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[s, 1].Value);
if (Check == 1)
{
string InTime = Convert.ToString(FpSpread.Sheets[0].Cells[s, 5].Text);
string StaffName = Convert.ToString(FpSpread.Sheets[0].Cells[s, 3].Text);
if (String.IsNullOrEmpty(InTime))
{
MyErr = "Please Set the InTime for the Staff '" + StaffName + "'!";
MyFlag = false;
return(MyFlag);
}
}
}
}
catch { }
return(MyFlag);
}
protected void btnSetTime_Click(object sender, EventArgs e)
{
try
{
lblMainErr.Visible = false;
string InTime = string.Empty;
InTime = Convert.ToString(ddlHr.SelectedItem.Text) + ":" + Convert.ToString(ddlMin.SelectedItem.Text) + " " + Convert.ToString(ddlMer.SelectedItem.Text);
if (CheckedOK())
{
for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++)
{
FpSpread.SaveChanges();
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value);
if (Check == 1)
{
FpSpread.Sheets[0].Cells[st, 5].Text = InTime;
FpSpread.Sheets[0].Cells[st, 1].Value = 0;
}
}
}
else
{
lblMainErr.Visible = true;
lblMainErr.Text = "Please Select Any Staff!";
}
}
catch { }
}
protected void btnRemove_Click(object sender, EventArgs e)
{
try
{
lblMainErr.Visible = false;
if (CheckedOK())
{
for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++)
{
FpSpread.SaveChanges();
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value);
if (Check == 1)
{
FpSpread.Sheets[0].Cells[st, 5].Text = "";
FpSpread.Sheets[0].Cells[st, 1].Value = 0;
}
}
}
else
{
lblMainErr.Visible = true;
lblMainErr.Text = "Please Select Any Staff!";
}
}
catch { }
}
protected void btnresetpriority_Click(object sender, EventArgs e)
{
try
{
if (FpSpread.Sheets[0].Rows.Count > 0 && chkpriority.Checked)
{
for (i = 0; i < FpSpread.Sheets[0].Rows.Count; i++)
{
string collcode = Convert.ToString(ddlcoll.SelectedValue);
string priority = Convert.ToString(FpSpread.Sheets[0].Cells[i, 4].Text.Trim());
string staffcode = Convert.ToString(FpSpread.Sheets[0].Cells[i, 1].Text);
FpSpread.Sheets[0].Cells[i, 3].Locked = false;
FpSpread.Sheets[0].Cells[i, 3].Value = 0;
FpSpread.Sheets[0].Cells[i, 4].Text = "";
if (priority.Trim() != "" && priority.Trim() != "0")
{
priority = "0";
int insQ = d2.update_method_wo_parameter("update staffmaster set PrintPriority=" + priority + " where staff_code='" + staffcode + "' and college_code=" + collcode + "", "Text");
}
}
}
FpSpread.SaveChanges();
}
catch { }
}
protected void Fpspread_render(object sender, EventArgs e)
{
try
{
if (flag_true == true)
{
FpSpread.SaveChanges();
string activrow = "";
activrow = FpSpread.Sheets[0].ActiveRow.ToString();
string activecol = FpSpread.Sheets[0].ActiveColumn.ToString();
int actcol = Convert.ToInt16(activecol);
int hy_order = 0;
for (i = 0; i <= Convert.ToInt16(FpSpread.Sheets[0].RowCount) - 1; i++)
{
int isval = Convert.ToInt32(FpSpread.Sheets[0].Cells[i, actcol].Value);
if (isval == 1)
{
hy_order++;
FpSpread.Sheets[0].Cells[Convert.ToInt32(activrow), actcol].Locked = true;
}
}
FpSpread.Sheets[0].Cells[Convert.ToInt32(activrow), actcol + 1].Text = hy_order.ToString();
}
}
catch
{
}
}
protected void Fpspread_buttoncommand(object sender, EventArgs e)
{
try
{
FpSpread.SaveChanges();
string activerow = FpSpread.ActiveSheetView.ActiveRow.ToString();
string activecol = FpSpread.ActiveSheetView.ActiveColumn.ToString();
if (activecol == "3")
{
int act1 = Convert.ToInt32(activerow);
int act2 = Convert.ToInt16(activecol);
if (FpSpread.Sheets[0].Cells[act1, act2].Value.ToString() == "1")
{
flag_true = true;
FpSpread.Sheets[0].Cells[act1, act2 + 1].Text = "";
}
else
{
flag_true = false;
}
}
FpSpread.SaveChanges();
}
catch
{
}
}
protected void FpSpread_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
FpSpread.SaveChanges();
Dictionary <string, string> diclea = new Dictionary <string, string>();
// int countvalue1 = Convert.ToInt32(Session["item_Value"]);
// countvalue1 = countvalue1 + 3;
string actrow = FpSpread.Sheets[0].ActiveRow.ToString(); //e.SheetView.ActiveRow.ToString();
string actcol = FpSpread.Sheets[0].ActiveColumn.ToString(); //e.SheetView.ActiveColumn.ToString();
string txtval = Convert.ToString(FpSpread.Sheets[0].Cells[Convert.ToInt32(actrow), Convert.ToInt32(actcol)].Text);
string last = e.CommandArgument.ToString();
if (actrow != "0")
{
if (actrow == last)
{
flag_true = false;
}
else
{
flag_true = true;
}
}
if (actcol == "1")
{
if (actrow == last)
{
flag_true = false;
}
else
{
flag_true = true;
}
}
if (flag_true == false)
{
string setval = "select * from leave_category where college_code='" + Session["collegecode"].ToString() + "'";
DataSet dsleavval = d2.select_method_wo_parameter(setval, "text");
for (int li = 0; li < dsleavval.Tables[0].Rows.Count; li++)
{
if (!diclea.ContainsKey(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower()))
{
diclea.Add(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower(), dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower());
}
}
}
}
catch (Exception ex)
{
}
}
private bool CheckedOK()
{
bool EntryFlag = false;
try
{
FpSpread.SaveChanges();
for (int s = 1; s < FpSpread.Sheets[0].RowCount; s++)
{
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[s, 1].Value);
if (Check == 1)
{
EntryFlag = true;
}
}
}
catch { }
return(EntryFlag);
}
protected bool checkvalue()
{
bool chkspr = true;
string sprstaffcode = "";
FpSpread.SaveChanges();
try
{
for (ik = 0; ik < FpSpread.Sheets[0].RowCount; ik++)
{
sprstaffcode = Convert.ToString(FpSpread.Sheets[0].Cells[ik, 0].Text);
if (sprstaffcode.Trim() == "")
{
chkspr = false;
}
}
}
catch { }
return(chkspr);
}
protected bool checkstaffcode()
{
bool chkspr = true;
string staffcode = Convert.ToString(ddlstafflst.SelectedValue);
string sprstaffcode = "";
FpSpread.SaveChanges();
try
{
for (ik = 0; ik < FpSpread.Sheets[0].RowCount; ik++)
{
sprstaffcode = Convert.ToString(FpSpread.Sheets[0].Cells[ik, 1].Text);
if (staffcode == sprstaffcode)
{
chkspr = false;
}
}
}
catch { }
return(chkspr);
}
protected void btnexcel_Click(object sender, EventArgs e)
{
try
{
FpSpread.SaveChanges();
string reportname = txtexcel.Text;
if (reportname.ToString().Trim() != "")
{
txtexcel.Text = "";
d2.printexcelreport(FpSpread, reportname);
lblerror.Visible = false;
}
else
{
lblerror.Text = "Please Enter Your Report Name";
lblerror.Visible = true;
}
btnprintmaster.Focus();
}
catch { }
}
protected void FpSpread_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
FpSpread.SaveChanges();
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[0, 1].Value);
if (Check == 1)
{
for (int sel = 1; sel < FpSpread.Sheets[0].RowCount; sel++)
{
FpSpread.Sheets[0].Cells[sel, 1].Value = 1;
}
}
else
{
for (int sel = 1; sel < FpSpread.Sheets[0].RowCount; sel++)
{
FpSpread.Sheets[0].Cells[sel, 1].Value = 0;
}
}
}
catch { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lblMainErr.Visible = false;
string MyErrTxt = string.Empty;
string Intime = string.Empty;
string StaffCode = string.Empty;
string StaffApplID = string.Empty;
string InsQ = string.Empty;
int insCount = 0;
string PayMonth = Convert.ToString(ddlMon.SelectedItem.Value);
string PayYear = Convert.ToString(ddlYear.SelectedItem.Text);
DateTime dtFrm = new DateTime();
DateTime dtTo = new DateTime();
dtFrm = GetMonFrstDate(txtFrmDt.Text);
dtTo = GetMonFrstDate(txtToDt.Text);
DataSet MyDs = new DataSet();
DataView dvnew = new DataView();
if (CheckedOK())
{
if (CheckedStr(ref MyErrTxt))
{
string GetApplID = "select appl_id,sm.staff_code from staff_appl_master sa,staffmaster sm,stafftrans st where sa.appl_no=sm.appl_no and st.staff_code=sm.staff_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code='" + clgcode + "'";
MyDs.Clear();
MyDs = d2.select_method_wo_parameter(GetApplID, "Text");
for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++)
{
FpSpread.SaveChanges();
byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value);
if (Check == 1)
{
StaffCode = Convert.ToString(FpSpread.Sheets[0].Cells[st, 2].Text);
Intime = Convert.ToString(FpSpread.Sheets[0].Cells[st, 5].Text);
if (MyDs.Tables.Count > 0 && MyDs.Tables[0].Rows.Count > 0)
{
MyDs.Tables[0].DefaultView.RowFilter = " Staff_Code='" + StaffCode + "'";
dvnew = MyDs.Tables[0].DefaultView;
if (dvnew.Count > 0)
{
StaffApplID = Convert.ToString(dvnew[0]["appl_id"]);
}
}
InsQ = "if exists(select * from Staff_InOut_BellTime_Individual where StaffApplID='" + StaffApplID + "' and StaffCode='" + StaffCode + "' and PayMonth='" + PayMonth + "' and Payyear='" + PayYear + "') Update Staff_InOut_BellTime_Individual set IN_Time='" + Intime + "',FromDate='" + dtFrm.ToString("MM/dd/yyyy") + "',Todate='" + dtTo.ToString("MM/dd/yyyy") + "' where StaffApplID='" + StaffApplID + "' and StaffCode='" + StaffCode + "' and PayMonth='" + PayMonth + "' and Payyear='" + PayYear + "' else insert into Staff_InOut_BellTime_Individual (StaffApplID,StaffCode,IN_Time,FromDate,Todate,PayMonth,Payyear) values ('" + StaffApplID + "','" + StaffCode + "','" + Intime + "','" + dtFrm.ToString("MM/dd/yyyy") + "','" + dtTo.ToString("MM/dd/yyyy") + "','" + PayMonth + "','" + PayYear + "')";
int myCount = d2.update_method_wo_parameter(InsQ, "Text");
if (myCount > 0)
{
insCount += 1;
}
}
}
if (insCount > 0)
{
alertpopwindow.Visible = true;
lblalerterr.Text = "Bell Time Settings Saved Successfully!";
}
}
else
{
lblMainErr.Visible = true;
lblMainErr.Text = MyErrTxt;
}
}
else
{
lblMainErr.Visible = true;
lblMainErr.Text = "Please Select Any Staff!";
}
}
catch { }
}
public void btn_go_Click(object sender, EventArgs e)
{
try
{
if (txt_staffCode.Text != "--Select--")
{
DataSet ds = new DataSet();
ds.Clear();
string appl_id = string.Empty;
string staff_code = string.Empty;
if (cbl_staffCode.Items.Count > 0)
{
for (int i = 0; i < cbl_staffCode.Items.Count; i++)
{
if (cbl_staffCode.Items[i].Selected == true)
{
string staffCode = Convert.ToString(cbl_staffCode.Items[i].Value);
string applno = d2.GetFunction("select appl_no from staffmaster where staff_code='" + staffCode + "'");
string applid = d2.GetFunction("select appl_id from staff_appl_master where appl_no='" + applno + "'");
if (appl_id == "")
{
appl_id = applid;
}
else
{
appl_id = appl_id + "','" + applid;
}
}
}
string getFromDate = Convert.ToString(txtfrom.Text);
string getTodate = Convert.ToString(txtto.Text);
string[] split_f = getFromDate.Split(new Char[] { '/' });
string[] split_t = getTodate.Split(new Char[] { '/' });
string fromdate = split_f[1] + "/" + split_f[0] + "/" + split_f[2];
string todate = split_t[1] + "/" + split_t[0] + "/" + split_t[2];
DateTime fdate = new DateTime();
DateTime tdate = new DateTime();
fdate = Convert.ToDateTime(fromdate);
tdate = Convert.ToDateTime(todate);
string getcolcode = rs.GetSelectedItemsValueAsString(cbl_clg);
string query = "select * from staff_CompensationLeave where holiday_date between '" + fdate + "' and '" + tdate + "' and appl_id in('" + appl_id + "') and college_code in('" + getcolcode + "') order by holiday_date";
ds = d2.select_method_wo_parameter(query, "text");
if (ds.Tables[0].Rows.Count > 0)
{
divPopAlert.Visible = false;
lblAlertMsg.Text = "";
sp_div.Visible = true;
FpSpread.Visible = true;
FpSpread.Sheets[0].RowCount = 0;
FpSpread.Sheets[0].ColumnCount = 0;
FpSpread.CommandBar.Visible = false;
FpSpread.Sheets[0].AutoPostBack = false;
FpSpread.Sheets[0].ColumnHeader.RowCount = 2;
FpSpread.Sheets[0].FrozenRowCount = 1;
FpSpread.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
FpSpread.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "S.No";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 50;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Name";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 250;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Compensation Date";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 107;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Holiday Date";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Worked On Holiday";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
// FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 200;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "M";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "E";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Compensation Leave";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 6, 1, 2);
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 200;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "M";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100;
FpSpread.Sheets[0].ColumnCount++;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "E";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true;
FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100;
FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 1, 2);
int sno = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
rprint.Visible = true;
string appl_ids = Convert.ToString(ds.Tables[0].Rows[i]["appl_id"]);
string appl_no = d2.GetFunction("select appl_no from staff_appl_master where appl_id='" + appl_ids + "'");
string staffcode = d2.GetFunction("select staff_code from staffmaster where appl_no='" + appl_no + "'");
string name = d2.GetFunction("select staff_name from staffmaster where appl_no='" + appl_no + "'");
string collegecode = d2.GetFunction("select college_code from staffmaster where appl_no='" + appl_no + "'");
string holidaydate = Convert.ToString(ds.Tables[0].Rows[i]["holiday_date"]);
string Leave_Morning = Convert.ToString(ds.Tables[0].Rows[i]["LeaveMorning"]);
string Leave_evng = Convert.ToString(ds.Tables[0].Rows[i]["LeaveEvening"]);
string compensationdate = Convert.ToString(ds.Tables[0].Rows[i]["compensation_date"]);
string morn_lve = string.Empty;
string evn_lve = string.Empty;
if (Leave_Morning != "0")
{
morn_lve = d2.GetFunction("select shortname from leave_category where LeaveMasterPK='" + Leave_Morning + "' and college_code='" + collegecode + "'");
}
if (Leave_evng != "0")
{
evn_lve = d2.GetFunction("select shortname from leave_category where LeaveMasterPK='" + Leave_evng + "' and college_code='" + collegecode + "'");
}
string monyearval = string.Empty;
string getdateval = string.Empty;
string commonyear = string.Empty;
string comgetdate = string.Empty;
string[] splitspace = holidaydate.Split(new char[] { ' ' });
string[] splitval = splitspace[0].Split(new Char[] { '/' });
string monthval = splitval[0].ToString();
string dateval = splitval[1].ToString();
string yearval = splitval[2].ToString();
string dateval1 = (dateval.TrimStart('0'));
string monthval1 = (monthval.TrimStart('0'));
monyearval = monthval + "/" + yearval;
getdateval = dateval + "/" + monthval + "/" + yearval;
string[] compdatesplitspace = compensationdate.Split(new char[] { ' ' });
string[] compdatesplitval = compdatesplitspace[0].Split(new Char[] { '/' });
string compmonval = compdatesplitval[0].ToString();
string compdateval = compdatesplitval[1].ToString();
string compyearval = compdatesplitval[2].ToString();
string compdate = (compdateval.TrimStart('0'));
string compmonth = (compmonval.TrimStart('0'));
comgetdate = compdateval + "/" + compmonval + "/" + compyearval;
dateval1 = "[" + dateval1 + "]";
string morning = string.Empty;
string evening = string.Empty;
string getpresentabs = d2.GetFunction("select " + dateval1 + " from staff_attnd where staff_code='" + staffcode + "' and mon_year='" + monyearval + "'");
if (getpresentabs != "" || getpresentabs != "0")
{
if (getpresentabs.Contains('-'))
{
string[] mor_evnf = getpresentabs.Split('-');
morning = Convert.ToString(mor_evnf[0]);
evening = Convert.ToString(mor_evnf[1]);
}
}
sno++;
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[i, 0].Text = Convert.ToString(sno);
FpSpread.Sheets[0].Cells[i, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[i, 0].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 0].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[i, 1].Text = Convert.ToString(name);
FpSpread.Sheets[0].Cells[i, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[i, 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[i, 2].Text = Convert.ToString(comgetdate);
FpSpread.Sheets[0].Cells[i, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[i, 2].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 2].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[i, 3].Text = Convert.ToString(getdateval);
FpSpread.Sheets[0].Cells[i, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[i, 3].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 3].Font.Name = "Book Antiqua";
if (morning != "")
{
FpSpread.Sheets[0].Cells[i, 4].Text = Convert.ToString(morning);
}
else
{
FpSpread.Sheets[0].Cells[i, 4].Text = "-";
}
FpSpread.Sheets[0].Cells[i, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[i, 4].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 4].Font.Name = "Book Antiqua";
if (evening != "")
{
FpSpread.Sheets[0].Cells[i, 5].Text = Convert.ToString(evening);
}
else
{
FpSpread.Sheets[0].Cells[i, 5].Text = "-";
}
FpSpread.Sheets[0].Cells[i, 5].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[i, 5].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 5].Font.Name = "Book Antiqua";
if (morn_lve != "")
{
FpSpread.Sheets[0].Cells[i, 6].Text = Convert.ToString(morn_lve);
}
else
{
FpSpread.Sheets[0].Cells[i, 6].Text = "-";
}
FpSpread.Sheets[0].Cells[i, 6].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[i, 6].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 6].Font.Name = "Book Antiqua";
if (evn_lve != "")
{
FpSpread.Sheets[0].Cells[i, 7].Text = Convert.ToString(evn_lve);
}
else
{
FpSpread.Sheets[0].Cells[i, 7].Text = "-";
}
FpSpread.Sheets[0].Cells[i, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[i, 7].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[i, 7].Font.Name = "Book Antiqua";
// FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(staffCode);
}
FpSpread.SaveChanges();
FpSpread.Visible = true;
lblAlertMsg.Text = string.Empty;
divPopAlert.Visible = false;
// btn_save.Visible = false;
FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount;
FpSpread.SaveChanges();
}
else
{
divPopAlert.Visible = true;
lblAlertMsg.Text = "No Records Found";
// btn_save.Visible = false;
}
}
}
else
{
//alert message
//please select Atleast one staff
divPopAlert.Visible = true;
lblAlertMsg.Text = "Please Select Atleast One Staff";
// btn_save.Visible = false;
}
}
catch (Exception ex)
{
}
}
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();
}
}
