protected void btndeletefp1_Click(object sender, EventArgs e)
{
try
{
string data = "";
FpSpread1.SaveChanges();
for (int iy = 1; iy < FpSpread1.Sheets[0].RowCount; iy++)
{
if (Convert.ToInt32(FpSpread1.Sheets[0].Cells[iy, 2].Value) == 0)
{
if (data == "")
{
data = FpSpread1.Sheets[0].Cells[iy, 1].Text.ToString();
}
else
{
data = data + ";" + FpSpread1.Sheets[0].Cells[iy, 1].Text.ToString();
}
}
}
if (data != "")
{
sql = "update IM_POSettings set TermsDesc='" + data + "' where collegecode='" + Session["collegecode"].ToString() + "' ";
int a = da.update_method_wo_parameter(sql, "text");
}
else
{
sql = "select * from IM_POSettings ";
ds.Clear();
ds = da.select_method_wo_parameter(sql, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
sql = "update IM_POSettings set TermsDesc='' where collegecode='" + Session["collegecode"].ToString() + "' ";
int a = da.update_method_wo_parameter(sql, "text");
}
}
showterms();
}
catch
{
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
string print = "";
string appPath = HttpContext.Current.Server.MapPath("~");
string strexcelname = "";
if (appPath != "")
{
strexcelname = txtexcelname.Text;
appPath = appPath.Replace("\\", "/");
if (strexcelname != "")
{
print = strexcelname;
//FpEntry.SaveExcel(appPath + "/Report/" + print + ".xls", FarPoint.Web.Spread.Model.IncludeHeaders.BothCustomOnly); //Print the sheet
//ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('" + print + ".xls" + " saved in" + " " + appPath + "/Report" + " successfully')", true);
//Aruna on 26feb2013============================
string szPath = appPath + "/Report/";
string szFile = print + ".xls"; // + DateTime.Now.ToString("yyyyMMddHHmmss")
FpSpread1.SaveExcel(szPath + szFile, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + szFile);
Response.ContentType = "application/vnd.ms-excel";
Response.Flush();
Response.WriteFile(szPath + szFile);
//=============================================
}
else
{
lblnorec.Text = "Please Enter Your Report Name";
lblnorec.Visible = true;
}
}
}
catch (Exception ex)
{
lblnorec.Text = ex.ToString();
}
}
//protected bool getCheckCount()
//{
// bool boolSave = false;
// foreach (GridViewRow row in FpSpread1.Rows)
// {
// CheckBox cbsel = (CheckBox)row.FindControl("cbselect");
// if (!cbsel.Checked)
// continue;
// boolSave = true;
// }
// return boolSave;
//}
protected bool getCheckCount()
{
FpSpread1.SaveChanges();
bool boolSave = false;
for (int i = 0; i < FpSpread1.Rows.Count; i++)
{
byte check = Convert.ToByte(FpSpread1.Sheets[0].Cells[i, 1].Value);
if (check == 1)
{
//string groupname = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 2].Text);
//string staffcode = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 2].Text);
//string updQ = "update staffmaster set sms_groupname='" + groupname + "' where staff_code='" + staffcode + "'";
//int upd = d2.update_method_wo_parameter(updQ, "Text");
//continue;
boolSave = true;
}
}
return(boolSave);
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
Control cntUpdateBtn = FpSpread1.FindControl("Update");
Control cntCancelBtn = FpSpread1.FindControl("Cancel");
Control cntCopyBtn = FpSpread1.FindControl("Copy");
Control cntCutBtn = FpSpread1.FindControl("Clear");
Control cntPasteBtn = FpSpread1.FindControl("Paste");
// Control cntPageNextBtn = FpSpread1.FindControl("Next");
// Control cntPagePreviousBtn = FpSpread1.FindControl("Prev");
//Control cntPagePrintBtn = FpSpread1.FindControl("Print");
if ((cntUpdateBtn != null))
{
TableCell tc = (TableCell)cntUpdateBtn.Parent;
TableRow tr = (TableRow)tc.Parent;
tr.Cells.Remove(tc);
tc = (TableCell)cntCancelBtn.Parent;
tr.Cells.Remove(tc);
tc = (TableCell)cntCopyBtn.Parent;
tr.Cells.Remove(tc);
tc = (TableCell)cntCutBtn.Parent;
tr.Cells.Remove(tc);
tc = (TableCell)cntPasteBtn.Parent;
tr.Cells.Remove(tc);
// tc = (TableCell)cntPageNextBtn.Parent;
// tr.Cells.Remove(tc);
// tc = (TableCell)cntPagePreviousBtn.Parent;
// tr.Cells.Remove(tc);
}
base.Render(writer);
}
//protected void Fpspread2_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
//{
// try
// {
// if (e.Row.RowType == DataControlRowType.Header)
// {
// e.Row.Cells[6].Attributes["onclick"] = Page.ClientScript.GetPostBackEventReference(this.Fpspread1, "Select$" + e.Row.RowIndex);
// }
// }
// catch { }
//}
//protected void Fpspread2_RowCommand(object sender, GridViewCommandEventArgs e)
//{
// try
// {
// if (e.CommandName == "Select")
// {
// }
// }
// catch
// {
// }
//}
//protected void Fpspread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
//{
// string actrow = Convert.ToString(e.SheetView.ActiveRow).Trim();
// if (flag_true == false && actrow == "0")
// {
// for (int j = 1; j < Convert.ToInt16(Fpspread2.Sheets[0].RowCount); j++)
// {
// string actcol = Convert.ToString(e.SheetView.ActiveColumn).Trim();
// string seltext = Convert.ToString(e.EditValues[Convert.ToInt16(actcol)]).Trim();
// if (seltext != "System.Object")
// Fpspread2.Sheets[0].Cells[j, Convert.ToInt16(actcol)].Text = Convert.ToString(seltext).Trim();
// }
// flag_true = true;
// }
//}
protected void Btndelete_Click(object sender, EventArgs e)
{
try
{
int count = 0;
//string datefrom = string.Empty;
Hashtable hat = new Hashtable();
string date1 = string.Empty;
date1 = txtFromDate.Text.ToString();
DateTime dt1 = new DateTime();// Convert.ToDateTime(datefrom.ToString());
bool isValidDate = DateTime.TryParseExact(date1, "dd/MM/yyyy", null, DateTimeStyles.None, out dt1);
int isval = 0;
FpSpread1.SaveChanges();
for (int s = 1; s < FpSpread1.Sheets[0].RowCount; s++)
{
//Convert.ToInt32(FpSpread1.Sheets[0].Cells[s, 4].Value);
int.TryParse(Convert.ToString(FpSpread1.Sheets[0].Cells[s, 4].Value), out isval);
if (isval == 1)
{
string batchYear = FpSpread1.Sheets[0].Cells[s, 1].Text;
string degCode = Convert.ToString(FpSpread1.Sheets[0].Cells[s, 2].Note);
hat.Clear();
hat.Add("@batchyear", batchYear);
hat.Add("@degreecode", degCode);
hat.Add("@doubleDate", dt1.ToString("MM/dd/yyyy"));
hat.Add("@college_code", Convert.ToString(ddlCollege.SelectedValue));
count = da.update_method_with_parameter("Delete_Doubleday_schdl", hat, "sp");
}
}
if (count > 0)
{
divPopAlert.Visible = true;
lblAlertMsg.Visible = true;
lblAlertMsg.Text = "Delete Successfully";
}
}
catch
{
}
}
protected void FpSpread1_ButtonCommand(object sender, EventArgs e)
{
FpSpread1.SaveChanges();
string activerow = FpSpread1.ActiveSheetView.ActiveRow.ToString();
string activecol = FpSpread1.ActiveSheetView.ActiveColumn.ToString();
if (activecol == "3")
{
int act1 = Convert.ToInt32(activerow);
int act2 = Convert.ToInt16(activecol);
if (FpSpread1.Sheets[0].Cells[act1, act2].Value.ToString() == "1")
{
flag_true = true;
FpSpread1.Sheets[0].Cells[act1, act2 + 1].Text = "";
}
else
{
flag_true = false;
}
}
FpSpread1.SaveChanges();
}
protected void Fpspread1_render(object sender, EventArgs e)
{
if (flag_true == true)
{
FpSpread1.SaveChanges();
string activrow = "";
activrow = FpSpread1.Sheets[0].ActiveRow.ToString();
string activecol = FpSpread1.Sheets[0].ActiveColumn.ToString();
int actcol = Convert.ToInt16(activecol);
int hy_order = 0;
for (int i = 0; i <= Convert.ToInt16(FpSpread1.Sheets[0].RowCount) - 1; i++)
{
int isval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[i, actcol].Value);
if (isval == 1)
{
hy_order++;
FpSpread1.Sheets[0].Cells[Convert.ToInt32(activrow), actcol].Locked = true;
}
}
FpSpread1.Sheets[0].Cells[Convert.ToInt32(activrow), actcol + 1].Text = hy_order.ToString();
}
}
protected void btnResetPriority_Click(object sender, EventArgs e)
{
try
{
bool check = false;
if (FpSpread1.Sheets[0].Rows.Count > 0)
{
for (int i = 0; i < FpSpread1.Sheets[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].Cells[i, 3].Locked = false;
FpSpread1.Sheets[0].Cells[i, 3].Value = 0;
FpSpread1.Sheets[0].Cells[i, 4].Text = "";
check = true;
}
}
FpSpread1.SaveChanges();
if (check)
{
lbl_alert.Text = "Reset Successfully";
imgdiv2.Visible = true;
}
}
catch { }
}
protected void btnxl_Click(object sender, EventArgs e)
{
string appPath = HttpContext.Current.Server.MapPath("~");
string print = "";
if (appPath != "")
{
int i = 1;
appPath = appPath.Replace("\\", "/");
e:
try
{
print = "Consolidated Student GPA And CGPA" + i;
//FpSpread1.SaveExcel(appPath + "/Report/" + print + ".xls", FarPoint.Web.Spread.Model.IncludeHeaders.BothCustomOnly);
//Aruna on 26feb2013============================
string szPath = appPath + "/Report/";
string szFile = print + ".xls"; // + DateTime.Now.ToString("yyyyMMddHHmmss")
FpSpread1.SaveExcel(szPath + szFile, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + szFile);
Response.ContentType = "application/vnd.ms-excel";
Response.Flush();
Response.WriteFile(szPath + szFile);
//=============================================
}
catch
{
i++;
goto e;
}
}
//ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('" + print + ".xls" + " saved in" + " " + appPath + "/Report" + " successfully')", true);
}
public void btndel_Click(object sender, EventArgs e)
{
try
{
int savecc = 0;
FpSpread1.SaveChanges();
string activerow = FpSpread1.ActiveSheetView.ActiveRow.ToString();
string sql = "delete from leave_category where LeaveMasterPK = '" + FpSpread1.Sheets[0].Cells[Convert.ToInt32(activerow), 7].Text.ToString() + "' and college_code= '" + collegecode + "'";
int qry = d2.update_method_wo_parameter(sql, "Text");
savecc++;
if (savecc > 0)
{
lbl_alert.Text = "Deleted Successfully";
lbl_alert.Visible = true;
imgdiv2.Visible = true;
btn_go_Click(sender, e);
}
}
catch (Exception ex)
{
d2.sendErrorMail(ex, collegecode, "LeaveMaster_Alter.aspx");
}
}
protected void FpSpread1_OnButtonCommand(object sender, EventArgs e)
{
if (ViewState["Acadamic_Isgeneral"] != null)
{
FpSpread1.SaveChanges();
int activerow = FpSpread1.ActiveSheetView.ActiveRow;
int activecol = FpSpread1.ActiveSheetView.ActiveColumn;
int checkval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[activerow, activecol].Value);
if (checkval == 1)
{
for (int i = 3; i < FpSpread1.Sheets[0].ColumnCount; i++)
{
if (i == Convert.ToInt32(activecol))
{
FpSpread1.Sheets[0].Cells[activerow, i].Value = 1;
}
else
{
FpSpread1.Sheets[0].Cells[activerow, i].Value = 0;
}
}
}
}
}
protected void btnPrioritySave_Click(object sender, EventArgs e)
{
try
{
bool UpdateFlag = false;
FpSpread1.SaveChanges();
for (int i = 0; i <= Convert.ToInt16(FpSpread1.Sheets[0].RowCount) - 1; i++)
{
int isval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[i, 2].Value);
if (isval == 1)
{
string GetPriority = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 3].Text);
string GetID = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 1].Tag);
string UpdQuery = "update IT_GroupMaster set Priority='" + GetPriority + "' where ITGroupPK='" + GetID + "' and collegeCode='" + ddlcolload.SelectedValue + "'";
int Upd = d2.update_method_wo_parameter(UpdQuery, "Text");
if (Upd > 0)
{
UpdateFlag = true;
}
}
}
if (UpdateFlag)
{
imgdiv2.Visible = true;
lbl_alerterr.Text = "Update Successfully";
}
else
{
imgdiv2.Visible = true;
lbl_alerterr.Text = "Not Updated";
}
}
catch
{
}
}
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 Page_Load(object sender, EventArgs e)
{
try
{
if (Session["collegecode"] == null) //Aruna For Back Button
{
Response.Redirect("~/Default.aspx");
}
errmsg.Visible = false;
FpSpread1.SaveChanges();
if (!IsPostBack)
{
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].SheetName = " ";
FpSpread1.Sheets[0].SheetCorner.Columns[0].Visible = false;
FpSpread1.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false;
FarPoint.Web.Spread.StyleInfo style1 = new FarPoint.Web.Spread.StyleInfo();
style1.Font.Size = 12;
style1.Font.Bold = true;
style1.HorizontalAlign = HorizontalAlign.Center;
style1.ForeColor = System.Drawing.Color.Black;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].AllowTableCorner = true;
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom;
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
FpSpread1.Pager.Align = HorizontalAlign.Right;
FpSpread1.Pager.Font.Bold = true;
FpSpread1.Pager.Font.Name = "Book Antiqua";
FpSpread1.Pager.ForeColor = System.Drawing.Color.DarkGreen;
FpSpread1.Pager.BackColor = System.Drawing.Color.Beige;
FpSpread1.Pager.BackColor = System.Drawing.Color.AliceBlue;
FpSpread1.Pager.PageCount = 5;
FpSpread1.Visible = false;
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom;
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
FpSpread1.Pager.Align = HorizontalAlign.Left;
FpSpread1.Pager.Font.Bold = true;
FpSpread1.Pager.Font.Name = "Book Antiqua";
FpSpread1.Pager.ForeColor = Color.DarkGreen;
// FpSpread1.Pager.BackColor = Color.Beige;
// FpSpread1.Pager.BackColor = Color.AliceBlue;
FpSpread1.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false;
FpSpread1.SheetCorner.Columns[0].Visible = false;
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false;
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
loadstage();
}
}
catch
{
}
}
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
{
}
}
public void btnsave_Click(object sender, EventArgs e)
{
try
{
DateTime dt = new DateTime();
string dtaccessdate = DateTime.Now.ToString();
string dtaccesstime = DateTime.Now.ToLongTimeString();
FpSpread1.SaveChanges();
if (cb_allowallmonth.Checked == true)
{
if (cbl_hostelname.Items.Count > 0)
{
for (int i = 0; i < cbl_hostelname.Items.Count; i++)
{
if (cbl_hostelname.Items[i].Selected == true)
{
string hostelcode = Convert.ToString(cbl_hostelname.Items[i].Value);
if (FpSpread1.Sheets[0].ColumnCount > 2)
{
for (int ik = 2; ik < FpSpread1.Sheets[0].ColumnCount; ik++)
{
for (int k = 0; k < cbl_month.Items.Count; k++)
{
if (cbl_month.Items[k].Selected == true)
{
string getmonthvalue = Convert.ToString(cbl_month.Items[k].Value);
if (FpSpread1.Sheets[0].RowCount > 0)
{
for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++)
{
string currentday = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Text);
string dayamount = Convert.ToString(FpSpread1.Sheets[0].Cells[row, ik].Text);
if (dayamount.Trim() != "" && dayamount.Trim() != null)
{
string query = "";
string rebatetype = "";
if (rdbdate.Checked == true)
{
if (cb_allowallmonth.Checked == true)
{
rebatetype = "1";
query = "if exists (select * from HM_RebateMaster where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "') update HM_RebateMaster set RebateDays ='" + dayamount + "' where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "'else insert into HM_RebateMaster (RebateType,RebateMonth,RebateDays,RebateActDays,HostelFK) values ('" + rebatetype + "','" + getmonthvalue + "','" + dayamount + "','" + currentday + "','" + hostelcode + "' )";
}
}
else
{
if (cb_allowallmonth.Checked == true)
{
rebatetype = "2";
query = "if exists (select * from HM_RebateMaster where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "') update HM_RebateMaster set RebateAmount ='" + dayamount + "' where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "'else insert into HM_RebateMaster (RebateType,RebateMonth,RebateAmount,RebateActDays,HostelFK) values ('" + rebatetype + "','" + getmonthvalue + "','" + dayamount + "','" + currentday + "','" + hostelcode + "' )";
}
}
int ivalue = d2.update_method_wo_parameter(query, "Text");
}
}
}
}
}
}
imgdiv2.Visible = true;
lblalerterr.Text = "Saved Successfully";
}
}
}
}
}
else
{
if (cbl_hostelname.Items.Count > 0)
{
for (int i = 0; i < cbl_hostelname.Items.Count; i++)
{
if (cbl_hostelname.Items[i].Selected == true)
{
string hostelcode = Convert.ToString(cbl_hostelname.Items[i].Value);
if (FpSpread1.Sheets[0].ColumnCount > 2)
{
for (int ik = 2; ik < FpSpread1.Sheets[0].ColumnCount; ik++)
{
string getmonthvalue = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, ik].Tag);
if (FpSpread1.Sheets[0].RowCount > 0)
{
for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++)
{
string currentday = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Text);
string dayamount = Convert.ToString(FpSpread1.Sheets[0].Cells[row, ik].Text);
if (dayamount.Trim() != "" && dayamount.Trim() != null)
{
string query = "";
string rebatetype = "";
if (rdbdate.Checked == true)
{
rebatetype = "1";
query = "if exists (select * from HM_RebateMaster where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "') update HM_RebateMaster set RebateDays ='" + dayamount + "' where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "'else insert into HM_RebateMaster (RebateType,RebateMonth,RebateDays,RebateActDays,HostelFK) values ('" + rebatetype + "','" + getmonthvalue + "','" + dayamount + "','" + currentday + "','" + hostelcode + "' )";
}
else
{
rebatetype = "2";
query = " if exists (select * from HM_RebateMaster where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "') update HM_RebateMaster set RebateAmount ='" + dayamount + "' where RebateActDays ='" + currentday + "' and RebateMonth='" + getmonthvalue + "' and HostelFK='" + hostelcode + "' and RebateType='" + rebatetype + "'else insert into HM_RebateMaster (RebateType,RebateMonth,RebateAmount,RebateActDays,HostelFK) values ('" + rebatetype + "','" + getmonthvalue + "','" + dayamount + "','" + currentday + "','" + hostelcode + "' )";
}
int ivalue = d2.update_method_wo_parameter(query, "Text");
}
}
}
}
imgdiv2.Visible = true;
lblalerterr.Text = "Saved Successfully";
}
}
}
}
}
btn_go_Click(sender, e);
}
catch
{
}
}
public void btn_go_Click(object sender, EventArgs e)
{
try
{
div_report.Visible = false;
Printcontrol.Visible = false;
FpSpread1.Visible = false;
FpSpread1.SaveChanges();
string itemheadercode = "";
for (int i = 0; i < cbl_hostelname.Items.Count; i++)
{
if (cbl_hostelname.Items[i].Selected == true)
{
if (itemheadercode == "")
{
itemheadercode = "" + cbl_hostelname.Items[i].Value.ToString() + "";
}
else
{
itemheadercode = itemheadercode + "'" + "," + "'" + cbl_hostelname.Items[i].Value.ToString() + "";
}
}
}
string month = "";
for (int i = 0; i < cbl_month.Items.Count; i++)
{
if (cbl_month.Items[i].Selected == true)
{
if (month == "")
{
month = "" + cbl_month.Items[i].Value.ToString() + "";
}
else
{
month = month + "'" + "," + "'" + cbl_month.Items[i].Value.ToString() + "";
}
}
}
if (txt_hostelname.Text == "--Select--")
{
lblerror.Visible = true;
lblerror.Text = "Kindly Select The Hostel";
btnsave.Visible = false;
btn_reset.Visible = false;
}
else
{
if (txt_month.Text == "--Select--")
{
lblerror.Visible = true;
lblerror.Text = "Kindly Select The Month";
btnsave.Visible = false;
btn_reset.Visible = false;
//FpSpread1.Visible = false;
}
else
{
//FpSpread1.Visible = true;
if (itemheadercode.Trim() != "")
{
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 1;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[0].Width = 50;
FpSpread1.Columns[0].Locked = true;
FpSpread1.Sheets[0].ColumnCount++;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Days";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread1.Columns[1].Width = 150;
FpSpread1.Columns[1].Locked = true;
for (int i = 0; i < cbl_month.Items.Count; i++)
{
if (cbl_month.Items[i].Selected == true)
{
FpSpread1.Sheets[0].ColumnCount++;
FarPoint.Web.Spread.DoubleCellType db = new FarPoint.Web.Spread.DoubleCellType();
db.ErrorMessage = "Enter only Numbers";
FpSpread1.Columns[FpSpread1.Sheets[0].ColumnCount - 1].CellType = db;
// FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(cbl_month.Items[i].Text);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(cbl_month.Items[i].Value);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium;
FpSpread1.Columns[1].Width = 150;
}
}
for (int row = 0; row < 31; row++)
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(row + 1);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
}
DataView dv = new DataView();
string query = "";
string rebatetype = "";
if (rdbdate.Checked == true)
{
rebatetype = "1";
}
else
{
rebatetype = "2";
}
query = "select RebateActDays, RebateDays,RebateAmount ,RebateMonth from HM_RebateMaster where HostelFK in ('" + itemheadercode + "') and RebateMonth in ('" + month + "') and RebateType ='" + rebatetype + "'";
//}
//else
//{
// rebatetype = "2";
// query = "select Actual_Day, Grant_Day,Grant_Amount ,Rebate_Month from Rebate_Master where Hostel_Code in ('" + itemheadercode + "') and Rebate_Month in ('" + month + "') and Rebate_Type ='" + rebatetype + "'";
//}
ds1 = d2.select_method_wo_parameter(query, "Text");
if (ds1.Tables[0].Rows.Count > 0)
{
if (FpSpread1.Sheets[0].ColumnCount > 2)
{
for (int ik = 2; ik < FpSpread1.Sheets[0].ColumnCount; ik++)
{
string getmonthvalue = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, ik].Tag);
if (FpSpread1.Sheets[0].RowCount > 0)
{
for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++)
{
string currentday = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Text);
ds1.Tables[0].DefaultView.RowFilter = "RebateActDays='" + currentday + "' and RebateMonth='" + getmonthvalue + "'";
dv = ds1.Tables[0].DefaultView;
if (dv.Count > 0)
{
if (rdbdate.Checked == true)
{
FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateDays"]);
FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right;
}
else
{
FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateAmount"]);
FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right;
}
}
}
}
}
}
}
//25.04.16
//if (txt_allmonth.Text.Trim() != "")
//{
// if (FpSpread1.Sheets[0].ColumnCount > 2)
// {
// for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount - 2; i++)
// {
// int k = 0;
// for (int row = 0; row < 31; row++)
// {
// k++;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Text = Convert.ToString(txt_allmonth.Text);
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].HorizontalAlign = HorizontalAlign.Center;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Size = FontUnit.Medium;
// FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Name = "Book Antiqua";
// }
// }
// }
//}
}
FpSpread1.Visible = true;
div_report.Visible = true;
//div1.Visible = true;
lblerror.Visible = false;
btnsave.Visible = true;
btn_reset.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
}
}
}
catch
{
}
}
protected void btn_go_Click(object sender, EventArgs e)
{
try
{
lbl_error.Visible = false;
FpSpread1.SaveChanges();
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = true;
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.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].ColumnHeader.Cells[0, 3].Text = "Question Option";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 59;
FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 150;
FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 328;
string headercode = rs.GetSelectedItemsValueAsString(cbl_header1);
string questionfk = rs.GetSelectedItemsValueAsString(cbl_question1);
string markmasterfk = rs.GetSelectedItemsValueAsString(cbl_option1);
string q1 = " select FeedBackMasterPK from CO_FeedBackMaster where FeedBackName='" + ddl_feedback1.SelectedItem.Value + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
string FeedBackMasterPK = GetdatasetRowstring(ds, "FeedBackMasterPK");
q1 = " select distinct t.TextVal,q.Question,m.MarkType,qt.QuestionmasterFK,qt.HeaderCode,qt.MarkMasterFK,q.CollegeCode from Co_Question_Type qt,CO_MarkMaster m,CO_QuestionMaster q,TextValTable t,CO_FeedBackQuestions fq where q.QuestionMasterPK=fq.QuestionMasterFK and t.TextCode= qt.HeaderCode and qt.MarkMasterFK=m.MarkMasterPK and qt.QuestionmasterFK=q.QuestionMasterPK and qt.HeaderCode=q.HeaderCode and m.CollegeCode=q.CollegeCode and q.HeaderCode in('" + headercode + "') and qt.MarkMasterFK in('" + markmasterfk + "') and qt.FeedbackFk=fq.FeedBackMasterFK and qt.FeedbackFk in('" + FeedBackMasterPK + "') and qt.QuestionmasterFK in('" + questionfk + "') order by TextVal";
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text"); int row = 0;
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < cbl_header1.Items.Count; i++)
{
if (cbl_header1.Items[i].Selected == true)
{
for (int j = 0; j < cbl_question1.Items.Count; j++)
{
if (cbl_question1.Items[j].Selected == true)
{
ds.Tables[0].DefaultView.RowFilter = " HeaderCode='" + cbl_header1.Items[i].Value + "' and QuestionmasterFK='" + cbl_question1.Items[j].Value + "'"; //and MarkType='"++"' and
DataView dv = ds.Tables[0].DefaultView;
if (dv.Count > 0)
{
foreach (DataRowView dr in dv)
{
row++;
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = row.ToString();
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(dr["TextVal"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].VerticalAlign = VerticalAlign.Middle;
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(dr["Question"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].VerticalAlign = VerticalAlign.Middle;
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(dr["MarkType"]);
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;
rptprint1.Visible = true;
}
}
}
}
}
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].Rows.Count;
FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
}
else
{
lbl_error.Visible = true;
lbl_error.Text = "No Records Found";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
}
else
{
lbl_error.Visible = true;
lbl_error.Text = "No Records Found";
FpSpread1.Visible = false;
rptprint1.Visible = false;
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
}
catch
{
}
}
protected void ddlpagecount_SelectedIndexChanged(object sender, EventArgs e)
{
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
ddlpage();
}
protected void FpSpread2_SelectedIndexChanged(Object sender, EventArgs e)
{
FpSpread1.SaveChanges();
}
protected void btn_go_OnClick(object sender, EventArgs e)
{
try
{
string deptcode = rs.GetSelectedItemsValueAsString(cbl_degree);
string degreecode = rs.GetSelectedItemsValueAsString(cbl_branch);
string batch = rs.GetSelectedItemsValueAsString(cbl_batch);
string housepk = rs.GetSelectedItemsValueAsString(cb1_housing);
if (deptcode.Trim() != "" && degreecode.Trim() != "" && batch.Trim() != "" && !string.IsNullOrEmpty(housepk.Trim()))
{
rs.Fpreadheaderbindmethod("S.No-50/House Name-100/Student Name-200/Roll No-150/Reg No-150/Admission No-150/Gender-90/Section-70/" + lbl_degreeT.Text + "-100/" + lbl_branchT.Text + "-200/ Semester-100", FpSpread1, "FALSE");
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,hd.housename from Registration r, degree d,Department dt,Course C,applyn a inner join HousingDetails hd on a.studhouse=hd.housePK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and hd.housePK in('" + housepk + "')";
string type = string.Empty;
switch (Convert.ToUInt32(ddl_searchtype.SelectedValue))
{
case 0:
type = "r.roll_no";
break;
case 1:
type = "r.reg_no";
break;
case 2:
type = "r.Roll_Admit";
break;
case 3:
type = "r.app_no";
break;
}
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('" + batch + "') and c.Course_Id in('" + deptcode + "') 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)
{
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);
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, 1].Text = Convert.ToString(dr["housename"]);
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"]);
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].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, 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].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";
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
rptprint.Visible = true;
}
else
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All The Fields";
}
}
catch (Exception f)
{
rptprint.Visible = false;
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = f.ToString();
}
}
protected void btngo_Click(object sender, EventArgs e)
{
try
{
hide();
string vehid = "";
string routeid = "";
string startdate = tbstart_date.Text;
string enddate = tbend_date.Text;
int counterr = 0;
for (int i = 0; i < cblveh.Items.Count; i++)
{
if (cblveh.Items[i].Selected == true)
{
counterr++;
if (vehid == "")
{
vehid = "" + cblveh.Items[i].Value.ToString() + "";
}
else
{
vehid = vehid + "','" + "" + cblveh.Items[i].Value.ToString() + "";
}
}
}
if (counterr == 0)
{
lblerroe.Text = "Please Select Atleast One Vehicle";
lblerroe.Visible = true;
hide();
return;
}
counterr = 0;
for (int i = 0; i < cblrt.Items.Count; i++)
{
if (cblrt.Items[i].Selected == true)
{
counterr++;
if (routeid == "")
{
routeid = "" + cblrt.Items[i].Value.ToString() + "";
}
else
{
routeid = routeid + "','" + "" + cblrt.Items[i].Value.ToString() + "";
}
}
}
if (counterr == 0)
{
lblerroe.Text = "Please Select Atleast One Route ID";
lblerroe.Visible = true;
hide();
return;
}
string date2ad = tbend_date.Text.ToString();
string date1ad = tbstart_date.Text.ToString();
string[] split5 = date2ad.Split(new Char[] { '/' });
if (split5.Length == 3)
{
date2ad = split5[1].ToString() + "/" + split5[0].ToString() + "/" + split5[2].ToString();
}
split5 = date1ad.Split(new Char[] { '/' });
if (split5.Length == 3)
{
date1ad = split5[1].ToString() + "/" + split5[0].ToString() + "/" + split5[2].ToString();
}
string sql = "select distinct Vehicle_Id,startplace,CONVERT(varchar(20),startptime,105) as sdate,startptime, CONVERT(varchar(20),arrivalptime,105) as adate,arrivalplace,arrivalptime,Opening_Km,Closing_Km,(closing_km - Opening_Km) as totalkm,staffmaster.staff_name from Vehicle_Usage ,staffmaster where staffmaster.staff_code=Vehicle_Usage.staffcode and Vehicle_Id in ('" + vehid + "') and Route_ID in ('" + routeid + "') and startpdate >='" + date1ad + "' and startpdate <='" + date2ad + "' and arrivalpdate >='" + date1ad + "' and arrivalpdate <='" + date2ad + "' order by Vehicle_Id";
ds.Clear();
ds.Clear();
double totalkmgrand = 0;
double outputdbl = 0;
FpSpread1.Sheets[0].Rows.Count = 0;
ds = d2.select_method_wo_parameter(sql, "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++)
{
string startdatetime = Convert.ToString(ds.Tables[0].Rows[i]["sdate"]) + " " + Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[i]["startptime"])).ToString("hh:mm tt");
string enddatetime = Convert.ToString(ds.Tables[0].Rows[i]["adate"]) + " " + Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[i]["arrivalptime"])).ToString("hh:mm tt");
FpSpread1.Sheets[0].Cells[i, 0].Text = Convert.ToString(i + 1);
FpSpread1.Sheets[0].Cells[i, 1].CellType = txtceltype;
FpSpread1.Sheets[0].Cells[i, 1].Text = ds.Tables[0].Rows[i]["Vehicle_Id"].ToString();
//string place = d2.GetFunction(" select sm.Stage_Name from stage_master sm, RouteMaster rm where sm.Stage_id=rm.Stage_Name and sm.Stage_id ='" + ds.Tables[0].Rows[i]["startplace"].ToString() + "' ");
string place = d2.GetFunction(" select sm.Stage_Name from stage_master sm, RouteMaster rm where cast(sm.Stage_id as varchar(100))=cast(rm.Stage_Name as varchar(100)) and sm.Stage_id ='" + ds.Tables[0].Rows[i]["startplace"].ToString() + "' ");//modified by rajasekar 08/09/2018
FpSpread1.Sheets[0].Cells[i, 2].Text = place;
FpSpread1.Sheets[0].Cells[i, 3].Text = startdatetime;
//place = d2.GetFunction(" select sm.Stage_Name from stage_master sm, RouteMaster rm where sm.Stage_id=rm.Stage_Name and sm.Stage_id ='" + ds.Tables[0].Rows[i]["arrivalplace"].ToString() + "' ");
place = d2.GetFunction(" select sm.Stage_Name from stage_master sm, RouteMaster rm where cast(sm.Stage_id as varchar(100))=cast(rm.Stage_Name as varchar(100)) and sm.Stage_id ='" + ds.Tables[0].Rows[i]["arrivalplace"].ToString() + "' ");//modified by rajasekar 08/09/2018
FpSpread1.Sheets[0].Cells[i, 4].Text = place;
FpSpread1.Sheets[0].Cells[i, 5].Text = enddatetime;
FpSpread1.Sheets[0].Cells[i, 6].Text = ds.Tables[0].Rows[i]["Opening_Km"].ToString();
FpSpread1.Sheets[0].Cells[i, 7].Text = ds.Tables[0].Rows[i]["Closing_Km"].ToString();
FpSpread1.Sheets[0].Cells[i, 8].Text = ds.Tables[0].Rows[i]["totalkm"].ToString();
if (double.TryParse(ds.Tables[0].Rows[i]["totalkm"].ToString(), out outputdbl))
{
totalkmgrand = totalkmgrand + Convert.ToDouble(ds.Tables[0].Rows[i]["totalkm"].ToString());
}
FpSpread1.Sheets[0].Cells[i, 9].Text = ds.Tables[0].Rows[i]["staff_name"].ToString();
//FpSpread1.Sheets[0].Cells[i, 2].HorizontalAlign = HorizontalAlign.Left;
}
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, 8);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(totalkmgrand);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = "Grand Total : ";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.SaveChanges();
FpSpread1.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
final.Visible = true;
lblerroe.Visible = false;
for (int i = 0; i < FpSpread1.Sheets[0].RowCount; i++)
{
for (int j = 0; j < FpSpread1.Sheets[0].ColumnCount; j++)
{
FpSpread1.Sheets[0].Cells[i, j].VerticalAlign = VerticalAlign.Middle;
}
}
}
else
{
lblerroe.Text = "No Records Found";
lblerroe.Visible = true;
hide();
}
}
catch
{
}
}
public void ddlpage()
{
try
{
string setpage = "";
string poppage_value = ddlpagecount.SelectedValue.ToString();
// FpSpread1.Sheets[0].Rows[0, FpSpread1.Sheets[0].RowCount - 1].Visible = true;
if (poppage_value == " ")
{
for (int ij = 0; ij < FpSpread1.Sheets[0].RowCount; ij++)
{
string gfg1 = FpSpread1.Sheets[0].Cells[ij, 0].Note;
if (gfg1 == "")
{
FpSpread1.Sheets[0].Cells[ij, 0, ij, 3].Row.Visible = false;
}
else
{
FpSpread1.Sheets[0].Rows[ij].Visible = true;
}
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
}
else
{
string[] split_page = poppage_value.Split(new char[] { '-' });
setpage = split_page[1];
if (Convert.ToInt32(setpage) > 1)
{
FpSpread1.Sheets[0].Rows[0, (Convert.ToInt32(setpage) - 1) * 18].Visible = false;
int row = (Convert.ToInt32(setpage) - 1) * 18;
int v = FpSpread1.Sheets[0].RowCount - row;
// FpSpread1.Sheets[0].PageSize = 18;
// int hh=row + 18;
if (v < 18)
{
FpSpread1.Sheets[0].Rows[row, FpSpread1.Sheets[0].RowCount - 1].Visible = true;
}
else
{
for (int iuj = 0; iuj < 18; iuj++)
{
string gfg = FpSpread1.Sheets[0].Cells[row + iuj, 0].Note;
if (gfg == "")
{
FpSpread1.Sheets[0].Cells[row + iuj, 0, row + iuj, 3].Row.Visible = false;
// FpSpread1.Sheets[0].Rows[row, row + iuj].Visible = false;
}
else
{
// FpSpread1.Sheets[0].Cells[row + iuj, 0, row + iuj, 3].Row.Visible = true;
FpSpread1.Sheets[0].Rows[row + iuj].Visible = true;
// FpSpread1.Sheets[0].Rows[row, row + iuj].Visible = true;
}
}
}
if (v > 18)
{
int hiderow = row + 18;
FpSpread1.Sheets[0].Rows[hiderow, FpSpread1.Sheets[0].RowCount - 1].Visible = false;
}
}
else
{
FpSpread1.Sheets[0].PageSize = Convert.ToInt32(setpage) * 18;
int row = (Convert.ToInt32(setpage)) * 18;
int v = FpSpread1.Sheets[0].RowCount - row;
if (v < 18)
{
FpSpread1.Sheets[0].Rows[row, FpSpread1.Sheets[0].RowCount - 1].Visible = true;
}
else
{
FpSpread1.Sheets[0].Rows[0, row + 18].Visible = true;
FpSpread1.Sheets[0].Rows[1].Visible = false;
FpSpread1.Sheets[0].Rows[2].Visible = false;
}
if (v > 18)
{
int hiderow = row;
FpSpread1.Sheets[0].Rows[hiderow, FpSpread1.Sheets[0].RowCount - 1].Visible = false;
}
}
}
FpSpread1.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
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 = true;
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 = "Vision";
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.Left;
FpSpread1.Sheets[0].Columns[3].Width = 500;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Mission";
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.Left;
FpSpread1.Sheets[0].Columns[4].Width = 500;
// 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].Text = Convert.ToString(ds.Tables[0].Rows[row]["deg_vission"]);
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(ds.Tables[0].Rows[row]["deg_mission"]);
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].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Visible = true;
print.Visible = true;
FpSpread1.ShowHeaderSelection = false;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
lblvalidation1.Text = "";
txtexcelname.Text = "";
#endregion
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["collegecode"] == null)
{
Response.Redirect("~/Default.aspx");
}
if (!Request.FilePath.Contains("TransportIndex"))
{
string strPreviousPage = "";
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/TransportMod/TransportIndex.aspx");
return;
}
}
if (!IsPostBack)
{
Bind_Routes();
bindvechicle();
tbstart_date.Attributes.Add("readonly", "readonly");
tbend_date.Attributes.Add("readonly", "readonly");
tbstart_date.Text = DateTime.Now.ToString("dd/MM/yyyy");
tbend_date.Text = DateTime.Now.ToString("dd/MM/yyyy");
final.Visible = false;
FpSpread1.Visible = false;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = true;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 10;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
// FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 40;
//FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 50;
//FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 120;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Vehicle No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Starting Place";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Starting Date Time";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Destination";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Arrival Date Time";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Starting Km";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Ending Km";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Text = "Total Km";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 9].Text = "Driver";
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = System.Drawing.Color.Teal;
//darkstyle.ForeColor = System.Drawing.Color.Black;
darkstyle.Font.Name = "Book Antiqua";
darkstyle.Font.Size = FontUnit.Medium;
darkstyle.Border.BorderSize = 1;
darkstyle.Border.BorderColor = System.Drawing.Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount; i++)
{
FpSpread1.Sheets[0].Columns[i].Locked = true;
}
FpSpread1.Sheets[0].Columns[0].Width = 40;
FpSpread1.Sheets[0].Columns[2].Width = 200;
FpSpread1.Sheets[0].Columns[3].Width = 200;
FpSpread1.Sheets[0].Columns[4].Width = 200;
FpSpread1.Sheets[0].Columns[5].Width = 200;
//FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 50;
//FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 120;
for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount; i++)
{
FpSpread1.Sheets[0].Columns[i].HorizontalAlign = HorizontalAlign.Left;
}
for (int g = 0; g < FpSpread1.Sheets[0].ColumnHeader.Columns.Count; g++)
{
FpSpread1.Sheets[0].ColumnHeader.Cells[0, g].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, g].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, g].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, g].ForeColor = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, g].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[g].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].Columns[g].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].Columns[g].Font.Bold = true;
FpSpread1.Sheets[0].Columns[g].ForeColor = Color.Black;
}
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[8].HorizontalAlign = HorizontalAlign.Center;
chkboxsel_all.AutoPostBack = true;
FpSpread1.SaveChanges();
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
//---------------------------
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (ddllibrary.Items.Count > 0)
{
lib_code = Convert.ToString(ddllibrary.SelectedValue);
}
if (ddl_year.Items.Count > 0)
{
SuYear = Convert.ToString(ddl_year.SelectedValue);
}
actrow = FpSpread1.Sheets[0].ActiveRow.ToString();
actcol = FpSpread1.Sheets[0].ActiveColumn.ToString();
arow = Convert.ToInt32(actrow);
acol = Convert.ToInt32(actcol);
string varStatus = "";
string strStatus = "";
string VarJrnCode = "";
string StrActDate = "";
string StrActDate1 = "";
string strAccno1 = "";
string sqlinsert = "";
string VarJrnName = "";
string StrIssueNo = "";
string StrMonthIssueNo = "";
int insert = 0;
int update = 0;
bool chk = false;
string Currentdate = DateTime.Now.ToString("MM/dd/yyyy");
string Acctime = DateTime.Now.ToString("hh:mm tt");
if (actrow.Trim() != "")
{
if (FpSpread1.Rows.Count > 0)
{
FpSpread1.SaveChanges();
for (int col = 3; col < FpSpread1.Sheets[0].ColumnCount; col++)
{
for (int row = 1; row < FpSpread1.Sheets[0].RowCount; row++)
{
VarJrnCode = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 0].Tag);
StrActDate1 = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Tag);
if (StrActDate1 != "")
{
string[] actdate = StrActDate1.Split('/');
StrActDate = actdate[1] + "/" + actdate[2] + "/" + actdate[0];
}
//varStatus = Convert.ToString(FpSpread1.Sheets[0].Cells[row, acol].Tag);
VarJrnName = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 2].Tag);
int checkval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[row, col].Value);
if (checkval == 1)
{
strStatus = "1";
}
else
{
strStatus = "0";
}
StrIssueNo = d2.GetFunction("SELECT IssueNo FROM Journal_Issues WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'");
StrMonthIssueNo = d2.GetFunction("SELECT MonthIssue_No FROM Journal_Issues WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'");
int IssueNo = Convert.ToInt32(StrIssueNo);
int MonthIssueNo = Convert.ToInt32(StrMonthIssueNo);
if (strStatus == "1")
{
strAccno1 = AutoAccessNo1();
if (strAccno1 != "")
{
sqlinsert = "INSERT INTO Journal(access_date,access_time,access_code,journal_code,title,dept_name,volume_no,issue_no,received_date,issue_date,noofcopies,remarks,bind_flag,attachement,back_flag,lib_code,issue_flag,receive_date,issn,contents,newaccno,supplier,invoice_no,address,pay_type,expiry_date,Pages,Price,Volume,S_Term,Budget_Head,Subs_Year,Issue_Year,Issue_Month,MonthIssue_No,ActIssueNo)VALUES('" + Currentdate + "','" + Acctime + "','" + strAccno1 + "','" + VarJrnCode + "','" + VarJrnName + "','','','" + StrIssueNo + "','" + Currentdate + "','" + Acctime + "','1','','No','Nil','No','" + lib_code + "','Available','" + StrActDate + "','','','','','','','','" + StrActDate + "','','','','','','" + SuYear + "','" + SuYear + "','" + StrActDate + "','" + MonthIssueNo + "','" + IssueNo + "')";
sqlinsert += "UPDATE Journal_Issues SET Issue_Status ='" + strStatus + "' where journal_code ='" + VarJrnCode + "' and subs_year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'";
insert = d2.update_method_wo_parameter(sqlinsert, "Text");
}
}
else
{
//strStatus = "1";
sqlinsert = "DELETE FROM Journal WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND Issue_No =" + IssueNo + " AND Issue_Month ='" + StrActDate + "'";
sqlinsert = "UPDATE Journal_Issues SET Issue_Status ='" + strStatus + "' where journal_code ='" + VarJrnCode + "' and subs_year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "' ";
insert = d2.update_method_wo_parameter(sqlinsert, "Text");
}
}
//else
//{
// for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++)
// {
// int checkval1 = Convert.ToInt32(FpSpread1.Sheets[0].Cells[row, acol].Value);
// if (checkval1 == 1)
// {
// chk = true;
// VarJrnCode = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 0].Tag);
// StrActDate1 = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Tag);
// if (StrActDate1 != "")
// {
// string[] actdate = StrActDate1.Split('/');
// StrActDate = actdate[2] + "-" + actdate[1] + "-" + actdate[0];
// }
// varStatus = Convert.ToString(FpSpread1.Sheets[0].Cells[row, acol].Tag);
// VarJrnName = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 2].Tag);
// if (varStatus == "1")
// strStatus = "1";
// else
// strStatus = "0";
// StrIssueNo = d2.GetFunction("SELECT IssueNo FROM Journal_Issues WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'");
// StrMonthIssueNo = d2.GetFunction("SELECT MonthIssue_No FROM Journal_Issues WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'");
// int IssueNo = Convert.ToInt32(StrIssueNo);
// int MonthIssueNo = Convert.ToInt32(StrMonthIssueNo);
// if (strStatus == "1")
// {
// strAccno1 = AutoAccessNo1();
// if (strAccno1 != "")
// {
// sqlinsert = "INSERT INTO Journal(access_date,access_time,access_code,journal_code,title,dept_name,volume_no,issue_no,received_date,issue_date,noofcopies,remarks,bind_flag,attachement,back_flag,lib_code,issue_flag,receive_date,issn,contents,newaccno,supplier,invoice_no,address,pay_type,expiry_date,Pages,Price,Volume,S_Term,Budget_Head,Subs_Year,Issue_Year,Issue_Month,MonthIssue_No,ActIssueNo) VALUES('" + Currentdate + "','" + Acctime + "','" + strAccno1 + "','" + VarJrnCode + "','" + VarJrnName + "','','','" + StrIssueNo + "','" + Currentdate + "','" + Acctime + "','1','','No','Nil','No','" + lib_code + "','Available','" + StrActDate + "','','','','','','','','" + StrActDate + "','','','','','','" + SuYear + "','" + SuYear + "','" + StrActDate + "','" + MonthIssueNo + "','" + IssueNo + "')";
// sqlinsert += "UPDATE Journal_Issues SET Issue_Status ='" + strStatus + "' where journal_code ='" + VarJrnCode + "' and subs_year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "'";
// insert = d2.update_method_wo_parameter(sqlinsert, "Text");
// }
// }
// else
// {
// sqlinsert = "DELETE FROM Journal WHERE Journal_Code ='" + VarJrnCode + "' AND Subs_Year ='" + SuYear + "' AND Issue_No =" + IssueNo + " AND Issue_Month ='" + StrActDate + "'";
// sqlinsert = "UPDATE Journal_Issues SET Issue_Status ='" + strStatus + "' where journal_code ='" + VarJrnCode + "' and subs_year ='" + SuYear + "' AND IssueDate ='" + StrActDate + "' ";
// insert = d2.update_method_wo_parameter(sqlinsert, "Text");
// }
// }
// }
//}
}
}
}
//if (!chk)
//{
// alertpopwindow.Visible = true;
// lblalerterr.Text = "Please Select Atleast one Record";
//}
if (insert > 0)
{
alertpopwindow.Visible = true;
lblalerterr.Text = "Saved Sucessfully";
btngo_Click(sender, e);
}
}
//catch (Exception ex) { d2.sendErrorMail(ex, userCollegeCode, "News_Paper_Entry"); }
catch (Exception ex) { }
}
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");
}
}
protected void Generate_Click(object sender, EventArgs e)
{
try
{
lblerror.Visible = false;
DataSet ds = new DataSet();
string clgcode = Session["collegecode"].ToString();
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].Columns.Count = 5;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[0].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "From Digit";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[1].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "To Digit";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[2].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[3].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Prefix/Suffix";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Columns[4].Width = 130;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0BA6CB");
darkstyle.ForeColor = Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
int val = 0;
Int32.TryParse(txtsize.Text, out val);
string[] item = new string[0];
if (val > 0)
{
for (int v = 0; v <= val; v++)
{
Array.Resize(ref item, item.Length + 1);
item[item.Length - 1] = Convert.ToString(v);
}
}
FarPoint.Web.Spread.ComboBoxCellType dropdown1 = new FarPoint.Web.Spread.ComboBoxCellType();
string query = "select distinct MasterCode,MasterValue from CO_MasterValues where MasterCriteria='ApplicationNumberGeneration' and CollegeCode='" + clgcode + "'";
ds.Clear();
ds = d2.select_method_wo_parameter(query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
dropdown1.DataSource = ds;
dropdown1.DataTextField = "MasterValue";
dropdown1.DataValueField = "MasterCode";
}
dropdown1.AutoPostBack = false;
FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType();
string[] prefix = new string[2];
prefix[0] = "Prefix";
prefix[1] = "Suffix";
FarPoint.Web.Spread.ComboBoxCellType dropdown = new FarPoint.Web.Spread.ComboBoxCellType(item, item);
FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix);
FarPoint.Web.Spread.DoubleCellType txtserialNo = new FarPoint.Web.Spread.DoubleCellType();
btn.CssClass = "textbox btn";
btn.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton;
btn.Text = "+";
DataSet CodeGenDS = d2.select_method_wo_parameter(" select NumberType,NumberLength,ag.collegeCode,FRange,TRange,DifferentRange,HeaderCode, Case when convert(varchar(max), startNo)!=0 then convert(varchar(max),startNo) else (case when PrefixOrSufix=1 then 'Prefix' when PrefixOrSufix=2 then 'Suffix' end) end as PrefixOrSufix,GenerationNumber,NumberSize,upper(MasterValue) as type,startNo from AdmissionNoGeneration ag,CO_MasterValues m where ag.collegecode='" + Convert.ToString(ddlclg.SelectedItem.Value) + "' and ag.headercode=m.MasterCode and MasterCriteria='ApplicationNumberGeneration' order by frange,trange ", "text");//ag.collegecode=m.collegecode and
string Frange = string.Empty;
string Trange = string.Empty;
string HeaderCode = string.Empty;
string PrefixOrSufix = string.Empty;
string NumberSize = string.Empty;
string type = string.Empty;
int rangeDiff = 0;
int StartNo = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FpSpread1.Sheets[0].RowCount++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].RowCount);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = dropdown;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = dropdown;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
dropdown1.ShowButton = true;
dropdown1.AutoPostBack = true;
dropdown1.UseValue = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = dropdown1;
FpSpread1.Sheets[0].Columns[3].CellType = dropdown1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = dropdown2;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
if (CodeGenDS.Tables != null)//24.01.18 barath
{
if (i < CodeGenDS.Tables[0].Rows.Count)
{
if (CodeGenDS.Tables[0].Rows.Count > 0)
{
Frange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["FRange"]);
Trange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["TRange"]);
HeaderCode = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["HeaderCode"]);
PrefixOrSufix = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["PrefixOrSufix"]);
int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["DifferentRange"]), out rangeDiff);
int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["startNo"]), out StartNo);
NumberSize = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["GenerationNumber"]);
type = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["type"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Frange;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Trange;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = HeaderCode;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix;
if (type == "QUOTA")
{
btn.Text = "Quota Settings";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = btn;
}
else if (type == "SERIAL NO")
{
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txtserialNo;
//string sd = generateApplicationNumber(StartNo, rangeDiff);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix;
}
}
}
}
FpSpread1.SaveChanges();
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
FpSpread1.Height = 270;
FpSpread1.Width = 568;
FpSpread1.Visible = true;
btnSave.Visible = true;
}
catch (Exception ex)
{
}
}
protected void btn_go_OnClick(object sender, EventArgs e)
{
try
{
#region Order by
string orderby_Setting = d2.GetFunction("select value from master_Settings where settings='order_by'");
string strorder = ",len(r.roll_no)";
if (orderby_Setting == "0")
{
strorder = ",len(r.roll_no)";
}
else if (orderby_Setting == "1")
{
strorder = ",len(r.Reg_No)";
}
else if (orderby_Setting == "2")
{
strorder = ",r.Stud_Name";
}
else if (orderby_Setting == "0,1,2")
{
strorder = ",len(r.roll_no),len(r.Reg_No),r.stud_name";
}
else if (orderby_Setting == "0,1")
{
strorder = ",len(r.roll_no),len(r.Reg_No)";
}
else if (orderby_Setting == "1,2")
{
strorder = ",len(r.Reg_No),r.Stud_Name";
}
else if (orderby_Setting == "0,2")
{
strorder = ",len(r.roll_no),r.Stud_Name";
}
#endregion
//FarPoint.Web.Spread.TextCellType txt;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
string degreecode = rs.GetSelectedItemsValueAsString(cbl_degree);
string deptcode = rs.GetSelectedItemsValueAsString(cbl_branch);
string batchyear = ddl_batch.SelectedItem.Text;
//string sem = rs.GetSelectedItemsValueAsString(cbl_sem);
DateTime FromDate = new DateTime();
DateTime ToDate = new DateTime();
string[] fromdate = txtfromdate.Text.Split('/');
string[] todate = txttodate.Text.Split('/');
FromDate = Convert.ToDateTime(fromdate[1] + "/" + fromdate[0] + "/" + fromdate[2]);
ToDate = Convert.ToDateTime(todate[1] + "/" + todate[0] + "/" + todate[2]);
if (ddlCatogery.SelectedValue.ToString() == "1")
{
q1 = "select distinct R.Stud_Name ,r.Roll_no,R.Reg_No, Convert(varchar(10),R.batch_year)+' - '+ Convert(varchar(10),c.Course_name)+' - '+de.Acronym+' - '+Convert(varchar(10),R.current_semester) as Degreedet,Convert(varchar(20),re.readm_date,103) as ReadmittedDate ,Convert(varchar(10), re.newbatch_year) +' - ' + Convert(varchar(10),re.Readm_Semester) +' SEM' as ReadmittedSemester from Readmission re,REgistration R,Degree de,Department dep,Course c where R.App_No=re.App_No and c.Course_id=de.Course_id and de.college_code=c.college_code and dep.Dept_code=de.Dept_code and dep.college_code=de.college_code and R.college_code=dep.college_code and R.degree_code=de.Degree_code and c.Course_id IN ('" + degreecode + "') and R.batch_year in ('" + batchyear + "') and dep.dept_code in('" + deptcode + "') and re.Dis_Date between '" + FromDate.ToString("MM/dd/yyyy") + "' and '" + ToDate.ToString("MM/dd/yyyy") + "' and REadmitreason='2' "; //REadmitreason 1 for Prolong Absent Students
}
else if (ddlCatogery.SelectedValue.ToString() == "2")
{
q1 = "select distinct R.Stud_Name ,r.Roll_no,R.Reg_No, Convert(varchar(10),R.batch_year)+' - '+ Convert(varchar(10),c.Course_name)+' - '+de.Acronym+' - '+Convert(varchar(10),R.current_semester) as Degreedet,Convert(varchar(20),re.readm_date,103) as ReadmittedDate ,Convert(varchar(10), re.newbatch_year) +' - ' + Convert(varchar(10),re.Readm_Semester) +' SEM' as ReadmittedSemester from Readmission re,REgistration R,Degree de,Department dep,Course c where R.App_No=re.App_No and c.Course_id=de.Course_id and de.college_code=c.college_code and dep.Dept_code=de.Dept_code and dep.college_code=de.college_code and R.college_code=dep.college_code and R.degree_code=de.Degree_code and c.Course_id IN ('" + degreecode + "') and R.batch_year in ('" + batchyear + "') and dep.dept_code in('" + deptcode + "') and re.Dis_Date between '" + FromDate.ToString("MM/dd/yyyy") + "' and '" + ToDate.ToString("MM/dd/yyyy") + "' and REadmitreason='1' "; //REadmitreason 1 for Discontinued Students
}
//q1 += " order by " + strorder.TrimStart(',') + " ";
if (deptcode.Trim() != "" && degreecode.Trim() != "") //&& sem.Trim() != ""
{
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "Text");
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-130/Reg No-150/Degree Details-180/Readmitted Date-120/Semester-140/", FpSpread1, "FALSE");
rs.Fpreadheaderbindmethod("S.No/Student Name/Roll No/Reg No/Degree Details/Readmitted Date/Semester/", FpSpread1, "TRUE");
FpSpread1.Sheets[0].Rows.Count++;
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].Text = Convert.ToString(FpSpread1.Sheets[0].Rows.Count - 1);
// FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(dr["degree_code"]);
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;
}
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["Stud_Name"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["Roll_no"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Degreedet"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["ReadmittedDate"]);
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["ReadmittedSemester"]);
FarPoint.Web.Spread.TextCellType txtclType = new FarPoint.Web.Spread.TextCellType();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].CellType = txtclType;
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].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, 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].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].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].Columns[7].Visible = false;
}
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
lbl_error.Visible = false;
print.Visible = true;
}
else
{
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
else
{
FpSpread1.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "Please Select All Fields";
}
}
catch { }
}
protected void Generate_Go_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
lblerror.Visible = false;
FpSpread1.SaveChanges();
StringBuilder sb = new StringBuilder();
int finalValue = 0;
bool isValid = true;
string numberlength = Convert.ToString(txtsize.Text);
int FromRange = 0; int ToRange = 0;
int val = 0;
string FromRangeValue = string.Empty;
string ToRangeValue = string.Empty;
string clgdetailsvalue = string.Empty;
string pre_suffvalue = string.Empty;
string SerialNo = string.Empty;
if (rdb_applicationno.Checked == true)
{
val = 1;
}
if (rdb_admissionno.Checked == true)
{
val = 0;
}
bool insertBool = false;
string clgcode = "";
//for (int chk = 0; chk < chklstclgacr.Items.Count; chk++)
//{
isValid = true;
//if (chklstclgacr.Items[chk].Selected == true)
//{
for (int j = 0; j < FpSpread1.Sheets[0].RowCount; j++)
{
FromRangeValue = Convert.ToString(FpSpread1.Sheets[0].Cells[j, 1].Text).Trim();
ToRangeValue = Convert.ToString(FpSpread1.Sheets[0].Cells[j, 2].Text).Trim();
clgdetailsvalue = Convert.ToString(FpSpread1.Sheets[0].Cells[j, 3].Text).Trim();
pre_suffvalue = Convert.ToString(FpSpread1.Sheets[0].Cells[j, 4].Text).Trim();
SerialNo = string.Empty;
if (FromRangeValue != "" && ToRangeValue != "" && clgdetailsvalue != "")
{
int.TryParse(Convert.ToString(FpSpread1.Sheets[0].Cells[j, 1].Text).Trim(), out FromRange);
int.TryParse(Convert.ToString(FpSpread1.Sheets[0].Cells[j, 2].Text).Trim(), out ToRange);
if (ToRange < FromRange)
{
isValid = false;
sb.Append("Enter the Range Greater Than Start Range");
popup_alert.Visible = true;
lblerror.Visible = true;
lblerror.Text = sb.ToString();
return;
}
if (j > 0)
{
if (FromRange < finalValue)
{
isValid = false;
sb.Append("Enter the Range Greater than selected Row Value");
popup_alert.Visible = true;
lblerror.Visible = true;
lblerror.Text = sb.ToString();
return;
}
}
finalValue = ToRange;
}
}
for (int i = 0; i < FpSpread1.Sheets[0].RowCount; i++)
{
FromRangeValue = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 1].Text).Trim();
ToRangeValue = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 2].Text).Trim();
clgdetailsvalue = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 3].Text).Trim();
pre_suffvalue = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 4].Text).Trim();
SerialNo = string.Empty;
if (FromRangeValue != "" && ToRangeValue != "" && clgdetailsvalue != "")
{
int.TryParse(Convert.ToString(FpSpread1.Sheets[0].Cells[i, 1].Text).Trim(), out FromRange);
int.TryParse(Convert.ToString(FpSpread1.Sheets[0].Cells[i, 2].Text).Trim(), out ToRange);
if (ToRange < FromRange)
{
isValid = false;
sb.Append("Enter the Range Greater Than Start Range");
lblerror.Visible = true;
lblerror.Text = sb.ToString();
return;
}
if (i > 0)
{
if (FromRange < finalValue)
{
isValid = false;
sb.Append("Enter the Range Greater than selected Row Value");
lblerror.Visible = true;
lblerror.Text = sb.ToString();
return;
}
}
finalValue = ToRange;
string clgdetails = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 3].Text).Trim();
string pre_suff = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 4].Text).Trim();
string HeaderCode = Convert.ToString(FpSpread1.Sheets[0].Cells[i, 3].Value).Trim();
string PrefixOrSufix = string.Empty;
if (pre_suff.Trim().ToUpper() == "PREFIX")
{
PrefixOrSufix = "1";
}
else if (pre_suff.Trim().ToUpper() == "SUFFIX")
{
PrefixOrSufix = "2";
}
else
{
PrefixOrSufix = pre_suff;
}
if (clgdetails.Trim().ToLower() == "serial no")
{
SerialNo = PrefixOrSufix;
PrefixOrSufix = string.Empty;
}
if (clgdetails.Trim().ToLower() == "quota")
{
PrefixOrSufix = string.Empty;
}
if (FromRange < ToRange)
{
//clgcode = Convert.ToString(chklstclgacr.Items[chk].Value);
clgcode = Convert.ToString(ddlclg.SelectedItem.Value);
string query = "if exists(select * from AdmissionNoGeneration where collegeCode='" + clgcode + "' and HeaderCode='" + HeaderCode + "')update AdmissionNoGeneration set NumberType='" + val + "',NumberLength='" + numberlength + "',FRange='" + FromRange + "',TRange='" + ToRange + "',HeaderCode='" + HeaderCode + "',PrefixOrSufix='" + PrefixOrSufix + "',StartNo='" + SerialNo + "' where collegeCode='" + clgcode + "' and HeaderCode='" + HeaderCode + "' else insert into AdmissionNoGeneration(NumberType,NumberLength,FRange,TRange,HeaderCode,PrefixOrSufix,collegeCode,StartNo)values('" + val + "','" + numberlength + "','" + FromRange + "','" + ToRange + "', '" + HeaderCode + "','" + PrefixOrSufix + "','" + clgcode + "','" + SerialNo + "')";
int insert = d2.update_method_wo_parameter(query, "text");
if (insert != 0)
{
insertBool = true;
}
}
popup_alert.Visible = true;
lblerror.Visible = true;
lblerror.Text = "Saved Successfully";
}
//else
//{
// lblerror.Visible = false;
//}
}
// }
//}
}
