protected void Button1_Click1(object sender, EventArgs e)
{
FpSpread2.SaveChanges();
int rcount = FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].ColumnCount = 4;
FpSpread2.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
FpSpread2.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].DefaultStyle.Font.Bold = false;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.ForeColor = Color.White;
FpSpread2.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.DoubleCellType intgrcell = new FarPoint.Web.Spread.DoubleCellType();
intgrcell.FormatString = System.Windows.Forms.MaskFormat.ExcludePromptAndLiterals.ToString();
intgrcell.MaximumValue = Convert.ToInt32(100);
intgrcell.MinimumValue = 0;
intgrcell.ErrorMessage = "Enter valid Number";
FpSpread2.Sheets[0].Columns[0].CellType = intgrcell;
FpSpread2.Sheets[0].Columns[1].CellType = intgrcell;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
int minustwo = FpSpread2.Sheets[0].RowCount - 2;
if (rcount != 0)
{
if (FpSpread2.Sheets[0].Cells[minustwo, 1].Text.ToString() != "" && FpSpread2.Sheets[0].Cells[minustwo, 0].Text.ToString() != "" && FpSpread2.Sheets[0].Cells[minustwo, 2].Text.ToString() != "")
{
double temp = Convert.ToDouble(FpSpread2.Sheets[0].Cells[minustwo, 1].Text.ToString());
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].CellType = intgrcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(temp);
//FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
}
else
{
FpSpread2.Sheets[0].RowCount--;
}
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].CellType = intgrcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = "00.00";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].CellType = intgrcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = "00.00";
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
string collcode = Convert.ToString(ddlclg.SelectedItem.Value);
try
{
int count = 0;
for (int i = 0; i < cbl_dptname.Items.Count; i++)
{
if (cbl_dptname.Items[i].Selected == true)
{
count++;
}
}
if (count == 0)
{
lbl_alert.Text = "Please Select Atleast One Department";
lbl_alert.Visible = true;
imgdiv2.Visible = true;
hide();
return;
}
string deptcod = "";
if (cbl_dptname.Items.Count > 0)
{
for (int i = 0; i < cbl_dptname.Items.Count; i++)
{
if (cbl_dptname.Items[i].Selected == true)
{
if (deptcod == "")
{
deptcod = Convert.ToString(cbl_dptname.Items[i].Value);
}
else
{
deptcod = deptcod + "','" + Convert.ToString(cbl_dptname.Items[i].Value);
}
}
}
}
count = 0;
string sql = "";
DataView dvfil = new DataView();
Fpspread1.Sheets[0].Rows.Count = 0;
Fpspread1.Sheets[0].Columns.Count = 6;
Fpspread1.Height = 340;
Fpspread1.Width = 800;
Fpspread1.CommandBar.Visible = false;
Fpspread1.Sheets[0].RowHeader.Visible = false;
Fpspread1.Sheets[0].AutoPostBack = false;
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.Columns[0].Width = 75;
Fpspread1.Sheets[0].ColumnHeader.Columns[1].Width = 310;
Fpspread1.Sheets[0].ColumnHeader.Columns[2].Width = 100;
Fpspread1.Sheets[0].ColumnHeader.Columns[3].Width = 100;
Fpspread1.Sheets[0].ColumnHeader.Columns[4].Width = 100;
Fpspread1.Sheets[0].ColumnHeader.Columns[5].Width = 100;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Designation";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Available Staff";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "No.of Req Staff";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "No.of Vacancy";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "No.of Additional Req Staff";
FarPoint.Web.Spread.DoubleCellType intgrcel = new FarPoint.Web.Spread.DoubleCellType();
intgrcel.FormatString = System.Windows.Forms.MaskFormat.ExcludePromptAndLiterals.ToString();
intgrcel.MinimumValue = 0;
intgrcel.ErrorMessage = "Enter valid Required Staff";
string desigcod = d2.GetFunction(" Select desig_code from desig_master where desig_name='" + txt_search.Text.ToString() + "' and collegeCode='" + collcode + "'");
string selquery = "";
selquery = "select t.desig_code,t.dept_code,count(s.staff_code)as count from staffmaster s,stafftrans t where s.staff_code =t.staff_code and t.latestrec ='1' and resign=0 and settled =0 and isnull(Discontinue,'0') ='0' and s.college_code ='" + collcode + "' group by t.desig_code,t.dept_code";
selquery = selquery + " select DeptCode,DesigCode,No_ofPersons from VacancyMaster where Collegecode ='" + collcode + "'";
DataSet dsnew = new DataSet();
dsnew.Clear();
dsnew = d2.select_method_wo_parameter(selquery, "Text");
int sno = 1;
int rowcount = 0;
if (cbl_dptname.Items.Count > 0 && txt_dptname.Text.Trim() != "--Select--")
{
for (int st = 0; st < cbl_dptname.Items.Count; st++)
{
if (cbl_dptname.Items[st].Selected == true)
{
rowcount = 0;
Fpspread1.Sheets[0].RowCount++;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(cbl_dptname.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, 6);
string selq = "select desig_code,desig_name from desig_master where ((dept_code like '" + Convert.ToString(cbl_dptname.Items[st].Value) + ";%') or (dept_code like '%;" + Convert.ToString(cbl_dptname.Items[st].Value) + "%') or (dept_code like '%" + Convert.ToString(cbl_dptname.Items[st].Value) + "') or (dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "'))";
ds.Clear();
ds = d2.select_method_wo_parameter(selq, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int ik = 0; ik < ds.Tables[0].Rows.Count; ik++)
{
if (txt_search.Text.Trim() != "")
{
if (Convert.ToString(ds.Tables[0].Rows[ik]["desig_code"]) == desigcod)
{
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].Text = Convert.ToString(txt_search.Text.Trim());
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(desigcod);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(cbl_dptname.Items[st].Value);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
if (dsnew.Tables.Count > 0 && dsnew.Tables[0].Rows.Count > 0)
{
DataView dvnew = new DataView();
dsnew.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and desig_code='" + desigcod + "'";
dvnew = dsnew.Tables[0].DefaultView;
if (dvnew.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dvnew[0]["count"]);
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-";
}
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-";
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
if (dsnew.Tables.Count > 0 && dsnew.Tables[1].Rows.Count > 0)
{
DataView dvmynew = new DataView();
dsnew.Tables[1].DefaultView.RowFilter = " DeptCode='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and DesigCode='" + desigcod + "'";
dvmynew = dsnew.Tables[1].DefaultView;
if (dvmynew.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dvmynew[0]["No_ofPersons"]);
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-";
}
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-";
}
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";
Double availcount = 0;
Double noofreq = 0;
Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text), out availcount);
Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text), out noofreq);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(noofreq - availcount);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
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 = intgrcel;
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";
}
}
else
{
for (int jk = 0; jk < cbl_desname.Items.Count; jk++)
{
if (cbl_desname.Items[jk].Selected == true)
{
if (Convert.ToString(ds.Tables[0].Rows[ik]["desig_code"]) == Convert.ToString(cbl_desname.Items[jk].Value))
{
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].Text = Convert.ToString(cbl_desname.Items[jk].Text);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(cbl_desname.Items[jk].Value);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(cbl_dptname.Items[st].Value);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
if (dsnew.Tables.Count > 0 && dsnew.Tables[0].Rows.Count > 0)
{
DataView dvnew = new DataView();
dsnew.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and desig_code='" + Convert.ToString(cbl_desname.Items[jk].Value) + "'";
dvnew = dsnew.Tables[0].DefaultView;
if (dvnew.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dvnew[0]["count"]);
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-";
}
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-";
}
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
if (dsnew.Tables.Count > 0 && dsnew.Tables[1].Rows.Count > 0)
{
DataView dvmynew = new DataView();
dsnew.Tables[1].DefaultView.RowFilter = " DeptCode='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and DesigCode='" + Convert.ToString(cbl_desname.Items[jk].Value) + "'";
dvmynew = dsnew.Tables[1].DefaultView;
if (dvmynew.Count > 0)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dvmynew[0]["No_ofPersons"]);
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-";
}
}
else
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-";
}
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";
Double availcount = 0;
Double noofreq = 0;
Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text), out availcount);
Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text), out noofreq);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(noofreq - availcount);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
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 = intgrcel;
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";
}
}
}
}
}
if (rowcount == 0)
{
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove();
}
}
else
{
Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove();
}
}
}
}
for (int ii = 0; ii < Fpspread1.Sheets[0].Columns.Count; ii++)
{
Fpspread1.Sheets[0].ColumnHeader.Columns[ii].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Size = FontUnit.Medium;
}
for (int kl = 0; kl < Fpspread1.Sheets[0].ColumnCount - 1; kl++)
{
Fpspread1.Sheets[0].Columns[kl].Locked = true;
}
if (Fpspread1.Sheets[0].RowCount > 1)
{
Fpspread1.Visible = true;
rptprint.Visible = true;
div1.Visible = true;
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.SaveChanges();
txt_search.Text = "";
}
else
{
txt_search.Text = "";
lbl_alert.Text = "No Records Found";
lbl_alert.Visible = true;
imgdiv2.Visible = true;
hide();
}
//}
//else
//{
// txt_search.Text = "";
// lbl_alert.Text = "No Records Found";
// lbl_alert.Visible = true;
// imgdiv2.Visible = true;
// hide();
//}
}
catch (Exception ex)
{
d2.sendErrorMail(ex, collcode, "manpower_Alter.aspx");
}
}
public void btn_go_Click(object sender, EventArgs e)
{
try
{
div_report.Visible = false;
Printcontrol.Visible = false;
FpSpread1.Visible = false;
FpSpread1.SaveChanges();
string itemheadercode = "";
for (int i = 0; i < cbl_hostelname.Items.Count; i++)
{
if (cbl_hostelname.Items[i].Selected == true)
{
if (itemheadercode == "")
{
itemheadercode = "" + cbl_hostelname.Items[i].Value.ToString() + "";
}
else
{
itemheadercode = itemheadercode + "'" + "," + "'" + cbl_hostelname.Items[i].Value.ToString() + "";
}
}
}
string month = "";
for (int i = 0; i < cbl_month.Items.Count; i++)
{
if (cbl_month.Items[i].Selected == true)
{
if (month == "")
{
month = "" + cbl_month.Items[i].Value.ToString() + "";
}
else
{
month = month + "'" + "," + "'" + cbl_month.Items[i].Value.ToString() + "";
}
}
}
if (txt_hostelname.Text == "--Select--")
{
lblerror.Visible = true;
lblerror.Text = "Kindly Select The Hostel";
btnsave.Visible = false;
btn_reset.Visible = false;
}
else
{
if (txt_month.Text == "--Select--")
{
lblerror.Visible = true;
lblerror.Text = "Kindly Select The Month";
btnsave.Visible = false;
btn_reset.Visible = false;
//FpSpread1.Visible = false;
}
else
{
//FpSpread1.Visible = true;
if (itemheadercode.Trim() != "")
{
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 1;
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.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[0].Width = 50;
FpSpread1.Columns[0].Locked = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Days";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
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.Columns[1].Width = 150;
FpSpread1.Columns[1].Locked = true;
for (int i = 0; i < cbl_month.Items.Count; i++)
{
if (cbl_month.Items[i].Selected == true)
{
FpSpread1.Sheets[0].ColumnCount++;
FarPoint.Web.Spread.DoubleCellType db = new FarPoint.Web.Spread.DoubleCellType();
db.ErrorMessage = "Enter only Numbers";
FpSpread1.Columns[FpSpread1.Sheets[0].ColumnCount - 1].CellType = db;
// FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(cbl_month.Items[i].Text);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(cbl_month.Items[i].Value);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
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.Columns[1].Width = 150;
}
}
for (int row = 0; row < 31; row++)
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
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(row + 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
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";
}
DataView dv = new DataView();
string query = "";
string rebatetype = "";
if (rdbdate.Checked == true)
{
rebatetype = "1";
}
else
{
rebatetype = "2";
}
query = "select RebateActDays, RebateDays,RebateAmount ,RebateMonth from HM_RebateMaster where HostelFK in ('" + itemheadercode + "') and RebateMonth in ('" + month + "') and RebateType ='" + rebatetype + "'";
//}
//else
//{
// rebatetype = "2";
// query = "select Actual_Day, Grant_Day,Grant_Amount ,Rebate_Month from Rebate_Master where Hostel_Code in ('" + itemheadercode + "') and Rebate_Month in ('" + month + "') and Rebate_Type ='" + rebatetype + "'";
//}
ds1 = d2.select_method_wo_parameter(query, "Text");
if (ds1.Tables[0].Rows.Count > 0)
{
if (FpSpread1.Sheets[0].ColumnCount > 2)
{
for (int ik = 2; ik < FpSpread1.Sheets[0].ColumnCount; ik++)
{
string getmonthvalue = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, ik].Tag);
if (FpSpread1.Sheets[0].RowCount > 0)
{
for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++)
{
string currentday = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Text);
ds1.Tables[0].DefaultView.RowFilter = "RebateActDays='" + currentday + "' and RebateMonth='" + getmonthvalue + "'";
dv = ds1.Tables[0].DefaultView;
if (dv.Count > 0)
{
if (rdbdate.Checked == true)
{
FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateDays"]);
FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right;
}
else
{
FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateAmount"]);
FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right;
}
}
}
}
}
}
}
//25.04.16
//if (txt_allmonth.Text.Trim() != "")
//{
// if (FpSpread1.Sheets[0].ColumnCount > 2)
// {
// for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount - 2; i++)
// {
// int k = 0;
// for (int row = 0; row < 31; row++)
// {
// k++;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Text = Convert.ToString(txt_allmonth.Text);
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].HorizontalAlign = HorizontalAlign.Center;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Size = FontUnit.Medium;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Name = "Book Antiqua";
// }
// }
// }
//}
}
FpSpread1.Visible = true;
div_report.Visible = true;
//div1.Visible = true;
lblerror.Visible = false;
btnsave.Visible = true;
btn_reset.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
}
}
}
catch
{
}
}
public void FpSpread2_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)//del
{
FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType();
FarPoint.Web.Spread.DoubleCellType txtserialNo = new FarPoint.Web.Spread.DoubleCellType();
txtserialNo.ErrorMessage = "Allow only numbers";
btn.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton;
btn.Text = "Quota Settings";
string clgDetails = string.Empty;
string actrow = FpSpread1.Sheets[0].ActiveRow.ToString();
string actcol = FpSpread1.Sheets[0].ActiveColumn.ToString();
if (actrow.Trim() != "" && actcol.Trim() != "")
{
clgDetails = Convert.ToString(FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), Convert.ToInt32(actcol)].Text);
if (clgDetails == "Quota")
{
btn.Text = "Quota Settings";
FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = btn;
}
//else
//{
// string[] prefix = new string[2];
// prefix[0] = "Prefix";
// prefix[1] = "Suffix";
// FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix);
// FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2;
//}
if (clgDetails == "Serial No")
{
string start = FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 1].Text;
string end = FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 2].Text;
int difference = 0, startVal = 0, endVal = 0;
int.TryParse(start, out startVal);
int.TryParse(end, out endVal);
difference = endVal - startVal;
double maxValue = Math.Pow(10, difference);
FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = txtserialNo;
txtserialNo.MinimumValue = 0;
txtserialNo.MaximumValue = maxValue - 1;
txtserialNo.ErrorMessage = "Must Enter Between 0 and " + (maxValue - 1);
txtserialNo.CssClass = "txtbgColor";
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0BA6CB");
darkstyle.ForeColor = Color.White;
}
if (checkSchoolSetting() == 0)
{
if (clgDetails == "College Acr" || clgDetails == "Department Acr" || clgDetails == "College Code" || clgDetails == "Year" || clgDetails == "Batch Year" || clgDetails == "Sem")
{
string[] prefix = new string[2];
prefix[0] = "Prefix";
prefix[1] = "Suffix";
FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix);
FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2;
}
if (actcol == "4")
{
if (btn.Text == "Quota Settings")
{
gridquota_DataBound();
alertpopwindow.Visible = true;
}
}
}
else
{
if (clgDetails == "School Acr" || clgDetails == "Department Acr" || clgDetails == "Class Code" || clgDetails == "Year" || clgDetails == "Batch Year" || clgDetails == "Term")
{
string[] prefix = new string[2];
prefix[0] = "Prefix";
prefix[1] = "Suffix";
FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix);
FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2;
}
if (actcol == "4")
{
if (btn.Text == "Quota Settings")
{
gridquota_DataBound();
alertpopwindow.Visible = true;
}
}
}
}
}
protected void Generate_Click(object sender, EventArgs e)
{
try
{
lblerror.Visible = false;
DataSet ds = new DataSet();
string clgcode = Session["collegecode"].ToString();
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].Columns.Count = 5;
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 = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "From Digit";
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.Columns[1].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "To Digit";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[2].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[3].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Prefix/Suffix";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[4].Width = 130;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0BA6CB");
darkstyle.ForeColor = Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
int val = 0;
Int32.TryParse(txtsize.Text, out val);
string[] item = new string[0];
if (val > 0)
{
for (int v = 0; v <= val; v++)
{
Array.Resize(ref item, item.Length + 1);
item[item.Length - 1] = Convert.ToString(v);
}
}
FarPoint.Web.Spread.ComboBoxCellType dropdown1 = new FarPoint.Web.Spread.ComboBoxCellType();
string query = "select distinct MasterCode,MasterValue from CO_MasterValues where MasterCriteria='ApplicationNumberGeneration' and CollegeCode='" + clgcode + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
dropdown1.DataSource = ds;
dropdown1.DataTextField = "MasterValue";
dropdown1.DataValueField = "MasterCode";
}
dropdown1.AutoPostBack = false;
FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType();
string[] prefix = new string[2];
prefix[0] = "Prefix";
prefix[1] = "Suffix";
FarPoint.Web.Spread.ComboBoxCellType dropdown = new FarPoint.Web.Spread.ComboBoxCellType(item, item);
FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix);
FarPoint.Web.Spread.DoubleCellType txtserialNo = new FarPoint.Web.Spread.DoubleCellType();
btn.CssClass = "textbox btn";
btn.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton;
btn.Text = "+";
DataSet CodeGenDS = d2.select_method_wo_parameter(" select NumberType,NumberLength,ag.collegeCode,FRange,TRange,DifferentRange,HeaderCode, Case when convert(varchar(max), startNo)!=0 then convert(varchar(max),startNo) else (case when PrefixOrSufix=1 then 'Prefix' when PrefixOrSufix=2 then 'Suffix' end) end as PrefixOrSufix,GenerationNumber,NumberSize,upper(MasterValue) as type,startNo from AdmissionNoGeneration ag,CO_MasterValues m where ag.collegecode='" + Convert.ToString(ddlclg.SelectedItem.Value) + "' and ag.headercode=m.MasterCode and MasterCriteria='ApplicationNumberGeneration' order by frange,trange ", "text");//ag.collegecode=m.collegecode and
string Frange = string.Empty;
string Trange = string.Empty;
string HeaderCode = string.Empty;
string PrefixOrSufix = string.Empty;
string NumberSize = string.Empty;
string type = string.Empty;
int rangeDiff = 0;
int StartNo = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].RowCount);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = dropdown;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = dropdown;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
dropdown1.ShowButton = true;
dropdown1.AutoPostBack = true;
dropdown1.UseValue = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = dropdown1;
FpSpread1.Sheets[0].Columns[3].CellType = dropdown1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = dropdown2;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
if (CodeGenDS.Tables != null)//24.01.18 barath
{
if (i < CodeGenDS.Tables[0].Rows.Count)
{
if (CodeGenDS.Tables[0].Rows.Count > 0)
{
Frange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["FRange"]);
Trange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["TRange"]);
HeaderCode = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["HeaderCode"]);
PrefixOrSufix = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["PrefixOrSufix"]);
int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["DifferentRange"]), out rangeDiff);
int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["startNo"]), out StartNo);
NumberSize = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["GenerationNumber"]);
type = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["type"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Frange;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Trange;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = HeaderCode;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix;
if (type == "QUOTA")
{
btn.Text = "Quota Settings";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = btn;
}
else if (type == "SERIAL NO")
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txtserialNo;
//string sd = generateApplicationNumber(StartNo, rangeDiff);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix;
}
}
}
}
FpSpread1.SaveChanges();
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
FpSpread1.Height = 270;
FpSpread1.Width = 568;
FpSpread1.Visible = true;
btnSave.Visible = true;
}
catch (Exception ex)
{
}
}
public void viewspd()
{
string mname = "";
for (int i = 0; i < cbl_pop1menu.Items.Count; i++)
{
if (cbl_pop1menu.Items[i].Selected == true)
{
if (mname == "")
{
mname = "" + cbl_pop1menu.Items[i].Value.ToString() + "";
}
else
{
mname = mname + "'" + "," + "'" + cbl_pop1menu.Items[i].Value.ToString() + "";
}
}
}
string q = "";
if (txt_pop1search.Text.Trim() != "")
{
q = "select MenuName ,MenuMasterPK from HM_MenuMaster where MenuName in('" + txt_pop1search.Text + "')";
}
else
{
q = "select MenuName ,MenuMasterPK from HM_MenuMaster where MenuMasterPK in('" + mname + "')";
}
//if (mname.Trim() != "")
// {
// string q = "";
// q = "select MenuName ,menucode from MenuMaster where MenuCode in('" + mname + "')";
ds = d2.select_method_wo_parameter(q, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
Fpspread2.Sheets[0].RowCount = 0;
Fpspread2.Sheets[0].ColumnCount = 0;
Fpspread2.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread2.CommandBar.Visible = false;
Fpspread2.Sheets[0].ColumnCount = 4;
Fpspread2.Sheets[0].AutoPostBack = false;
Fpspread2.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
Fpspread2.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread2.Columns[0].Width = 50;
Fpspread2.Columns[0].Locked = true;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Menu Name";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread2.Columns[1].Width = 150;
Fpspread2.Columns[1].Locked = true;
FarPoint.Web.Spread.DoubleCellType db = new FarPoint.Web.Spread.DoubleCellType();
db.ErrorMessage = "Enter only Numbers";
Fpspread2.Columns[2].CellType = db;
Fpspread2.Columns[2].BackColor = Color.White;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Quantity";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspread2.Columns[2].Width = 100;
Fpspread2.Columns[2].Locked = false;
FarPoint.Web.Spread.DoubleCellType db1 = new FarPoint.Web.Spread.DoubleCellType();
db1.ErrorMessage = "Enter only Numbers";
Fpspread2.Columns[3].CellType = db1;
Fpspread2.Columns[3].BackColor = Color.White;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Cost";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspread2.Columns[3].Width = 100;
Fpspread2.Columns[3].Locked = false;
//Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Change Date";
//Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
//Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
//Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium;
//Fpspread2.Columns[5].Width = 150;
//Fpspread2.Columns[5].Locked = true;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Fpspread2.Sheets[0].RowCount++;
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(i + 1);
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
//FarPoint.Web.Spread.CheckBoxCellType chkbox = new FarPoint.Web.Spread.CheckBoxCellType();
//chkbox.AutoPostBack = false;
//Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
//Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].CellType = chkbox;
//Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
//Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[i]["menuname"]);
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[i]["MenuMasterPK"]);
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[i][""]);
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[i][""]);
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
}
Fpspread2.Sheets[0].PageSize = Fpspread2.Sheets[0].RowCount;
Fpspread2.Visible = true;
lblerror1.Visible = false;
btn_pop1save.Visible = true;
btn_pop1exit.Visible = true;
}
else
{
lblerror1.Visible = true;
lblerror1.Text = "No Record Found";
Fpspread2.Visible = false;
btn_pop1save.Visible = false;
btn_pop1exit.Visible = false;
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
Printcontrol.Visible = false;
string mname = "";
for (int i = 0; i < cbl_menuname.Items.Count; i++)
{
if (cbl_menuname.Items[i].Selected == true)
{
if (mname == "")
{
mname = "" + cbl_menuname.Items[i].Value.ToString() + "";
}
else
{
mname = mname + "'" + "," + "'" + cbl_menuname.Items[i].Value.ToString() + "";
}
}
}
string q = "";
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 (mname.Trim() != "")
{
if (txt_search.Text.Trim() != "")
{
//q = "select Menu_Name,SessionMenu_Code,Qty,Cost,CONVERT(varchar(10),From_Date,103) as From_Date from MenuCost_Master where Menu_Name in('" + txt_search.Text + "') and From_Date between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' order by SessionMenu_Code";
q = " select mm.MenuMasterPK,mm.MenuName,mc.MenuQty,mc.MenuAmount,mc.Menucost_Date from HM_MenuCostMaster MC,HM_MenuMaster MM where mm.MenuMasterPK =mc.MenuMasterFK and CollegeCode ='" + collegecode1 + "' and mm.MenuName in('" + txt_search.Text + "')";
}
else
{
q = "select mm.MenuMasterPK,mm.MenuName,mc.MenuQty,mc.MenuAmount,convert(varchar(10),Menucost_Date,103)as Menucost_Date from HM_MenuCostMaster MC,HM_MenuMaster MM where mm.MenuMasterPK =mc.MenuMasterFK and CollegeCode ='" + collegecode1 + "' and mc.MenuMasterFK in ('" + mname + "') and mc.Menucost_Date between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "'";
}
ds = d2.select_method_wo_parameter(q, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
Fpspread3.Sheets[0].RowCount = 0;
Fpspread3.Sheets[0].ColumnCount = 0;
Fpspread3.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread3.CommandBar.Visible = false;
Fpspread3.Sheets[0].ColumnCount = 5;
Fpspread3.Sheets[0].AutoPostBack = true;
Fpspread3.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
Fpspread3.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Columns[0].Width = 50;
Fpspread3.Columns[0].Locked = true;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Menu Name";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspread3.Columns[1].Width = 250;
Fpspread3.Columns[1].Locked = true;
//Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Menu Name";
//Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
//Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
//Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
//Fpspread3.Columns[2].Width = 150;
//Fpspread3.Columns[2].Locked = true;
FarPoint.Web.Spread.DoubleCellType db = new FarPoint.Web.Spread.DoubleCellType();
db.ErrorMessage = "Enter only Numbers";
Fpspread3.Columns[2].CellType = db;
Fpspread3.Columns[2].BackColor = Color.White;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Quantity";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspread3.Columns[2].Width = 100;
Fpspread3.Columns[2].Locked = true;
FarPoint.Web.Spread.DoubleCellType db1 = new FarPoint.Web.Spread.DoubleCellType();
db1.ErrorMessage = "Enter only Numbers";
Fpspread3.Columns[3].CellType = db1;
Fpspread3.Columns[3].BackColor = Color.White;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Cost";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspread3.Columns[3].Width = 100;
Fpspread3.Columns[3].Locked = true;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Date";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fpspread3.Columns[4].Width = 100;
Fpspread3.Columns[4].Locked = true;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Fpspread3.Sheets[0].RowCount++;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(i + 1);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
//FarPoint.Web.Spread.CheckBoxCellType chkbox = new FarPoint.Web.Spread.CheckBoxCellType();
//chkbox.AutoPostBack = false;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].CellType = chkbox;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
//Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[i]["MenuName"]);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[i]["MenuMasterPK"]);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[i]["MenuQty"]);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[i]["MenuAmount"]);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[i]["Menucost_Date"]);
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[Fpspread3.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
}
Fpspread3.Sheets[0].PageSize = Fpspread3.Sheets[0].RowCount;
Fpspread3.Visible = true;
lblerror.Visible = false;
div_report.Visible = true;
div1.Visible = true;
}
else
{
lblerror.Visible = true;
lblerror.Text = "No Record Found";
Fpspread3.Visible = false;
div_report.Visible = false;
div1.Visible = false;
}
}
else
{
lblerror.Visible = true;
lblerror.Text = "Please Select Menu Name";
Fpspread3.Visible = false;
div_report.Visible = false;
div1.Visible = false;
}
}
catch
{
}
}
public void LoadDepartmentSpread()
{
try
{
FpDeptment.Visible = false;
btnSave.Visible = false;
string dayorder = "";
string sel_edu_level = "";
if (ddlBatch.Items.Count > 0)
{
batchyear = Convert.ToString(ddlBatch.SelectedItem.Text);
}
if (rblCourse.Items.Count == 0)
{
lbl_popuperr.Text = "No Records Found";
imgdiv2.Visible = true;
return;
}
else if (ddlDays.Items.Count == 0)
{
lbl_popuperr.Text = "No Days are Found";
imgdiv2.Visible = true;
return;
}
else
{
if (ddlDays.SelectedValue.ToString() == "0" || ddlDays.SelectedValue.ToString() == "-1")
{
lbl_popuperr.Text = "Please Select Other Than Sunday and Empty";
imgdiv2.Visible = true;
return;
}
dayorder = Convert.ToString(ddlDays.SelectedValue);
sel_edu_level = Convert.ToString(rblCourse.SelectedItem.Text);
//and r.degree_code=45
//select distinct (c.Course_Name+'-'+ dpt.dept_acronym) as dept,dg.Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration,r.Current_Semester,r.Sections from Degree dg,course c,Department dpt,Registration r where r.college_code=dg.college_code and r.degree_code=dg.Degree_Code and c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and r.delflag=0 and r.cc=0 and r.exam_flag<>'debar' and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' and Batch_Year="'+batchyear+'" order by r.batch_year desc,current_semester asc, dg.degree_code,r.Sections asc;
//qry = "select distinct Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration from Degree dg,course c,Department dpt where c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' order by Course_Name; select * from PeriodAttndScheduleNew where DayOrder='" + dayorder + "'";
qry = "select distinct (c.Course_Name+'-'+ dpt.dept_acronym) as dept,r.batch_year,dg.Degree_Code,c.Course_Name,dpt.Dept_Name,dg.NoofSections,Duration,r.Current_Semester,r.Sections from Degree dg,course c,Department dpt,Registration r where r.college_code=dg.college_code and r.degree_code=dg.Degree_Code and c.college_code=dpt.college_code and dpt.college_code=dg.college_code and dg.Dept_Code=dpt.Dept_Code and r.delflag=0 and r.cc=0 and r.exam_flag<>'debar' and dg.Course_Id=c.Course_Id and c.Edu_Level='" + sel_edu_level + "' and dg.college_code='" + Convert.ToString(Session["collegecode"]) + "' and Batch_Year='" + batchyear + "' order by r.batch_year desc,r.current_semester asc, dg.degree_code,r.Sections asc; select * from PeriodAttndScheduleNew where DayOrder='" + dayorder + "' and batch_year='" + batchyear + "'";
ds = d2.select_method_wo_parameter(qry, sptype);
if (ds.Tables[0].Rows.Count > 0)
{
FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo();
style2.Font.Size = FontUnit.Medium;
style2.Font.Name = "Book Antiqua";
style2.Font.Bold = false;
style2.HorizontalAlign = HorizontalAlign.Center;
style2.VerticalAlign = VerticalAlign.Middle;
style2.ForeColor = System.Drawing.Color.Black;
FarPoint.Web.Spread.DoubleCellType dblcell = new FarPoint.Web.Spread.DoubleCellType();
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType chkeach = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.IntegerCellType intgrcell = new FarPoint.Web.Spread.IntegerCellType();
intgrcell.ErrorMessage = "Enter Positive Integer Values Only";
intgrcell.MinimumValue = 0;
chkall.AutoPostBack = true;
FpDeptment.Sheets[0].RowCount = 0;
FpDeptment.Sheets[0].AutoPostBack = false;
FpDeptment.Sheets[0].RowCount++;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 1].CellType = chkall;
FpDeptment.Sheets[0].SpanModel.Add(FpDeptment.Sheets[0].RowCount - 1, 2, 1, 12);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].Locked = true;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].Locked = true;
FpDeptment.Sheets[0].FrozenRowCount = 1;
FpDeptment.Sheets[0].FrozenColumnCount = 7;
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
FpDeptment.Sheets[0].RowCount++;
//int noofsec = 0;
//int.TryParse(Convert.ToString(ds.Tables[0].Rows[row]["NoofSections"]), out noofsec);
string degree_code = Convert.ToString(ds.Tables[0].Rows[row]["Degree_Code"]);
string sem = Convert.ToString(ds.Tables[0].Rows[row]["Current_Semester"]);
string sec = Convert.ToString(ds.Tables[0].Rows[row]["Sections"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 1].CellType = chkeach;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 2].Text = batchyear;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["Course_Name"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].Tag = Convert.ToString(degree_code);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[row]["Dept_Name"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(ds.Tables[0].Rows[row]["Current_Semester"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(ds.Tables[0].Rows[row]["Sections"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].CellType = intgrcell;
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].CellType = intgrcell;
if (ds.Tables.Count == 2)
{
if (ds.Tables[1].Rows.Count > 0)
{
ds.Tables[1].DefaultView.RowFilter = "Degree_Code='" + degree_code + "' and semester='" + sem + "' and section='" + sec + "'";
DataView dv = new DataView();
dv = ds.Tables[1].DefaultView;
if (dv.Count > 0)
{
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dv[0]["No_of_hrs_per_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dv[0]["no_of_hrs_I_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(dv[0]["no_of_hrs_II_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 10].Text = Convert.ToString(dv[0]["min_pres_I_half_day"]);
FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 11].Text = Convert.ToString(dv[0]["min_pres_II_half_day"]);
}
}
}
//if (noofsec == 0)
//{
// FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = "";
//}
//else if (noofsec == 1)
//{
// FpDeptment.Sheets[0].Cells[FpDeptment.Sheets[0].RowCount - 1, 4].Text = "A";
//}
//else if (noofsec > 1)
//{
//}
}
FpDeptment.Visible = true;
btnSave.Visible = true;
}
else
{
FpDeptment.Visible = false;
btnSave.Visible = false;
lbl_popuperr.Text = "No Departments were Found for " + sel_edu_level;
imgdiv2.Visible = true;
return;
}
}
FpDeptment.Sheets[0].PageSize = FpDeptment.Sheets[0].RowCount;
FpDeptment.Height = (FpDeptment.Sheets[0].RowCount * 28) + 120;
FpDeptment.SaveChanges();
}
catch (Exception ex)
{
}
}
protected void Buttongo_Click(object sender, EventArgs e)
{
try
{
ss2 = "";
p = "";
FpSpread2.Visible = false;//btnreset.Visible = false;
FpSpread2.CommandBar.Visible = false;
FpSpread2.Sheets[0].RowCount = 0;
FpSpread2.Sheets[0].ColumnCount = 4;
FpSpread2.Sheets[0].Columns[0].Width = 100;
FpSpread2.Sheets[0].Columns[1].Width = 100;
FpSpread2.Sheets[0].Columns[2].Width = 100;
FpSpread2.Sheets[0].Columns[3].Width = 100;
// FpSpread2.Sheets[0].Columns[4].Width = 90;
//FpSpread2.Sheets[0].Columns[0].Locked = true;
//FpSpread2.Sheets[0].Columns[1].Locked = true;
//FpSpread2.Sheets[0].Columns[2].Locked = true;
//FpSpread2.Sheets[0].Columns[4].Locked = true;
FpSpread2.Sheets[0].RowHeader.Visible = false;
FpSpread2.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
FpSpread2.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].SheetCorner.RowCount = 1;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "From Point";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "To Point";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Credit Points";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Grade";
// FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Priority";
FarPoint.Web.Spread.DoubleCellType intgrcell = new FarPoint.Web.Spread.DoubleCellType();
intgrcell.FormatString = System.Windows.Forms.MaskFormat.ExcludePromptAndLiterals.ToString();
intgrcell.MaximumValue = Convert.ToInt32(100);
intgrcell.MinimumValue = 0;
intgrcell.ErrorMessage = "Enter valid Mark";
FarPoint.Web.Spread.DoubleCellType intgrcell_cp = new FarPoint.Web.Spread.DoubleCellType();
intgrcell_cp.FormatString = System.Windows.Forms.MaskFormat.ExcludePromptAndLiterals.ToString();
intgrcell_cp.MaximumValue = Convert.ToInt32(10);
intgrcell_cp.MinimumValue = 0;
intgrcell_cp.ErrorMessage = "Enter valid Credit Points";
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FpSpread2.Sheets[0].Columns[0].CellType = intgrcell;
FpSpread2.Sheets[0].Columns[1].CellType = intgrcell;
FpSpread2.Sheets[0].Columns[2].CellType = intgrcell_cp;
FpSpread2.Sheets[0].Columns[3].CellType = txt;
FpSpread2.Sheets[0].AutoPostBack = false;
string batchyear = ddlbatch.SelectedValue.ToString();
string degree = ddldegree.SelectedItem.Value.ToString();
string depart_code = ddlbranch.SelectedValue.ToString();
string studinfo = "";
studinfo = "select * from Grade_Master where College_Code='" + Session["collegecode"].ToString() + "' and batch_year='" + ddlbatch.SelectedItem.Text.ToString() + "' and degree_code='" + depart_code + "'";
DataSet dsstudinfo = da.select_method_wo_parameter(studinfo, "Text");
if (dsstudinfo.Tables[0].Rows.Count > 0)
{
btnsave.Visible = true;
int sno = 0;
for (int studcount = 0; studcount < dsstudinfo.Tables[0].Rows.Count; studcount++)
{
FpSpread2.Visible = true;
sno++;
FpSpread2.Sheets[0].RowCount = FpSpread2.Sheets[0].RowCount + 1;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = dsstudinfo.Tables[0].Rows[studcount]["Frange"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = dsstudinfo.Tables[0].Rows[studcount]["Trange"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = dsstudinfo.Tables[0].Rows[studcount]["Credit_Points"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Text = dsstudinfo.Tables[0].Rows[studcount]["Mark_Grade"].ToString();;
}
}
else
{
//clear();
//lblerror.Text = "No Records Found";
//lblerror.Visible = true;
FpSpread2.Visible = true;
btnsave.Visible = true;
Button1.Visible = true;
showdata.Visible = true;
}
string totalrows = FpSpread2.Sheets[0].RowCount.ToString();
FpSpread2.Sheets[0].PageSize = (Convert.ToInt32(totalrows) * 20) + 40;
FpSpread2.Height = 350;
FpSpread2.SaveChanges();
FpSpread2.Visible = true;
btnsave.Visible = true;
Button1.Visible = true;
showdata.Visible = true;
}
catch (Exception ex)
{
lblerror.Text = ex.ToString();
lblerror.Visible = true;
}
}
protected void FSpread1_SelectedIndexChanged(Object sender, EventArgs e)
{
try
{
if (Cellclick == true)
{
lbl_errmsg.Visible = false;
lblerr.Visible = false;
Labelheader.Visible = true;
lbl_rpt.Visible = true;
txt_rpt.Visible = true;
spreadpdf2.Visible = true;
spreadexcel2.Visible = true;
Panelshow.Height = 500;
modelpopsetting.Show();
FpSpread1.Visible = true;
Panelshow.Visible = true;
spreadexcel1.Visible = true;
spreadpdf1.Visible = true;
FpSpread2.Visible = true;
lbl_routename.Visible = true;
lbl_routeid.Visible = true;
string query = "";
string activerow = "";
string activecol = "";
DataSet dcal = new DataSet();
FarPoint.Web.Spread.TextCellType txtcell = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.DoubleCellType speed1 = new FarPoint.Web.Spread.DoubleCellType();
FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo();
style2.Font.Size = 13;
style2.Font.Name = "Book Antiqua";
style2.Font.Bold = true;
style2.HorizontalAlign = HorizontalAlign.Center;
style2.ForeColor = Color.Purple;
style2.BackColor = ColorTranslator.FromHtml("#58D3F7");
FpSpread2.Sheets[0].ColumnCount = 2;
FpSpread2.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].AllowTableCorner = true;
FpSpread2.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].AutoPostBack = true;
FpSpread2.Sheets[0].RowCount = 0;
activerow = FpSpread1.ActiveSheetView.ActiveRow.ToString();
activecol = FpSpread1.ActiveSheetView.ActiveColumn.ToString();
string vechicle = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Text;
string route = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 2].Text;
string stage = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Text;
string course = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 3].Text;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "BOARDING POINT";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[0].Width = 200;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "TIME ";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[1].Width = 100;
FpSpread2.Sheets[0].Columns[0].Locked = true;
FpSpread2.Sheets[0].Columns[1].Locked = true;
string currenttime = Convert.ToString(DateTime.Now);
string[] split = currenttime.Split(); // date time am/pm
string timenow = split[2].ToString();
string curtime = split[1].ToString();
lbl_routeid.Text = " " + route.ToString() + " : ";
lbl_routename.Text = course.ToString();
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[0, 0].Text = "MORNING TIME";
FpSpread2.Sheets[0].SpanModel.Add(0, 0, 1, 2);
FpSpread2.Sheets[0].Cells[0, 0].ForeColor = Color.Brown;
FpSpread2.Sheets[0].Cells[0, 0].Font.Bold = true;
FpSpread2.Sheets[0].Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[0, 0].BackColor = ColorTranslator.FromHtml("#CEECF5");
query = "select r.Route_ID,r.Mdate,r.Stage_Name as stage,Arr_Time,Dep_Time,sess,Veh_ID,s.Stage_id,s.Stage_Name,s.Address from RouteMaster r,Stage_Master s where str(r.Stage_Name)=str(s.Stage_id) and sess='M' and Route_ID in('" + route + "') order by convert(nvarchar(5),Dep_Time,103) asc ";
dcal = da.select_method_wo_parameter(query, "text");
for (int temp = 0; temp < dcal.Tables[0].Rows.Count; temp++)
{
string stastage = dcal.Tables[0].Rows[temp]["Stage_Name"].ToString();
string starttime = dcal.Tables[0].Rows[temp]["Arr_Time"].ToString();
if (starttime == "Halt" || starttime == "-")
{
starttime = dcal.Tables[0].Rows[temp]["Dep_Time"].ToString();
}
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = stastage.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].BackColor = ColorTranslator.FromHtml("#CEECF5");
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].CellType = txtcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = starttime.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].BackColor = ColorTranslator.FromHtml("#CEECF5");
}
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = "EVENING TIME";
FpSpread2.Sheets[0].SpanModel.Add(FpSpread2.Sheets[0].RowCount - 1, 0, 1, 2);
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Font.Bold = true;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].BackColor = ColorTranslator.FromHtml("#CEECF5");
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].ForeColor = Color.Brown;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
query = "select r.Route_ID,r.Mdate,r.Stage_Name as stage,Arr_Time,Dep_Time,sess,Veh_ID,s.Stage_id,s.Stage_Name,s.Address from RouteMaster r,Stage_Master s where str(r.Stage_Name)=str(s.Stage_id) and sess='A' and Route_ID in('" + route + "') order by convert(nvarchar(5),Dep_Time,103) asc ";
dcal = da.select_method_wo_parameter(query, "text");
for (int temp = 0; temp < dcal.Tables[0].Rows.Count; temp++)
{
string stastage = dcal.Tables[0].Rows[temp]["Stage_Name"].ToString();
string starttime1 = dcal.Tables[0].Rows[temp]["Arr_Time"].ToString();
if (starttime1 == "-" || starttime1 == "Halt")
{
starttime1 = dcal.Tables[0].Rows[temp]["Dep_Time"].ToString();
}
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = stastage.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].BackColor = ColorTranslator.FromHtml("#CEECF5");
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].CellType = txtcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = starttime1.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].BackColor = ColorTranslator.FromHtml("#CEECF5");
}
FpSpread2.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread2.Sheets[0].Columns[0].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
modelpopsetting.Show();
Panelshow.Visible = true;
FpSpread2.Visible = true;
FpSpread1.Visible = true;
FpSpread2.Sheets[0].PageSize = FpSpread2.Sheets[0].RowCount;
FpSpread2.Width = 500;
FpSpread2.Height = 400;
}
else
{
}
}
catch (Exception ex)
{
IblError.Visible = true;
IblError.Text = ex.ToString();
}
}
protected void getAllotedDetails()
{
try
{
#region
Fp_Route.Sheets[0].RowCount = 0;
Fp_Route.Sheets[0].ColumnCount = 0;
Fp_Route.CommandBar.Visible = false;
Fp_Route.Sheets[0].AutoPostBack = true;
Fp_Route.Sheets[0].ColumnHeader.RowCount = 1;
Fp_Route.Sheets[0].RowHeader.Visible = false;
Fp_Route.Sheets[0].ColumnCount = 6;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
Fp_Route.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fp_Route.Sheets[0].AutoPostBack = false;
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cball.AutoPostBack = true;
cb.AutoPostBack = false;
FarPoint.Web.Spread.DoubleCellType intgrcel = new FarPoint.Web.Spread.DoubleCellType();
intgrcel.MinimumValue = 0;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[0].Width = 50;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Route ID";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[1].Width = 100;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Start Place";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left;
Fp_Route.Sheets[0].Columns[2].Width = 300;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].Text = "End Place";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Left;
Fp_Route.Sheets[0].Columns[3].Width = 300;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Cost";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Right;
Fp_Route.Sheets[0].Columns[4].Width = 120;
//Fp_Route.Sheets[0].Columns[4].CellType = intgrcel;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Pay Type";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].ForeColor = ColorTranslator.FromHtml("#000000");
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium;
Fp_Route.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
Fp_Route.Sheets[0].Columns[5].VerticalAlign = VerticalAlign.Middle;
Fp_Route.Sheets[0].Columns[5].Width = 80;
#endregion
string routeid = Convert.ToString(getCblSelectedValue(chklstrouteid));
string stageid = Convert.ToString(getCblSelectedValue(cblstage));
//string pattern = Convert.ToString(ddl_pattern.SelectedItem.Text);
string clgCode = Convert.ToString(ddlclg.SelectedValue);
ArrayList arstageId = new ArrayList();
SettingRights();
if (!string.IsNullOrEmpty(routeid) && !string.IsNullOrEmpty(stageid))
{
string selQ = " select distinct sm.stage_id,sm.Stage_Name,rm.Rou_To,f.cost,f.paytype,f.college_code,rm.route_id,f.Month_Value from stage_master sm,routemaster rm ,feeinfo F where cast(rm.stage_name as varchar(100))=cast(sm.stage_id as varchar(100)) and f.StrtPlace=cast(sm.stage_id as varchar(100)) and f.StrtPlace= cast(rm.stage_name as varchar(100)) and f.college_code in('" + clgCode + "') and rm.route_id in ('" + routeid + "') and rm.stage_name in('" + stageid + "') and paytype='" + pattern + "' order by rm.route_id";
DataSet dsval = d2.select_method_wo_parameter(selQ, "Text");
if (dsval.Tables.Count > 0 && dsval.Tables[0].Rows.Count > 0)
{
int rowCnt = 0;
bool boolcheck = false;
for (int crow = 0; crow < ddlclg.Items.Count; crow++)
{
bool clgName = false;
arstageId.Clear();
if (ddlclg.Items[crow].Selected)
{
collegecode = Convert.ToString(ddlclg.Items[crow].Value);
dsval.Tables[0].DefaultView.RowFilter = "college_code='" + collegecode + "'";
DataView dv = dsval.Tables[0].DefaultView;
if (dv.Count > 0)
{
for (int row = 0; row < dv.Count; row++)
{
string stageId = Convert.ToString(dv[row]["stage_id"]);
//if (!arstageId.Contains(stageId))//purpose for dont repeat same stage multiple route id//
//{
//if (!boolcheck)
//{
// Fp_Route.Sheets[0].RowCount++;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 1].CellType = cball;
//}
//if (!clgName)
//{
// Fp_Route.Sheets[0].RowCount++;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(ddlclg.Items[crow].Text);
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].BackColor = Color.Green;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].ForeColor = Color.White;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Font.Bold = true;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
// Fp_Route.Sheets[0].SpanModel.Add(Fp_Route.Sheets[0].RowCount - 1, 0, 1, 4);
// clgName = true;
//}
rowCnt++;
Fp_Route.Sheets[0].RowCount++;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(rowCnt);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Tag = collegecode;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dv[row]["route_id"]);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dv[row]["Stage_Name"]);
string routeId = Convert.ToString(dv[row]["route_id"]);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 2].Tag = stageId;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 2].Note = routeId;
string endstagename = d2.GetFunction("select Stage_Name from stage_master where Stage_id='" + Convert.ToString(dv[row]["Rou_To"]) + "'");
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 3].Text = endstagename;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 3].Tag = stageId;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 3].Note = routeId;
double costAmount = 0;
double.TryParse(Convert.ToString(dv[row]["cost"]), out costAmount);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(costAmount);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 0].Locked = true;
// Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 1].Locked = true;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dv[row]["paytype"]);
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 5].Locked = true;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 3].Locked = true;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 2].Locked = true;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 1].Locked = true;
Fp_Route.Sheets[0].Cells[Fp_Route.Sheets[0].RowCount - 1, 4].Locked = true;
boolcheck = true;
arstageId.Add(stageId);
//}
}
Fp_Route.Sheets[0].SetColumnMerge(5, FarPoint.Web.Spread.Model.MergePolicy.Always);
}
}
}
if (boolcheck)
{
Fp_Route.Width = 970;
Fp_Route.Sheets[0].PageSize = Fp_Route.Sheets[0].RowCount;
Fp_Route.ShowHeaderSelection = false;
Fp_Route.SaveChanges();
Fp_Route.Visible = true;
divspread.Visible = true;
btndetails.Visible = true;
}
}
else
{
Fp_Route.Visible = false;
divspread.Visible = false;
btndetails.Visible = false;
imgAlert.Visible = true;
lbl_alert.Text = "No Record Found!";
}
}
else
{
Fp_Route.Visible = false;
divspread.Visible = false;
btndetails.Visible = false;
imgAlert.Visible = true;
lbl_alert.Text = "No Record Found!";
}
}
catch { }
}
protected void FSpread1_SelectedIndexChanged(Object sender, EventArgs e)
{
try
{
if (Cellclick == true)
{
modelpopsetting.Show();
FpSpread1.Visible = true;
FarPoint.Web.Spread.TextCellType txtcell = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.DoubleCellType speed1 = new FarPoint.Web.Spread.DoubleCellType();
Panelshow.Visible = true;
spreadexcel1.Visible = false;
spreadpdf1.Visible = false;
FpSpread2.Visible = true;
string query = "";
string activerow = "";
string activecol = "";
double speed = 0;
string vehid = "";
int sno = 1;
DataSet dcal = new DataSet();
FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo();
style2.Font.Size = 13;
style2.Font.Name = "Book Antiqua";
style2.Font.Bold = true;
style2.HorizontalAlign = HorizontalAlign.Center;
style2.ForeColor = Color.White;
style2.BackColor = Color.Teal;
FpSpread2.Sheets[0].ColumnCount = 10;
FpSpread2.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].AllowTableCorner = true;
FpSpread2.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].AutoPostBack = true;
FpSpread2.Sheets[0].RowCount = 0;
activerow = FpSpread1.ActiveSheetView.ActiveRow.ToString();
activecol = FpSpread1.ActiveSheetView.ActiveColumn.ToString();
string vechicle = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Text;
string route = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 2].Text;
string course = FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 3].Text;
FpSpread2.Sheets[0].ColumnHeader.RowCount = 2;
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1);
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[0].Width = 10;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Vehicle ID ";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[1].Visible = false;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Route ID";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[2].Visible = false;
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 5, 2, 1);
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Start Time";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[3].Width = 90;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "End Time";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[4].Width = 80;
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 6, 2, 1);
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Stage";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 5].Border.BorderColor = Color.Black;
FpSpread2.Sheets[0].Columns[5].Width = 150;
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(1, 0, 1, 8);
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Speed";
FpSpread2.Sheets[0].Columns[6].Width = 90;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Total No of Student";
FpSpread2.Sheets[0].Columns[7].Width = 150;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 8].Text = "";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 9].Text = "";
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 7, 1, 3);
FpSpread2.Sheets[0].ColumnHeader.Cells[1, 7].Text = "Male";
FpSpread2.Sheets[0].Columns[8].Width = 150;
FpSpread2.Sheets[0].ColumnHeader.Cells[1, 8].Text = "Female";
FpSpread2.Sheets[0].Columns[9].Width = 150;
FpSpread2.Sheets[0].ColumnHeader.Cells[1, 9].Text = "Staff";
FpSpread2.Sheets[0].Columns[0].Locked = true;
FpSpread2.Sheets[0].Columns[1].Locked = true;
FpSpread2.Sheets[0].Columns[2].Locked = true;
FpSpread2.Sheets[0].Columns[3].Locked = true;
FpSpread2.Sheets[0].Columns[4].Locked = true;
string currenttime = Convert.ToString(DateTime.Now);
string[] split = currenttime.Split(); // date time am/pm
string timenow = split[2].ToString();
string curtime = split[1].ToString();
if (timenow.Trim() == "AM")
{
query = "select r.Route_ID,r.Mdate,r.Stage_Name as stage,Arr_Time,Dep_Time,sess,Veh_ID,s.Stage_id,s.Stage_Name,s.Address from RouteMaster r,Stage_Master s where str(r.Stage_Name)=str(s.Stage_id) and sess='M' and Route_ID in('" + route + "') order by convert(nvarchar(5),Dep_Time,103) asc ";
}
else
{
query = "select r.Route_ID,r.Mdate,r.Stage_Name as stage,Arr_Time,Dep_Time,sess,Veh_ID,s.Stage_id,s.Stage_Name,s.Address from RouteMaster r,Stage_Master s where str(r.Stage_Name)=str(s.Stage_id) and sess='A' and Route_ID in('" + route + "') order by convert(nvarchar(5),Dep_Time,103) asc ";
}
dcal = da.select_method_wo_parameter(query, "text");
for (int temp = 0; temp < dcal.Tables[0].Rows.Count; temp++)
{
string routid = dcal.Tables[0].Rows[temp]["Route_ID"].ToString();
vehid = dcal.Tables[0].Rows[temp]["Veh_ID"].ToString();
string stastage = dcal.Tables[0].Rows[temp]["Stage_Name"].ToString();
string enddingtime = dcal.Tables[0].Rows[temp]["Dep_Time"].ToString();
string starttime = dcal.Tables[0].Rows[temp]["Arr_Time"].ToString();
string stageid = dcal.Tables[0].Rows[temp]["Stage_id"].ToString();
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = sno.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Tag = vehid.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Tag);
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = routid.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].CellType = txtcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Text = starttime.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].CellType = txtcell;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Text = enddingtime.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 5].Text = stastage.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
//string tottab = " select COUNT(*) as tot from Registration r,applyn a where Boarding = '" + stageid + "' and VehID ='" + vehid + "'";
//DataSet spreadtot = new DataSet();
//spreadtot = da.select_method_wo_parameter(tottab, "text");
//if (spreadtot.Tables[0].Rows.Count > 0)
//{
// string totcount = spreadtot.Tables[0].Rows[0]["tot"].ToString();
// FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].Text = totcount.ToString();
// FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
//}
//else
//{
// FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].Text = "";
// FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
// FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].v
//}
string maletab = " select COUNT(*) as male from Registration r,applyn a where r.App_No = a.app_no and Boarding = '" + stageid + "' and VehID ='" + vehid + "' and sex = 0";
DataSet spreadmale = new DataSet();
spreadmale = da.select_method_wo_parameter(maletab, "text");
if (spreadmale.Tables[0].Rows.Count > 0)
{
string malecount = spreadmale.Tables[0].Rows[0]["male"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].Text = malecount.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].Text = "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
}
string femaletab = " select COUNT(*) as female from Registration r,applyn a where r.App_No = a.app_no and Boarding = '" + stageid + "' and VehID ='" + vehid + "' and sex = 1";
DataSet spreadfemale = new DataSet();
spreadfemale = da.select_method_wo_parameter(femaletab, "text");
if (spreadfemale.Tables[0].Rows.Count > 0)
{
string femalecount = spreadfemale.Tables[0].Rows[0]["female"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 8].Text = femalecount.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 8].Text = "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
}
string stafftab = "select COUNT(*) as staffcount from staffmaster m where Boarding = '" + stageid + "' and VehID = '" + vehid + "' ";
DataSet spreadstaff = new DataSet();
spreadstaff = da.select_method_wo_parameter(stafftab, "text");
if (spreadstaff.Tables[0].Rows.Count > 0)
{
string staffcount = spreadstaff.Tables[0].Rows[0]["staffcount"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 9].Text = staffcount.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Center;
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 9].Text = "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread2.Sheets[0].Columns[6].Visible = false;
sno++;
string stage = "select GPSFixstatus,Speed from VTSGPRSData where VehicleID ='" + vehid + "'";
DataSet dstage = new DataSet();
string gpstage = "";
dstage = da.select_method_wo_parameter(stage, "Text");
if (dstage.Tables[0].Rows.Count > 0)
{
gpstage = dstage.Tables[0].Rows[0]["GPSFixstatus"].ToString();
speed = Convert.ToDouble(dstage.Tables[0].Rows[0]["Speed"]);
}
else
{
gpstage = "";
//speed = "Speed Not Found";
}
string status = "";
ArrayList add = new ArrayList();
if (dstage.Tables[0].Rows.Count > 0)
{
stage = stage + " select distinct address from RouteMaster where Route_ID='" + routid + "' ";
dstage = da.select_method_wo_parameter(stage, "Text");
for (int b = 0; b < dstage.Tables[1].Rows.Count; b++)
{
status = dstage.Tables[1].Rows[b]["address"].ToString();
add.Add(status);
}
}
else
{
}
if (add.Contains(gpstage))
{
for (int search = 0; search < FpSpread2.Sheets[0].RowCount; search++)
{
if (stastage == gpstage)
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 5].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].BackColor = Color.Khaki;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].BackColor = Color.Khaki;
Error.Visible = false;
}
}
}
else
{
//Error.Text = "Stage Not Found";
//Error.Visible = true;
}
if (add.Contains(gpstage))
{
for (int search = 0; search < FpSpread2.Sheets[0].RowCount; search++)
{
if (stastage == gpstage)
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].CellType = speed1;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(speed);
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].CellType = speed1;
}
}
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].Text = "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
}
}
string count = "select COUNT(*) as count from Registration r,applyn a where r.App_No = a.app_no and VehID = '" + vehid + "' ";
DataSet dstot = new DataSet();
dstot = da.select_method_wo_parameter(count, "text");
Label1.Text = dstot.Tables[0].Rows[0]["count"].ToString();
string female = "select COUNT(*) as count from Registration r,applyn a where r.App_No = a.app_no and VehID = '" + vehid + "'and sex = 1";
DataSet dsfemale = new DataSet();
dstot = da.select_method_wo_parameter(female, "text");
Label3.Text = dstot.Tables[0].Rows[0]["count"].ToString();
lblmale.Text = "Male";
Label5.Text = " " + ":";
lblstaff.Text = "Staff";
Label6.Text = " " + ":";
lblfemale.Text = "Female";
Label7.Text = " " + ":";
Totalstudent.Text = "Total No of Student ";
Label8.Text = ":";
string male = "select COUNT(*) as count from Registration r,applyn a where r.App_No = a.app_no and VehID = '" + vehid + "'and sex = 0";
DataSet dsmale = new DataSet();
dstot = da.select_method_wo_parameter(male, "text");
Label2.Text = dstot.Tables[0].Rows[0]["count"].ToString();
string staff = "select COUNT(*) as count from staffmaster m where VehID = '" + vehid + "'";
DataSet dsstaff = new DataSet();
dstot = da.select_method_wo_parameter(staff, "text");
Label4.Text = dstot.Tables[0].Rows[0]["count"].ToString();
FpSpread2.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread2.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread2.Sheets[0].Columns[0].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[2].VerticalAlign = VerticalAlign.Middle;
sno++;
modelpopsetting.Show();
Panelshow.Visible = true;
FpSpread2.Visible = true;
FpSpread1.Visible = true;
Label1.Visible = true;
Label2.Visible = true;
Label3.Visible = true;
Label4.Visible = true;
Totalstudent.Visible = true;
lblmale.Visible = true;
lblfemale.Visible = true;
lblstaff.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
Label7.Visible = true;
Label8.Visible = true;
FpSpread2.Sheets[0].PageSize = FpSpread2.Sheets[0].RowCount;
}
else
{
FpSpread2.Visible = false;
}
}
catch (Exception ex)
{ }
}
