protected void lblComp_Click(object sender, EventArgs e)
{
DtGrid = Lo.GetDashboardData("Company", "");
DataView dv = new DataView(DtGrid);
if (objCrypto.DecryptData(Session["Type"].ToString()) != "Admin" && objCrypto.DecryptData(Session["Type"].ToString()) != "SuperAdmin")
{
if (DtGrid.Rows.Count > 0)
{
//code to filter role wise
DataTable dtParentNode = Lo.RetriveParentNode(objCrypto.DecryptData(Session["Type"].ToString()).ToUpper(), Session["CompanyRefNo"].ToString());
if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "COMPANY")
{
dv.RowFilter = "CompanyRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "DIVISION")
{
dv.RowFilter = "CompanyRefNo='" + dtParentNode.Rows[0]["CompanyRefNo"].ToString() + "'";
}
else
{
dv.RowFilter = "CompanyRefNo='" + dtParentNode.Rows[0]["CompanyRefNo"].ToString() + "'";
}
}
}
try
{
int[] iColumns = { 1, 2, 6, 5, 7 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dv.ToTable(), iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "CompanyList.xls");
}
catch (Exception ex)
{
}
}
protected void btnexcelexport_Click(object sender, EventArgs e)
{
if (txtsearch.Text != "" || txtenddate.Text != "" || txtstartdate.Text != "")
{
SeachResult();
if (ViewState["mExcel"] != null)
{
DataTable msdt = (DataTable)ViewState["mExcel"];
int[] iColumns = { 0, 1, 2, 3, 4 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(msdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Intrested.xls");
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('No Record Found')", true);
}
}
else
{
DataTable dtm = new DataTable();
dtm = (DataTable)Session["TempData"];
int[] iColumns = { 0, 1, 2, 3, 4 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dtm, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Intrested.xls");
}
}
public string ExportDataTableToExcel(DataTable dtData, string ExcelName)
{
string isCreated = "";
try
{
string path = HttpContext.Current.Server.MapPath("~") + "//ExportExcel//";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string fullFileName = "";
fullFileName = path;
DateTime currenttime = Logger.getIndiantimeDT();
string FileName = ExcelName + "_" + currenttime.Ticks.ToString() + ".xls";
fullFileName += FileName;
if (fullFileName.Trim() != "")
{
// Export all the details to Excel
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
objExport.ExportDetails(dtData, RKLib.ExportData.Export.ExportFormat.Excel, fullFileName);
}
isCreated = FileName;
}
catch (Exception ex)
{
Logger.WriteCriticalLog("ExportToExcel 56: exception:" + ex.Message + "::::::::" + ex.StackTrace);
}
return(isCreated);
}
public void Exportexcel(DataTable dt)
{
try
{
int[] iColumns = { 0, 2, 4, 5, 10, 11, 16, 17, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 74 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "ProductList.xls");
}
catch (Exception ex)
{
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
DataTable searchdt = (DataTable)Session["ExcelDT"];
int[] iColumns = { 0, 1, 2, 3, 4, 5, 6, 7 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(searchdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "SO_No_Indig.xls");
}
catch (Exception ex)
{
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
DataTable searchdt = (DataTable)Session["ExcelDT"];
int[] iColumns = { 0, 3, 6, 12, 13, 15, 16, 23, 25, 26, 27 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(searchdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Make-II.xls");
}
catch (Exception ex)
{
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
DataTable searchdt = (DataTable)Session["ExcelDT"];
int[] iColumns = { 0, 3, 6, 18, 12, 28, 26, 20, 22, 14, 16 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(searchdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "SuccessStoryList.xls");
}
catch (Exception ex)
{
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
DataTable searchdt = (DataTable)Session["ExcelDT"];
int[] iColumns = { 1, 3, 9, 14, 6, 8, 15, 18, 20, 22, 23, 25, 26 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(searchdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "CategoryWiseReport.xls");
}
catch (Exception ex)
{
}
}
protected void btnexcel_Click(object sender, EventArgs e)
{
try
{
DataTable searchdt = (DataTable)Session["TempData"];
//DataTable dtnew == (DataTable)Session["PDatatTable"];
int[] iColumns = { 4, 5, 6, 15, 19, 20, 1, 21, 22 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(searchdt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "VendorList.xls");
}
catch (Exception ex)
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
ds = new DataSet();
objreport = new Base_BLL_Report_Collection();
string year = ddlyear.SelectedValue.ToString() + "-1-1";
ds = objreport.GetYearlyCollectionReport(year);
DataTable table = new DataTable();
table = ds.Tables[0];
if (table == null || table.Rows.Count == 0)
{
//clsJava.MessageBox("There is no records to export");
return;
}
int[] columnList =
{
table.Columns["FullName"].Ordinal,
table.Columns["LocalOutside"].Ordinal,
table.Columns["NewOld"].Ordinal,
table.Columns["TockenID"].Ordinal,
table.Columns["Fees"].Ordinal,
table.Columns["AppoinmentDateTime"].Ordinal,
table.Columns["InTime"].Ordinal,
table.Columns["Fees"].Ordinal,
};
string[] HeadingList =
{
"FullName",
"Local/Outside",
"New/Old",
"TockenId",
"Fees",
"AppoinmenmentDate",
"InTime",
"Fees",
};
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(table, columnList, HeadingList, RKLib.ExportData.Export.ExportFormat.Excel, "PatientsReport.xls");
}
protected void crtSubdomain_Click(object sender, ImageMapEventArgs e)
{
string[] pointData = e.PostBackValue.Split(',');
subdomain = pointData[0];
mRefNo.Value = subdomain.ToString();
DtGrid = Lo.GetDashboardData("ProdSearchNor", mRefNo.Value);
if (DtGrid.Rows.Count > 0)
{
try
{
int[] iColumns = { 2, 4, 6, 7, 9, 11, 18, 19, 20, 21, 22, 24, 25, 57, 60, 58, 59, 62, 61 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(DtGrid, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "ProductIndustryDomian.xls");
}
catch (Exception ex)
{
}
}
}
protected void gvnsngroupclass_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "exview")
{
string RefNo = e.CommandArgument.ToString();
DtGrid = Lo.GetDashboardData("ProdSearchNor", RefNo);
if (DtGrid.Rows.Count > 0)
{
try
{
int[] iColumns = { 2, 4, 6, 7, 9, 11, 18, 19, 20, 21, 22, 24, 25, 57, 60, 58, 59, 62, 63, 61 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(DtGrid, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "ProductNSNGROUPorClass.xls");
}
catch (Exception ex)
{
}
}
}
}
protected void lnkEmp_Click(object sender, EventArgs e)
{
DtGrid = Lo.GetDashboardData("Employee", "");
DataView dv = new DataView(DtGrid);
if (objCrypto.DecryptData(Session["Type"].ToString()) != "Admin" && objCrypto.DecryptData(Session["Type"].ToString()) != "SuperAdmin")
{
if (DtGrid.Rows.Count > 0)
{
this.UpdateDtGridValue();
// code to filter row role wise
if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "COMPANY")
{
dv.RowFilter = "CompanyRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "DIVISION")
{
dv.RowFilter = "FactoryRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else
{
dv.RowFilter = "UnitRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
}
}
dv.Sort = "CompanyName asc,FactoryName asc";
//renaming colm for user
dv.Table.Columns["Type"].ColumnName = "Role";
dv.Table.Columns["FactoryName"].ColumnName = "DivisionName";
try
{
int[] iColumns = { 1, 2, 3, 4, 8, 11, 14, 19 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dv.ToTable(), iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Employee.xls");
}
catch (Exception ex)
{
}
}
protected void lnkDiv_Click(object sender, EventArgs e)
{
DtGrid = Lo.GetDashboardData("Division", "");
DataView dv = new DataView(DtGrid);
if (objCrypto.DecryptData(Session["Type"].ToString()) != "Admin" && objCrypto.DecryptData(Session["Type"].ToString()) != "SuperAdmin")
{
if (DtGrid.Rows.Count > 0)
{
//code to filter role wise
DataTable dtParentNode = Lo.RetriveParentNode(objCrypto.DecryptData(Session["Type"].ToString()).ToUpper(), Session["CompanyRefNo"].ToString());
if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "COMPANY")
{
dv.RowFilter = "CompanyRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "DIVISION")
{
dv.RowFilter = "FactoryRefNo='" + dtParentNode.Rows[0]["FactoryRefNo"].ToString() + "'";
}
else
{
dv.RowFilter = "UnitRefNo='" + dtParentNode.Rows[0]["UnitRefNo"].ToString() + "'";
}
}
}
//renaming colm for user
dv.Table.Columns["FactoryRefNo"].ColumnName = "DivisionRefNo";
dv.Table.Columns["FactoryName"].ColumnName = "DivisionName";
try
{
int[] iColumns = { 2, 5, 4, 7, 9 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dv.ToTable(), iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Division.xls");
}
catch (Exception ex)
{
}
}
protected void lbitemdisapproveddown_Click(object sender, EventArgs e)
{
DtGrid = Lo.GetDashboardData("IsApprovedNo", Session["CompanyRefNo"].ToString());
DataView dv = new DataView(DtGrid);
// dv.RowFilter = "IsApproved='N'";
if (objCrypto.DecryptData(Session["Type"].ToString()) != "Admin" && objCrypto.DecryptData(Session["Type"].ToString()) != "SuperAdmin")
{
if (DtGrid.Rows.Count > 0)
{
this.UpdateDtGridValue();
// code to filter row role wise
if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "COMPANY")
{
dv.RowFilter = "CompanyRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else if (objCrypto.DecryptData(Session["Type"].ToString()).ToUpper() == "DIVISION")
{
dv.RowFilter = "FactoryRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
else
{
dv.RowFilter = "UnitRefNo='" + Session["CompanyRefNo"].ToString() + "'";
}
}
}
dv.Sort = "CompanyName asc,FactoryName asc";
//renaming colm for user
dv.Table.Columns["FactoryName"].ColumnName = "DivisionName";
DataTable DtFinalNew = dv.ToTable();
DtFinalNew.Columns.Add("Price-17", typeof(decimal));
DtFinalNew.Columns.Add("Price-18", typeof(decimal));
DtFinalNew.Columns.Add("Price-19", typeof(decimal));
DtFinalNew.Columns.Add("Price-20", typeof(decimal));
DtFinalNew.Columns.Add("Quan-17", typeof(int));
DtFinalNew.Columns.Add("Quan-18", typeof(int));
DtFinalNew.Columns.Add("Quan-19", typeof(int));
DtFinalNew.Columns.Add("Quan-20", typeof(int));
for (int i = 0; DtFinalNew.Rows.Count > i; i++)
{
DataTable dtEstimate1 = Lo.RetriveProductCode("", DtFinalNew.Rows[i]["ProductRefNo"].ToString(), "estimate", "");
if (dtEstimate1.Rows.Count > 0)
{
for (int es = 0; dtEstimate1.Rows.Count > es; es++)
{
if (dtEstimate1.Rows[es]["FYear"].ToString() == "2017-18" && dtEstimate1.Rows[es]["Type"].ToString() == "O")
{
DtFinalNew.Rows[i]["Price-17"] = dtEstimate1.Rows[es]["EstimatedPrice"].ToString();
DtFinalNew.Rows[i]["Quan-17"] = dtEstimate1.Rows[es]["EstimatedQty"].ToString();
}
if (dtEstimate1.Rows[es]["FYear"].ToString() == "2018-19" && dtEstimate1.Rows[es]["Type"].ToString() == "O")
{
DtFinalNew.Rows[i]["Price-18"] = dtEstimate1.Rows[es]["EstimatedPrice"].ToString();
DtFinalNew.Rows[i]["Quan-18"] = dtEstimate1.Rows[es]["EstimatedQty"].ToString();
}
if (dtEstimate1.Rows[es]["FYear"].ToString() == "2019-20" && dtEstimate1.Rows[es]["Type"].ToString() == "O")
{
DtFinalNew.Rows[i]["Price-19"] = dtEstimate1.Rows[es]["EstimatedPrice"].ToString();
DtFinalNew.Rows[i]["Quan-19"] = dtEstimate1.Rows[es]["EstimatedQty"].ToString();
}
if (dtEstimate1.Rows[es]["FYear"].ToString() == "2020-21" && dtEstimate1.Rows[es]["Type"].ToString() == "F")
{
DtFinalNew.Rows[i]["Price-20"] = dtEstimate1.Rows[es]["EstimatedPrice"].ToString();
DtFinalNew.Rows[i]["Quan-20"] = dtEstimate1.Rows[es]["EstimatedQty"].ToString();
}
DtFinalNew.Rows[i]["Max Value"] = dtEstimate1.Rows[es]["MaxValue"].ToString();
}
}
}
try
{
// int[] iColumns = { 10, 9, 4, 14, 18, 19, 20, 21, 22, 24, 25 };
int[] iColumns = { 13, 2, 4, 6, 7, 9, 11, 18, 19, 20, 21, 22, 24, 25, 27, 29, 31, 33, 35, 37, 39, 41, 43, 45, 47, 49, 51, 53, 55, 57, 60, 58, 59, 62, 61 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(DtFinalNew, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "Disapprove Product.xls");
}
catch (Exception ex)
{
}
}
public void SeachResult(string sortExpression = null)
{
try
{
DtFilterView = (DataTable)Session["TempData"];
if (DtFilterView.Rows.Count > 0)
{
DataView dv = new DataView(DtFilterView);
DataTable dtnew = dv.ToTable();
if (dtnew.Rows.Count > 0)
{
dv.RowFilter = BindInsertfilter();
DataTable dtinner = dv.ToTable();
if (dtinner.Rows.Count > 0)
{
lbltotal.Text = "Filter/Search Results " + dtinner.Rows.Count.ToString();
lbltotfilter.Text = dtinner.Rows.Count.ToString();
DataTable dtads = dv.ToTable();
if (dtads.Rows.Count > 0)
{
if (foruse == "Excle")
{
int[] iColumns = { 0, 1, 2, 3, 4, 5 };
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
objExport.ExportDetails(dtads, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "IssueFeedBack.xls");
}
else
{
pgsource.DataSource = dtinner.DefaultView;
pgsource.AllowPaging = true;
pgsource.PageSize = Convert.ToInt32(ddlpaging.SelectedItem.Value);
pgsource.CurrentPageIndex = pagingCurrentPage;
lblpaging.Text = "Page " + (pagingCurrentPage + 1) + " of " + pgsource.PageCount;
lnkbtnPgPrevious.Enabled = !pgsource.IsFirstPage;
LinkButton1.Enabled = !pgsource.IsFirstPage;
lnkbtnPgNext.Enabled = !pgsource.IsLastPage;
LinkButton2.Enabled = !pgsource.IsLastPage;
pgsource.DataSource = dtads.DefaultView;
if (ddlsort.SelectedItem.Value != "Sort by")
{
if (ddlsort.SelectedItem.Text == "DESC")
{
dtads.DefaultView.Sort = "desc";
}
else if (ddlsort.SelectedItem.Text == "ASC")
{
dtads.DefaultView.Sort = "asc";
}
}
else
{
dv.Sort = "RiseDate desc";
}
gvcase.DataSource = pgsource;
gvcase.DataBind();
lbltotalleft.Text = "Total :- " + DtFilterView.Rows.Count.ToString();
lbltotalshowpageitem.Text = pgsource.FirstIndexInPage + 1 + " - " + (pgsource.FirstIndexInPage + pgsource.Count);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('No Record Found')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('No Record Found')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('No Record Found')", true);
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
