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; } }