protected void txtOrderbill_Click(object sender, EventArgs e)
{
grid();
decimal totalamt = 0;
foreach (GridViewRow gv in gdvNotice.Rows)
{
totalamt += decimal.Parse(gv.Cells[4].Text.ToString());
}
OrderBillMaster bm = new OrderBillMaster();
bm.OrderBILL_ID = OrderBillMaster.MaxId() + 1;
bm.BILLNO = bm.OrderBILL_ID.ToString();
bm.TOTAL = Math.Round(totalamt, 0);
bm.STATUS = "Send";
bm.BILLDATE = DateTime.Today.Date;
bm.REMARKS = null;
bm.LOGIN_ID = int.Parse(Session["PickupID"].ToString());
bm.Bil_Stutas = "Used";
bm.Extra_Payment = decimal.Parse(txtextra.Text);
bm.NO_OF_Items = txtNOPro.Text;
bm.Save();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Order Send Successfully...');</Script>", false);
PrintBill();
}
public void GetMaxbillid()
{
try
{
billid = OrderBillMaster.MaxId() + 1;
}
catch (Exception ew) { }
}
public void PrintBill()
{
try
{
List <OrderMaster> _bill = OrderMasterCollection.GetAll().FindAll(x => x.OrderBILL_ID == billid);
string BillNo = OrderBillMaster.GetByOrderBILL_ID(billid).BILLNO;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
this.ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("/Report/PickUpOrder.rdlc");
ReportDataSource datasource = new ReportDataSource("ProductOrder", _bill);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(datasource);
this.ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{ }
}
public void PrintBill()
{
try
{
int UserId = ddlUser.SelectedIndex;
List <ProductInvoice_Master> _bill = ProductInvoice_MasterCollection.GetAll().FindAll(x => x.BILL_ID == billid);
#region Company
string CompanyName = USERPROFILEMASTER.GetByRegistration_ID(1).First_Name;
string CompanyAddress = USERPROFILEMASTER.GetByRegistration_ID(1).Address;
string CompanyState = USERPROFILEMASTER.GetByRegistration_ID(1).StateName;
string CompanyCity = USERPROFILEMASTER.GetByRegistration_ID(1).CityName;
string ZipCode = USERPROFILEMASTER.GetByRegistration_ID(1).ZipCode;
string CompanyGST = USERPROFILEMASTER.GetByRegistration_ID(1).GstinVerified;
string CompanyContact = USERPROFILEMASTER.GetByRegistration_ID(1).ContactNumber;
#endregion
#region Seller
string ShipName = USERPROFILEMASTER.GetByRegistration_ID(UserId).First_Name + " " + USERPROFILEMASTER.GetByRegistration_ID(UserId).Last_Name;
string ShipAdd1 = USERPROFILEMASTER.GetByRegistration_ID(UserId).Address;
string ShipAdd2 = USERPROFILEMASTER.GetByRegistration_ID(UserId).AddressLine2;
string ShipCity = USERPROFILEMASTER.GetByRegistration_ID(UserId).CityName;
string ShipState = USERPROFILEMASTER.GetByRegistration_ID(UserId).StateName;
string ShipZip = USERPROFILEMASTER.GetByRegistration_ID(UserId).ZipCode;
string Contry = USERPROFILEMASTER.GetByRegistration_ID(UserId).COUNTRY;
string BillName = USERPROFILEMASTER.GetByRegistration_ID(UserId).First_Name + " " + USERPROFILEMASTER.GetByRegistration_ID(UserId).Last_Name;
string PermanentAdd1 = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingAddress;
string PermanentAdd2 = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingAddressLine2;
string PermanentCity = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShipCityName;
string PermanentState = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippStateName;
string PermanentZip = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingZip;
string Gstin = USERPROFILEMASTER.GetByRegistration_ID(UserId).GstinVerified;
#endregion
#region BillDetail
System.Guid guid = System.Guid.NewGuid();
String id = guid.ToString();
string OrderId = id;
DateTime dt = System.DateTime.Today;
string InvoiNo = "";
string InvoiDate = dt.ToString();
string Phone = USERPROFILEMASTER.GetByRegistration_ID(UserId).ContactNumber;
string Email = USERPROFILEMASTER.GetByRegistration_ID(UserId).Email;
#endregion
string BillNo = OrderBillMaster.GetByOrderBILL_ID(billid).BILLNO;
decimal totamt = Math.Round(ProductBill_Master.GetByBILL_ID(billid).TOTAL, 0);
var values = totamt.ToString(CultureInfo.InvariantCulture).Split('.');
Int64 rup = Convert.ToInt64(values[0]);
Int64 paise = 0;
if (values.Length == 2)
{
paise = Convert.ToInt64(values[1]);
}
string rupee = string.Empty;
string pa = string.Empty;
if (paise != 0)
{
pa = Rupees(paise) + "Paise Only";
rupee = Rupees(rup) + "Rupees and " + pa;
}
else
{
rupee = Rupees(rup) + "Rupees Only";
}
ReportViewer1.ProcessingMode = ProcessingMode.Local;
this.ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("/Report/PickUpOrder.rdlc");
ReportDataSource datasource = new ReportDataSource("BillGenrate", _bill);
//ReportParameter[] rpt = new ReportParameter[28];
//rpt[0] = new ReportParameter("CompanyName", CompanyName);
//rpt[1] = new ReportParameter("CompanyAddress", CompanyAddress);
//rpt[2] = new ReportParameter("CompanyState", CompanyState);
//rpt[3] = new ReportParameter("CompanyCity", CompanyCity);
//rpt[4] = new ReportParameter("ZipCode", ZipCode);
//rpt[5] = new ReportParameter("CompanyGST", CompanyGST);
//rpt[6] = new ReportParameter("CompanyContact", CompanyContact);
//rpt[7] = new ReportParameter("ShipName", ShipName);
//rpt[8] = new ReportParameter("ShipAdd1", ShipAdd1);
//rpt[9] = new ReportParameter("ShipAdd2", ShipAdd2);
//rpt[10] = new ReportParameter("ShipCity", ShipCity);
//rpt[11] = new ReportParameter("ShipState", ShipState);
//rpt[12] = new ReportParameter("ShipZip", ShipZip);
//rpt[13] = new ReportParameter("Contry", Contry);
//rpt[14] = new ReportParameter("BillName", BillName);
//rpt[15] = new ReportParameter("PermanentAdd1", PermanentAdd1);
//rpt[16] = new ReportParameter("PermanentAdd2", PermanentAdd2);
//rpt[17] = new ReportParameter("PermanentCity", PermanentCity);
//rpt[18] = new ReportParameter("PermanentState", PermanentState);
//rpt[19] = new ReportParameter("PermanentZip", PermanentZip);
//rpt[20] = new ReportParameter("Gstin", Gstin);
//rpt[21] = new ReportParameter("OrderId", OrderId);
//rpt[22] = new ReportParameter("InvoiNo", InvoiNo);
//rpt[23] = new ReportParameter("InvoiDate", InvoiDate);
//rpt[24] = new ReportParameter("Phone", Phone);
//rpt[25] = new ReportParameter("Email", Email);
//rpt[26] = new ReportParameter("TotalAmountWord", rupee);
//rpt[27] = new ReportParameter("@PaymentMod", "Wallet");
//this.ReportViewer1.LocalReport.SetParameters(rpt);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(datasource);
this.ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{ }
}