protected void dpAgent_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = new DataSet();
MarketingData marketingdata = new MarketingData();
int AgentID = Convert.ToInt32(dpAgent.SelectedItem.Value);
string AgentName = dpAgent.SelectedItem.Text;
ds = marketingdata.GetAgentInfoForSchemeRefund(AgentID);
if (!Comman.Comman.IsDataSetEmpty(ds))
{
double totalscheme;
totalscheme = Convert.ToDouble(string.IsNullOrEmpty(ds.Tables[0].Rows[0]["TotalSchemeAmount"].ToString()) ? string.Empty : ds.Tables[0].Rows[0]["TotalSchemeAmount"].ToString());
txtTotalSchemeAmt.Text = string.Format("{0:0.00}", totalscheme);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Scheme Not Available')", true);
dpAgent.ClearSelection();
txtTotalSchemeAmt.Text = string.Empty;
txtbalanceamt.Text = string.Empty;
txtrefundAmt.Text = string.Empty;
}
}
private void UpdateRecord(string agentId, int routeid, int categoryid, int typeid, int commodityid, string damagereplacementrate, bool isActive)
{
int result = 0;
MarketingData marketingdata = new MarketingData();
result = marketingdata.AddAgentDamageReplacementRateSetup(agentId, routeid, categoryid, typeid, commodityid, damagereplacementrate, isActive);
if (result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Rate Updated Successfully";
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
// GET: Marketing
public ActionResult Index()
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
try
{
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/Uploads/First"));
foreach (FileInfo fi in di.GetFiles())
{
ViewBag.extension1 = fi.Extension;
}
if (di.GetFiles().Count() == 0)
{
ViewBag.extension1 = "none";
}
DirectoryInfo di2 = new DirectoryInfo(Server.MapPath("~/Uploads/Second"));
foreach (FileInfo fi in di2.GetFiles())
{
ViewBag.extension2 = fi.Extension;
}
if (di2.GetFiles().Count() == 0)
{
ViewBag.extension2 = "none";
}
DirectoryInfo di3 = new DirectoryInfo(Server.MapPath("~/Uploads/Third"));
foreach (FileInfo fi in di3.GetFiles())
{
ViewBag.extension3 = fi.Extension;
}
if (di3.GetFiles().Count() == 0)
{
ViewBag.extension3 = "none";
}
DirectoryInfo di4 = new DirectoryInfo(Server.MapPath("~/Uploads/Fourth"));
foreach (FileInfo fi in di4.GetFiles())
{
ViewBag.extension4 = fi.Extension;
}
if (di4.GetFiles().Count() == 0)
{
ViewBag.extension4 = "none";
}
MarketingData md = new MarketingData();
List <Marketing> lst = md.GetMarketingData();
return(View(lst));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public async Task UpdateLocationAsync(MarketingData marketingData)
{
var filter = Builders <MarketingData> .Filter.Eq("UserId", marketingData.UserId);
var update = Builders <MarketingData> .Update
.Set("Locations", marketingData.Locations)
.CurrentDate("UpdateDate");
await _context.MarketingData
.UpdateOneAsync(filter, update, new UpdateOptions { IsUpsert = true });
}
protected void btnAddSchemeRefund_Click(object sender, EventArgs e)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Javascript", "javascript:Confirm(); ", true);
string confirmValue = Request.Form["confirm_value"];
start:
if (confirmValue == "Yes")
{
goto start;
}
{
marketingdata = new MarketingData();
marketing = new Marketings();
marketing.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
marketing.AgentID = Convert.ToInt32(dpAgent.SelectedItem.Value);
marketing.TotalSchemeAmt = Convert.ToDouble(txtTotalSchemeAmt.Text);
marketing.SchemerefundAmt = Convert.ToDouble(txtrefundAmt.Text);
marketing.balanceAmt = Convert.ToDouble(txtbalanceamt.Text);
marketing.requestdate = string.IsNullOrEmpty(txtrequesteddate.Text) ? string.Empty : (Convert.ToDateTime(txtrequesteddate.Text)).ToString("dd-MM-yyyy");
marketing.refunddate = string.IsNullOrEmpty(txtrefunddate.Text) ? string.Empty : (Convert.ToDateTime(txtrefunddate.Text)).ToString("dd-MM-yyyy");
marketing.CreatedBy = GlobalInfo.Userid;
marketing.TokanNo = hftokanno.Value;
int Result = 0;
Result = marketingdata.AddSchemeRefund(marketing);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = " SchemeRefund Added Successfully";
ClearTextBox();
BindSchemeRefundInfo();
btnPrint.Visible = true;
pnlError.Update();
upMain.Update();
//uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
btnPrint.Visible = false;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
public string Print()
{
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/Uploads/First"));
foreach (FileInfo fi in di.GetFiles())
{
ViewBag.extension1 = fi.Extension;
}
if (di.GetFiles().Count() == 0)
{
ViewBag.extension1 = "none";
}
DirectoryInfo di2 = new DirectoryInfo(Server.MapPath("~/Uploads/Second"));
foreach (FileInfo fi in di2.GetFiles())
{
ViewBag.extension2 = fi.Extension;
}
if (di2.GetFiles().Count() == 0)
{
ViewBag.extension2 = "none";
}
DirectoryInfo di3 = new DirectoryInfo(Server.MapPath("~/Uploads/Third"));
foreach (FileInfo fi in di3.GetFiles())
{
ViewBag.extension3 = fi.Extension;
}
if (di3.GetFiles().Count() == 0)
{
ViewBag.extension3 = "none";
}
DirectoryInfo di4 = new DirectoryInfo(Server.MapPath("~/Uploads/Fourth"));
foreach (FileInfo fi in di4.GetFiles())
{
ViewBag.extension4 = fi.Extension;
}
if (di4.GetFiles().Count() == 0)
{
ViewBag.extension4 = "none";
}
MarketingData md = new MarketingData();
List <Marketing> lst = md.GetMarketingData();
string s = new PageOrientations().RenderRazorViewToString(this, "Print", lst);
return(s);
}
public async Task UpdateLocationAsync(MarketingData marketingData)
{
var filter = Builders <MarketingData> .Filter.Eq("UserId", marketingData.UserId);
var update = Builders <MarketingData> .Update
.Set("Locations", marketingData.Locations)
.CurrentDate("UpdateDate");
await _context.MarketingData
.UpdateOneAsync(filter, update, new UpdateOptions { IsUpsert = true });
if (_cachingEnabled)
{
var item = new CacheItem(JsonConvert.SerializeObject(marketingData))
{
Expiration = new Expiration(ExpirationType.Absolute, TimeSpan.FromMinutes(_expirationTime))
};
await _cache.InsertAsync($"MarketingData:UserID:{marketingData.UserId}", item);
}
}
public ActionResult MarketingEdit(FormCollection form)
{
try
{
MarketingData md = new MarketingData();
List <Marketing> lstexisting = md.GetMarketingData();
List <Marketing> lst = new List <Marketing>();
Marketing obj = new Marketing();
obj.Type = form["Type1"];
obj.TypeValue = form["TypeValue1"];
obj.Kpi1 = form["Kpi11"];
obj.Kpi2 = form["kpi12"];
obj.Kpi3 = form["Kpi13"];
obj.Result1 = form["Result11"];
obj.Result2 = form["Result12"];
obj.Result3 = form["Result13"];
lst.Add(obj);
Marketing obj1 = new Marketing();
obj1.Type = form["Type2"];
obj1.TypeValue = form["TypeValue2"];
obj1.Kpi1 = form["Kpi21"];
obj1.Kpi2 = form["kpi22"];
obj1.Kpi3 = form["Kpi23"];
obj1.Result1 = form["Result21"];
obj1.Result2 = form["Result22"];
obj1.Result3 = form["Result23"];
lst.Add(obj1);
lst.Add(lstexisting[2]);
lst.Add(lstexisting[3]);
md.UpdateMarketingData(lst);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
public ActionResult MarketingEdit(bool?firstUploaded = false, bool?secondUploaded = false)
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
if (Session["roleid"].ToString() == "1" || Session["roleid"].ToString() == "5")
{
try
{
MarketingData md = new MarketingData();
List <Marketing> lst = md.GetMarketingData();
bool a = firstUploaded == true ? true : false;
bool b = secondUploaded == true ? true : false;
if (a)
{
ViewBag.message1 = "File Uploaded Successfully";
}
if (b)
{
ViewBag.message2 = "File Uploaded Successfully";
}
return(View(lst));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(View("Accessdenied"));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult MarketingEditSecond(FormCollection form)
{
try
{
MarketingData md = new MarketingData();
List <Marketing> lstexisting = md.GetMarketingData();
List <Marketing> lst = new List <Marketing>();
lst.Add(lstexisting[0]);
lst.Add(lstexisting[1]);
Marketing obj = new Marketing();
obj.Type = form["Type3"];
obj.TypeValue = form["TypeValue3"];
obj.Kpi1 = form["Kpi31"];
obj.Kpi2 = form["kpi32"];
obj.Kpi3 = form["Kpi33"];
obj.Result1 = form["Result31"];
obj.Result2 = form["Result32"];
obj.Result3 = form["Result33"];
lst.Add(obj);
Marketing obj1 = new Marketing();
obj1.Type = form["Type4"];
obj1.TypeValue = form["TypeValue4"];
obj1.Kpi1 = form["Kpi41"];
obj1.Kpi2 = form["kpi42"];
obj1.Kpi3 = form["Kpi43"];
obj1.Result1 = form["Result41"];
obj1.Result2 = form["Result42"];
obj1.Result3 = form["Result43"];
lst.Add(obj1);
md.UpdateMarketingData(lst);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
protected void btnViewDetails_Click(object sender, EventArgs e)
{
{
string result = string.Empty;
marketingdata = new MarketingData();
DS = new DataSet();
DS = marketingdata.ViewAgentListNotPlacedOrder((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value));
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
try
{
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["AgentID"] };
DS.Tables[1].PrimaryKey = new[] { DS.Tables[1].Columns["AgentID"] };
}
catch (Exception) { }
try
{
DS.Tables[1].Merge(DS.Tables[0], false, MissingSchemaAction.Add);
}
catch (Exception) { }
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
//sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<table class='tg style1' style=' position:relative;align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:160px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='3' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.PH:248370,248605 </b>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>");
sb.Append("<b><u>Agent List Not Placed Order </u></b> <br/>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
if (dpRoute.SelectedItem.Value == "0")
{
sb.Append("All Route");
}
else
{
sb.Append(dpRoute.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("Start Date:");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td>");
sb.Append("End Date:");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Sr.No.</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Agency Code</b>");
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append("<b>Agency Name</b>");
sb.Append("</td>");
sb.Append("</tr>");
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("RouteId");
dt.Columns.Add("AgentId");
dt.Columns.Add("AgentCode");
dt.Columns.Add("AgentName");
foreach (DataRow rows in DS.Tables[1].Rows)
{
DataRow dr = dt.NewRow();
if (rows["Available"].ToString() != "1")
{
dt.Rows.Add(rows["RouteID"], rows["AgentID"], rows["AgentCode"], rows["AgentName"]);
dt.Rows.Add(dr);
}
}
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "RouteId", "AgentId", "AgentCode", "AgentName");
int count = 0;
int routcount = 0;
foreach (DataRow rowr in DS.Tables[2].Rows)
{
routcount++;
sb.Append("<tr> ");
sb.Append("<td colsapn='4'> ");
sb.Append(" ");
sb.Append("</td>");
sb.Append("</tr> ");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='4'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
sb.Append(rowr["RouteCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append(rowr["RouteName"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
int srno = 0;
foreach (DataRow nagent in distinctValues.Rows)
{
if (rowr["RouteId"].ToString() == nagent["RouteId"].ToString())
{
count++;
srno++;
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(nagent["AgentCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append(nagent["AgentName"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='4'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("Total Route: ");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(routcount.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append("Agents not placed order:");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(count.ToString());
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
genratedBIll.Text = result;
//Session["ctrl"] = sb.ToString();
Session["ctrl"] = pnlBill;
//Response.Redirect("/print.aspx", true);
}
else
{
result = "New Agent List Not found";
genratedBIll.Text = result;
}
}
}
protected void btnViewDetails_Click(object sender, EventArgs e)
{
string result = string.Empty;
marketingdata = new MarketingData();
DS = new DataSet();
DS = marketingdata.ViewAgentSlabReportList((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpSlab.SelectedItem.Value), Convert.ToInt32(dpProductType.SelectedItem.Value));
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
try
{
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["AgentID"] };
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["AgentCode"] };
DS.Tables[1].PrimaryKey = new[] { DS.Tables[0].Columns["AgentID"] };
DS.Tables[1].PrimaryKey = new[] { DS.Tables[0].Columns["AgentCode"] };
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[1], false, MissingSchemaAction.Add);
}
catch (Exception) { }
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
//sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<table class='tg style1' style=' position:relative;align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:160px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='4' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append(" <br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>");
sb.Append("<b><u>AgentList Basis Of Slab Report</u> </b><br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
if (dpRoute.SelectedItem.Value == "0")
{
sb.Append("All Route");
}
else
{
sb.Append(dpRoute.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
if (dpSlab.SelectedItem.Value == "0")
{
sb.Append("All Slab");
}
else
{
sb.Append(dpSlab.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append(dpProductType.SelectedItem.Text);
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td colspan='6'> </td></tr>");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Sr.No.</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Agency Code</b>");
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append("<b>Agency Name</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>TotalQty.</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Average</b>");
sb.Append("</td>");
sb.Append("</tr>");
int srno = 0;
DateTime olddate = Convert.ToDateTime(txtStartDate.Text);
DateTime newdate = Convert.ToDateTime(txtEndDate.Text);
TimeSpan ts = newdate - olddate;
int differenceInDays = ts.Days + 1;
int routsno = 0;
double totalqty = 0;
double totalavg = 0;
foreach (DataRow rows in DS.Tables[2].Rows)
{
routsno++;
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='6'>");
sb.Append("<b>" + rows["SlabName"].ToString() + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
//sb.Append("<tr><td colspan='6'> </td></tr>");
//sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append(routsno.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + rows["RouteCode"].ToString() + "</b>");
sb.Append("</td>");
sb.Append("<td colspan = '4'>");
sb.Append("<b>" + rows["RouteName"].ToString() + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
double qty = 0;
double avg = 0;
double qty1 = 0;
double qty2 = 0;
double subtotalqty = 0;
double subtotalavg = 0;
int subcountsrno = 0;
foreach (DataRow row in DS.Tables[0].Rows)
{
if (row["AgentName"].ToString() != "" && rows["SlabID"].ToString() == row["SlabID"].ToString())
{
if (row["AgentName"].ToString() != "" && rows["RouteID"].ToString() == row["RouteID"].ToString())
{
srno++;
subcountsrno++;
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["AgentCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append(row["AgentName"].ToString());
sb.Append("</td>");
sb.Append("<td>");
try { qty1 = Convert.ToDouble(row["Quantity"]); } catch { qty1 = 0; }
try
{ qty2 = Convert.ToDouble(row["Quantity1"]); }
catch { qty2 = 0; }
qty = qty1 + qty2;
sb.Append(Convert.ToDecimal(qty).ToString("#.##"));
sb.Append("</td>");
sb.Append("<td>");
try
{
subtotalqty += qty;
totalqty += qty;
avg = qty / differenceInDays;
subtotalavg += avg;
totalavg += avg;
sb.Append(Convert.ToDecimal(avg).ToString("#.##"));
}
catch { sb.Append(" "); qty = 0; avg = 0; }
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan = '4'>");
sb.Append(subcountsrno.ToString());
sb.Append("</td>");
sb.Append("<td >");
sb.Append(Convert.ToDecimal(subtotalqty).ToString("#.##"));
sb.Append("</td>");
sb.Append("<td >");
sb.Append(Convert.ToDecimal(subtotalavg).ToString("#.##"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td colspan='6'> </td></tr>");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan = '4'>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td >");
sb.Append(Convert.ToDecimal(totalqty).ToString("#.##"));
sb.Append("</td>");
sb.Append("<td >");
sb.Append(Convert.ToDecimal(totalavg).ToString("#.##"));
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
genratedBIll.Text = result;
//Session["ctrl"] = sb.ToString();
Session["ctrl"] = pnlBill;
//Response.Redirect("/print.aspx", true);
}
else
{
result = "Report Not found";
genratedBIll.Text = result;
}
}
public void BindSchemeRefundInfo()
{
marketingdata = new MarketingData();
marketing = new Marketings();
DataSet DS = new DataSet();
marketing.AgentID = Convert.ToInt32(dpAgent.SelectedItem.Value);
marketing.CreatedBy = GlobalInfo.Userid;
marketing.TokanNo = hftokanno.Value;
DS = marketingdata.GetSchemeRefundInfo(marketing);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:150px'>");
sb.Append("<col style = 'width:150px'>");
sb.Append("<col style = 'width:120px'>");
sb.Append("<col style = 'width:120px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='2' style='text-align:center; font-size: 80%;'>");
sb.Append("<u> Scheme Refund </u> <br/>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' colspan='2' style='text-align:right; font-size: 80%;'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:Left'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt. Ph:248370, 248605</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan ='2' style='text-align:left; font-size: 80%;'>");
sb.Append("Scheme Refund");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(" ");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right; font-size: 80%;'>");
sb.Append("SchemeRefund No ");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan ='2' style='text-align:left; font-size: 80%;'>");
sb.Append(DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(" ");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right; font-size: 80%;'>");
sb.Append("<b>" + DS.Tables[0].Rows[0]["ID"] + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
//sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '5'> </td> </tr>");
sb.Append("<tr style='border-bottom:0.5px solid'>");
sb.Append("<td colspan='2'>");
sb.Append("Route" + " " + "<b>" + DS.Tables[0].Rows[0]["Route"] + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='5'>");
sb.Append("Agent" + " " + "<b>" + DS.Tables[0].Rows[0]["Agent"] + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:0.5px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("RequestDate");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("RefundDate");
sb.Append("</td>");
sb.Append("<td style='text-align:center'>");
sb.Append("TotalSchemeAmount");
sb.Append("</td>");
sb.Append("<td style='text-align:center'>");
sb.Append("RefundAmount");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("BalanceAmount");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:0.5px solid'>");
foreach (DataRow row in DS.Tables[0].Rows)
{
sb.Append("<td class='tg-yw4l' style='text-align:left'>");
sb.Append(row["RequestedDate"].ToString());
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:left'>");
sb.Append(row["RefundDate"].ToString());
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:center'>");
sb.Append(row["TotalSchemeAmt"].ToString());
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:center'>");
sb.Append(row["RefundAmt"].ToString());
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append(row["Balance"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:0.5px solid'>");
sb.Append("<td colspan='5'> ");
sb.Append("Approved By: " + "<b>" + DS.Tables[0].Rows[0]["Name"] + "</b>");
sb.Append("</td> ");
sb.Append("</tr>");
}
sb.Append("<tr>");
sb.Append("<td colspan='5' style='text-align:center >");
sb.Append(" Thanks, Visit Again...!!");
sb.Append("</td >");
sb.Append("</tr >");
result = sb.ToString();
genratedBIll.Text = result;
//Session["ctrl"] = sb.ToString();
Session["ctrl"] = pnlBills;
//Response.Redirect("/print.aspx", true);
}
else
{
//result = "No Records Found";
//genratedBIll.Text = result;
}
}
protected void btnViewDetails_Click(object sender, EventArgs e)
{
string result = string.Empty;
marketingdata = new MarketingData();
DS = new DataSet();
DS = marketingdata.ViewItemwisePurchaseAgentList((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpType.SelectedItem.Value), Convert.ToInt32(dpCommodity.SelectedItem.Value));
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
//sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<table class='tg style1' style=' position:relative;align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:160px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='2' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.PH:248370,248605 </b>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("GSTIN: 33AAECN2463R1Z2<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>");
sb.Append("<b><u>ItemWise Purchase Agent List</u> </b><br/>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
if (dpRoute.SelectedItem.Value == "0")
{
sb.Append("All Route");
}
else
{
sb.Append(dpRoute.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(DateTime.Now.ToString("dd-mm-yyyy HH:mm"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("Start Date: " + (Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("End Date: " + (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append(dpType.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append(dpCommodity.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Sr.No.</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Agency Code</b>");
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append("<b>Agency Name</b>");
sb.Append("</td>");
sb.Append("</tr>");
int srno = 0;
foreach (DataRow row in DS.Tables[0].Rows)
{
srno++;
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["AgentCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append(row["AgentName"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
result = sb.ToString();
genratedBIll.Text = result;
//Session["ctrl"] = sb.ToString();
Session["ctrl"] = pnlBill;
//Response.Redirect("/print.aspx", true);
}
else
{
result = "New Agent List Not found";
genratedBIll.Text = result;
}
}
protected void btnViewDetails_Click(object sender, EventArgs e)
{
string result = string.Empty;
marketingdatas = new MarketingData();
DS = new DataSet();
DS = marketingdatas.NewAgentListDetails((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpASO.SelectedItem.Value));
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
//sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<table class='tg style1' style=' position:relative;align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:160px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:120px'>");
sb.Append("<col style = 'width:120px'>");
sb.Append("<col style = 'width:120px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='5' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append(" <br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='5' style='text-align:center'>");
sb.Append("<b><u>New Agent List Report </u></b> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
if (dpRoute.SelectedItem.Value == "0")
{
sb.Append("Route : All");
}
else
{
sb.Append("");
}
sb.Append("</td>");
sb.Append("<td colspan='2'>");
if (dpASO.SelectedItem.Value == "0")
{
sb.Append("ASO : All");
}
else
{
sb.Append("ASO :" + dpASO.SelectedItem.Text.ToString());
}
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='4'>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("<b>Sr.No.</b>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center' >");
sb.Append("<b>Agency</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(" ");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>JoiningDate</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>CreatedBy</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Status</b>");
sb.Append("</td>");
sb.Append("</tr>");
int routcount = 0;
int count = 0;
foreach (DataRow rows in DS.Tables[1].Rows)
{
routcount++;
sb.Append("<tr> ");
sb.Append("<td colsapn='7'> ");
sb.Append(" ");
sb.Append("</td>");
sb.Append("</tr> ");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='7'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
sb.Append(rows["RouteCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '5'>");
sb.Append(rows["RouteName"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
int srno = 0;
foreach (DataRow row in DS.Tables[0].Rows)
{
if (rows["RouteId"].ToString() == row["RouteId"].ToString())
{
srno++;
count++;
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:center'>");
sb.Append(row["AgentCode"].ToString());
sb.Append("</td>");
sb.Append("<td colspan = '2'>");
sb.Append(row["AgentName"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["DateofJoining"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(row["Name"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
if (row["Isactive"].ToString() == "True")
{
sb.Append("Active");
}
else
{
sb.Append("InActive");
}
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr> ");
sb.Append("<td colsapn='7'> ");
sb.Append(" ");
sb.Append("</td>");
sb.Append("</tr> ");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='7'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
sb.Append("Total Route : ");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(routcount.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(" New Agents :");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(count.ToString());
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
genratedBIll.Text = result;
Session["ctrl"] = pnlBill;
}
else
{
result = "New Agent List Not found";
genratedBIll.Text = result;
}
}
protected void btnViewDetails_Click(object sender, EventArgs e)
{
int flag;
if (chkAmt.Checked)
{
flag = 0;
}
else
{
flag = 1;
}
DateTime olddate = Convert.ToDateTime(txtStartDate.Text);
DateTime newdate = Convert.ToDateTime(txtEndDate.Text);
TimeSpan ts = newdate - olddate;
int differenceInDays = ts.Days + 1;
string result = string.Empty;
DS = new DataSet();
marketingdata = new MarketingData();
double startamt = 0;
double endamt = 0;
try {
startamt = Convert.ToDouble(txtStartAmt.Text);
endamt = Convert.ToDouble(txtEndAmt.Text);
} catch { startamt = 0; endamt = 0; }
DS = marketingdata.AmountwiseIceCreamReport((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpType.SelectedItem.Value), Convert.ToInt32(dpCommodity.SelectedItem.Value), startamt, endamt, flag);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
try
{
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[1].PrimaryKey = new[] { DS.Tables[1].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[1], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DataView view = new DataView(DS.Tables[0]);
var strExpr = string.Empty;
if (flag == 1)
{
try
{
strExpr = "TotalBill >= " + @startamt + " AND TotalBill <= " + @endamt;
view.RowFilter = strExpr;
}
catch { }
}
else
{
try
{
strExpr = string.Empty;
view.RowFilter = strExpr;
}
catch { }
}
DataTable DefaultView = view.ToTable();
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }");
sb.Append(".tg .tg-yw4l{vertical-align:top}");
sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}");
sb.Append("</style>");
//sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<table class='tg style1' style=' position:relative;align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:200px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='3' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.PH:248370,248605 </b>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("GSTIN: 33AAECN2463R1Z2<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>");
sb.Append("<b><u>Amountwise Product Type Purchase Agents</u></b> <br/>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
if (dpRoute.SelectedItem.Value == "0")
{
sb.Append("All Route");
}
else
{
sb.Append(dpRoute.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
if (dpType.SelectedItem.Value == "0")
{
sb.Append("All Product Type");
}
else
{
sb.Append(dpType.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
if (dpCommodity.SelectedItem.Value == "0")
{
sb.Append("All Commodity");
}
else
{
sb.Append(dpCommodity.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append(" StartDate: " + (Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(" EndDate: " + (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
if (chkAmt.Checked)
{
sb.Append("<td colspan='5 ' style='text-align:center'>");
sb.Append("<b> All Amount</b>");
sb.Append("</td>");
}
else
{
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append(" Start Amount : " + txtStartAmt.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(" End Amount : " + txtEndAmt.Text.ToString());
sb.Append("</td>");
}
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Sr.No.</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Agency Code</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>Agency Name</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Average</b>");
sb.Append("</td>");
sb.Append("</tr>");
int count = 0;
double totalamt = 0;
double totalavg = 0;
foreach (DataRow row in DefaultView.Rows)
{
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '5'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("<b>" + row["RouteCode"].ToString() + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='4' style='text-align:right'>");
sb.Append("<b>" + row["RouteName"].ToString() + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
int srno = 0;
foreach (DataRow rows in DefaultView.Rows)
{
if (row["RouteID"].ToString() == rows["RouteID"].ToString())
{
srno++;
count++;
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(srno.ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(rows["AgentCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(rows["AgentName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
double amt1;
try { amt1 = Convert.ToDouble(rows["TotalBill"]); } catch { amt1 = 0; };
totalamt += amt1;
sb.Append(Convert.ToDecimal(amt1).ToString("#.##"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
double avg1;
avg1 = amt1 / differenceInDays;
totalavg += avg1;
sb.Append(Convert.ToDecimal(avg1).ToString("#.##"));
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '5'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append(count.ToString());
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(Convert.ToDecimal(totalamt).ToString("#.##"));
sb.Append("</td>");
sb.Append("<td colspan='3' style='text-align:right'>");
sb.Append(Convert.ToDecimal(totalavg).ToString("#.##"));
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
genratedBIll.Text = result;
//Session["ctrl"] = sb.ToString();
Session["ctrl"] = pnlBill;
//Response.Redirect("/print.aspx", true);
}
catch (Exception) {
result = "Report Not found";
genratedBIll.Text = result;
}
}
else
{
result = "Report Not found";
genratedBIll.Text = result;
}
}
