public void loaduser()
{
try
{
Fpuser.Sheets[0].ColumnCount = 4;
Fpuser.Sheets[0].RowCount = 0;
Fpuser.SheetCorner.ColumnCount = 0;
Fpuser.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpuser.Sheets[0].Columns[0].Width = 50;
Fpuser.Sheets[0].ColumnHeader.Cells[0, 1].Text = "User Name";
Fpuser.Sheets[0].Columns[1].Width = 200;
Fpuser.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Description";
Fpuser.Sheets[0].Columns[2].Width = 200;
Fpuser.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
Fpuser.Sheets[0].Columns[3].Width = 50;
Fpuser.CommandBar.Visible = false;
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
string chkgroup = " and (isnull(group_code,'')='' or group_code='0' or group_code='-1')";
if (chkincludegroup.Checked == true)
{
chkgroup = "";
}
string strusename = "";
if (txtusersearch.Text.ToString().Trim() != "")
{
strusename = " and user_id like '" + txtusersearch.Text.ToString() + "%'";
}
string strquery = "select User_code,user_id,Description from usermaster where college_code='" + ddlcollege.SelectedValue.ToString() + "' " + chkgroup + " " + strusename + " order by user_id";
DataSet ds = d2.select_method_wo_parameter(strquery, "Text");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Fpuser.Sheets[0].RowCount++;
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 0].Text = Fpuser.Sheets[0].RowCount.ToString();
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 1].CellType = txt;
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 1].Text = ds.Tables[0].Rows[i]["user_id"].ToString();
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 2].CellType = txt;
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 2].Text = ds.Tables[0].Rows[i]["Description"].ToString();
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 1].Tag = ds.Tables[0].Rows[i]["User_code"].ToString();
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 3].CellType = chk;
Fpuser.Sheets[0].Cells[Fpuser.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
}
Fpuser.Width = 518;
Fpuser.Sheets[0].PageSize = Fpuser.Sheets[0].RowCount;
}
catch (Exception ex)
{
lblperrmsg.Visible = true;
lblperrmsg.Text = ex.ToString();
}
}
public void loadstage()
{
FarPoint.Web.Spread.TextCellType tb = new FarPoint.Web.Spread.TextCellType();
//FpSpreadstage.Sheets[0].AutoPostBack = true;
//FpSpreadstage.ActiveSheetView.SheetCorner.Cells[0, 0].Text = "S.No";
//FpSpreadstage.ActiveSheetView.SheetCorner.DefaultStyle.Font.Bold = true;
FpSpreadstage.ActiveSheetView.DefaultRowHeight = 25;
FpSpreadstage.ActiveSheetView.Rows.Default.Font.Name = "MS Sans Serif";
FpSpreadstage.ActiveSheetView.Rows.Default.Font.Size = FontUnit.Small;
FpSpreadstage.ActiveSheetView.Rows.Default.Font.Bold = false;
FpSpreadstage.ActiveSheetView.Columns.Default.Font.Bold = false;
FpSpreadstage.Sheets[0].RowHeader.Visible = false;
FpSpreadstage.ActiveSheetView.Columns.Default.Font.Name = "MS Sans Serif";
FpSpreadstage.ActiveSheetView.Columns.Default.Font.Size = FontUnit.Small;
FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "MS Sans Serif";
FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Small;
FpSpreadstage.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded;
FpSpreadstage.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded;
FarPoint.Web.Spread.ButtonCellType btnmodify = new FarPoint.Web.Spread.ButtonCellType();
FarPoint.Web.Spread.CheckBoxCellType cbxd = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.ComboBoxCellType cf = new FarPoint.Web.Spread.ComboBoxCellType();
cf.AutoPostBack = true;
cbxd.AutoPostBack = true;
btnmodify.Text = "Remove";
FpSpreadstage.Sheets[0].RowCount = 0;
FpSpreadstage.Sheets[0].ColumnCount = 5;
FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 1].Text = "District";
FpSpreadstage.Sheets[0].Columns[1].CellType = cf;
FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Stage Name";
FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Address";
FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select";
FpSpreadstage.Sheets[0].Columns[4].CellType = cbxd;
//FpSpreadstage.Sheets[0].Columns[2].CellType = btnmodify;
FpSpreadstage.Sheets[0].Columns[3].Visible = true;
FpSpreadstage.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpreadstage.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
//FpSpreadstage.Sheets[0].Columns[2].Font.Bold = true;
FpSpreadstage.Sheets[0].Columns[0].Width = 40;
FpSpreadstage.Sheets[0].Columns[1].Width = 200;
FpSpreadstage.Sheets[0].Columns[2].Width = 350;
FpSpreadstage.Sheets[0].Columns[3].Width = 340;
FpSpreadstage.Sheets[0].Columns[4].Width = 50;
FpSpreadstage.Sheets[0].PageSize = 100;
FpSpreadstage.Width = 1000;
FpSpreadstage.Height = 391;
FpSpreadstage.SaveChanges();
FpSpreadstage.CommandBar.Visible = false;
}
protected void btngo_click(object sender, EventArgs e)
{
try
{
string selq = "";
string collcode = Convert.ToString(ddlpopclg.SelectedItem.Value);
if (ddldept.SelectedItem.Text != "Select" && ddlstaffcat.SelectedItem.Text != "Select")
{
if (ddldept.SelectedItem.Text == "All" && ddlstaffcat.SelectedItem.Text == "All")
{
selq = " select sm.staff_code,staff_name,Fingerprint1,dept_name,desig_name,Fingerprint1 as MachineNo from staffmaster sm,hrdept_master h,desig_master d,stafftrans st,staffcategorizer sc where sm.staff_code=st.staff_code and sc.category_code=st.category_code and sc.college_code=sm.college_code and sm.college_code=h.college_code and sm.college_code=d.collegeCode and st.dept_code=h.dept_code and st.desig_code=d.desig_code and st.latestrec='1' and sm.college_code='" + collcode + "'";
}
else if (ddldept.SelectedItem.Text == "All" && ddlstaffcat.SelectedItem.Text != "All")
{
selq = " select sm.staff_code,staff_name,Fingerprint1,dept_name,desig_name,Fingerprint1 as MachineNo from staffmaster sm,hrdept_master h,desig_master d,stafftrans st,staffcategorizer sc where sm.staff_code=st.staff_code and sc.category_code=st.category_code and sc.college_code=sm.college_code and sm.college_code=h.college_code and sm.college_code=d.collegeCode and st.dept_code=h.dept_code and st.desig_code=d.desig_code and st.latestrec='1' and sm.college_code='" + collcode + "' and st.category_code='" + ddlstaffcat.SelectedItem.Value + "'";
}
else if (ddldept.SelectedItem.Text != "All" && ddlstaffcat.SelectedItem.Text == "All")
{
selq = " select sm.staff_code,staff_name,Fingerprint1,dept_name,desig_name,Fingerprint1 as MachineNo from staffmaster sm,hrdept_master h,desig_master d,stafftrans st,staffcategorizer sc where sm.staff_code=st.staff_code and sc.category_code=st.category_code and sc.college_code=sm.college_code and sm.college_code=h.college_code and sm.college_code=d.collegeCode and st.dept_code=h.dept_code and st.desig_code=d.desig_code and st.latestrec='1' and sm.college_code='" + collcode + "' and st.dept_code='" + ddldept.SelectedItem.Value + "'";
}
else if (ddldept.SelectedItem.Text != "All" && ddlstaffcat.SelectedItem.Text != "All")
{
selq = " select sm.staff_code,staff_name,Fingerprint1,dept_name,desig_name,Fingerprint1 as MachineNo from staffmaster sm,hrdept_master h,desig_master d,stafftrans st,staffcategorizer sc where sm.staff_code=st.staff_code and sc.category_code=st.category_code and sc.college_code=sm.college_code and sm.college_code=h.college_code and sm.college_code=d.collegeCode and st.dept_code=h.dept_code and st.desig_code=d.desig_code and st.latestrec='1' and sm.college_code='" + collcode + "' and st.dept_code='" + ddldept.SelectedItem.Value + "' and st.category_code='" + ddlstaffcat.SelectedItem.Value + "'";
}
if (chkincrel.Checked == false)
{
selq = selq + " and ((sm.resign='0' and sm.settled='0') or sm.Discontinue='0')";
}
if (rbfingerid.Checked == true)
{
selq = selq + " and ((sm.Fingerprint1 is not null) and (cast(sm.FingerPrint1 as varchar)<>''))";
}
else
{
selq = selq + " and ((sm.Fingerprint1 is null) or (cast(sm.FingerPrint1 as varchar)=''))";
}
}
ds.Clear();
ds = d2.select_method_wo_parameter(selq, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
loadrepsprcolumns();
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cb.AutoPostBack = false;
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
cball.AutoPostBack = true;
FarPoint.Web.Spread.TextCellType txtcell = new FarPoint.Web.Spread.TextCellType();
Fpspreadpop.Sheets[0].RowCount++;
Fpspreadpop.Sheets[0].Cells[0, 1].CellType = cball;
Fpspreadpop.Sheets[0].Cells[0, 1].Value = 0;
Fpspreadpop.Sheets[0].Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpop.Sheets[0].Cells[0, 1].Font.Name = "Book Antiqua";
for (ik = 0; ik < ds.Tables[0].Rows.Count; ik++)
{
Fpspreadpop.Sheets[0].RowCount++;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(ik + 1);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 1].CellType = cb;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[ik]["staff_Code"]);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 2].CellType = txtcell;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[ik]["staff_name"]);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[ik]["desig_name"]);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(ds.Tables[0].Rows[ik]["dept_name"]);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 6].CellType = txtcell;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(ds.Tables[0].Rows[ik]["Fingerprint1"]);
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
//Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(ds.Tables[0].Rows[ik]["MachineNo"]);
//Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
//Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
//Fpspreadpop.Sheets[0].Cells[Fpspreadpop.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
}
Fpspreadpop.Sheets[0].PageSize = Fpspreadpop.Sheets[0].RowCount;
Fpspreadpop.Visible = true;
lblpoperr.Visible = false;
rprint.Visible = true;
divpopspr.Visible = true;
}
else
{
Fpspreadpop.Visible = false;
lblpoperr.Visible = true;
lblpoperr.Text = "No Records Found!";
rprint.Visible = false;
divpopspr.Visible = false;
}
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
FpSpread1.Height = Unit.Pixel(300);
FpSpread1.Width = Unit.Pixel(763);
FpSpread1.Sheets[0].ColumnCount = 8;
FpSpread1.Sheets[0].RowCount = 100;
//set colunm head
FpSpread1.ColumnHeader.Cells[0, 0].Text = "Check #";
FpSpread1.ColumnHeader.Cells[0, 1].Text = "Date";
FpSpread1.ColumnHeader.Cells[0, 2].Text = "Description";
FpSpread1.ColumnHeader.Cells[0, 3].Text = "Tax?";
FpSpread1.ColumnHeader.Cells[0, 4].Text = "Cleared";
FpSpread1.ColumnHeader.Cells[0, 5].Text = "Debit";
FpSpread1.ColumnHeader.Cells[0, 6].Text = "Credit";
FpSpread1.ColumnHeader.Cells[0, 7].Text = "Balance";
//set up the column width
FpSpread1.Sheets[0].Columns[0].Width = 50;
FpSpread1.Sheets[0].Columns[1].Width = 50;
FpSpread1.Sheets[0].Columns[2].Width = 200;
FpSpread1.Sheets[0].Columns[3].Width = 40;
FpSpread1.Sheets[0].Columns[4].Width = 65;
FpSpread1.Sheets[0].Columns[5].Width = 100;
FpSpread1.Sheets[0].Columns[6].Width = 100;
FpSpread1.Sheets[0].Columns[7].Width = 125;
FpSpread1.Sheets[0].DataAutoCellTypes = false;
//set cell types -CheckBox
FarPoint.Web.Spread.CheckBoxCellType objIntCell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].Columns[0].CellType = objIntCell;
//datetime celltype
FarPoint.Web.Spread.DateTimeCellType objDateCell = new FarPoint.Web.Spread.DateTimeCellType();
objDateCell.FormatString = "M/dd/yyyy";
FpSpread1.Sheets[0].Columns[1].CellType = objDateCell;
FpSpread1.ActiveSheetView.Cells[0, 1].Value = DateTime.Now;
// Create Description column of general cells.
FarPoint.Web.Spread.GeneralCellType objGenCell = new FarPoint.Web.Spread.GeneralCellType();
FpSpread1.Sheets[0].Columns[2].CellType = objGenCell;
// Create Tax? and Cleared? columns of check box cells.
FarPoint.Web.Spread.CheckBoxCellType objCheckCell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].Columns[3].CellType = objCheckCell;
FpSpread1.Sheets[0].Columns[4].CellType = objCheckCell;
//////////////////////////////////////
FarPoint.Web.Spread.Extender.DateCalendarCellType objDDDcell = new FarPoint.Web.Spread.Extender.DateCalendarCellType();
objDDDcell.Animated = true;
objDDDcell.DateFormat = "MM/dd/yyyy";
objDDDcell.EnableOnClient = true;
// objDDDcell.ShowEditor = true;
//dc.Animated = True
//dc.DateFormat = "MM/dd/yyyy"
//dc.EnableOnClient = True
//Dim mee As New AjaxControlToolkit.MaskedEditExtender
//mee.Mask = "99/99/9999"
//mee.MaskType = AjaxControlToolkit.MaskedEditType.Date
//dc.Extenders.Add(mee)
//dc.ShowEditor = True
FpSpread1.Sheets[0].Columns[5].CellType = objDDDcell;
}
public void bindspread()
{
try
{
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
strquery = "SELECT DISTINCT Stage_ID,S.Stage_Name,R.Veh_ID,len(r.Veh_ID),(select priority from tbl_vechile_priority p where p.veh_id=r.veh_id and p.stage_id=s.Stage_ID) as periorty FROM RouteMaster R,Vehicle_Master V,Stage_Master S WHERE R.Veh_ID = V.Veh_ID AND R.Stage_Name = S.Stage_ID";
if (ddlstage.SelectedItem.ToString() != "All")
{
strquery = strquery + " and R.Stage_Name = '" + ddlstage.SelectedValue.ToString() + "' ";
}
strquery = strquery + " order by S.Stage_Name,len(r.Veh_ID),R.Veh_ID";
ds = d2.select_method_wo_parameter(strquery, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
lblrptname.Visible = true;
txtexcelname.Visible = true;
btnxl.Visible = true;
btnprintmaster.Visible = true;
Printcontrol.Visible = false;
FpSpread1.Visible = true;
btnsave.Enabled = true;
btnreset.Enabled = true;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].ColumnCount = 5;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].BackColor = Color.AliceBlue;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Height = 25;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Stage";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Vehicle";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Priority";
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FpSpread1.Sheets[0].Columns[0].CellType = txt;
FpSpread1.Sheets[0].Columns[1].CellType = txt;
FpSpread1.Sheets[0].Columns[2].CellType = txt;
FpSpread1.Sheets[0].Columns[4].CellType = txt;
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
chk.AutoPostBack = true;
FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].Columns[0].Width = 75;
FpSpread1.Sheets[0].Columns[1].Width = 250;
FpSpread1.Sheets[0].Columns[2].Width = 150;
FpSpread1.Sheets[0].Columns[3].Width = 50;
FpSpread1.Sheets[0].Columns[4].Width = 100;
int srno = 0;
string stageid = "";
string priority = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].RowCount++;
srno++;
stageid = ds.Tables[0].Rows[i]["Stage_ID"].ToString();
priority = ds.Tables[0].Rows[i]["periorty"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = srno.ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = ds.Tables[0].Rows[i]["Stage_Name"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = stageid;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = ds.Tables[0].Rows[i]["Veh_ID"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = chk;
if (priority.Trim() != "0" && priority.Trim() != "" && priority.Trim().ToLower() != null)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = priority;
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = "";
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
}
}
else
{
lblrptname.Visible = false;
txtexcelname.Visible = false;
btnxl.Visible = false;
btnprintmaster.Visible = false;
Printcontrol.Visible = false;
FpSpread1.Visible = false;
errmsg.Visible = true;
errmsg.Text = "no Records Found";
btnsave.Enabled = false;
btnreset.Enabled = false;
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
int h1 = 100;
for (int i = 0; i < FpSpread1.Sheets[0].RowCount; i++)
{
h1 = h1 + FpSpread1.Sheets[0].Rows[i].Height;
}
if (h1 < 500)
{
FpSpread1.Height = h1;
}
else
{
FpSpread1.Height = 500;
}
h1 = 20;
for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount; i++)
{
h1 = h1 + FpSpread1.Sheets[0].Columns[i].Width;
}
FpSpread1.Width = h1;
}
catch
{
}
}
//private void loadgrid(DataSet ds)
//{
// try
// {
// DataTable dt = new DataTable();
// dt.Columns.Add("SNo");
// dt.Columns.Add("staff_code");
// dt.Columns.Add("staff_name");
// dt.Columns.Add("stftype");
// dt.Columns.Add("per_mobileno");
// dt.Columns.Add("email");
// dt.Columns.Add("appno");
// dt.Columns.Add("sms_groupCode");
// DataRow drow;
// int rowcount = 0;
// for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
// {
// drow = dt.NewRow();
// drow["SNo"] = Convert.ToString(++rowcount);
// drow["staff_code"] = Convert.ToString(ds.Tables[0].Rows[row]["staff_code"]);
// drow["staff_name"] = Convert.ToString(ds.Tables[0].Rows[row]["staff_name"]);
// drow["stftype"] = Convert.ToString(ds.Tables[0].Rows[row]["stftype"]);
// drow["per_mobileno"] = Convert.ToString(ds.Tables[0].Rows[row]["per_mobileno"]);
// drow["email"] = Convert.ToString(ds.Tables[0].Rows[row]["email"]);
// drow["appno"] = Convert.ToString(ds.Tables[0].Rows[row]["app_no"]);
// drow["sms_groupCode"] = Convert.ToString(ds.Tables[0].Rows[row]["sms_groupCode"]);
// dt.Rows.Add(drow);
// }
// if (dt.Rows.Count > 0)
// {
// gdReport.DataSource = dt;
// gdReport.DataBind();
// divGrid.Visible = true;
// btnSave.Visible = true;
// }
// }
// catch
// {
// }
//}
private void loadspread(DataSet ds)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("SNo");
dt.Columns.Add("Select");
dt.Columns.Add("Staff Code");
dt.Columns.Add("Staff Name");
dt.Columns.Add("Staff Type");
dt.Columns.Add("Staff-MobileNo");
dt.Columns.Add("Staff-EmailId");
dt.Columns.Add("Group Name");
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;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
for (int row = 0; row < dt.Columns.Count; row++)
{
FpSpread1.Sheets[0].ColumnCount++;
string col = Convert.ToString(dt.Columns[row].ColumnName);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].Text = col;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].ForeColor = ColorTranslator.FromHtml("#000000");
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, row].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
//int rollNo = 0;
//int regNo = 0;
//int admNo = 0;
//bool boolroll=false;
switch (col)
{
case "SNo":
FpSpread1.Sheets[0].Columns[row].Width = 50;
break;
case "Select":
FpSpread1.Sheets[0].Columns[row].Width = 50;
break;
case "Staff Code":
FpSpread1.Sheets[0].Columns[row].Width = 100;
//admNo = Convert.ToInt32(spreadDet.Sheets[0].ColumnCount - 1);
//boolroll = true;
break;
case "Staff Name":
FpSpread1.Sheets[0].Columns[row].Width = 150;
//rollNo = Convert.ToInt32(spreadDet.Sheets[0].ColumnCount - 1);
//boolroll = true;
break;
case "Staff Type":
FpSpread1.Sheets[0].Columns[row].Width = 150;
//regNo = Convert.ToInt32(spreadDet.Sheets[0].ColumnCount - 1);
//boolroll = true;
break;
case "Staff-MobileNo":
FpSpread1.Sheets[0].Columns[row].Width = 150;
break;
case "Staff-EmailId":
FpSpread1.Sheets[0].Columns[row].Width = 200;
break;
case "Group Name":
FpSpread1.Sheets[0].Columns[row].Width = 120;
break;
//case "Semester":
// spreadDet.Sheets[0].Columns[spreadDet.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
// break;
}
}
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
cball.AutoPostBack = true;
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cb.AutoPostBack = false;
DataRow drow;
int rowcount = 0;
int height = 0;
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = cball;
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
FpSpread1.Sheets[0].RowCount++;
height += 10;
for (int col = 0; col < dt.Columns.Count; col++)
{
if (col == 0)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Text = Convert.ToString(++rowcount);
}
else if (col == 1)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].CellType = cb;
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Text = Convert.ToString(ds.Tables[0].Rows[row][col - 2]);
}
}
//drow = dt.NewRow();
//drow["SNo"] = Convert.ToString(++rowcount);
//drow["Roll No"] = Convert.ToString(ds.Tables[0].Rows[row]["roll_no"]);
//drow["Reg No"] = Convert.ToString(ds.Tables[0].Rows[row]["reg_no"]);
//drow["Addmission No"] = Convert.ToString(ds.Tables[0].Rows[row]["roll_admit"]);
//drow["Student Name"] = Convert.ToString(ds.Tables[0].Rows[row]["stud_name"]);
//drow["Course"] = Convert.ToString(ds.Tables[0].Rows[row]["course"]);
//drow["Stream"] = stream;
//drow["BatchYear"] = Convert.ToString(ds.Tables[0].Rows[row]["batch_year"]);
//drow["Branch"] = Convert.ToString(ds.Tables[0].Rows[row]["Branch"]);
//drow["Department"] = Convert.ToString(ds.Tables[0].Rows[row]["deptname"]);
//drow["Q1"] = Convert.ToString(ds.Tables[0].Rows[row]["param_1"]);
//drow["Q2"] = Convert.ToString(ds.Tables[0].Rows[row]["param_2"]);
//drow["Q3"] = Convert.ToString(ds.Tables[0].Rows[row]["param_3"]);
//drow["Q4"] = Convert.ToString(ds.Tables[0].Rows[row]["param_4"]);
//drow["Q5"] = Convert.ToString(ds.Tables[0].Rows[row]["param_5"]);
//drow["Q6"] = Convert.ToString(ds.Tables[0].Rows[row]["param_6"]);
//drow["Q7"] = Convert.ToString(ds.Tables[0].Rows[row]["param_7"]);
//drow["Q8"] = Convert.ToString(ds.Tables[0].Rows[row]["param_8"]);
//dt.Rows.Add(drow);
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
//FpSpread1.Height = height;
FpSpread1.Width = 1000;
FpSpread1.Height = 500;
FpSpread1.Visible = true;
print.Visible = true;
}
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 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 { }
}
public void LoadDetails()
{
try
{
FpSpread2.Sheets[0].ColumnCount = 0;
FpSpread2.Sheets[0].RowCount = 0;
FpSpread2.Sheets[0].SheetCorner.ColumnCount = 0;
FpSpread2.CommandBar.Visible = false;
FpSpread2.Sheets[0].ColumnCount = 7;
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Batch Year";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Degree";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Sem";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Subject Name - Code";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Common Subject Name - Code";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Select";
FpSpread2.Sheets[0].Columns[0].Width = 50;
FpSpread2.Sheets[0].Columns[1].Width = 80;
FpSpread2.Sheets[0].Columns[2].Width = 200;
FpSpread2.Sheets[0].Columns[3].Width = 50;
FpSpread2.Sheets[0].Columns[4].Width = 220;
FpSpread2.Sheets[0].Columns[5].Width = 220;
FpSpread2.Sheets[0].Columns[6].Width = 50;
FpSpread2.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Center;
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 = System.Drawing.Color.White;
style2.BackColor = System.Drawing.Color.Teal;
FpSpread2.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2);
FpSpread2.Sheets[0].SheetName = " ";
FpSpread2.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread2.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread2.Sheets[0].DefaultStyle.Font.Bold = false;
FpSpread2.Sheets[0].AutoPostBack = false;
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
string strquery = "select sy.Batch_Year,c.Course_Name,de.Dept_Name,sy.semester,ss.subject_type,s.subject_name,s.subject_code,d.Degree_Code,s.subject_no,(Select s1.subject_name+' - '+s1.subject_code from subject s1 where s1.subject_no=t.Common_Subject_no) com_subname,";
strquery = strquery + " t.Common_Subject_no from syllabus_master sy,Degree d,Course c,subject s,sub_sem ss,Department de,tbl_equal_subject_Grade_System t where sy.syll_code=ss.syll_code and ss.subType_no=s.subType_no and sy.degree_code=d.Degree_Code and d.Course_Id=c.Course_Id and d.Dept_Code=de.Dept_Code and s.subject_no=t.Subject_no";
strquery = strquery + " and c.edu_level='" + ddledu.SelectedItem.ToString() + "' and d.college_code='" + ddlcollege.SelectedValue.ToString() + "' and sy.batch_year>='" + ddlbatch.SelectedItem.ToString() + "' and ss.subject_type='" + ddlsubtype.SelectedItem.ToString() + "' order by ss.subject_type,s.subject_name,s.subject_code desc,d.degree_code,sy.Batch_Year desc";
ds.Dispose();
ds.Reset();
ds = d2.select_method_wo_parameter(strquery, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
int srno = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
srno++;
string batch = ds.Tables[0].Rows[i]["Batch_Year"].ToString();
string course = ds.Tables[0].Rows[i]["Course_Name"].ToString();
string dept = ds.Tables[0].Rows[i]["Dept_Name"].ToString();
string sem = ds.Tables[0].Rows[i]["semester"].ToString();
string subtype = ds.Tables[0].Rows[i]["subject_type"].ToString();
string subjectname = ds.Tables[0].Rows[i]["subject_name"].ToString();
string subcode = ds.Tables[0].Rows[i]["subject_code"].ToString();
string degreecode = ds.Tables[0].Rows[i]["Degree_Code"].ToString();
string subno = ds.Tables[0].Rows[i]["subject_no"].ToString();
string comsubno = ds.Tables[0].Rows[i]["Common_Subject_no"].ToString();
string comsubjectname = ds.Tables[0].Rows[i]["com_subname"].ToString();
FpSpread2.Sheets[0].RowCount++;
if ((FpSpread2.Sheets[0].RowCount % 2) == 0)
{
FpSpread2.Sheets[0].Rows[FpSpread2.Sheets[0].RowCount - 1].BackColor = System.Drawing.Color.LightGray;
}
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = srno.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = batch.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = course + " - " + dept;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Text = sem.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Text = subjectname.ToString() + " - " + subcode.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Tag = subno;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 5].Text = comsubjectname.ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 5].Tag = comsubno;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 6].CellType = chk;
}
FpSpread2.Visible = true;
btndelete.Visible = true;
}
else
{
errmsg.Visible = true;
errmsg.Text = "No Records Found";
}
FpSpread2.Width = 940;
FpSpread2.Height = 500;
FpSpread2.Sheets[0].PageSize = FpSpread2.Sheets[0].RowCount;
}
catch (Exception ex)
{
errmsg.Visible = true;
errmsg.Text = ex.ToString();
}
}
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 = 5;
FpSpread2.Sheets[0].Columns[0].Width = 40;
FpSpread2.Sheets[0].Columns[1].Width = 113;
FpSpread2.Sheets[0].Columns[2].Width = 342;
FpSpread2.Sheets[0].Columns[3].Width = 83;
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].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
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 = 2;
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 2, 1);
FpSpread2.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 2, 1);
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Subject Code";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Subject Name";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Priority";
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread2.Sheets[0].RowCount = 0;
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread2.Sheets[0].RowCount = FpSpread2.Sheets[0].RowCount + 1;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].CellType = chkcell1;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].FrozenRowCount = 1;
chkcell1.AutoPostBack = true;
chkcell.AutoPostBack = true;
FpSpread2.Sheets[0].AutoPostBack = false;
string batchyear = ddlbatch.SelectedValue.ToString();
string degreecode = ddlbranch.SelectedValue.ToString();
string year = ddlbatch.SelectedValue.ToString();
string degree = ddldegree.SelectedItem.ToString();
string course = ddldegree.SelectedItem.ToString();
string depart_code = ddlbranch.SelectedValue.ToString();
string batchyearatt = ddlbatch.SelectedValue.ToString();
string studinfo = "";
//studinfo = "select distinct s.subject_no,subject_code,subject_name,subject_type,ss.subtype_no,subjectpriority from subject s,syllabus_master sm ,sub_sem ss where ss.syll_code=sm.syll_code and sm.syll_code=s.syll_code and ss.syll_code=s.syll_code and ss.subtype_no=s.subtype_no and batch_year='" + ddlbatch.SelectedItem.Text.ToString() + "' and semester='" + ddlsem.SelectedItem.Text.ToString() + "' and degree_code='" + depart_code + "' and ss.subtype_no='" + ddlsubtype.SelectedItem.Value.ToString() + "'";
studinfo = "select distinct s.subject_no,subject_code,subject_name,subject_type,ss.subtype_no,subjectpriority from subject s,syllabus_master sm ,sub_sem ss where ss.syll_code=sm.syll_code and sm.syll_code=s.syll_code and ss.syll_code=s.syll_code and ss.subtype_no=s.subtype_no and batch_year='" + ddlbatch.SelectedItem.Text.ToString() + "' and semester='" + ddlsem.SelectedItem.Text.ToString() + "' and degree_code='" + depart_code + "' order by subject_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++)
{
string regno = "";
string studname = "";
string rollno = "";
FpSpread2.Visible = true;
sno++;
FpSpread2.Sheets[0].RowCount = FpSpread2.Sheets[0].RowCount + 1;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = sno + "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].CellType = txt;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = dsstudinfo.Tables[0].Rows[studcount]["subject_code"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Note = dsstudinfo.Tables[0].Rows[studcount]["subject_no"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = dsstudinfo.Tables[0].Rows[studcount]["subject_name"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = dsstudinfo.Tables[0].Rows[studcount]["subject_name"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Text = dsstudinfo.Tables[0].Rows[studcount]["subjectpriority"].ToString();;
if (FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Text.Trim() != "")
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Value = 1;
btnreset.Visible = true;
}
else
{
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Locked = false;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Value = 0;
btnreset.Visible = false;
}
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].CellType = chkcell;
}
}
else
{
clear();
lblerror.Text = "No Records Found";
lblerror.Visible = true;
}
string totalrows = FpSpread2.Sheets[0].RowCount.ToString();
FpSpread2.Sheets[0].PageSize = (Convert.ToInt32(totalrows) * 20) + 40;
FpSpread2.Height = (Convert.ToInt32(totalrows) * 50) + 40;
FpSpread2.SaveChanges();
}
catch (Exception ex)
{
lblerror.Text = ex.ToString();
lblerror.Visible = true;
}
}
protected void btngo_click(object sender, EventArgs e)
{
try
{
if (maincol.Trim() != "")
{
string deptcode = "";
string desigcode = "";
string stftype = "";
string collcode = Convert.ToString(ddlcoll.SelectedValue);
if (txtdept.Text.Trim() != "--Select--")
{
if (cbl_dept.Items.Count > 0)
{
for (i = 0; i < cbl_dept.Items.Count; i++)
{
if (cbl_dept.Items[i].Selected == true)
{
if (deptcode.Trim() == "")
{
deptcode = "" + Convert.ToString(cbl_dept.Items[i].Value) + "";
}
else
{
deptcode = deptcode + "'" + "," + "'" + Convert.ToString(cbl_dept.Items[i].Value) + "";
}
}
}
}
}
if (txtdesig.Text.Trim() != "--Select--")
{
if (cbl_desig.Items.Count > 0)
{
for (i = 0; i < cbl_desig.Items.Count; i++)
{
if (cbl_desig.Items[i].Selected == true)
{
if (desigcode.Trim() == "")
{
desigcode = "" + Convert.ToString(cbl_desig.Items[i].Value) + "";
}
else
{
desigcode = desigcode + "'" + "," + "'" + Convert.ToString(cbl_desig.Items[i].Value) + "";
}
}
}
}
}
if (txtstftype.Text.Trim() != "--Select--")
{
if (cbl_stftype.Items.Count > 0)
{
for (i = 0; i < cbl_stftype.Items.Count; i++)
{
if (cbl_stftype.Items[i].Selected == true)
{
if (stftype.Trim() == "")
{
stftype = "" + Convert.ToString(cbl_stftype.Items[i].Text) + "";
}
else
{
stftype = stftype + "'" + "," + "'" + Convert.ToString(cbl_stftype.Items[i].Text) + "";
}
}
}
}
}
string selq = "select distinct s.staff_code,staff_name,PrintPriority,dept.dept_name,desig.desig_name from staffmaster s,stafftrans st,staff_appl_master a,hrdept_master dept,desig_master desig where s.staff_code=st.staff_code and s.appl_no=a.appl_no and st.dept_code=dept.dept_code and st.desig_code=desig.desig_code and s.college_code=dept.college_code and s.college_Code=desig.collegeCode and s.resign='0' and s.settled='0' and ISNULL(Discontinue,'0')='0' and st.latestrec='1' and s.college_Code='" + collcode + "'";
if (deptcode.Trim() != "")
{
selq = selq + " and dept.dept_code in('" + deptcode + "')";
}
if (deptcode.Trim() != "")
{
selq = selq + " and desig.desig_code in('" + desigcode + "')";
}
if (stftype.Trim() != "")
{
selq = selq + " and st.stftype in('" + stftype + "')";
}
ds.Clear();
ds = d2.select_method_wo_parameter(selq, "Text");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
FpSpread.Sheets[0].RowCount = 0;
FpSpread.Sheets[0].ColumnCount = 0;
FpSpread.CommandBar.Visible = false;
FpSpread.Sheets[0].AutoPostBack = false;
FpSpread.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread.Sheets[0].RowHeader.Visible = false;
FpSpread.Sheets[0].ColumnCount = 5;
FarPoint.Web.Spread.CheckBoxCellType cbpriority = new FarPoint.Web.Spread.CheckBoxCellType();
cbpriority.AutoPostBack = true;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.Font.Bold = true;
darkstyle.Border.BorderSize = 1;
darkstyle.HorizontalAlign = HorizontalAlign.Center;
darkstyle.VerticalAlign = VerticalAlign.Middle;
darkstyle.Border.BorderColor = System.Drawing.Color.Transparent;
FpSpread.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Columns[0].Locked = true;
FpSpread.Columns[0].Width = 75;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Staff Code";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Columns[1].Locked = true;
if (chkpriority.Checked)
{
FpSpread.Columns[1].Width = 150;
}
else
{
FpSpread.Columns[1].Width = 100;
}
FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Name";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Columns[2].Locked = true;
if (chkpriority.Checked)
{
FpSpread.Columns[2].Width = 275;
}
else
{
FpSpread.Columns[2].Width = 225;
}
FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Set Priority";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Columns[3].Width = 110;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Priority";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Columns[4].Locked = true;
FpSpread.Columns[4].Width = 110;
for (i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(i + 1);
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].Text = Convert.ToString(ds.Tables[0].Rows[i]["staff_code"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
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].Text = Convert.ToString(ds.Tables[0].Rows[i]["staff_name"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
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].CellType = cbpriority;
if (Convert.ToString(ds.Tables[0].Rows[i]["PrintPriority"]).Trim() != "" && Convert.ToString(ds.Tables[0].Rows[i]["PrintPriority"]).Trim() != "0")//delsi0313
{
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Value = 1;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = true;
}
else
{
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Value = 0;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = false;
}
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
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].Text = Convert.ToString(ds.Tables[0].Rows[i]["PrintPriority"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
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.Visible = true;
divspr.Visible = true;
rprint.Visible = true;
lblspreaderr.Visible = false;
FpSpread.Width = 750;
FpSpread.Height = 300;
FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount;
if (chkpriority.Checked == true)
{
FpSpread.Sheets[0].Columns[3].Visible = true;
FpSpread.Sheets[0].AutoPostBack = false;
btnsetpriority.Visible = true;
btnresetpriority.Visible = true;
}
else
{
FpSpread.Sheets[0].Columns[3].Visible = false;
FpSpread.Sheets[0].AutoPostBack = true;
btnsetpriority.Visible = false;
btnresetpriority.Visible = false;
}
}
else
{
FpSpread.Visible = false;
divspr.Visible = false;
rprint.Visible = false;
lblspreaderr.Visible = true;
lblspreaderr.Text = "No Records Found!";
}
}
else
{
FpSpread.Visible = false;
divspr.Visible = false;
rprint.Visible = false;
lblspreaderr.Visible = true;
lblspreaderr.Text = "No Records Found!";
}
}
}
catch
{
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
lblerror.Visible = false;
Fpstudents.Visible = false;
string batch = ddlBatch.SelectedValue.ToString();
string degree_code = ddlBranch.SelectedValue.ToString();
string sem = ddlSem.SelectedValue;
string subjectno = ddlSubject.SelectedValue.ToString();
string examdate = "";
string examcode = "";
string examdate1 = txtExamDate.Text;
string datechangenew = "";
string datechange = "";
if (txtExamDate.Text != "")
{
string[] splitdate = examdate1.Split(new Char[] { '/' });
string reqdate = splitdate[0].ToString();
string reqmonth = splitdate[1].ToString();
string reqyear = splitdate[2].ToString();
datechange = reqmonth + "-" + reqdate + "-" + reqyear;
datechangenew = reqdate + "-" + reqmonth + "-" + reqyear;
}
if (batch != "" && degree_code != "" && sem != "" && subjectno != "")
{
string examdatequery = "select convert(varchar(10),exam_date,105) as exam_date,ex.exam_code from exmtt ex,exmtt_det ed where ex.exam_code=ed.exam_code and ex.degree_code=" + degree_code + " and ex.batchto=" + batch + " and ex.semester=" + sem + " and ed.subject_no=" + subjectno + "";
SqlDataAdapter daexamdatequery = new SqlDataAdapter(examdatequery, con5);
DataSet dsexamdatequery = new DataSet();
con5.Close();
con5.Open();
daexamdatequery.Fill(dsexamdatequery);
if (dsexamdatequery.Tables[0].Rows.Count > 0)
{
examdate = Convert.ToString(dsexamdatequery.Tables[0].Rows[0]["exam_date"]);
examcode = Convert.ToString(dsexamdatequery.Tables[0].Rows[0]["exam_code"]);
}
if (examdate != "")
{
if (txBatch.Text != "")
{
if (txtExamDate.Text != "")
{
Connection();
int n = Convert.ToInt16(txBatch.Text.ToString());
name = new string[n + 1];
int mm = 0;
for (int j = 1; j <= n; j++)
{
name[j] = ("B" + j);
name[0] = " ";
}
string[] strcomo = new string[] { " " };
cb = new FarPoint.Web.Spread.ComboBoxCellType(name);
cb.AutoPostBack = true;
Hashtable ht = new Hashtable();
ht.Clear();
DAccess2 da = new DAccess2();
DataSet ds = new DataSet();
if (ddlSem.SelectedValue.ToString() != "" && ddlBranch.SelectedValue.ToString() != "" && ddlSection.SelectedItem.Text.ToString() != "" && ddlBatch.SelectedItem.Text.ToString() != "" && ddlSubject.SelectedValue.ToString() != "")
{
ht.Add("Semester", ddlSem.SelectedItem.Text.ToString());
ht.Add("CollegeCode", Session["collegecode"].ToString());
ht.Add("DegreeCode", ddlBranch.SelectedValue.ToString());
ht.Add("Sections", ddlSection.SelectedItem.Text.ToString());
ht.Add("BatchYear", ddlBatch.SelectedItem.Text.ToString());
ht.Add("SubjectNo", ddlSubject.SelectedValue.ToString());
ds = da.select_method("ProcBatchAllocationRegNoDetails", ht, "sp");
Fpstudents.Sheets[0].RowCount = 0;
Fpstudents.Sheets[0].RowCount = ds.Tables[0].Rows.Count + 1;
Fpstudents.Sheets[0].PageSize = ds.Tables[0].Rows.Count + 1 * 20;
Fpstudents.Sheets[0].SpanModel.Add(0, 0, 1, 5);
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
Fpstudents.Sheets[0].Cells[0, 5].CellType = chkcell1;
Fpstudents.Sheets[0].Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].FrozenRowCount = 1;
chkcell1.AutoPostBack = true;
if (ds.Tables[0].Rows.Count > 0)
{
btnsave.Visible = true;
Fpstudents.Visible = true;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string batch1 = "";
if (txtExamDate.Text != "")
{
string selectbatch = "select batch from batch_allocation_practical where batch_year=" + ddlBatch.SelectedItem.Text.ToString() + " and degree_code=" + ddlBranch.SelectedValue.ToString() + " and semester=" + ddlSem.SelectedValue.ToString() + " and exam_code=" + examcode + " and subject_no=" + ddlSubject.SelectedValue.ToString() + " and roll_no='" + ds.Tables[0].Rows[i]["RollNo"].ToString() + "' and subject_no=" + subjectno + "";
SqlDataAdapter daselectbatch = new SqlDataAdapter(selectbatch, con5);
DataSet dsselectbatch = new DataSet();
con5.Close();
con5.Open();
daselectbatch.Fill(dsselectbatch);
if (dsselectbatch.Tables[0].Rows.Count > 0)
{
batch1 = dsselectbatch.Tables[0].Rows[0]["batch"].ToString();
}
}
Fpstudents.Sheets[0].Cells[i + 1, 0].Text = Convert.ToString(i + 1);
Fpstudents.Sheets[0].Cells[i + 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].Cells[i + 1, 1].Text = ds.Tables[0].Rows[i]["RollNo"].ToString();
Fpstudents.Sheets[0].Cells[i + 1, 1].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].Cells[i + 1, 2].Text = ds.Tables[0].Rows[i]["RegNo"].ToString();
Fpstudents.Sheets[0].Cells[i + 1, 2].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].Cells[i + 1, 3].Text = ds.Tables[0].Rows[i]["StudentName"].ToString();
Fpstudents.Sheets[0].Cells[i + 1, 4].CellType = cb;
Fpstudents.Sheets[0].SetText(i + 1, 4, batch1);
}
}
int rowcount = Fpstudents.Sheets[0].RowCount;
Fpstudents.Sheets[0].RowCount = rowcount;
Fpstudents.Height = rowcount * 20;
if (Session["Rollflag"] == "0")
{
Fpstudents.Width = 560;
Fpstudents.Sheets[0].Columns[1].Visible = false;
}
if (Session["Regflag"] == "0")
{
Fpstudents.Width = 510;
Fpstudents.Sheets[0].Columns[2].Visible = false;
if (Session["Rollflag"] == "0")
{
Fpstudents.Width = 410;
}
}
}
}
else
{
btnsave.Visible = false;
Fpstudents.Visible = false;
lblerror.Visible = true;
lblerror.Text = "Exam Date Not Filled";
}
}
else
{
btnsave.Visible = false;
Fpstudents.Visible = false;
lblerror.Visible = true;
lblerror.Text = "No of Batches not Filled";
//ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('No of Batches is not Filled')", true);
}
}
else
{
btnsave.Visible = false;
Fpstudents.Visible = false;
lblerror.Visible = true;
lblerror.Text = "Time Table not created for this Subject";
//ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('Time Table is not created for this Subject')", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//****************************************************//
if (Session["collegecode"] == null)
{
Response.Redirect("~/Default.aspx");
}
if (!Request.FilePath.Contains("CoeHome"))
{
string strPreviousPage = "";
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/CoeMod/CoeHome.aspx");
return;
}
}
//****************************************************//
if (!IsPostBack)
{
Master1 = "select * from Master_Settings where usercode=" + Session["usercode"] + "";
setcon.Close();
setcon.Open();
SqlDataReader mtrdr;
Session["Rollflag"] = "0";
Session["Regflag"] = "0";
Session["Studflag"] = "0";
SqlCommand mtcmd = new SqlCommand(Master1, setcon);
mtrdr = mtcmd.ExecuteReader();
{
if (mtrdr.HasRows)
{
while (mtrdr.Read())
{
if (mtrdr["settings"].ToString() == "Roll No" && mtrdr["value"].ToString() == "1")
{
Session["Rollflag"] = "1";
}
if (mtrdr["settings"].ToString() == "Register No" && mtrdr["value"].ToString() == "1")
{
Session["Regflag"] = "1";
}
}
}
}
DAccess2 da = new DAccess2();
DataSet ds = new DataSet();
ds = da.select_method_wo_parameter("bind_batch", "sp");
if (ds.Tables[0].Rows.Count > 0)
{
ddlBatch.Items.Clear();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ddlBatch.Items.Add(ds.Tables[0].Rows[i]["batch_year"].ToString());
}
}
binddegree();
bindbranch();
bindSem();
bindsections();
ddlSubjectType.Items.Insert(0, new ListItem("All", "0"));
ddlSubjectType.Items.Insert(1, new ListItem("Regular", "1"));
ddlSubjectType.Items.Insert(2, new ListItem("Arear", "2"));
ddlSession.Items.Insert(0, new ListItem("F.N", "0"));
ddlSession.Items.Insert(1, new ListItem("A.N", "1"));
Fpstudents.Sheets[0].RowCount = 1;
Fpstudents.Sheets[0].ColumnCount = 6;
}
Fpstudents.Sheets[0].Columns[0].Width = 60;
Fpstudents.Sheets[0].Columns[1].Width = 100;
Fpstudents.Sheets[0].Columns[2].Width = 150;
Fpstudents.Sheets[0].Columns[3].Width = 250;
Fpstudents.Sheets[0].Columns[4].Width = 50;
Fpstudents.Sheets[0].Columns[5].Width = 50;
Fpstudents.Sheets[0].Columns[0].Locked = true;
Fpstudents.Sheets[0].Columns[1].Locked = true;
Fpstudents.Sheets[0].Columns[2].Locked = true;
Fpstudents.Sheets[0].Columns[3].Locked = true;
Fpstudents.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Center;
Fpstudents.Sheets[0].Columns[3].CellType = cb;
Fpstudents.Sheets[0].RowHeader.Visible = false;
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Roll.No";
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Reg.No";
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Name";
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Batch";
Fpstudents.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Select";
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
Fpstudents.Sheets[0].Columns[5].CellType = chkcell;
Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
Fpstudents.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
Fpstudents.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
Fpstudents.Sheets[0].DefaultStyle.Font.Bold = false;
Fpstudents.CommandBar.Visible = false;
//Fpstudents.RowHeader.Visible = false;
}
catch (Exception ex)
{
}
}
//Spread Load
private void loadSpread(string collegeCode)
{
try
{
Fpspread1.Visible = false;
rptprint.Visible = false;
lblvalidation1.Visible = false;
Printcontrol.Visible = false;
txtexcelname.Text = string.Empty;
lblRecNotFound.Visible = true;
string prevUser = getPrevUser(collegeCode);
string selectQ = "select user_code,USER_ID,Full_Name, Description, SingleUser, is_staff, staff_code ,case when ISNULL(is_staff,'0')='1' then 'Yes' else 'No' end as isstaff,case when ISNULL(SingleUser,'0')='1' then 'Yes' else 'No' end as IsSingleUser from UserMaster where college_code='" + collegeCode + "' ";
DataTable dtUser = dirAccess.selectDataTable(selectQ);
if (dtUser.Rows.Count > 0)
{
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 = 8;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.Black;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[0].Width = 40;
Fpspread1.Columns[0].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "User ID";
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 = 160;
Fpspread1.Columns[1].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Full Name";
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 = 200;
Fpspread1.Columns[2].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Description";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Column.Width = 150;
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 = 200;
Fpspread1.Columns[3].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Single User";
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 = 100;
Fpspread1.Columns[4].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Staff";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[5].Width = 60;
Fpspread1.Columns[5].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Staff Code";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[6].Width = 100;
Fpspread1.Columns[6].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Select";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 7].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Columns[7].Width = 60;
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = true;
for (int row = 0; row < dtUser.Rows.Count; 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(dtUser.Rows[row]["USER_ID"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dtUser.Rows[row]["user_code"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dtUser.Rows[row]["Full_Name"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dtUser.Rows[row]["Description"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dtUser.Rows[row]["IsSingleUser"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Tag = Convert.ToString(dtUser.Rows[row]["SingleUser"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dtUser.Rows[row]["isstaff"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Tag = Convert.ToString(dtUser.Rows[row]["is_staff"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dtUser.Rows[row]["staff_code"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].CellType = chkall;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
if (prevUser.Trim() == Convert.ToString(dtUser.Rows[row]["user_code"]).Trim())
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 7].Value = 1;
for (int k = 0; k < Fpspread1.Columns.Count; k++)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].BackColor = ColorTranslator.FromHtml("#00CC00");
}
}
}
Fpspread1.Visible = true;
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.Width = 950;
Fpspread1.Height = 400;
rptprint.Visible = true;
lblRecNotFound.Visible = false;
}
}
catch { }
}
protected void bttngo_Click(object sender, EventArgs e)
{
Printcontrol.Visible = false;
btns.Visible = false;
try
{
string acccode = "";
for (int i = 0; i < cblaccname.Items.Count; i++)
{
if (cblaccname.Items[i].Selected == true)
{
if (acccode == "")
{
acccode = "" + cblaccname.Items[i].Value.ToString() + "";
}
else
{
acccode = acccode + "'" + "," + "'" + cblaccname.Items[i].Value.ToString() + "";
}
}
}
if (acccode.Trim() != "")
{
string selectqurey = "";
selectqurey = "select FinYearPK,FinYearAcr,FinYearName,(CONVERT(varchar(10), FinYearStart,103)+' - '+CONVERT(varchar(10), FinYearEnd,103))as Finyear,CollegeCode from FM_FinYearMaster where CollegeCode ='" + collegestat0 + "' AND FinYearPK in('" + acccode + "')";
ds.Clear();
ds = d2.select_method_wo_parameter(selectqurey, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
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 = 5;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.Black;
Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
// Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].ForeColor = System.Drawing.Color.Black;
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 = 65;
Fpspread1.Columns[0].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Account Name";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
// Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].ForeColor = System.Drawing.Color.Black;
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 = 300;
Fpspread1.Columns[1].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Account Acronym";
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].ForeColor = System.Drawing.Color.Black;
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.Columns[2].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Financial Year";
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Column.Width = 150;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
// Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].ForeColor = System.Drawing.Color.Black;
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 = 250;
Fpspread1.Columns[3].Locked = true;
Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select";
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].ForeColor = System.Drawing.Color.Black;
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 = 65;
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = true;
string acctid = d2.getCurrentFinanceYear(usercode, collegestat0);
for (int row = 0; row < ds.Tables[0].Rows.Count; 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(ds.Tables[0].Rows[row]["FinYearName"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["FinYearPK"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["FinYearAcr"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(ds.Tables[0].Rows[row]["CollegeCode"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["Finyear"]);
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].CellType = chkall;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
if (acctid.Trim() == Convert.ToString(ds.Tables[0].Rows[row]["FinYearPK"]))
{
countnew = 1;
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Value = 1;
for (int k = 0; k < Fpspread1.Columns.Count; k++)
{
Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].BackColor = ColorTranslator.FromHtml("#00CC00");
}
}
}
Fpspread1.Visible = true;
rptprint.Visible = true;
//div1.Visible = true;
lblerr.Visible = false;
Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount;
Fpspread1.Width = 850;
Fpspread1.Height = 300;
btns.Visible = true;
}
else
{
Fpspread1.Visible = false;
rptprint.Visible = false;
//div1.Visible = false;
lblerr.Visible = true;
lblerr.Text = "No Records Found";
//btns.Visible = false;
}
}
else
{
Fpspread1.Visible = false;
rptprint.Visible = false;
//div1.Visible = false;
lblerr.Visible = true;
lblerr.Text = "No Records Found!";
//btns.Visible = false;
}
}
catch
{
}
}
protected void btnviewre_Click(object sender, EventArgs e)
{
try
{
clear();
if (ddlYear1.SelectedIndex == 0)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Year";
return;
}
if (ddlMonth1.SelectedIndex == 0)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Month";
return;
}
if (ddltype.SelectedIndex == 0)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Type";
return;
}
if (ddldegree1.SelectedIndex == 0 && chksubwise.Checked == false)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Degree";
return;
}
if (ddlbranch1.SelectedIndex == 0 && chksubwise.Checked == false)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select branch";
return;
}
if (ddlsem1.SelectedIndex == 0)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Semester";
return;
}
if (ddlSubject.SelectedIndex == 0)
{
lblerr1.Visible = true;
lblerr1.Text = "Please Select Subject";
return;
}
fpspread.Width = 906;
fpspread.Visible = false;
fpspread.Sheets[0].RowCount = 0;
fpspread.Sheets[0].ColumnCount = 0;
fpspread.Sheets[0].ColumnCount = 5;
fpspread.Sheets[0].RowHeader.Visible = false;
fpspread.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
fpspread.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
fpspread.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
fpspread.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
fpspread.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
fpspread.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
fpspread.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
fpspread.Sheets[0].DefaultStyle.Font.Bold = false;
fpspread.Sheets[0].ColumnHeader.RowCount = 1;
fpspread.Sheets[0].AutoPostBack = false;
fpspread.CommandBar.Visible = false;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
fpspread.Sheets[0].ColumnHeader.Columns[0].Width = 50;
fpspread.Sheets[0].ColumnHeader.Columns[1].Width = 100;
fpspread.Sheets[0].ColumnHeader.Columns[2].Width = 100;
fpspread.Sheets[0].ColumnHeader.Columns[3].Width = 250;
fpspread.Sheets[0].ColumnHeader.Columns[4].Width = 80;
fpspread.Sheets[0].ColumnHeader.Columns[0].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].ColumnHeader.Columns[1].HorizontalAlign = HorizontalAlign.Left;
fpspread.Sheets[0].ColumnHeader.Columns[2].HorizontalAlign = HorizontalAlign.Left;
fpspread.Sheets[0].ColumnHeader.Columns[3].HorizontalAlign = HorizontalAlign.Left;
fpspread.Sheets[0].ColumnHeader.Columns[4].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].Columns[0].VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Columns[2].VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Columns[3].VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Columns[4].VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Columns[0].Locked = true;
fpspread.Sheets[0].Columns[1].Locked = true;
fpspread.Sheets[0].Columns[2].Locked = true;
fpspread.Sheets[0].Columns[3].Locked = true;
fpspread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
fpspread.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Roll No";
fpspread.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Reg No";
fpspread.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Student Name";
fpspread.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select";
fpspread.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
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 = System.Drawing.Color.White;
style2.BackColor = System.Drawing.Color.Teal;
fpspread.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2);
fpspread.Sheets[0].SheetName = " ";
fpspread.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
fpspread.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
fpspread.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
fpspread.Sheets[0].DefaultStyle.Font.Bold = false;
fpspread.Sheets[0].Columns[1].Visible = false;
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = true;
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
string repav = " and r.cc=1";
if (ddlicatype.SelectedValue.ToString() == "1")
{
repav = " and r.cc=0";
}
//string strquery1 = "select m.roll_no,m.internal_mark,m.external_mark,m.result from Exam_Details ed,mark_entry m,subject s where m.exam_code=ed.exam_code and m.subject_no=s.subject_no and s.subject_code='"+ddlSubject.SelectedValue.ToString()+"' and ed.Exam_Month=11 and ed.Exam_year=2015";
//DataSet dsmarkentry = da.select_method_wo_parameter(strquery1, "Text");
string strbaks = "select ea.roll_no,ea.appl_no,ed.current_semester from Exam_Details ed,exam_application ea,exam_appl_details ead,subject s where ea.exam_code=ed.exam_code and ea.appl_no=ead.appl_no and ead.subject_no=s.subject_no and ead.type='1' and s.subject_code='" + ddlSubject.SelectedValue.ToString() + "' and ed.Exam_Month='" + ddlMonth1.SelectedValue.ToString() + "' and ed.Exam_year='" + ddlYear1.SelectedValue.ToString() + "'";
DataSet dsexamapp = da.select_method_wo_parameter(strbaks, "Text");
string degreeval = string.Empty;
if (chksubwise.Checked == false)
{
degreeval = " and r.degree_code='" + ddlbranch1.SelectedValue.ToString() + "'";
}
string strquery = "select s.subject_no,s.subject_name,subject_code,r.Roll_No,r.Reg_No,r.Stud_Name,r.Batch_Year,r.degree_code,r.current_semester,r.cc,r.delflag,max(m.internal_mark) ICA,max(m.external_mark) EXE from mark_entry m,subject s,Registration r where m.subject_no=s.subject_no and r.Roll_No=m.roll_no and s.subject_code='" + ddlSubject.SelectedValue.ToString() + "' " + degreeval + " " + repav + " and m.roll_no not in (select m1.roll_no from mark_entry m1 where m1.roll_no=m.roll_no and m.subject_no=m1.subject_no and m1.result='Pass') group by s.subject_no,s.subject_name,subject_code,r.Roll_No,r.Reg_No,r.Stud_Name,r.Batch_Year,r.degree_code,r.current_semester,r.cc,r.delflag";
strquery = strquery + " union select s.subject_no,s.subject_name,subject_code,r.Roll_No,r.Reg_No,r.Stud_Name,r.Batch_Year,r.degree_code,r.current_semester,r.cc,r.delflag,max(m.internal_mark) ICA,max(m.external_mark) EXE from mark_entry m,subject s,Registration r,Exam_Details ed,exam_application ea,exam_appl_details ead where m.subject_no=s.subject_no and r.Roll_No=m.roll_no and s.subject_code='" + ddlSubject.SelectedValue.ToString() + "' " + degreeval + " " + repav + " and r.cc=1 and r.Roll_No=ea.roll_no and ed.exam_code=m.exam_code and ed.exam_code=ea.exam_code and ea.appl_no=ead.appl_no and ead.type='1' and m.result='Pass' group by s.subject_no,s.subject_name,subject_code,r.Roll_No,r.Reg_No,r.Stud_Name,r.Batch_Year,r.degree_code,r.current_semester,r.cc,r.delflag order by r.batch_year desc,r.degree_code,r.reg_no desc";
ds2.Dispose();
ds2.Reset();
ds2 = da.select_method_wo_parameter(strquery, "Text");
if (ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0)
{
btnsave1.Visible = true;
fpspread.Visible = true;
int srno = 0;
fpspread.Sheets[0].RowCount++;
fpspread.Sheets[0].SpanModel.Add(fpspread.Sheets[0].RowCount - 1, 0, 1, 4);
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].CellType = chkall;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
string rollno = ds2.Tables[0].Rows[i]["Roll_No"].ToString();
string regno = ds2.Tables[0].Rows[i]["Reg_No"].ToString();
string name = ds2.Tables[0].Rows[i]["Stud_Name"].ToString();
string subno = ds2.Tables[0].Rows[i]["subject_no"].ToString();
srno++;
fpspread.Sheets[0].RowCount++;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 0].Text = srno.ToString();
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 1].CellType = txt;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 2].CellType = txt;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 3].CellType = txt;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 1].Text = rollno;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 2].Text = regno;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 3].Text = name;
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 1].Tag = ds2.Tables[0].Rows[i]["batch_year"].ToString();
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 2].Tag = ds2.Tables[0].Rows[i]["degree_code"].ToString();
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 3].Tag = ds2.Tables[0].Rows[i]["current_semester"].ToString();
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].Tag = ds2.Tables[0].Rows[i]["subject_no"].ToString();
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].CellType = chk;
dsexamapp.Tables[0].DefaultView.RowFilter = "roll_no='" + rollno + "'";
DataView dvexmapp = dsexamapp.Tables[0].DefaultView;
if (dvexmapp.Count > 0)
{
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].Value = 1;
}
else
{
fpspread.Sheets[0].Cells[fpspread.Sheets[0].RowCount - 1, 4].Value = 0;
}
}
}
else
{
lblerr1.Visible = true;
lblerr1.Text = "No Records Found";
}
fpspread.SaveChanges();
fpspread.Width = 600;
fpspread.Sheets[0].PageSize = fpspread.Sheets[0].RowCount;
int hei = 300;
for (int col = 0; col < fpspread.Sheets[0].RowCount; col++)
{
hei = hei + fpspread.Sheets[0].Rows[col].Height;
}
fpspread.Height = hei;
fpspread.SaveChanges();
}
catch (Exception ex)
{
lblerr1.Visible = true;
lblerr1.Text = ex.ToString();
}
}
public void loadsavedetails()
{
try
{
Fpsaved.Sheets[0].RowCount = 0;
Fpsaved.Sheets[0].RowHeader.Visible = false;
Fpsaved.CommandBar.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.Black;
Fpsaved.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpsaved.Sheets[0].ColumnCount = 4;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpsaved.Sheets[0].Columns[0].Width = 80;
Fpsaved.Sheets[0].Columns[0].VerticalAlign = VerticalAlign.Middle;
Fpsaved.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Subjectcode_Year";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpsaved.Sheets[0].Columns[1].Width = 200;
Fpsaved.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Subject_Name";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpsaved.Sheets[0].Columns[2].Width = 400;
Fpsaved.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
Fpsaved.Sheets[0].Columns[3].Width = 50;
Fpsaved.Width = 750;
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
year = ddlYear.SelectedItem.Text.Trim();
exam_month = ddlMonth.SelectedItem.Value;
//string strsql = " select distinct t.Equal_Subject_Code,s.subject_name from tbl_equal_paper_Matching t,Exam_Details ed,exam_application ea,exam_appl_details ead,Degree d,course c,subject s where ed.exam_code=ea.exam_code and ea.appl_no=ead.appl_no and ead.subject_no=s.subject_no and ed.Exam_Month=t.exam_month and ed.Exam_year=t.exam_year and d.Degree_Code=ed.degree_code and d.Course_Id=c.Course_Id and s.subject_code=t.Equal_Subject_Code and ed.exam_month='" + exam_month + "' and ed.exam_year='" + year + "' and c.Edu_Level='" +ddldegree.SelectedItem.ToString() + "' and c.type='" +ddltype.SelectedItem.ToString() + "' order by t.Equal_Subject_Code desc";
string strsql = string.Empty;
if (!cbGeneral.Checked)
{
strsql = " select distinct t.Equal_Subject_Code,s.subject_name,t.Com_Subject_Code from tbl_equal_paper_Matching t,Degree d,course c,subject s,syllabus_master sy where sy.syll_code=s.syll_code and d.Degree_Code=sy.degree_code and d.Course_Id=c.Course_Id and s.subject_code=t.Equal_Subject_Code and c.Edu_Level='" + ddldegree.SelectedItem.ToString() + "' and c.type='" + ddltype.SelectedItem.ToString() + "' order by t.Com_Subject_Code,s.subject_name,t.Equal_Subject_Code desc";
}
else
{
strsql = " select distinct t.Equal_Subject_Code,s.subject_name,t.Com_Subject_Code from tbl_Subject_paper_Matching t,Degree d,course c,subject s,syllabus_master sy where sy.syll_code=s.syll_code and d.Degree_Code=sy.degree_code and d.Course_Id=c.Course_Id and s.subject_code=t.Equal_Subject_Code and c.Edu_Level='" + ddldegree.SelectedItem.ToString() + "' and c.type='" + ddltype.SelectedItem.ToString() + "' order by t.Com_Subject_Code,s.subject_name,t.Equal_Subject_Code desc";
}
DataSet dsequalsubject = new DataSet();
dsequalsubject.Clear();
dsequalsubject = da.select_method_wo_parameter(strsql, "Text");
if (dsequalsubject.Tables[0].Rows.Count > 0)
{
Fpsaved.Visible = true;
btnremove.Visible = true;
Fpsaved.Sheets[0].RowCount = 0;
int sno = 0;
for (int i = 0; i < dsequalsubject.Tables[0].Rows.Count; i++)
{
sno++;
Fpsaved.Sheets[0].RowCount++;
Fpsaved.Sheets[0].Cells[i, 0].Text = Convert.ToString(sno);
Fpsaved.Sheets[0].Cells[i, 1].Text = Convert.ToString(dsequalsubject.Tables[0].Rows[i]["Equal_Subject_Code"]);
Fpsaved.Sheets[0].Cells[i, 2].Text = Convert.ToString(dsequalsubject.Tables[0].Rows[i]["subject_name"]);
Fpsaved.Sheets[0].Cells[i, 3].CellType = chk;
}
}
else
{
Fpsaved.Visible = false;
btnremove.Visible = false;
}
Fpsaved.Sheets[0].PageSize = Fpsaved.Sheets[0].RowCount;
}
catch (Exception ex)
{
errmsg.Visible = true;
errmsg.Text = ex.ToString();
}
}
protected void btngo_click(object sender, EventArgs e)
{
try
{
// btnresetpriority_click(sender, e);
string degreecode = rs.GetSelectedItemsValueAsString(cbl_degree);
string collegecode = Convert.ToString(ddlcolhouse.SelectedItem.Value);
if (!string.IsNullOrEmpty(degreecode) && ddlcolhouse.Items.Count > 0)
{
string selectquery = "select Degree_Code,isnull(c.type,'')+'-'+c.Course_Name+'-'+dt.Dept_Name as Dept_Name,Dept_Priority,Acronym from Degree d,Department dt,course c where d.Dept_Code=dt.Dept_Code and c.Course_Id =d.Course_Id and d.college_code in ('" + collegecode + "') and d.Degree_Code in('" + degreecode + "') order by ISNULL(c.Priority,0)";
ds.Clear();
ds = d2.select_method_wo_parameter(selectquery, "Text");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Fpspreadpophouse.Sheets[0].RowCount = 0;
Fpspreadpophouse.Sheets[0].ColumnCount = 0;
Fpspreadpophouse.CommandBar.Visible = false;
Fpspreadpophouse.Sheets[0].AutoPostBack = false;
Fpspreadpophouse.Sheets[0].ColumnHeader.RowCount = 1;
Fpspreadpophouse.Sheets[0].RowHeader.Visible = false;
Fpspreadpophouse.Sheets[0].ColumnCount = 5;
FarPoint.Web.Spread.CheckBoxCellType cbhousepriority = new FarPoint.Web.Spread.CheckBoxCellType();
cbhousepriority.AutoPostBack = true;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.Font.Bold = true;
darkstyle.Border.BorderSize = 1;
darkstyle.HorizontalAlign = HorizontalAlign.Center;
darkstyle.VerticalAlign = VerticalAlign.Middle;
darkstyle.Border.BorderColor = System.Drawing.Color.Transparent;
Fpspreadpophouse.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[0].Locked = true;
Fpspreadpophouse.Columns[0].Width = 50;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Degree";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[1].Locked = true;
Fpspreadpophouse.Columns[1].Width = 400;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Degree Acronym";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[2].Locked = true;
Fpspreadpophouse.Columns[2].Width = 150;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Set Priority";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[3].Locked = false;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Degree Priority";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
Fpspreadpophouse.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].ColumnHeader.Columns[4].Locked = true;
Fpspreadpophouse.Columns[4].Width = 85;
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
Fpspreadpophouse.Sheets[0].RowCount++;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[row]["Dept_Name"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["Degree_Code"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["Acronym"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].CellType = cbhousepriority;
if (Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]).Trim() != "" && Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]).Trim() != "0")
{
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Value = 1;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Locked = true;
}
else
{
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Value = 0;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].Locked = false;
}
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 4].Text = (Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]) == "0") ? "" : Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]);
Fpspreadpophouse.Sheets[0].Cells[Fpspreadpophouse.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
}
spreadDiv.Visible = true;
Fpspreadpophouse.Sheets[0].PageSize = Fpspreadpophouse.Sheets[0].RowCount;
}
else
{
spreadDiv.Visible = false;
}
}
else
{
spreadDiv.Visible = false;
}
Fpspreadpophouse.SaveChanges();
}
else
{
spreadDiv.Visible = false;
alertpop.Visible = true;
lbl_alert.Visible = true;
lbl_alert.Text = "Please Select All Fields";
}
}
catch { }
}
public void newsloadspread(DataSet dsnews)
{
try
{
FpSpread1.SaveChanges();
if (dsnews.Tables.Count > 0 && dsnews.Tables[0].Rows.Count > 0)
{
FpSpread1.Sheets[0].RowCount = 1;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].ColumnHeader.Columns.Count = 3;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.Black;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Columns[0].Locked = true;
FpSpread1.Columns[0].Width = 50;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Journal Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[1].Width = 150;
FpSpread1.Columns[1].Visible = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Journal Code";
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 = 150;
FpSpread1.Columns[2].Visible = false;
FarPoint.Web.Spread.TextCellType txtCell = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
chkcell1.AutoPostBack = true;
FarPoint.Web.Spread.CheckBoxCellType chkcell2 = new FarPoint.Web.Spread.CheckBoxCellType();
chkcell2.AutoPostBack = false;
int sno = 0;
DateTime dateFromDate = new DateTime();
DateTime dateToDate = new DateTime();
dateFromDate = getdate(txt_fromdate.Text.ToString());
dateToDate = getdate(txt_todate.Text.ToString());
string coldate = "";
int col = 0;
while (dateFromDate <= dateToDate)
{
coldate = dateFromDate.ToString("dd/MM/yyyy");
col = FpSpread1.Sheets[0].ColumnHeader.Columns.Count++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, col].Text = coldate;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, col].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[col].Width = 90;
FpSpread1.Columns[col].Visible = true;
FpSpread1.Sheets[0].Cells[0, col].CellType = chkcell1;
FpSpread1.Sheets[0].Cells[0, col].HorizontalAlign = HorizontalAlign.Center;
dateFromDate = dateFromDate.AddDays(1);
col++;
}
int nojoural = dsnews.Tables[0].Rows.Count;
for (int row = 0; row < dsnews.Tables[0].Rows.Count; row++)
{
FpSpread1.Sheets[0].RowCount++;
sno++;
dateFromDate = getdate(txt_fromdate.Text.ToString());
dateToDate = getdate(txt_todate.Text.ToString());
string lan = Convert.ToString(dsnews.Tables[0].Rows[row]["TitleLanguage"]).Trim();
string jname = Convert.ToString(dsnews.Tables[0].Rows[row]["Journal_Name"]).Trim();
string jcode = Convert.ToString(dsnews.Tables[0].Rows[row]["Journal_Code"]).Trim();
string yr = Convert.ToString(dsnews.Tables[0].Rows[row]["Subs_Year"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].CellType = txtCell;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = txtCell;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Tag = jcode;
if (lan == "1")
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = jname;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Amudham";
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = jname;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Arial";
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Tag = jname;
col = 3;
while (dateFromDate <= dateToDate)
{
coldate = dateFromDate.ToString("yyyy/MM/dd");
string Sqlqry = d2.GetFunction("SELECT Issue_Status FROM Journal_Issues WHERE Journal_Code ='" + jcode + "' AND Subs_Year='" + yr + "' AND IssueDate ='" + coldate + "'");
if (Sqlqry == "1")
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Tag = Sqlqry;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = coldate;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].CellType = chkcell2;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Value = 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].BackColor = Color.Green;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].HorizontalAlign = HorizontalAlign.Center;
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Tag = Sqlqry;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = coldate;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].CellType = chkcell2;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].Value = 0;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].BackColor = Color.Red;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, col].HorizontalAlign = HorizontalAlign.Center;
}
dateFromDate = dateFromDate.AddDays(1);
col++;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Locked = true;
}
FpSpread1.Sheets[0].PageSize = 100;
FpSpread1.Sheets[0].CurrentPageIndex = 0;
FpSpread1.SaveChanges();
//FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Width = 1000;
FpSpread1.Height = 400;
FpSpread1.Visible = true;
btn_Save.Visible = true;
lbl_total_journal.Visible = true;
lbl_total_journal.Text = "No. Of Journals:" + nojoural;
}
}
catch (Exception ex) { d2.sendErrorMail(ex, userCollegeCode, "News_Paper_Entry"); }
}
protected void loadfsstaff()
{
string sql = "";
if (ddldepratstaff.SelectedIndex != 0)
{
if (txt_search.Text != "")
{
if (ddlstaff.SelectedIndex == 0)
{
sql = "SELECT distinct staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0)and (staffmaster.settled = 0) and (staff_name like '" + txt_search.Text + "%') and (hrdept_master.dept_code = '" + ddldepratstaff.SelectedValue + "') and (staffmaster.college_code =hrdept_master.college_code) and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
else if (ddlstaff.SelectedIndex == 1)
{
sql = "SELECT distinct staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0) and (staffmaster.settled = 0) and (staffmaster.staff_code like '" + txt_search.Text + "%') and (hrdept_master.dept_code = '" + ddldepratstaff.SelectedValue + "') and (staffmaster.college_code =hrdept_master.college_code) and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
}
else
{
//sql = "SELECT staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0) and (staffmaster.settled = 0) and (hrdept_master.dept_name = '" + ddldepratstaff.Text + "') AND (staffmaster.college_code = '" + ddlcollege.SelectedValue + "' and (staffmaster.college_code =hrdept_master.college_code)";
sql = "SELECT staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0) and (staffmaster.settled = 0) and (hrdept_master.dept_code = '" + ddldepratstaff.SelectedValue + "') AND (staffmaster.college_code = '" + ddlcollege.SelectedValue + "') and (staffmaster.college_code =hrdept_master.college_code)";
}
}
else if (txt_search.Text != "")
{
if (ddlstaff.SelectedIndex == 0)
{
sql = "SELECT distinct staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0) and (staffmaster.settled = 0) and (staffmaster.staff_name like '" + txt_search.Text + "%') and (staffmaster.college_code =hrdept_master.college_code) and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
else if (ddlstaff.SelectedIndex == 1)
{
sql = "SELECT distinct staffmaster.staff_code, staffmaster.staff_name FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code WHERE (stafftrans.latestrec <> 0) AND (staffmaster.resign = 0) and (staffmaster.settled = 0) and (staffmaster.staff_code like '" + txt_search.Text + "%') and (staffmaster.college_code =hrdept_master.college_code) and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
else if (ddlcollege.SelectedIndex != -1)
{
sql = "select distinct staffmaster.staff_code, staff_name from stafftrans,staffmaster where stafftrans.staff_code=staffmaster.staff_code and latestrec<>0 and resign=0 and settled=0 and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
else
{
sql = "select distinct staffmaster.staff_code, staff_name from stafftrans,staffmaster,hrdept_master.dept_name where stafftrans.staff_code=staffmaster.staff_code and latestrec<>0 and resign=0 and staffmaster.college_code='" + ddlcollege.SelectedValue + "'";//Modifed By Srinath 9/5/2013
}
}
else
if (ddldepratstaff.SelectedValue.ToString() == "All")
{
sql = "select distinct staffmaster.staff_code, staff_name from stafftrans,staffmaster where stafftrans.staff_code=staffmaster.staff_code and latestrec<>0 and resign=0 and settled=0 and staffmaster.college_code='" + ddlcollege.SelectedValue + "'"; //Modifed By Srinath 9/5/2013
}
fsstaff.Sheets[0].RowCount = 0;
fsstaff.SaveChanges();
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
//fsstaff.Sheets[0].RowCount = fsstaff.Sheets[0].RowCount + 1;
//fsstaff.Sheets[0].SpanModel.Add(fsstaff.Sheets[0].RowCount - 1, 0, 1, 3);
fsstaff.Sheets[0].AutoPostBack = false;
// string bindspread = sql;
DataSet dsbindspread = new DataSet();
dsbindspread = da.select_method_wo_parameter(sql, "Text");
//con.Close();
// con.Open();
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
fsstaff.Sheets[0].RowCount = 0;
if (dsbindspread.Tables[0].Rows.Count > 0)
{
int sno = 0;
for (int rolcount = 0; rolcount < dsbindspread.Tables[0].Rows.Count; rolcount++)
{
sno++;
string name = dsbindspread.Tables[0].Rows[rolcount]["staff_name"].ToString();
string code = dsbindspread.Tables[0].Rows[rolcount]["staff_code"].ToString();
// fsstaff.Sheets[0].ColumnHeader.Columns[0].Label = "S.No";
fsstaff.Sheets[0].ColumnHeader.Columns[0].Label = "Select";
fsstaff.Sheets[0].ColumnHeader.Columns[2].Label = "Staff Name";
fsstaff.Sheets[0].ColumnHeader.Columns[1].Label = "Staff Code";
fsstaff.Sheets[0].Columns[1].CellType = txt;
fsstaff.SheetCorner.Cells[0, 0].Text = "S.No";
fsstaff.SheetCorner.Cells[0, 0].Font.Bold = true;
fsstaff.Sheets[0].Columns[1].Locked = true;//Added By Srinath 16/8/2013
fsstaff.Sheets[0].Columns[2].Locked = true;
fsstaff.Sheets[0].Columns[2].Width = 200;
fsstaff.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
fsstaff.Sheets[0].ColumnCount = 3;
fsstaff.Sheets[0].Columns[2].Width = 250;
fsstaff.Sheets[0].Columns[1].Width = 120;
fsstaff.Width = 515;
//fsstaff.Width = 398;
fsstaff.Sheets[0].RowCount = fsstaff.Sheets[0].RowCount + 1;
fsstaff.Sheets[0].Rows[fsstaff.Sheets[0].RowCount - 1].Font.Bold = false;
//fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
//fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].Text = name;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].CellType = txt;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].Text = dsbindspread.Tables[0].Rows[rolcount]["staff_code"].ToString();
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].CellType = chkcell1;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
fsstaff.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Left;
chkcell1.AutoPostBack = true;
}
int rowcount = fsstaff.Sheets[0].RowCount;
fsstaff.Height = 278;
fsstaff.Sheets[0].PageSize = 25 + (rowcount * 20);
fsstaff.SaveChanges();
// con.Close();
}
}
protected void btn_go_OnClick(object sender, EventArgs e)
{
try
{
btn_save.Visible = false;
Fpspread3.Visible = false;
DataSet dsSubDetails = new DataSet();
string month = Convert.ToString(ddl_mm.SelectedItem.Value).Trim();
string year = Convert.ToString(ddl_yy.SelectedItem.Text).Trim();
string yr_val = Convert.ToString(ddl_yy.SelectedItem.Value).Trim();
lblErr.Visible = false;
//if (txt_searchbyreg.Text == "" || txt_searchbyroll.Text == "")
//{
// lblErr.Text = "Please Enter Roll No or Reg. No";
// lblErr.Visible = true;
// return;
//}
if (month.Trim() == "0" || yr_val.Trim() == "0")
{
lblErr.Text = "Please Select Month and Year";
lblErr.Visible = true;
return;
}
if (ddl_searchby.SelectedItem.Text.Trim() == "Reg No")
{
if (txt_searchbyreg.Text.Trim() == "")
{
lblErr.Text = "Please Enter Reg. No";
lblErr.Visible = true;
return;
}
search = txt_searchbyreg.Text.Trim();
filterby = "Reg_No='" + search + "'";
}
else if (ddl_searchby.SelectedItem.Text.Trim() == "Roll No")
{
if (txt_searchbyroll.Text.Trim() == "")
{
lblErr.Text = "Please Enter Roll No";
lblErr.Visible = true;
return;
}
search = txt_searchbyroll.Text.Trim();
filterby = "Roll_No='" + search + "'";
}
string query = string.Empty;
if (!string.IsNullOrEmpty(filterby))
{
query = "select Stud_Name,Roll_No,Reg_No,Batch_Year,degree_code,Current_Semester from Registration where " + filterby;
ds = d2.select_method_wo_parameter(query, "Text");
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
batch_year = Convert.ToString(ds.Tables[0].Rows[0]["Batch_Year"]).Trim();
degree_code = Convert.ToString(ds.Tables[0].Rows[0]["degree_code"]).Trim();
roll_no = Convert.ToString(ds.Tables[0].Rows[0]["Roll_No"]).Trim();
if (degree_code != "" && batch_year != "" && month != "0" && yr_val != "0")
{
exam_code = d2.GetFunctionv("select exam_code from Exam_Details where batch_year='" + batch_year + "' and degree_code='" + degree_code + "' and Exam_year='" + year + "' and Exam_Month='" + month + "'");
}
if (rdb_tot.Checked == true)
{
if (exam_code.Trim() != "" && exam_code.Trim() != "0" && roll_no.Trim() != "")
{
query = "select isnull(s.subjectpriority,'0') as subjectpriority,subject_code,subject_name,s.subject_no,me.exam_code,ed.Exam_year,ed.Exam_Month from mark_entry me,subject s,Exam_Details ed where ed.exam_code=me.exam_code and s.subject_no=me.subject_no and external_mark>='0' and me.exam_code='" + exam_code + "' and roll_no='" + roll_no + "' order by subjectpriority,s.subject_no";
dsSubDetails = d2.select_method_wo_parameter(query, "Text");
}
}
else if (rdb_take.Checked == true)
{
if (!string.IsNullOrEmpty(roll_no.Trim()))
{
query = "select distinct isnull(s.subjectpriority,'0') as subjectpriority,subject_code,subject_name,s.subject_no,internal_mark,result,ed.Exam_year,ed.Exam_Month,me.exam_code from mark_entry me,subject s,Exam_Details ed where ed.exam_code=me.exam_code and s.subject_no=me.subject_no and isnull(internal_mark,'0')>='-1' and (isnull(internal_mark,'0')<isnull(s.min_int_marks,'0') or isnull(me.total,'0')<isnull(s.mintotal,'0')) and result<>'Pass' and roll_no='" + roll_no + "' and me.subject_no not in (select subject_no from mark_entry where roll_no='" + roll_no + "' and result ='Pass') order by subjectpriority,s.subject_no";
dsSubDetails = d2.select_method_wo_parameter(query, "Text");
}
}
if (dsSubDetails.Tables.Count > 0 && dsSubDetails.Tables[0].Rows.Count > 0)
{
DataTable dtDistinctSubject = new DataTable();
dtDistinctSubject = dsSubDetails.Tables[0].DefaultView.ToTable(true, "subject_code", "subject_name", "subject_no");
Fpspread3.Visible = true;
Fpspread3.Sheets[0].AutoPostBack = false;
Fpspread3.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
Fpspread3.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
Fpspread3.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
Fpspread3.ActiveSheetView.RowHeader.DefaultStyle.Font.Name = "Book Antiqua";
Fpspread3.ActiveSheetView.RowHeader.DefaultStyle.Font.Size = FontUnit.Medium;
Fpspread3.ActiveSheetView.RowHeader.DefaultStyle.Font.Bold = true;
Fpspread3.ActiveSheetView.DefaultStyle.Font.Name = "Book Antiqua";
Fpspread3.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].RowHeader.Visible = false;
Fpspread3.Sheets[0].ColumnHeader.RowCount = 0;
Fpspread3.Sheets[0].ColumnCount = 0;
Fpspread3.Sheets[0].RowCount = 0;
Fpspread3.Sheets[0].RowHeader.Visible = false;
//Fpspread1.Sheets[0].AutoPostBack = true;
Fpspread3.CommandBar.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.Black;
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.Font.Bold = true;
darkstyle.Border.BorderSize = 0;
darkstyle.HorizontalAlign = HorizontalAlign.Center;
darkstyle.VerticalAlign = VerticalAlign.Middle;
darkstyle.Border.BorderColor = System.Drawing.Color.Transparent;
Fpspread3.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FarPoint.Web.Spread.CheckBoxCellType chktypeall = new FarPoint.Web.Spread.CheckBoxCellType();
chktypeall.AutoPostBack = true;
FarPoint.Web.Spread.CheckBoxCellType chktype = new FarPoint.Web.Spread.CheckBoxCellType();
Fpspread3.Sheets[0].RowCount = 0;
Fpspread3.Sheets[0].ColumnCount = 4;
Fpspread3.Sheets[0].ColumnHeader.RowCount = 1;
Fpspread3.Sheets[0].ColumnHeader.Columns[0].Width = 50;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
Fpspread3.Columns[0].Width = 75;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Subject Code";
Fpspread3.Columns[1].Width = 200;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Subject Name";
Fpspread3.Columns[2].Width = 300;
Fpspread3.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
Fpspread3.Columns[3].Width = 50;
btn_save.Visible = true;
Fpspread3.Sheets[0].RowCount = dtDistinctSubject.Rows.Count + 1;
Fpspread3.Sheets[0].Cells[0, 3].CellType = chktypeall;
Fpspread3.Sheets[0].Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[0, 3].VerticalAlign = VerticalAlign.Middle;
Fpspread3.SaveChanges();
for (int r = 0; r < dtDistinctSubject.Rows.Count; r++)
{
//subject_code,subject_name,s.subject_no
Fpspread3.Sheets[0].Cells[r + 1, 0].Text = Convert.ToString(r + 1);
Fpspread3.Sheets[0].Cells[r + 1, 0].Font.Bold = true;
Fpspread3.Sheets[0].Cells[r + 1, 0].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[r + 1, 0].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[r + 1, 0].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[r + 1, 0].VerticalAlign = VerticalAlign.Middle;
string examCode = string.Empty;
DataView dvExamCode = new DataView();
dsSubDetails.Tables[0].DefaultView.RowFilter = "subject_no='" + Convert.ToString(dtDistinctSubject.Rows[r]["subject_no"]).Trim() + "'";
dvExamCode = dsSubDetails.Tables[0].DefaultView;
dvExamCode.Sort = "exam_year desc,exam_month desc";
if (dvExamCode.Count > 0)
{
examCode = Convert.ToString(dvExamCode[0]["exam_code"]).Trim();
}
Fpspread3.Sheets[0].Cells[r + 1, 1].Text = Convert.ToString(dtDistinctSubject.Rows[r]["subject_code"]).Trim();
Fpspread3.Sheets[0].Cells[r + 1, 1].Tag = Convert.ToString(dtDistinctSubject.Rows[r]["subject_no"]).Trim();
Fpspread3.Sheets[0].Cells[r + 1, 1].Font.Bold = true;
Fpspread3.Sheets[0].Cells[r + 1, 1].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[r + 1, 1].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[r + 1, 1].HorizontalAlign = HorizontalAlign.Left;
Fpspread3.Sheets[0].Cells[r + 1, 1].VerticalAlign = VerticalAlign.Middle;
Fpspread3.Sheets[0].Cells[r + 1, 2].Text = Convert.ToString(dtDistinctSubject.Rows[r]["subject_name"]).Trim();
Fpspread3.Sheets[0].Cells[r + 1, 2].Tag = examCode;
Fpspread3.Sheets[0].Cells[r + 1, 2].Font.Bold = true;
Fpspread3.Sheets[0].Cells[r + 1, 2].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[r + 1, 2].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[r + 1, 2].HorizontalAlign = HorizontalAlign.Left;
Fpspread3.Sheets[0].Cells[r + 1, 2].VerticalAlign = VerticalAlign.Middle;
Fpspread3.Sheets[0].Cells[r + 1, 3].CellType = chktype;
Fpspread3.Sheets[0].Cells[r + 1, 3].Font.Bold = true;
Fpspread3.Sheets[0].Cells[r + 1, 3].Font.Name = "Book Antiqua";
Fpspread3.Sheets[0].Cells[r + 1, 3].Font.Size = FontUnit.Medium;
Fpspread3.Sheets[0].Cells[r + 1, 3].HorizontalAlign = HorizontalAlign.Center;
Fpspread3.Sheets[0].Cells[r + 1, 3].VerticalAlign = VerticalAlign.Middle;
}
Fpspread3.Sheets[0].PageSize = Fpspread3.Sheets[0].RowCount;
Fpspread3.SaveChanges();
}
else
{
Fpspread3.Visible = false;
btn_save.Visible = false;
lblErr.Text = "No Records Found";
lblErr.Visible = true;
return;
}
}
else
{
Fpspread3.Visible = false;
btn_save.Visible = false;
lblErr.Text = "No Student Records Were Found";
lblErr.Visible = true;
return;
}
}
catch (Exception ex)
{
}
}
public void loadspread(DataSet ds)
{
try
{
DataView dv = new DataView();
spreadDet1.Sheets[0].RowCount = 0;
spreadDet1.Sheets[0].ColumnCount = 6;
spreadDet1.CommandBar.Visible = false;
spreadDet1.Sheets[0].AutoPostBack = false;
spreadDet1.Sheets[0].ColumnHeader.RowCount = 1;
spreadDet1.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
spreadDet1.Sheets[0].Columns[0].Locked = true;
spreadDet1.Columns[0].Width = 80;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Store Name";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].Columns[1].Locked = true;
spreadDet1.Columns[1].Width = 150;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Item Header Name";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].Columns[2].Locked = true;
spreadDet1.Columns[2].Width = 200;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Item SubHeader Name";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].Columns[3].Locked = true;
spreadDet1.Columns[3].Width = 200;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Item Name";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Columns[4].Width = 200;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Select";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
spreadDet1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium;
spreadDet1.Columns[5].Width = 50;
FarPoint.Web.Spread.TextCellType txtCell = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = false;
int sno = 0;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
spreadDet1.Sheets[0].RowCount++;
sno++;
string strname = Convert.ToString(ds.Tables[0].Rows[row]["StoreName"]).Trim();
string headname = Convert.ToString(ds.Tables[0].Rows[row]["ItemHeaderName"]).Trim();
string subheadname = Convert.ToString(ds.Tables[0].Rows[row]["ItemSubHeadername"]).Trim();
string itemname = Convert.ToString(ds.Tables[0].Rows[row]["ItemName"]).Trim();
string itemcode = Convert.ToString(ds.Tables[0].Rows[row]["ItemCode"]).Trim();
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 0].CellType = txtCell;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 1].CellType = txtCell;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 2].CellType = txtCell;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].CellType = txtCell;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].CellType = txtCell;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 5].CellType = chkall;
ds.Tables[1].DefaultView.RowFilter = "ItemCode ='" + Convert.ToString(ds.Tables[0].Rows[row]["ItemCode"]) + "'";
dv = ds.Tables[1].DefaultView;
if (dv.Count > 0)
{
spreadDet1.Sheets[0].Cells[row, 5].Value = 1;
}
else
{
spreadDet1.Sheets[0].Cells[row, 5].Value = 0;
}
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 1].Text = strname;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 2].Text = headname;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].Text = subheadname;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].Tag = itemcode;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].Text = itemname;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].Tag = itemname;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 0].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 1].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 2].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 5].VerticalAlign = VerticalAlign.Middle;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 0].Locked = true;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 1].Locked = true;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 2].Locked = true;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].Locked = true;
spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].Locked = true;
//spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].ForeColor = Color.Blue;
//spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 3].Font.Underline = true;
//spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].ForeColor = Color.Blue;
//spreadDet1.Sheets[0].Cells[spreadDet1.Sheets[0].RowCount - 1, 4].Font.Underline = true;
spreadDet1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
spreadDet1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
spreadDet1.Sheets[0].SetColumnMerge(3, FarPoint.Web.Spread.Model.MergePolicy.Always);
}
//spreadDet1.Sheets[0].Columns[0].Width = 50;
//spreadDet1.Sheets[0].Columns[1].Width = 160;
//spreadDet1.Sheets[0].Columns[2].Width = 100;
//spreadDet1.Sheets[0].Columns[3].Width = 100;
//spreadDet1.Sheets[0].Columns[4].Width = 200;
spreadDet1.Sheets[0].PageSize = spreadDet1.Sheets[0].RowCount;
spreadDet1.SaveChanges();
ShowReport.Visible = true;
spreadDet1.Visible = true;
}
}
catch
{
}
}
protected void Buttongo_Click(object sender, EventArgs e)
{
try
{
lblvalidation1.Text = "";
ss2 = "";
p = "";
FpSpread2.Visible = false; btnreset.Visible = false;
FpSpread2.CommandBar.Visible = false;
FpSpread2.Sheets[0].RowCount = 0;
FpSpread2.Sheets[0].ColumnCount = 5;
FpSpread2.Sheets[0].Columns[0].Width = 40;
FpSpread2.Sheets[0].Columns[1].Width = 113;
FpSpread2.Sheets[0].Columns[2].Width = 342;
FpSpread2.Sheets[0].Columns[3].Width = 83;
FpSpread2.Sheets[0].Columns[4].Width = 90;
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].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Reg.No.";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Student Name";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Total Papers Selected";
FpSpread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Total Papers Appeared";
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].Columns[0].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[2].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[3].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[4].VerticalAlign = VerticalAlign.Middle;
FpSpread2.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left;
FpSpread2.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread2.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
loadheader();
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread2.Sheets[0].RowCount = 0;
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
chkcell1.AutoPostBack = true;
chkcell.AutoPostBack = true;
FpSpread2.Sheets[0].AutoPostBack = true;
DataSet printds = new DataSet();
string batchyear = ddlbatch.SelectedValue.ToString();
string degreecode = ddlbranch.SelectedValue.ToString();
string year = ddlbatch.SelectedValue.ToString();
string degree = ddldegree.SelectedItem.ToString();
string course = ddldegree.SelectedItem.ToString();
string depart_code = ddlbranch.SelectedValue.ToString();
string batchyearatt = ddlbatch.SelectedValue.ToString();
string studinfo = "";
studinfo = "select Stud_Name,Roll_No,Reg_No,APP_No from Registration where Batch_Year='" + ddlbatch.SelectedItem.Text.ToString() + "' and degree_code='" + depart_code + "' and DelFlag=0 and Exam_Flag<>'DEBAR' order by Reg_No ; select m.roll_no,ed.Exam_year,ed.Exam_Month,m.subject_no,m.internal_mark,m.external_mark,m.total,m.result from mark_entry m,Exam_Details ed where ed.exam_code=m.exam_code and ed.batch_year='" + ddlbatch.SelectedItem.Text.ToString() + "' and ed.degree_code='" + depart_code + "' order by m.roll_no,m.subject_no,ed.Exam_year,ed.Exam_Month";
studinfo = studinfo + " select r.Roll_No,Count(distinct sc.subject_no) subcount from Registration r,subjectChooser sc where r.Roll_No=sc.roll_no and r.Batch_Year='" + ddlbatch.SelectedItem.Text.ToString() + "' and r.degree_code='" + depart_code + "' and DelFlag=0 and Exam_Flag<>'DEBAR' group by r.Roll_No";
studinfo = studinfo + " select r.Roll_No,Count(distinct m.subject_no) subcount from Registration r,mark_entry m,subjectChooser sc where r.Roll_No=m.roll_no and r.Roll_No=sc.roll_no and sc.subject_no=m.subject_no and sc.roll_no=m.roll_no and r.Batch_Year='" + ddlbatch.SelectedItem.Text.ToString() + "' and r.degree_code='" + depart_code + "' and DelFlag=0 and Exam_Flag<>'DEBAR' group by r.Roll_No";
dsstudinfo = da.select_method_wo_parameter(studinfo, "Text");
dv = new DataView();
if (dsstudinfo.Tables[0].Rows.Count > 0)
{
btnsave.Visible = false;
FpSpread2.Visible = true;
btnPrint.Visible = true;
int sno = 0;
for (int studcount = 0; studcount < dsstudinfo.Tables[0].Rows.Count; studcount++)
{
sno++;
string roll_no = dsstudinfo.Tables[0].Rows[studcount]["Roll_No"].ToString();
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 0].Text = sno + "";
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].CellType = txt;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Text = dsstudinfo.Tables[0].Rows[studcount]["Reg_No"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 1].Note = dsstudinfo.Tables[0].Rows[studcount]["Roll_No"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Text = dsstudinfo.Tables[0].Rows[studcount]["Stud_Name"].ToString();
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 2].Tag = dsstudinfo.Tables[0].Rows[studcount]["APP_No"].ToString();
int noofsubject = 0;
dsstudinfo.Tables[2].DefaultView.RowFilter = "roll_no='" + roll_no + "'";
dv = dsstudinfo.Tables[2].DefaultView;
if (dv.Count > 0)
{
noofsubject = Convert.ToInt32(dv[0]["subcount"].ToString());
}
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 3].Text = noofsubject.ToString();
noofsubject = 0;
dsstudinfo.Tables[3].DefaultView.RowFilter = "roll_no='" + roll_no + "'";
dv = dsstudinfo.Tables[3].DefaultView;
if (dv.Count > 0)
{
noofsubject = Convert.ToInt32(dv[0]["subcount"].ToString());
}
FpSpread2.Sheets[0].Cells[FpSpread2.Sheets[0].RowCount - 1, 4].Text = noofsubject.ToString();
int startrow = FpSpread2.Sheets[0].RowCount;
for (int i = 5; i < FpSpread2.Sheets[0].Columns.Count; i++)
{
string strm_y = "";
int noofrow = startrow;
string subject_no = FpSpread2.Sheets[0].ColumnHeader.Cells[0, i].Tag.ToString();
dsstudinfo.Tables[1].DefaultView.RowFilter = "roll_no='" + roll_no + "' and subject_no='" + subject_no + "'";
dv = dsstudinfo.Tables[1].DefaultView;
for (int k = 0; k < dv.Count; k++)
{
int e_month = Convert.ToInt32(dv[k]["Exam_Month"].ToString());
string e_year = dv[k]["Exam_year"].ToString();
string strMonthName = CultureInfo.CurrentCulture.DateTimeFormat.AbbreviatedMonthGenitiveNames[e_month - 1];
strMonthName = e_year + "-" + strMonthName;
string strintmark = dv[k]["internal_mark"].ToString();
if (strintmark.Trim() == "-1")
{
strintmark = "AB";
}
else if (strintmark.Trim() == "-2")
{
strintmark = "NE";
}
else if (strintmark.Trim() == "-3")
{
strintmark = "NR";
}
string strextmark = dv[k]["external_mark"].ToString();
if (strextmark.Trim() == "-1")
{
strextmark = "AB";
}
else if (strextmark.Trim() == "-2")
{
strextmark = "NE";
}
else if (strextmark.Trim() == "-3")
{
strextmark = "NR";
}
if (strm_y.Trim() == "")
{
strm_y = strMonthName + "-" + strintmark + "," + strextmark;
}
else
{
strm_y = strm_y + " " + strMonthName + "-" + strintmark + "," + strextmark;
noofrow++;
if (FpSpread2.Sheets[0].RowCount < noofrow)
{
FpSpread2.Sheets[0].RowCount++;
FpSpread2.Sheets[0].Rows[FpSpread2.Sheets[0].RowCount - 2].Border.BorderColorBottom = Color.White;
}
}
FpSpread2.Sheets[0].Cells[noofrow - 1, i].Text = strMonthName + "-" + strintmark + "," + strextmark;
}
}
}
dsstudinfo.Clear();
dsstudinfo.Dispose();
rptprint.Visible = true;
}
else
{
clear();
lblerror.Text = "No Records Found";
lblerror.Visible = true;
}
string totalrows = FpSpread2.Sheets[0].RowCount.ToString();
FpSpread2.Sheets[0].PageSize = (Convert.ToInt32(totalrows) * 20) + 40;
FpSpread2.Height = (Convert.ToInt32(totalrows) * 50) + 40;
FpSpread2.Sheets[0].Columns[0].Width = 40;
FpSpread2.Sheets[0].Columns[1].Width = 113;
FpSpread2.Sheets[0].Columns[2].Width = 342;
FpSpread2.Sheets[0].Columns[3].Width = 83;
FpSpread2.Sheets[0].Columns[4].Width = 90;
FpSpread2.Sheets[0].PageSize = FpSpread2.Sheets[0].RowCount;
FpSpread2.SaveChanges();
FpSpread2.Visible = true;
}
catch (Exception ex)
{
lblerror.Text = ex.ToString();
lblerror.Visible = true;
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
q1 = " 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 from applyn a,Registration r, degree d,Department dt,Course C 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' ";
string type = flitertype();
string degreecode = rs.GetSelectedItemsValueAsString(cbl_branch);
string deptcode = rs.GetSelectedItemsValueAsString(cbl_degree);
string Batchyear = rs.GetSelectedItemsValueAsString(cbl_batch);
string sem = Convert.ToString(ddl_feecatagory.SelectedItem.Text).Split(' ')[0];
if (Convert.ToString(ViewState["linkName"]).ToUpper() == "TERM")
{
sem = "1";//Convert.ToString(ddl_feecatagory.SelectedItem.Text).Split(' ')[1] + " ";
}
string CertificateId = rs.GetSelectedItemsValueAsString(cbl_certificate);
if (!string.IsNullOrEmpty(degreecode) && !string.IsNullOrEmpty(deptcode) && !string.IsNullOrEmpty(Batchyear) && !string.IsNullOrEmpty(CertificateId))
{
if (txt_searchappno.Text.Trim() != "")
{
q1 += " and " + type + "='" + txt_searchappno.Text.Trim() + "'";
}
else
{
q1 += " and r.degree_code in('" + degreecode + "')and r.Batch_Year in('" + Batchyear + "') and c.Course_Id in('" + deptcode + "') and r.Current_Semester in('" + sem + "') and r.college_code='" + Convert.ToString(ddlcollege.SelectedItem.Value) + "' ";
}
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
rs.Fpreadheaderbindmethod("S.No-50/Select-50/Student Name-210/Roll No-150/Reg No-150/Admission No-150/Gender-100/Section-70/" + lbl_degree.Text + "-100/" + lbl_branch.Text + "-300/" + lbl_semT.Text + "-100", FpSpread1, "FALSE");
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cb.AutoPostBack = false;
cball.AutoPostBack = true;
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = cball;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread1.Sheets[0].Rows.Count++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count - 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = cb;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[3].Visible = false;
FpSpread1.Sheets[0].Columns[4].Visible = false;
FpSpread1.Sheets[0].Columns[5].Visible = false;
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[4].Visible = true;
}
if (Convert.ToString(Session["Admissionflag"]) == "1")
{
FpSpread1.Sheets[0].Columns[5].Visible = true;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["stud_name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["roll_no"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Reg_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["Roll_Admit"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sex"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["sections"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Course_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Text = Convert.ToString(dr["Dept_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Text = Convert.ToString(dr["Current_Semester"]);
#region Fpspread Alignment and style
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 10].Font.Name = "Book Antiqua";
#endregion
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
btn_request.Visible = true;
}
else
{
btn_request.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
btn_request.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All Fields";
}
}
catch (Exception ex)
{
lbl_error.Visible = true;
lbl_error.Text = ex.ToString();
FpSpread1.Visible = false;
btn_request.Visible = false;
}
}
public void Prioriry()
{
try
{
CreateGroup.Visible = false;
CreatePriority.Visible = true;
CreateMapping.Visible = false;
string Query = "select GroupName,ITGroupPK,Priority from IT_GroupMaster where parentCode=0 and collegeCode ='" + ddlcolload.SelectedValue + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(Query, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
FpSpread1.Visible = true;
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 = 4;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread1.Columns[0].Locked = true;
FpSpread1.Columns[0].Width = 50;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Group Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
FpSpread1.Columns[1].Width = 200;
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Set Priority";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
FpSpread1.Columns[2].Width = 75;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Priority";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
FpSpread1.Columns[3].Locked = true;
FpSpread1.Columns[3].Width = 75;
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(i + 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(ds.Tables[0].Rows[i]["GroupName"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[i]["ITGroupPK"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = chkall;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Value = 0;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
string Prioriry = Convert.ToString(ds.Tables[0].Rows[i]["Priority"]);
if (Prioriry.Trim() != "" && Prioriry.Trim() != "0")
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Prioriry.ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Value = 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
}
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.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
}
FpSpread1.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
FpSpread1.Height = 400;
FpSpread1.Width = 600;
lblalert.Visible = false;
}
else
{
FpSpread1.Visible = false;
imgdiv2.Visible = true;
lbl_alerterr.Text = "Not Updated";
}
}
catch
{
}
}
protected void loadSpread(DataSet ds)
{
try
{
#region design
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 5;
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].ForeColor = ColorTranslator.FromHtml("#000000");
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Degree";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].ForeColor = ColorTranslator.FromHtml("#000000");
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].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Department";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].ForeColor = ColorTranslator.FromHtml("#000000");
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].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Columns[2].Width = 350;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Set Priority";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].ForeColor = ColorTranslator.FromHtml("#000000");
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].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Priority";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].ForeColor = ColorTranslator.FromHtml("#000000");
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].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.CheckBoxCellType cb = new FarPoint.Web.Spread.CheckBoxCellType();
cb.AutoPostBack = true;
#endregion
#region value
for (int row = 0; row < ds.Tables[0].Rows.Count; 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].Tag = Convert.ToString(ds.Tables[0].Rows[row]["college_code"]);
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(ds.Tables[0].Rows[row]["Course_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["Course_id"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["dept_name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(ds.Tables[0].Rows[row]["Degree_Code"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = cb;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
double deptPr = 0;
double.TryParse(Convert.ToString(ds.Tables[0].Rows[row]["Dept_Priority"]), out deptPr);
if (deptPr != 0)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Value = 1;
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = false;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(deptPr);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
}
FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Visible = true;
print.Visible = true;
divpriority.Visible = true;
FpSpread1.ShowHeaderSelection = false;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
lblvalidation1.Text = "";
txtexcelname.Text = "";
#endregion
}
catch { }
}
protected void loadfsstaff()
{
try
{
string sql = "select sm.staff_name,st.staff_code from staffmaster sm,stafftrans st,hrdept_master h where sm.staff_code=st.staff_code and st.dept_code=h.dept_code and sm.college_code=h.college_code and sm.college_code='" + ddlcollege.SelectedValue + "'";
if (ddldepratstaff.SelectedItem.ToString() != "All")
{
sql = sql + " and st.dept_code='" + ddldepratstaff.SelectedValue.ToString() + "'";
}
if (txt_search.Text != "")
{
if (ddlstaff.SelectedIndex == 0)
{
sql = sql + " and sm.staff_name like '" + txt_search.Text.ToString() + "%'";
}
else
{
sql = sql + " and sm.staff_code like '" + txt_search.Text.ToString() + "%'";
}
}
DataSet dsbindspread = d2.select_method_wo_parameter(sql, "Text");
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
fsstaff.Sheets[0].RowCount = 0;
fsstaff.CommandBar.Visible = false;
fsstaff.SheetCorner.ColumnCount = 0;
if (dsbindspread.Tables[0].Rows.Count > 0)
{
int sno = 0;
fsstaff.Sheets[0].ColumnHeader.Columns[0].Label = "S.No";
fsstaff.Sheets[0].ColumnHeader.Columns[2].Label = "Staff Name";
fsstaff.Sheets[0].ColumnHeader.Columns[1].Label = "Staff Code";
fsstaff.Sheets[0].ColumnHeader.Columns[3].Label = "Select";
fsstaff.Sheets[0].Columns[0].Width = 50;
fsstaff.Sheets[0].Columns[1].Width = 210;
fsstaff.Sheets[0].Columns[2].Width = 350;
fsstaff.Sheets[0].Columns[3].Width = 64;
fsstaff.Sheets[0].ColumnCount = 4;
fsstaff.Width = 690;
fsstaff.Visible = true;
FarPoint.Web.Spread.TextCellType btva = new FarPoint.Web.Spread.TextCellType();
for (int rolcount = 0; rolcount < dsbindspread.Tables[0].Rows.Count; rolcount++)
{
sno++;
string name = dsbindspread.Tables[0].Rows[rolcount]["staff_name"].ToString();
string code = dsbindspread.Tables[0].Rows[rolcount]["staff_code"].ToString();
fsstaff.Sheets[0].RowCount = fsstaff.Sheets[0].RowCount + 1;
fsstaff.Sheets[0].Rows[fsstaff.Sheets[0].RowCount - 1].Font.Bold = false;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].Text = name;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].Locked = true;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].CellType = btva;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].CellType = btva;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].Text = code;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].Locked = true;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 3].CellType = chkcell1;
fsstaff.Sheets[0].Cells[fsstaff.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
fsstaff.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Left;
chkcell1.AutoPostBack = true;
}
}
else
{
fsstaff.Visible = false;
errstaff.Visible = true;
errstaff.Text = "No Records Found";
}
fsstaff.Sheets[0].AutoPostBack = false;
fsstaff.Sheets[0].PageSize = fsstaff.Sheets[0].RowCount;
fsstaff.SaveChanges();
}
catch (Exception ex)
{
errstaff.Visible = true;
errstaff.Text = ex.ToString();
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
FpSpread.Visible = false;
rprint.Visible = false;
lblMainErr.Visible = false;
fldTime.Visible = false;
string selectquery = string.Empty;
string scode = txt_scode.Text;
string sname = txt_sname.Text;
string deptCode = GetSelectedItemsValueAsString(cbl_dept);
string desigCode = GetSelectedItemsValueAsString(cbl_desig);
string CatCode = GetSelectedItemsValueAsString(cbl_staffc);
string StfType = GetSelectedItemsText(cbl_stype);
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = true;
chkcell.AutoPostBack = false;
if (txtFrmDt.Enabled == false || txtToDt.Enabled == false)
{
lblMainErr.Visible = true;
lblMainErr.Text = "Please Select Valid HR Month!";
return;
}
if (GetMonFrstDate(txtFrmDt.Text) > GetMonFrstDate(txtToDt.Text))
{
lblMainErr.Visible = true;
lblMainErr.Text = "From Date Should be less than To Date!";
return;
}
if (txt_scode.Text != "")
{
selectquery = "select sm.staff_code,sm.staff_name,h.dept_acronym,desig.desig_acronym,desig.desig_name,st.stftype,sc.category_name,sc.category_code from staffmaster sm,staff_appl_master sa,hrdept_master h,desig_master desig,staffcategorizer sc,stafftrans st where sa.appl_no=sm.appl_no and sm.staff_code=st.staff_code and st.dept_code=h.dept_code and st.desig_code=desig.desig_code and st.category_code=sc.category_code and sm.college_code=h.college_code and sm.college_code=desig.collegeCode and sm.college_code=sc.college_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code = '" + clgcode + "' and st.staff_code='" + scode + "'";
}
else if (txt_sname.Text != "")
{
selectquery = "select sm.staff_code,sm.staff_name,h.dept_acronym,desig.desig_acronym,desig.desig_name,st.stftype,sc.category_name,sc.category_code from staffmaster sm,staff_appl_master sa,hrdept_master h,desig_master desig,staffcategorizer sc,stafftrans st where sa.appl_no=sm.appl_no and sm.staff_code=st.staff_code and st.dept_code=h.dept_code and st.desig_code=desig.desig_code and st.category_code=sc.category_code and sm.college_code=h.college_code and sm.college_code=desig.collegeCode and sm.college_code=sc.college_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code = '" + clgcode + "' and sm.staff_name='" + sname + "'";
}
else
{
selectquery = "select sm.staff_code,sm.staff_name,h.dept_acronym,desig.desig_acronym,desig.desig_name,st.stftype,sc.category_name,sc.category_code from staffmaster sm,staff_appl_master sa,hrdept_master h,desig_master desig,staffcategorizer sc,stafftrans st where sa.appl_no=sm.appl_no and sm.staff_code=st.staff_code and st.dept_code=h.dept_code and st.desig_code=desig.desig_code and st.category_code=sc.category_code and sm.college_code=h.college_code and sm.college_code=desig.collegeCode and sm.college_code=sc.college_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code = '" + clgcode + "' and h.dept_code in('" + deptCode + "') and desig.desig_code in('" + desigCode + "') and sc.category_code in('" + CatCode + "') and st.stftype in('" + StfType + "')";
}
ds.Clear();
ds = d2.select_method_wo_parameter(selectquery, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
LoadHeader();
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].CellType = chkall;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Value = 0;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
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";
for (int sk = 0; sk < ds.Tables[0].Rows.Count; sk++)
{
FpSpread.Sheets[0].RowCount++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sk + 1);
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].CellType = chkcell;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Value = 0;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[sk]["staff_code"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
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].Text = Convert.ToString(ds.Tables[0].Rows[sk]["staff_name"]);
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].Text = Convert.ToString(ds.Tables[0].Rows[sk]["dept_acronym"]) + " - " + Convert.ToString(ds.Tables[0].Rows[sk]["desig_name"]) + " - " + Convert.ToString(ds.Tables[0].Rows[sk]["category_name"]);
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].Text = "";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center;
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].PageSize = FpSpread.Sheets[0].RowCount;
FpSpread.Sheets[0].FrozenRowCount = 1;
FpSpread.Visible = true;
rprint.Visible = true;
fldTime.Visible = true;
}
else
{
lblMainErr.Visible = true;
lblMainErr.Text = "No Record(s) Found!";
}
}
catch { }
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
hide();
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = true;
FpSpread1.Height = 1000;
FpSpread1.Width = 600;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 8;
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.Visible = true;
FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType();
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
chkall.AutoPostBack = false;
string selqry = "select category,shortname,status,LeaveMasterPK from leave_category where college_Code='" + collegecode1 + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(selqry, "text");
if (ds.Tables[0].Rows.Count > 0)
{
FpSpread1.Sheets[0].Rows.Count = ds.Tables[0].Rows.Count;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].Cells[i, 3].CellType = chk;
FpSpread1.Sheets[0].Cells[i, 4].CellType = chk;
FpSpread1.Sheets[0].Cells[i, 5].CellType = chk;
FpSpread1.Sheets[0].Cells[i, 6].CellType = chk;
FpSpread1.Sheets[0].Cells[i, 3].Locked = true;
FpSpread1.Sheets[0].Cells[i, 4].Locked = true;
FpSpread1.Sheets[0].Cells[i, 5].Locked = true;
FpSpread1.Sheets[0].Cells[i, 6].Locked = true;
FpSpread1.Sheets[0].Cells[i, 0].Text = Convert.ToString(i + 1);
FpSpread1.Sheets[0].Cells[i, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 1].Text = ds.Tables[0].Rows[i]["category"].ToString();
FpSpread1.Sheets[0].Cells[i, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 2].Text = ds.Tables[0].Rows[i]["shortname"].ToString();
FpSpread1.Sheets[0].Cells[i, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 7].Value = ds.Tables[0].Rows[i]["LeaveMasterPK"].ToString();
FpSpread1.Sheets[0].Cells[i, 7].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[i, 5].Font.Name = "Book Antiqua";
string statusss = ds.Tables[0].Rows[i]["status"].ToString();
if (statusss.Trim() == "2")
{
FpSpread1.Sheets[0].Cells[i, 3].Value = 1;
}
if (statusss.Trim() == "0")
{
FpSpread1.Sheets[0].Cells[i, 4].Value = 1;
}
if (statusss.Trim() == "1")
{
FpSpread1.Sheets[0].Cells[i, 5].Value = 1;
}
}
FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 60;
FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 244;
FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 150;
FpSpread1.Sheets[0].ColumnHeader.Columns[3].Width = 102;
FpSpread1.Sheets[0].ColumnHeader.Columns[4].Width = 102;
FpSpread1.Sheets[0].ColumnHeader.Columns[5].Width = 102;
FpSpread1.Sheets[0].ColumnHeader.Columns[6].Width = 102;
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, 1].Text = "Leave Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Short Form";
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, 3].Text = "Earn Leave";
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, 4].Text = "Treated As Present";
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, 5].Text = "Treated As LOP";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Id";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Columns[7].Visible = false;
FpSpread1.Sheets[0].Columns[6].Visible = false;
for (int i = 0; i < FpSpread1.Sheets[0].Columns.Count; i++)
{
FpSpread1.Sheets[0].ColumnHeader.Columns[i].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Columns[i].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread1.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.SaveChanges();
FpSpread1.Sheets[0].PageSize = ds.Tables[0].Rows.Count;
FpSpread1.Visible = true;
addnew.Visible = false;
div1.Visible = true;
rptprint.Visible = true;
lbl_error.Visible = false;
}
else
{
lbl_error.Visible = true;
lbl_error.Text = "No Records Found";
}
}
catch (Exception ex)
{
d2.sendErrorMail(ex, collegecode1, "LeaveMaster_Alter.aspx");
}
}
public void online(string fbfk)
{
try
{
lbl_alrt.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 2;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 3;
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.Visible = true;
FarPoint.Web.Spread.ComboBoxCellType cmb = new FarPoint.Web.Spread.ComboBoxCellType();
cmb.AutoPostBack = false;
FarPoint.Web.Spread.CheckBoxCellType cball = new FarPoint.Web.Spread.CheckBoxCellType();
cball.AutoPostBack = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
//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].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Header";
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Questions";
//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.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1);
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 2, 1);
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 52;
FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 200;
FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 350;
DataView dv = new DataView(); DataView filteroption_dv = new DataView();
ds.Clear();
string selqury = "select Batch_Year,DegreeCode,Section,semester,CollegeCode,Subject_Type,OptionalSubject_type,isnull(Acadamic_Isgeneral,0)Acadamic_Isgeneral,isnull(IsType_Individual,0)IsType_Individual,InclueCommon,isnull(IsSubjectType,0)IsSubjectType from CO_FeedBackMaster where FeedBackMasterPK='" + fbfk + "'";
ds = d2.select_method_wo_parameter(selqury, "Text");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
ViewState["Acadamic_Isgeneral"] = null;
string Acadamic_Isgeneral = Convert.ToString(ds.Tables[0].Rows[0]["Acadamic_Isgeneral"]);
string Optiontypefilter = Convert.ToString(ds.Tables[0].Rows[0]["IsType_Individual"]);
string IsSubjectType = Convert.ToString(ds.Tables[0].Rows[0]["IsSubjectType"]);
if (IsSubjectType.Trim() == "1" || IsSubjectType.Trim() == "True")
{
lockNote.Visible = true;
}
else
{
lockNote.Visible = false;
}
if (Acadamic_Isgeneral.Trim() == "0" || Acadamic_Isgeneral.Trim() == "False")
{
#region acadamic
string Deg_code = ds.Tables[0].Rows[0]["DegreeCode"].ToString();
string Batch = ds.Tables[0].Rows[0]["Batch_Year"].ToString();
string Semester = ds.Tables[0].Rows[0]["semester"].ToString();
string collegecode = Convert.ToString(ds.Tables[0].Rows[0]["CollegeCode"]);
string section = ds.Tables[0].Rows[0]["Section"].ToString();
string subtype = ds.Tables[0].Rows[0]["Subject_Type"].ToString();
string subtype1 = ds.Tables[0].Rows[0]["OptionalSubject_type"].ToString();
string st_type = string.Empty;
string st_type1 = string.Empty;
string sub_type = string.Empty;
string sub_type1 = string.Empty;
string filteroption = string.Empty;
if (!string.IsNullOrEmpty(subtype))
{
st_type = subtype.ToString();
string[] split = st_type.Split(',');
for (int i = 0; i < split.Length; i++)
{
if (string.IsNullOrEmpty(sub_type))
{
sub_type = split[i];
}
else
{
sub_type += "," + split[i];
}
}
}
if (!string.IsNullOrEmpty(subtype1))
{
st_type1 = subtype1.ToString();
string[] split = st_type1.Split(',');
for (int i = 0; i < split.Length; i++)
{
if (string.IsNullOrEmpty(sub_type1))
{
sub_type1 = split[i];
}
else
{
sub_type1 += "," + split[i];
}
}
}
if (!string.IsNullOrEmpty(sub_type1.Trim()))
{
if (string.IsNullOrEmpty(sub_type.Trim()))
{
sub_type = sub_type1;
}
else
{
sub_type = sub_type + "," + sub_type1;
}
}
if (Optiontypefilter.Trim() == "1" || Optiontypefilter.Trim() == "True")
{
filteroption = "1";
}
else
{
filteroption = "0";
}
hat.Add("UnicodeValue", txt_unic_fb.Text.ToString());
hat.Add("CollegeCode", collegecode);
hat.Add("degree_code", Deg_code);
hat.Add("batch_year", Batch);
hat.Add("Semester", Semester);
hat.Add("sections", section);
hat.Add("subjectType", sub_type);
hat.Add("OptionalSubjectType", sub_type1);
hat.Add("filteroptionmark", filteroption);
ds.Clear();
ds = d2.select_method("FeedbackQuery", hat, "sp");
FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType();
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
string optional = string.Empty;
if (ds.Tables[4].Rows.Count > 0)
{
for (int p = 0; p < ds.Tables[4].Rows.Count; p++)
{
if (string.IsNullOrEmpty(optional))
{
optional = ds.Tables[4].Rows[p]["subject_no"].ToString();
}
else
{
optional = optional + "," + ds.Tables[4].Rows[p]["subject_no"].ToString();
}
}
Session["Optional subject"] = optional;
}
else
{
Session["Optional subject"] = "";
}
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0 && ds.Tables[2].Rows.Count > 0 && ds.Tables[3].Rows.Count > 0)
{
lbl_Name.Visible = true;
lbl_Name.Text = ds.Tables[0].Rows[0]["FeedBackName"].ToString();
if (ds.Tables[1].Rows.Count > 0)
{
for (int row = 0; row < ds.Tables[2].Rows.Count; row++)
{
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(ds.Tables[2].Rows[row]["subject_name"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(ds.Tables[2].Rows[row]["subject_no"]);
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
//FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
if (ds.Tables[3].Rows.Count > 0)
{
ds.Tables[3].DefaultView.RowFilter = "subject_no='" + Convert.ToString(ds.Tables[2].Rows[row]["subject_no"]) + "'";
dv = ds.Tables[3].DefaultView;
if (dv.Count > 0)
{
for (int d = 0; d < dv.Count; d++)
{
if (d == 0)
{
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(dv[d]["staff_name"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(dv[d]["staff_code"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Note = Convert.ToString(ds.Tables[2].Rows[row]["subject_type"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(ds.Tables[2].Rows[row]["subject_no"]);
//FpSpread1.Sheets[0].ColumnHeader.Cells[2, FpSpread1.Sheets[0].ColumnCount - 1].CellType = cball;
}
else
{
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(dv[d]["staff_name"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(dv[d]["staff_code"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Note = Convert.ToString(ds.Tables[2].Rows[row]["subject_type"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(ds.Tables[2].Rows[row]["subject_no"]);
//FpSpread1.Sheets[0].ColumnHeader.Cells[2, FpSpread1.Sheets[0].ColumnCount - 1].CellType = cball;
}
//FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Font.Bold = true;
//FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
//FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
//FpSpread1.Sheets[0].ColumnHeader.Cells[2, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
//FpSpread1.Sheets[0].Columns[FpSpread1.Sheets[0].ColumnCount - 1].CellType = cb;
}
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread1.Sheets[0].ColumnCount - dv.Count, 1, dv.Count);
}
}
}
}
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(i + 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Tag = ds.Tables[0].Rows[i]["FeedBackMasterPK"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = ds.Tables[0].Rows[i]["HeaderCode"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = ds.Tables[0].Rows[i]["HeaderName"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = ds.Tables[0].Rows[i]["Question"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Tag = ds.Tables[0].Rows[i]["QuestionMasterPK"].ToString();
if (Optiontypefilter.Trim() == "1" || Optiontypefilter.Trim() == "True")
{
ds.Tables[1].DefaultView.RowFilter = " QuestionmasterFK='" + ds.Tables[0].Rows[i]["QuestionMasterPK"].ToString() + "' and FeedbackFk='" + ds.Tables[0].Rows[i]["FeedBackMasterPK"].ToString() + "'";
filteroption_dv = ds.Tables[1].DefaultView;
cb = new FarPoint.Web.Spread.ComboBoxCellType();
cb.DataSource = filteroption_dv.ToTable();
cb.DataTextField = "MarkType";
cb.DataValueField = "MarkType";
if (filteroption_dv.Count == 0)
{
ds.Tables[1].DefaultView.RowFilter = " QuestionmasterFK='" + ds.Tables[0].Rows[i]["QuestionMasterPK"].ToString() + "'";
//filteroption_dv = ds.Tables[1].DefaultView.(true, "MarkType");
//filteroption_dv = ds.Tables[1].DefaultView(true, "MarkType");
DataTable dt = ds.Tables[1].DefaultView.ToTable(true, "MarkType");
cb = new FarPoint.Web.Spread.ComboBoxCellType();
cb.DataSource = dt;
cb.DataTextField = "MarkType";
cb.DataValueField = "MarkType";
}
}
else
{
cb = new FarPoint.Web.Spread.ComboBoxCellType();
cb.DataSource = ds.Tables[1];
cb.DataTextField = "MarkType";
cb.DataValueField = "MarkType";
}
for (int r = 3; r < FpSpread1.Sheets[0].ColumnCount; r++)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].CellType = cb;
FpSpread1.Sheets[0].Columns[r].HorizontalAlign = HorizontalAlign.Center;
if (IsSubjectType.Trim() == "1" || IsSubjectType.Trim() == "True")//Subject Wise
{
string subjectHeader = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, r].Note);
bool flag = false;//delsi2303
string subjecttype = Convert.ToString(ds.Tables[0].Rows[i]["SubjectType"]);
string[] subjectsplit = subjecttype.Split(',');
if (subjectsplit.Length > 0)
{
for (int val = 0; val < subjectsplit.Length; val++)
{
string subjectstring = Convert.ToString(subjectsplit[val]);
if (subjectstring.ToLower().Trim() == subjectHeader.ToLower().Trim())
{
flag = true;
}
}
}
//if (!Convert.ToString(ds.Tables[0].Rows[i]["SubjectType"]).Contains(subjectHeader))
//{
// FpSpread1.Sheets[0].Cells[i, r].Locked = true;
// FpSpread1.Sheets[0].Cells[i, r].BackColor = Color.Lavender;
//}
if (flag == false) //delsi2303
{
FpSpread1.Sheets[0].Cells[i, r].Locked = true;
FpSpread1.Sheets[0].Cells[i, r].BackColor = Color.Lavender;
}
}
}
}
FpSpread1.Sheets[0].RowCount++;//txt
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = "Enter Comments";
for (int r = 3; r < FpSpread1.Sheets[0].ColumnCount; r++)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].CellType = txt;
}
FpSpread1.Sheets[0].Columns[0].Locked = true;
FpSpread1.Sheets[0].Columns[1].Locked = true;
FpSpread1.Sheets[0].Columns[2].Locked = true;
FpSpread1.Width = 1000;
FpSpread1.Height = 550;
FpSpread1.Sheets[0].FrozenColumnCount = 1;
FpSpread1.Sheets[0].FrozenColumnCount = 2;
FpSpread1.Sheets[0].FrozenColumnCount = 3;
FpSpread1.SaveChanges();
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
MainDivPart.Visible = true;
}
else
{
lbl_alrt.Visible = true;
lbl_alrt.Text = "No Records Found";
txt_unic_fb.Text = "";
FpSpread1.Visible = false;
btn_save.Visible = false;
MainDivPart.Visible = false;
}
#endregion
}
if (Acadamic_Isgeneral.Trim() == "1" || Acadamic_Isgeneral.Trim() == "True")
{
#region Acadamic_Isgeneral
DataView dv_hd = new DataView(); ViewState["Acadamic_Isgeneral"] = "1";
string Withoutquestiontype = "0";
if (Optiontypefilter.Trim() == "1" || Optiontypefilter.Trim() == "True")
{
Withoutquestiontype = "1";
}
hat.Clear();
hat.Add("FeedbackFK", fbfk);
hat.Add("CollegeCode", collegecode1);
hat.Add("Withoutquestiontypematch", Withoutquestiontype);
ds.Clear();
ds = d2.select_method("Feedback_acadamic_general", hat, "sp");//barath change procedure
if (ds.Tables[2].Rows.Count > 0)
{
lbl_Name.Text = ds.Tables[2].Rows[0]["FeedBackName"].ToString();
}
lbl_Name.Visible = true;
FpSpread1.Columns[2].Visible = false;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Question";
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
for (int row = 0; row < ds.Tables[1].Rows.Count; row++)
{
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread1.Sheets[0].ColumnCount - 1, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(ds.Tables[1].Rows[row]["MarkType"]);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(ds.Tables[1].Rows[row]["MarkMasterPK"]);
FpSpread1.Sheets[0].Columns[FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
}
FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType();
chk.AutoPostBack = true;
int sno = 0; string headername = "";
for (int i = 0; i < ds.Tables[3].Rows.Count; i++)
{
if (headername.Trim() != ds.Tables[3].Rows[i]["HeaderCode"].ToString())
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, FpSpread1.Sheets[0].ColumnCount);
//FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = ds.Tables[3].Rows[i]["HeaderCode"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = ds.Tables[3].Rows[i]["HeaderName"].ToString();
headername = ds.Tables[3].Rows[i]["HeaderCode"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].ForeColor = Color.Blue;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
}
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].DefaultView.RowFilter = " HeaderCode='" + ds.Tables[3].Rows[i]["HeaderCode"].ToString() + "' and QuestionMasterPK='" + ds.Tables[3].Rows[i]["QuestionMasterPK"].ToString() + "'";
dv_hd = ds.Tables[0].DefaultView; string prewquestionmasterfk = ""; bool checklock = false;
if (dv_hd.Count > 0)
{
for (int rs = 0; rs < dv_hd.Count; rs++)
{
if (prewquestionmasterfk.Trim() != dv_hd[rs]["QuestionMasterPK"].ToString())
{
FpSpread1.Sheets[0].RowCount++;
sno++;
checklock = true;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Tag = dv_hd[rs]["FeedBackMasterPK"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Note = dv_hd[rs]["FeedBackMasterPK"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = dv_hd[rs]["Question"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = dv_hd[rs]["QuestionMasterPK"].ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Locked = true;
prewquestionmasterfk = dv_hd[rs]["QuestionMasterPK"].ToString();
//optionfilter
if (Optiontypefilter.Trim() == "1" || Optiontypefilter.Trim() == "True")
{
for (int r = 3; r < FpSpread1.Sheets[0].ColumnHeader.Columns.Count; r++)
{
string markfk = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, r].Tag);
if (Convert.ToString(dv_hd[rs]["MarkMasterFK"]) == markfk)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].Locked = false;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].CellType = chk;
}
else
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].CellType = chk;
if (checklock == true)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].Locked = true;
}
}
}
}
else
{
for (int r = 3; r < FpSpread1.Sheets[0].ColumnHeader.Columns.Count; r++)
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].Locked = false;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, r].CellType = chk;
}
}
checklock = false;
}
}
}
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Width = 800;
FpSpread1.Height = 500;
MainDivPart.Visible = true;
btn_save.Visible = true;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "No Records Found";
FpSpread1.Visible = false;
btn_save.Visible = false;
}
#endregion
}
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "No Records Found";
FpSpread1.Visible = false;
btn_save.Visible = false;
MainDivPart.Visible = false;
}
}
else
{
imgdiv2.Visible = true;
lbl_alert1.Text = "No Records Found";
FpSpread1.Visible = false;
btn_save.Visible = false;
MainDivPart.Visible = false;
}
}
catch (Exception ex)
{
imgdiv2.Visible = true;
lbl_alert1.Text = ex.ToString();
}
}