protected void btnRep_Click(object sender, EventArgs e)
{
try
{
ReportsBL.ReportClass rpt = new ReportsBL.ReportClass();
divPrint.Visible = true;
DateTime startDate, endDate;
int iExecID = 0;
if (drpIncharge.SelectedItem != null)
{
iExecID = Convert.ToInt32(drpIncharge.SelectedItem.Value);
}
startDate = Convert.ToDateTime(txtStartDate.Text);
endDate = Convert.ToDateTime(txtEndDate.Text);
DataSet ds = new DataSet();
if (iExecID != 0)
{
ds = rpt.GenerateExecutiveSales(sDataSource, iExecID, startDate, endDate);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('No Executives Found')", true);
return;
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
gvSales.DataSource = ds;
gvSales.DataBind();
}
else
{
lblSales.Text = "0.00";
gvSales.DataSource = null;
gvSales.DataBind();
}
//ds = rpt.GenerateExecutiveSalesReturn(sDataSource, iExecID,startDate, endDate);
// if (ds != null && ds.Tables[0].Rows.Count > 0)
//{
//gvSalesReturn.DataSource = ds;
//gvSalesReturn.DataBind();
//}
// else
// {
// lblSalesReturn.Text = "0.00";
// gvSalesReturn.DataSource = null;
// gvSalesReturn.DataBind();
// }
lblSalesReturn.Text = "0.00";
Double bal = 0.0d;
bal = Convert.ToDouble(lblSales.Text) - Convert.ToDouble(lblSalesReturn.Text);
lblBalance.Text = bal.ToString("#0.00");
DataSet dsMain = rpt.GetLedgerExecutive(sDataSource, iExecID);
DataSet dsItem = new DataSet();
dsItem = rpt.GenerateSalesExecutiveItemwise(sDataSource, startDate, endDate, Convert.ToString(iExecID));
gvSalesItemwise.DataSource = dsItem;
gvSalesItemwise.DataBind();
//string ledgerID = string.Empty;
//if (dsMain != null)
//{
// if (dsMain.Tables[0].Rows.Count > 0)
// {
// foreach (DataRow maindr in dsMain.Tables[0].Rows)
// {
// if (maindr["LedgerID"] != null && maindr["LedgerID"].ToString() != "")
// {
// ledgerID = ledgerID + Convert.ToString(maindr["LedgerID"]) + ",";
// }
// }
// if (ledgerID != string.Empty)
// {
// ledgerID = ledgerID.Remove(ledgerID.LastIndexOf(',', ledgerID.Length - 1));
// dsItem = rpt.GenerateSalesExecutiveItemwise(sDataSource, startDate, endDate, ledgerID);
// gvSalesItemwise.DataSource = dsItem;
// gvSalesItemwise.DataBind();
// //dsItem = rpt.GenerateSalesReturnExecutiveItemwise(sDataSource, startDate, endDate, ledgerID);
// //gvSalesReturnItemwise.DataSource = dsItem;
// //gvSalesReturnItemwise.DataBind();
// double commision = 0;
// commision = Convert.ToDouble(lblTotalSalesComm.Text);//- Convert.ToDouble(hdSalesReturn.Value);
// lblTotalSalesComm.Text = commision.ToString("f2");
// }
// }
// else
// {
// gvSalesItemwise.DataSource = null;
// gvSalesItemwise.DataBind();
// gvSalesReturnItemwise.DataSource = null;
// gvSalesReturnItemwise.DataBind();
// }
//}
//else
//{
// gvSalesItemwise.DataSource = null;
// gvSalesItemwise.DataBind();
// gvSalesReturnItemwise.DataSource = null;
// gvSalesReturnItemwise.DataBind();
//}
div1.Visible = false;
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
sDataSource = ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
txtStartDate.Text = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToShortDateString();
DateTime indianStd = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "India Standard Time");
string dtaa = Convert.ToDateTime(indianStd).ToString("dd/MM/yyyy");
txtEndDate.Text = dtaa;
//txtEndDate.Text = DateTime.Now.ToShortDateString();
ReportsBL.ReportClass rpt = new ReportsBL.ReportClass();
divPrint.Visible = true;
DateTime startDate, endDate;
int iExecID = 0;
if (drpIncharge.SelectedItem != null)
{
iExecID = Convert.ToInt32(drpIncharge.SelectedItem.Value);
}
DateTime stdt = Convert.ToDateTime(txtStartDate.Text);
DateTime etdt = Convert.ToDateTime(txtEndDate.Text);
if (Request.QueryString["startDate"] != null)
{
stdt = Convert.ToDateTime(Request.QueryString["startDate"].ToString());
}
if (Request.QueryString["endDate"] != null)
{
etdt = Convert.ToDateTime(Request.QueryString["endDate"].ToString());
}
startDate = Convert.ToDateTime(stdt);
endDate = Convert.ToDateTime(etdt);
if (Request.QueryString["iExecID"] != null)
{
iExecID = Convert.ToInt32(Request.QueryString["iExecID"].ToString());
}
DataSet ds = new DataSet();
if (iExecID != 0)
{
ds = rpt.GenerateExecutiveSales(sDataSource, iExecID, startDate, endDate);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('No Executives Found')", true);
return;
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
gvSales.DataSource = ds;
gvSales.DataBind();
}
else
{
lblSales.Text = "0.00";
gvSales.DataSource = null;
gvSales.DataBind();
}
//ds = rpt.GenerateExecutiveSalesReturn(sDataSource, iExecID,startDate, endDate);
// if (ds != null && ds.Tables[0].Rows.Count > 0)
//{
//gvSalesReturn.DataSource = ds;
//gvSalesReturn.DataBind();
//}
// else
// {
// lblSalesReturn.Text = "0.00";
// gvSalesReturn.DataSource = null;
// gvSalesReturn.DataBind();
// }
lblSalesReturn.Text = "0.00";
Double bal = 0.0d;
bal = Convert.ToDouble(lblSales.Text) - Convert.ToDouble(lblSalesReturn.Text);
lblBalance.Text = bal.ToString("#0.00");
DataSet dsMain = rpt.GetLedgerExecutive(sDataSource, iExecID);
DataSet dsItem = new DataSet();
dsItem = rpt.GenerateSalesExecutiveItemwise(sDataSource, startDate, endDate, Convert.ToString(iExecID));
gvSalesItemwise.DataSource = dsItem;
gvSalesItemwise.DataBind();
//string ledgerID = string.Empty;
//if (dsMain != null)
//{
// if (dsMain.Tables[0].Rows.Count > 0)
// {
// foreach (DataRow maindr in dsMain.Tables[0].Rows)
// {
// if (maindr["LedgerID"] != null && maindr["LedgerID"].ToString() != "")
// {
// ledgerID = ledgerID + Convert.ToString(maindr["LedgerID"]) + ",";
// }
// }
// if (ledgerID != string.Empty)
// {
// ledgerID = ledgerID.Remove(ledgerID.LastIndexOf(',', ledgerID.Length - 1));
// dsItem = rpt.GenerateSalesExecutiveItemwise(sDataSource, startDate, endDate, ledgerID);
// gvSalesItemwise.DataSource = dsItem;
// gvSalesItemwise.DataBind();
// //dsItem = rpt.GenerateSalesReturnExecutiveItemwise(sDataSource, startDate, endDate, ledgerID);
// //gvSalesReturnItemwise.DataSource = dsItem;
// //gvSalesReturnItemwise.DataBind();
// double commision = 0;
// commision = Convert.ToDouble(lblTotalSalesComm.Text);//- Convert.ToDouble(hdSalesReturn.Value);
// lblTotalSalesComm.Text = commision.ToString("f2");
// }
// }
// else
// {
// gvSalesItemwise.DataSource = null;
// gvSalesItemwise.DataBind();
// gvSalesReturnItemwise.DataSource = null;
// gvSalesReturnItemwise.DataBind();
// }
//}
//else
//{
// gvSalesItemwise.DataSource = null;
// gvSalesItemwise.DataBind();
// gvSalesReturnItemwise.DataSource = null;
// gvSalesReturnItemwise.DataBind();
//}
div1.Visible = false;
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}