protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["TRAN_TYPE"] != null &&
Session["ACODE"] != null)
{
DataSet Subds = new DataSet();
DataTable DtFilterSub = new DataTable();
Subds = InventoryReport_Logiclayer.GetORDER_MASOutStandingDetailSubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
rprt.Load(Server.MapPath("~/ReportInventory/OrderMasterOutStandingMainReport.rpt"));
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
DataSet ds = new DataSet();
ds = InventoryReport_Logiclayer.GetORDER_MASDetailsFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Session["ACODE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
rprt.SetDataSource(ds.Tables[0]);
rprt.Subreports[0].SetDataSource(Subds.Tables[0]);
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy"));
CryRptStockOutstanding.Zoom(130);
CryRptStockOutstanding.ReportSource = rprt;
}
else
{
//LOgout Code
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["QUO_TYPE"] != null &&
Session["REPORT_TYPE"] != null)
{
if (Session["REPORT_TYPE"].ToString() == "DT_WS")
{
rprt.Load(Server.MapPath("~/ReportInventory/QuotationDateWiseReport.rpt"));
}
else if (Session["REPORT_TYPE"].ToString() == "PT_WS")
{
rprt.Load(Server.MapPath("~/ReportInventory/QuotationPartyWiseReport.rpt"));
}
if (string.IsNullOrEmpty(Session["ACODE"] as string))
{
Session["ACODE"] = "0";
}
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
DataSet ds = new DataSet();
// DataSet Subds = new DataSet();
ds = InventoryReport_Logiclayer.GetQUOTATION_MASDetailsFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Session["ACODE"].ToString() == null ? "0" : Session["ACODE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["QUO_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
// Subds = InventoryReport_Logiclayer.GetQUOTATION_MASDetailsFor_SubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
if ((ds.Tables.Count > 0))
{
rprt.SetDataSource(ds.Tables[0]);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy"));
}
CryRptQuotation.Zoom(120);
CryRptQuotation.ReportSource = rprt;
}
else
{
//LOgout Code
}
}
catch (Exception Ex)
{
Response.AppendToLog(Ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["TRAN_TYPE"] != null &&
Session["TRN_TYPE"] != null &&
Session["REPORT_TYPE"] != null)
{
if (Session["TRAN_TYPE"].ToString() == "D" && Session["TRN_TYPE"].ToString() == "P" && Session["REPORT_TYPE"].ToString() == "DT_WS_DETAILS")
{
rprt.Load(Server.MapPath("~/ReportInventory/DCDetailsDateWisePurchaseReport.rpt"));
}
else if (Session["TRAN_TYPE"].ToString() == "D" && Session["TRN_TYPE"].ToString() == "S" && Session["REPORT_TYPE"].ToString() == "DT_WS_DETAILS")
{
rprt.Load(Server.MapPath("~/ReportInventory/DCDetailsDateWiseSalesReport.rpt"));
}
else if (Session["TRAN_TYPE"].ToString() == "D" && Session["TRN_TYPE"].ToString() == "P" && Session["REPORT_TYPE"].ToString() == "PT_WS_DETAILS")
{
rprt.Load(Server.MapPath("~/ReportInventory/DCDetailsPartyWisePurchaseReport.rpt"));
}
else if (Session["TRAN_TYPE"].ToString() == "D" && Session["TRN_TYPE"].ToString() == "S" && Session["REPORT_TYPE"].ToString() == "PT_WS_DETAILS")
{
rprt.Load(Server.MapPath("~/ReportInventory/DCDetailsPartyWiseSalesReport.rpt"));
}
if (string.IsNullOrEmpty(Session["ACODE"] as string))
{
Session["ACODE"] = "0";
}
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
DataSet ds = new DataSet();
DataSet Subds = new DataSet();
DataTable Dt = new DataTable();
ds = InventoryReport_Logiclayer.GetINVENTORY_DC_MAS_DateWiseChallanForReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Session["ACODE"].ToString() == null ? "0" : Session["ACODE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["TRN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
Subds = InventoryReport_Logiclayer.GetINVENTORY_DC_MAS_Detail_DateWiseChallanForSubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
string HeadingRpt = "[ALL CHALLAN]";
Dt = ds.Tables[0];
DataView Dv = new DataView(Dt);
string FilterStr = string.Empty;
if (Session["VIEW_REPORT"].ToString() == "CNF" || Session["VIEW_REPORT"].ToString() == "NCNF")
{
if (Session["VIEW_REPORT"].ToString() == "CNF")
{
FilterStr = "ConfirmFlag='YES'";
HeadingRpt = "[CONFIRM CHALLAN]";
}
else
{
FilterStr = "ConfirmFlag='NO'";
HeadingRpt = "[NON-CONFIRM CHALLAN]";
}
}
else if (Session["VIEW_REPORT"].ToString() == "GBC" || Session["VIEW_REPORT"].ToString() == "NGB")
{
FilterStr = "GenerateBillFlag='" + Session["VIEW_REPORT"].ToString() + "'";
HeadingRpt = "[GENERATE BILL]";
if (Session["VIEW_REPORT"].ToString().Contains("N"))
{
HeadingRpt = "[NON-GENERATE BILL]";
}
}
else if (Session["VIEW_REPORT"].ToString() == "F" || Session["VIEW_REPORT"].ToString() == "C" || Session["VIEW_REPORT"].ToString() == "T")
{
FilterStr = "DC_TYPE='" + Session["VIEW_REPORT"].ToString() + "'";
HeadingRpt = "[FOC CHALLAN]";
if (Session["VIEW_REPORT"].ToString().Contains("C"))
{
HeadingRpt = "[CANCEL CHALLAN]";
}
else if (Session["VIEW_REPORT"].ToString().Contains("T"))
{
HeadingRpt = "[RETURNABLE CHALLAN]";
}
}
if (FilterStr != string.Empty)
{
Dv.RowFilter = FilterStr;
}
//ConfirmFlag DC_TYPE GenerateBillFlag
DataTable Dt1 = new DataTable();
Dt1 = Dv.ToTable();
rprt.SetDataSource(Dt1);
rprt.Subreports[0].SetDataSource(Subds.Tables[0]);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy"));
rprt.SetParameterValue("View_Report", HeadingRpt);
CryRptDCDetails.Zoom(120);
CryRptDCDetails.ReportSource = rprt;
}
else
{
//LOgout Code
}
}
catch (Exception Ex)
{
Response.AppendToLog(Ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["TRAN_TYPE"] != null &&
Session["REPORT_TYPE"] != null)
{
if (string.IsNullOrEmpty(Session["SCODE"] as string))
{
Session["SCODE"] = "0";
}
if (string.IsNullOrEmpty(Session["CAT_CODE"] as string))
{
Session["CAT_CODE"] = "0";
}
DataSet ds = new DataSet();
DataSet dsSub = new DataSet();
DataTable Dt = new DataTable();
string HeadingRpt = "[ALL CHALLAN]";
if (Session["REPORT_TYPE"].ToString() == "DT_WS")
{
rprt.Load(Server.MapPath("~/ReportInventory/BranchReceivedRegister_DateWiseReport.rpt"));
Session["BRANCH_CODE_VALUE"].ToString();
ds = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
// Check ReceivedFlag REC_FLAG From MasterTable
Dt = ds.Tables[0];
DataView Dv = new DataView(Dt);
string FilterStr = string.Empty;
if (Session["VIEW_REPORT"].ToString() == "CNF" || Session["VIEW_REPORT"].ToString() == "NCNF")
{
if (Session["VIEW_REPORT"].ToString() == "CNF")
{
FilterStr = "REC_FLAG='Yes'";
HeadingRpt = "[RECEIVED CHALLAN]";
}
else
{
FilterStr = "REC_FLAG='No'";
HeadingRpt = "[NON-RECEIVED CHALLAN]";
}
}
if (FilterStr != string.Empty)
{
Dv.RowFilter = FilterStr;
}
DataTable Dt1 = new DataTable();
Dt1 = Dv.ToTable();
// end
rprt.SetDataSource(Dt1);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR_END"].ToString()).ToString("dd-MM-yyyy"));
rprt.SetParameterValue("View_Report", HeadingRpt);
}
else if (Session["REPORT_TYPE"].ToString() == "DT_WS_DET")
{
rprt.Load(Server.MapPath("~/ReportInventory/BranchReceivedRegisterDetails_DateWiseReport.rpt"));
Session["BRANCH_CODE_VALUE"].ToString();
ds = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
dsSub = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_SubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
// Check ReceivedFlag REC_FLAG From MasterTable
Dt = ds.Tables[0];
DataView Dv = new DataView(Dt);
string FilterStr = string.Empty;
if (Session["VIEW_REPORT"].ToString() == "CNF" || Session["VIEW_REPORT"].ToString() == "NCNF")
{
if (Session["VIEW_REPORT"].ToString() == "CNF")
{
FilterStr = "REC_FLAG='Yes'";
HeadingRpt = "[RECEIVED CHALLAN]";
}
else
{
FilterStr = "REC_FLAG='No'";
HeadingRpt = "[NON-RECEIVED CHALLAN]";
}
}
if (FilterStr != string.Empty)
{
Dv.RowFilter = FilterStr;
}
DataTable Dt1 = new DataTable();
Dt1 = Dv.ToTable();
// end
rprt.SetDataSource(Dt1);
rprt.Subreports[0].SetDataSource(dsSub.Tables[0]);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR_END"].ToString()).ToString("dd-MM-yyyy"));
rprt.SetParameterValue("View_Report", HeadingRpt);
}
else if (Session["REPORT_TYPE"].ToString() == "BRANCH_WS")
{
rprt.Load(Server.MapPath("~/ReportInventory/BranchReceivedRegister_BranchWiseReport.rpt"));
Session["BRANCH_CODE_VALUE"].ToString();
ds = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
// Check ReceivedFlag REC_FLAG From MasterTable
Dt = ds.Tables[0];
DataView Dv = new DataView(Dt);
string FilterStr = string.Empty;
if (Session["VIEW_REPORT"].ToString() == "CNF" || Session["VIEW_REPORT"].ToString() == "NCNF")
{
if (Session["VIEW_REPORT"].ToString() == "CNF")
{
FilterStr = "REC_FLAG='Yes'";
HeadingRpt = "[RECEIVED CHALLAN]";
}
else
{
FilterStr = "REC_FLAG='No'";
HeadingRpt = "[NON-RECEIVED CHALLAN]";
}
}
if (FilterStr != string.Empty)
{
Dv.RowFilter = FilterStr;
}
DataTable Dt1 = new DataTable();
Dt1 = Dv.ToTable();
// end
rprt.SetDataSource(Dt1);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR_END"].ToString()).ToString("dd-MM-yyyy"));
rprt.SetParameterValue("View_Report", HeadingRpt);
}
else if (Session["REPORT_TYPE"].ToString() == "BRANCH_WS_DET")
{
rprt.Load(Server.MapPath("~/ReportInventory/BranchReceivedRegisterDetails_BranchWiseReport.rpt"));
Session["BRANCH_CODE_VALUE"].ToString();
ds = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
dsSub = InventoryReport_Logiclayer.GetBRANCH_RECEIVED_STK_RECMASFor_SubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
// Check ReceivedFlag REC_FLAG From MasterTable
Dt = ds.Tables[0];
DataView Dv = new DataView(Dt);
string FilterStr = string.Empty;
if (Session["VIEW_REPORT"].ToString() == "CNF" || Session["VIEW_REPORT"].ToString() == "NCNF")
{
if (Session["VIEW_REPORT"].ToString() == "CNF")
{
FilterStr = "REC_FLAG='Yes'";
HeadingRpt = "[RECEIVED CHALLAN]";
}
else
{
FilterStr = "REC_FLAG='No'";
HeadingRpt = "[NON-RECEIVED CHALLAN]";
}
}
if (FilterStr != string.Empty)
{
Dv.RowFilter = FilterStr;
}
DataTable Dt1 = new DataTable();
Dt1 = Dv.ToTable();
// end
rprt.SetDataSource(Dt1);
rprt.Subreports[0].SetDataSource(dsSub.Tables[0]);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR_END"].ToString()).ToString("dd-MM-yyyy"));
rprt.SetParameterValue("View_Report", HeadingRpt);
}
else
{
}
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
CryRptStockReceived.Zoom(120);
CryRptStockReceived.ReportSource = rprt;
}
else
{
//LOgout Code
}
}
catch (Exception Ex)
{
Response.AppendToLog(Ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["TRAN_TYPE"] != null &&
Session["ACODE"] != null)
{
if (Session["REPORT_VIEW"].ToString() == "1")
{
rprt.Load(Server.MapPath("~/ReportInventory/PurchaseOrderMainReport.rpt"));
}
else if (Session["REPORT_VIEW"].ToString() == "2")
{
rprt.Load(Server.MapPath("~/ReportInventory/PurchaseOrderPartyWiseMainReport.rpt"));
}
else
{
}
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
DataSet ds = new DataSet();
DataSet Subds = new DataSet();
ds = InventoryReport_Logiclayer.GetORDER_MASDetailsFor_MainReport(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Session["ACODE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
Subds = InventoryReport_Logiclayer.GetORDER_MASDetailsFor_SubReport(Session["CAT_CODE"] == null ? "0" : Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
if ((ds.Tables.Count > 0))
{
rprt.SetDataSource(ds.Tables[0]);
rprt.Subreports[0].SetDataSource(Subds.Tables[0]);
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy"));
}
CrystalReportOrderMaster.Zoom(120);
CrystalReportOrderMaster.ReportSource = rprt;
}
else
{
//LOgout Code
}
}
catch (Exception Ex)
{
Response.AppendToLog(Ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null)
{
if (Session["COMP_CODE"] != null &&
Session["USERCODE"] != null &&
Session["USERNAME"] != null &&
Session["USERTYPE"] != null &&
Session["COMP_CODE"] != null &&
Session["COMP_NAME"] != null &&
Session["WORK_VIEWFLAG"] != null &&
Session["BRANCH_CODE"] != null &&
Session["BRANCH_NAME"] != null &&
Session["BRANCH_TYPE"] != null &&
Session["FIN_YEAR"] != null &&
Session["FIN_YEAR_END"] != null &&
Session["FROM_DATE"] != null &&
Session["TO_DATE"] != null &&
Session["TRAN_TYPE"] != null &&
Session["TRN_TYPE"] != null &&
Session["REPORT_TYPE"] != null)
{
if (Session["REPORT_TYPE"].ToString() == "IT_WS_PT")
{
rprt.Load(Server.MapPath("~/ReportInventory/BillRegisterltemWise_PartyWiseReport.rpt"));
}
else if (Session["REPORT_TYPE"].ToString() == "PT_WS_IT")
{
rprt.Load(Server.MapPath("~/ReportInventory/BillRegisterlPartyWise_ItemWiseReport.rpt"));
}
else if (Session["REPORT_TYPE"].ToString() == "PT_WS_BILL")
{
rprt.Load(Server.MapPath("~/ReportInventory/BillRegisterlPartyWise_BillWiseReport.rpt"));
}
else
{
}
if (string.IsNullOrEmpty(Session["ACODE"] as string))
{
Session["ACODE"] = "0";
}
if (string.IsNullOrEmpty(Session["SCODE"] as string))
{
Session["SCODE"] = "0";
}
if (string.IsNullOrEmpty(Session["CAT_CODE"] as string))
{
Session["CAT_CODE"] = "0";
}
rprt.SetDatabaseLogon("veeradatabase", "Veera@welcome!1");
DataSet ds = new DataSet();
ds = InventoryReport_Logiclayer.GetREC_ISS_M_Sales_Purchase_For_Register_Report(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE_VALUE"].ToString(), Session["ACODE"].ToString() == null ? "0" : Session["ACODE"].ToString(), Convert.ToDateTime(Session["FROM_DATE"].ToString()), Convert.ToDateTime(Session["TO_DATE"].ToString()), Session["TRAN_TYPE"].ToString(), Session["TRN_TYPE"].ToString(), Session["CAT_CODE"].ToString(), Session["SCODE"] == null ? "0" : Session["SCODE"].ToString());
if ((ds.Tables.Count > 0))
{
rprt.SetDataSource(ds.Tables[0]);
rprt.SetParameterValue("Comp_Name", (Session["COMP_NAME"].ToString()));
rprt.SetParameterValue("Branch_Name", (Session["BRANCH_NAME"].ToString()));
rprt.SetParameterValue("UserName", (Session["USERNAME"].ToString()));
rprt.SetParameterValue("FromToDate", Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy") + " To " + Convert.ToDateTime(Session["FIN_YEAR"].ToString()).ToString("dd-MM-yyyy"));
}
CryRptRegister.Zoom(120);
CryRptRegister.ReportSource = rprt;
}
else
{
}
}
else
{
//LOgout Code
}
}
catch (Exception Ex)
{
Response.AppendToLog(Ex.ToString());
}
}
