protected void Page_Load(object sender, EventArgs e)
{
hdApiUrl.Value = WebConfigurationManager.AppSettings["APIURL"].ToString();
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(CPublic.GetLocationID());
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationId = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.SalesRequestRegister sr = new Entities.Register.SalesRequestRegister();
sr = Entities.Register.SalesRequestRegister.GetDetails(id, locationId);
dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationId);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblCustName.Text = sr.CustomerName;
lblComp.Text = sr.Company;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCompGst.Text = c.RegId1;
lblCompEmail.Text = c.Email;
lblCustPhone.Text = sr.BillingAddress[0].Phone1;
lblLocName.Text = sr.Location;
lblLocAddr1.Text = sr.LocationAddress1;
lblLocAddr2.Text = sr.LocationAddress2;
lblLocPhone.Text = sr.LocationPhone;
lblDate.Text = sr.EntryDateString;
lblInvoiceNo.Text = sr.RequestNo;
lblTax.Text = Convert.ToString(sr.TaxAmount);
lblGross.Text = Convert.ToString(sr.Gross);
lblroundOff.Text = Convert.ToString(sr.RoundOff);
lblNet.Text = Convert.ToString(sr.NetAmount);
tAndC.Text = sr.TermsandConditon; //Entities.Application.Settings.GetSetting(127);
for (int i = 0; i < sr.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
TableCell t2 = new TableCell();
t2.Text = sr.Products[i].ItemCode;
r.Cells.Add(t2);
TableCell t3 = new TableCell();
t3.Text = sr.Products[i].Name;
r.Cells.Add(t3);
TableCell t4 = new TableCell();
t4.Text = sr.Products[i].Quantity.ToString();
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = sr.Products[i].MRP.ToString();
r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sr.Products[i].SellingPrice.ToString();
r.Cells.Add(t6);
TableCell t7 = new TableCell();
t7.Text = sr.Products[i].TaxPercentage.ToString();
r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = sr.Products[i].Gross.ToString();
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = sr.Products[i].TaxAmount.ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = sr.Products[i].NetAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Request | Page_Load(object sender, EventArgs e) ");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationid = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.PurchaseQuoteRegister pq = new Entities.Register.PurchaseQuoteRegister();
pq = Entities.Register.PurchaseQuoteRegister.GetDetails(id, locationid);
dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationid);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblSupName.Text = pq.Supplier;
lblComp.Text = pq.Company;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCompEmail.Text = c.Email;
lblCompGst.Text = c.RegId1;
lblSupPhone.Text = pq.BillingAddress[0].Phone1;
lblLocName.Text = pq.Location;
lblLocAddr1.Text = pq.LocationAddress1;
lblLocAddr2.Text = pq.LocationAddress2;
lblLocPhone.Text = pq.LocationPhone;
lblDate.Text = pq.EntryDateString;
lblInvoiceNo.Text = pq.QuoteNumber;
lblTax.Text = Convert.ToString(pq.TaxAmount);
lblGross.Text = Convert.ToString(pq.Gross);
lblroundOff.Text = Convert.ToString(pq.RoundOff);
lblNet.Text = Convert.ToString(pq.NetAmount);
tAndC.Text = Entities.Application.Settings.GetSetting(118);
for (int i = 0; i < pq.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
TableCell t2 = new TableCell();
t2.Text = pq.Products[i].ItemCode;
r.Cells.Add(t2);
if (settings.EnableDescription)
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += pq.Products[i].Name;
itemName += "</b><br/>";
itemName += pq.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = pq.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = pq.Products[i].Quantity.ToString();
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = pq.Products[i].MRP.ToString();
r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = pq.Products[i].CostPrice.ToString();
r.Cells.Add(t6);
TableCell t7 = new TableCell();
t7.Text = pq.Products[i].Gross.ToString();
r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = pq.Products[i].TaxPercentage.ToString();
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = pq.Products[i].TaxAmount.ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = pq.Products[i].NetAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "quote | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationid = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.WareHousing.Damage d = new Entities.WareHousing.Damage();
d = Entities.WareHousing.Damage.GetDetails(id, locationid);
dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationid);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblCompAddr1.Text = c.Address1;
lblComp.Text = c.Name;
lblCompEmail.Text = c.Email;
lblCompPh.Text = c.Address1;
lblLocName.Text = d.Location;
lblLocAddr1.Text = d.LocationAddress1;
lblLocAddr2.Text = d.LocationAddress2;
lblLocPhone.Text = d.LocationPhone;
lblDate.Text = d.EntryDateString;
lblInvoiceNo.Text = d.DamageNo;
lblGross.Text = Convert.ToString(d.Gross);
lblTax.Text = Convert.ToString(d.TaxAmount);
lblroundOff.Text = Convert.ToString(d.RoundOff);
lblNet.Text = Convert.ToString(d.NetAmount);
tAndC.Text = Entities.Application.Settings.GetSetting(147);
for (int i = 0; i < d.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
TableCell t2 = new TableCell();
t2.Text = d.Products[i].Name;
r.Cells.Add(t2);
TableCell t3 = new TableCell();
t3.Text = d.Products[i].ItemCode;
r.Cells.Add(t3);
TableCell t4 = new TableCell();
t4.Text = d.Products[i].Quantity.ToString();
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = d.Products[i].MRP.ToString();
r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = d.Products[i].CostPrice.ToString();
r.Cells.Add(t6);
TableCell t7 = new TableCell();
t7.Text = d.Products[i].Gross.ToString();
r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = d.Products[i].TaxPercentage.ToString();
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = d.Products[i].TaxAmount.ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = d.Products[i].TaxAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationId = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.SalesEstimate sq = new Entities.Register.SalesEstimate();
sq = Entities.Register.SalesEstimate.GetDetails(id, locationId);
dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationId);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblCustName.Text = sq.CustomerName;
lblComp.Text = sq.Company;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCompGst.Text = c.RegId1;
lblCompEmail.Text = sq.CompanyEmail;
lblCustPhone.Text = sq.BillingAddress[0].Phone1;
lblLocName.Text = sq.Location;
lblLocAddr1.Text = sq.LocationAddress1;
lblLocAddr2.Text = sq.LocationAddress2;
lblLocPhone.Text = sq.LocationPhone;
lblDate.Text = sq.EntryDateString;
lblCompName.Text = sq.Company;
lblInvoiceNo.Text = sq.EstimateNumber;
lblTax.Text = Convert.ToString(sq.TaxAmount);
lblGross.Text = Convert.ToString(sq.Gross);
lblroundOff.Text = Convert.ToString(sq.RoundOff);
lblNet.Text = Convert.ToString(sq.NetAmount);
lblAmountinWords.Text = NumberToWords(Convert.ToDouble(sq.NetAmount));
tAndC.Text = sq.TermsandConditon;/*Entities.Application.Settings.GetSetting(149);*/
lblPaymentTerms.Text = sq.Payment_Terms;
lblValidity.Text = sq.Validity;
lblProjectName.Text = sq.JobName;
lblCompletion.Text = sq.ETA;
for (int i = 0; i < sq.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
//TableCell t2 = new TableCell();
//t2.Text = sq.Products[i].ItemCode;
//r.Cells.Add(t2);
//TableCell t3 = new TableCell();
//t3.Text = sq.Products[i].Name;
//r.Cells.Add(t3);
if (setting.EnableDescription)//Enabled Description
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += sq.Products[i].Name;
itemName += "</b><br/>";
itemName += sq.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = sq.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = sq.Products[i].Quantity.ToString();
r.Cells.Add(t4);
//TableCell t5 = new TableCell();
//t5.Text = sq.Products[i].MRP.ToString();
//r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sq.Products[i].SellingPrice.ToString();
r.Cells.Add(t6);
//TableCell t7 = new TableCell();
//t7.Text = sq.Products[i].TaxPercentage.ToString();
//r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = sq.Products[i].Gross.ToString();
r.Cells.Add(t8);
//TableCell t9 = new TableCell();
//t9.Text = sq.Products[i].TaxAmount.ToString();
//r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = sq.Products[i].NetAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Estimate | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationId = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
string invoicetype = "";
try
{
invoicetype = Request.QueryString["invoicetype"].ToString();
}
catch (Exception)
{
}
Entities.Register.SalesDeliveryNote sr = new Entities.Register.SalesDeliveryNote();
sr = Entities.Register.SalesDeliveryNote.GetDetails(id, locationId);
dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationId);
lblCompRegNo.Text = c.RegId1;
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
//lblCustName.Text = sr.Customer;
lblCustomer.Text = sr.CustomerName;
lblCustomerAddress1.Text = sr.BillingAddress[0].Address1;
lblCustomerAddress2.Text = sr.BillingAddress[0].Address2;
lblCustPh.Text = sr.BillingAddress[0].Phone1;
lblCustEmail.Text = sr.BillingAddress[0].Email;
lblCustTRN.Text = sr.CustomerTaxNo;
lblComp.Text = sr.Company;
lblTerms.Text = sr.TermsandConditon;
lblJob.Text = sr.JobName;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCompEmail.Text = c.Email;
lblCustPhone.Text = sr.BillingAddress[0].Phone1;
lblCompanyEmail.Text = c.Email;
lblLocName.Text = sr.Location;
lblLocAddr1.Text = sr.LocationAddress1;
lblLocAddr2.Text = sr.LocationAddress2;
lblWords.Text = NumberToWords(Convert.ToDouble(sr.NetAmount));
//lblCustName.Text = sr.Customer;
//lblDiscount.Text = Convert.ToString(sr.Discount);
//lblFreight.Text = Convert.ToString(sr.FreightAmount);
lblLocPhone.Text = sr.LocationPhone;
lblDate.Text = sr.EntryDateString;
lblInvoiceNo.Text = sr.DeliveryNoteNumber;
lblTax.Text = Convert.ToString(sr.TaxAmount);
lblGross.Text = Convert.ToString(sr.Gross);
lblroundOff.Text = Convert.ToString(sr.RoundOff);
//lblNet.Text = Convert.ToString(sr.NetAmount);
lblAmountinWords.Text = Convert.ToString(sr.NetAmount);
lblComp.Text = sr.Company;
//lblDuedate.Text = sr.EntryDateString;
lblCompanyPhone.Text = c.OfficeNo;
//lblAddress.Text = sr.CustomerAddress;
//lblCustName.Text = sr.Customer;
lblCustPhone.Text = sr.BillingAddress[0].Phone1;
//lblTfn.Text = sr.CustomerTaxNo;
lblProjectName.Text = sr.JobName;
lblDeduction.Text = Convert.ToString(sr.Discount);
lblMainHead.Text = "Delivery Note";
//lblTrn.Text = sr.CustomerTaxNo;
tAndC.Text = sr.TermsandConditon; //Entities.Application.Settings.GetSetting(148);
if (invoicetype == "delivery")
{
thRate.Visible = false;
thTotal.Visible = false;
for (int i = 0; i < sr.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
//TableCell t2 = new TableCell();
//t2.Text = sr.Products[i].ItemCode;
//r.Cells.Add(t2);
if (setting.EnableDescription)//Enabled Description
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += sr.Products[i].Name;
itemName += "</b><br/>";
itemName += sr.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = sr.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = sr.Products[i].Quantity.ToString();
t4.Style.Add("text-align", "right");
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = sr.Products[i].Unit.ToString();
t5.Style.Add("text-align", "right");
r.Cells.Add(t5);
//TableCell t5 = new TableCell();
//t5.Text = sr.Products[i].MRP.ToString();
//r.Cells.Add(t5);
//TableCell t6 = new TableCell();
//t6.Text = sr.Products[i].SellingPrice.ToString();
//r.Cells.Add(t6);
//TableCell t7 = new TableCell();
//t7.Text = sr.Products[i].TaxPercentage.ToString();
//r.Cells.Add(t7);
//TableCell t8 = new TableCell();
//t8.Text = sr.Products[i].Gross.ToString();
//r.Cells.Add(t8);
//TableCell t9 = new TableCell();
//t9.Text = sr.Products[i].TaxAmount.ToString();
//r.Cells.Add(t9);
//TableCell t10 = new TableCell();
//t10.Text = sr.Products[i].NetAmount.ToString();
//r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
else
{
for (int i = 0; i < sr.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
//TableCell t2 = new TableCell();
//t2.Text = sr.Products[i].ItemCode;
//r.Cells.Add(t2);
if (setting.EnableDescription)//Enabled Description
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += sr.Products[i].Name;
itemName += "</b><br/>";
itemName += sr.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = sr.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = sr.Products[i].Quantity.ToString();
t4.Style.Add("text-align", "right");
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = sr.Products[i].Unit.ToString();
t5.Style.Add("text-align", "right");
r.Cells.Add(t5);
//TableCell t5 = new TableCell();
//t5.Text = sr.Products[i].MRP.ToString();
//r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sr.Products[i].CostPrice.ToString();
t6.Style.Add("text-align", "right");
r.Cells.Add(t6);
//TableCell t7 = new TableCell();
//t7.Text = sr.Products[i].TaxPercentage.ToString();
//r.Cells.Add(t7);
//TableCell t8 = new TableCell();
//t8.Text = sr.Products[i].Gross.ToString();
//r.Cells.Add(t8);
//TableCell t9 = new TableCell();
//t9.Text = sr.Products[i].TaxAmount.ToString();
//r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = sr.Products[i].Gross.ToString();
t10.Style.Add("text-align", "right");
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
TableFooterRow tf = new TableFooterRow();
TableFooterRow TaxAmountcell = new TableFooterRow();
TableFooterRow SubTotal = new TableFooterRow();
tf.CssClass = "inv-footer beige";
TaxAmountcell.CssClass = "inv-footer beige";
SubTotal.CssClass = "inv-footer ";
TableCell tfc1 = new TableCell();
tfc1.Text = "<b>VAT AMOUNT</b>";
tfc1.ColumnSpan = 5;
tfc1.HorizontalAlign = HorizontalAlign.Right;
TaxAmountcell.Cells.Add(tfc1);
TableCell tfc2 = new TableCell();
tfc2.Text = "<b>" + Convert.ToString(sr.TaxAmount) + "</b>";
tfc2.HorizontalAlign = HorizontalAlign.Right;
TaxAmountcell.Cells.Add(tfc2);
listTable.Rows.Add(TaxAmountcell);
TableCell tfc3 = new TableCell();
tfc3.Text = "<b>SUB TOTAL</b>";
tfc3.ColumnSpan = 5;
tfc3.HorizontalAlign = HorizontalAlign.Right;
SubTotal.Cells.Add(tfc3);
TableCell tfc4 = new TableCell();
tfc4.Text = "<b>" + Convert.ToString(sr.Gross) + "</b>";
tfc4.HorizontalAlign = HorizontalAlign.Right;
SubTotal.Cells.Add(tfc4);
listTable.Rows.Add(SubTotal);
TableCell tfc5 = new TableCell();
tfc5.Text = "<b>GRAND TOTAL ( " + setting.CurrencySymbol + " )</b>";
tfc5.ColumnSpan = 5;
tfc5.HorizontalAlign = HorizontalAlign.Right;
tf.Cells.Add(tfc5);
TableCell tfc6 = new TableCell();
tfc6.Text = "<b>" + Convert.ToString(sr.NetAmount) + "</b>";
tfc6.HorizontalAlign = HorizontalAlign.Right;
tf.Cells.Add(tfc6);
listTable.Rows.Add(tf);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationId = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
string invoicetype = "";
try
{
invoicetype = Request.QueryString["invoicetype"].ToString();
}
catch (Exception)
{
}
Entities.Register.SalesEntryRegister sr = new Entities.Register.SalesEntryRegister();
sr = Entities.Register.SalesEntryRegister.GetDetails(id, locationId);
dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationId);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblCustName.Text = sr.Customer;
lblComp.Text = sr.Company;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCompEmail.Text = sr.CompanyEmail;
lblCustPhone.Text = sr.CustomerPhone;
lblLocName.Text = sr.Location;
lblLocAddr1.Text = sr.LocationAddress1;
lblLocAddr2.Text = sr.LocationAddress2;
lblCustomerName.Text = sr.Customer;
//lblDiscount.Text = Convert.ToString(sr.Discount);
//lblFreight.Text = Convert.ToString(sr.FreightAmount);
lblLocPhone.Text = sr.LocationPhone;
lblDate.Text = sr.EntryDateString;
lblInvoiceNo.Text = sr.SalesBillNo;
lblTax.Text = Convert.ToString(sr.TaxAmount);
lblGross.Text = Convert.ToString(sr.Gross);
lblroundOff.Text = Convert.ToString(sr.RoundOff);
lblNet.Text = Convert.ToString(sr.NetAmount);
lblAmountinWords.Text = NumberToWords(Convert.ToDouble(sr.NetAmount));
lblCompName.Text = sr.Company;
//lblAddress.Text = sr.CustomerAddress;
lblCustName.Text = sr.Customer;
lblCustPhone.Text = sr.CustomerPhone;
//lblTfn.Text = sr.CustomerTaxNo;
lblProjectName.Text = sr.JobName;
lblLPONumber.Text = sr.LPO;
lblDeduction.Text = Convert.ToString(sr.Discount);
lblCustCare.Text = sr.Careof;
if (sr.PaymentStatus == 0)
{
if (invoicetype == "delivery")
{
lblMainHead.Text = "DELIVERY NOTE";
}
else
{
lblMainHead.Text = "TAX INVOICE";
}
}
else if (sr.PaymentStatus == 1)
{
if (invoicetype == "delivery")
{
lblMainHead.Text = "DELIVERY NOTE";
}
else
{
lblMainHead.Text = "PROFORMA INVOICE";
}
}
else if (sr.PaymentStatus == 2)
{
if (invoicetype == "delivery")
{
lblMainHead.Text = "DELIVERY NOTE";
}
else
{
lblMainHead.Text = "PROFORMA INVOICE";
}
}
//lblTrn.Text = sr.CustomerTaxNo;
//tAndC.Text = Entities.Application.Settings.GetSetting(148);
tAndC.Text = sr.TermsandConditon;
lblPaymentTerms.Text = sr.Payment_Terms;
for (int i = 0; i < sr.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
//TableCell t2 = new TableCell();
//t2.Text = sr.Products[i].ItemCode;
//r.Cells.Add(t2);
if (setting.EnableDescription)//Enabled Description
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += sr.Products[i].Name;
itemName += "</b><br/>";
itemName += sr.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = sr.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = sr.Products[i].Quantity.ToString();
r.Cells.Add(t4);
//TableCell t5 = new TableCell();
//t5.Text = sr.Products[i].MRP.ToString();
//r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sr.Products[i].SellingPrice.ToString();
r.Cells.Add(t6);
//TableCell t7 = new TableCell();
//t7.Text = sr.Products[i].TaxPercentage.ToString();
//r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = sr.Products[i].Gross.ToString();
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = sr.Products[i].TaxAmount.ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = sr.Products[i].NetAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationid = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.SalesEntryRegister sr = new Entities.Register.SalesEntryRegister();
sr = Entities.Register.SalesEntryRegister.GetDetails(id, locationid);
dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationid);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblCustName.Text = sr.Customer;
lblCompRegId.Text = c.RegId1;
lblCity.Text = c.City;
lblCompState.Text = c.State;
lblCompCountry.Text = c.Country;
lblCustState.Text = sr.BillingAddress[0].State;
lblCustCountry.Text = sr.BillingAddress[0].Country;
lblLocRegId.Text = sr.LocationRegId;
lblCustTaxNo.Text = sr.CustomerTaxNo;
lblCustAddr1.Text = sr.BillingAddress[0].Address1;
lblComp.Text = sr.Company;
lblCompAddr1.Text = c.Address1;
lblCompAddr2.Text = c.Address2;
lblCompPh.Text = c.MobileNo1;
lblCustAddr2.Text = sr.BillingAddress[0].Address2;
lblCustPhone.Text = sr.BillingAddress[0].Phone1;
lblLocName.Text = sr.Location;
lblDiscount.Text = Convert.ToString(sr.Discount);
lblFreight.Text = Convert.ToString(sr.FreightAmount);
lblLocAddr1.Text = sr.LocationAddress1;
lblLocAddr2.Text = sr.LocationAddress2;
lblLocPhone.Text = sr.LocationPhone;
lblDate.Text = sr.EntryDateString;
lblInvoiceNo.Text = sr.SalesBillNo;
lblTotal.Text = Convert.ToString(sr.Gross);
lblTax.Text = Convert.ToString(sr.TaxAmount);
lblroundOff.Text = Convert.ToString(sr.RoundOff);
lblNet.Text = Convert.ToString(sr.NetAmount);
tAndC.Text = Entities.Application.Settings.GetSetting(116);
for (int i = 0; i < sr.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
if (settings.EnableDescription)//Enabled Description
{
TableCell t2 = new TableCell();
t2.Width = 500;
string itemName = "<b>";
itemName += sr.Products[i].Name;
itemName += "</b><br/>";
itemName += sr.Products[i].Description;
t2.Text = itemName;
r.Cells.Add(t2);
}
else
{
TableCell t2 = new TableCell();
t2.Text = sr.Products[i].Name;
r.Cells.Add(t2);
}
TableCell t3 = new TableCell();
t3.Text = sr.Products[i].ItemCode;
r.Cells.Add(t3);
TableCell t4 = new TableCell();
t4.Text = sr.Products[i].MRP.ToString();
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = sr.Products[i].SellingPrice.ToString();
r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sr.Products[i].Quantity.ToString();
r.Cells.Add(t6);
TableCell t7 = new TableCell();
t7.Text = sr.Products[i].Gross.ToString();
r.Cells.Add(t7);
TableCell t8 = new TableCell();
t8.Text = sr.Products[i].TaxPercentage.ToString();
r.Cells.Add(t8);
if (sr.BillingAddress[0].StateID == c.StateId)
{
TableCell t9 = new TableCell();
t9.Text = (Convert.ToDecimal(sr.Products[i].TaxAmount) / 2).ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = (Convert.ToDecimal(sr.Products[i].TaxAmount) / 2).ToString();
r.Cells.Add(t10);
TableCell t11 = new TableCell();
t11.Text = "0.00";
r.Cells.Add(t11);
}
else
{
TableCell t9 = new TableCell();
t9.Text = "0.00";
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = "0.00";
r.Cells.Add(t10);
TableCell t11 = new TableCell();
t11.Text = sr.Products[i].TaxAmount.ToString();
r.Cells.Add(t11);
}
TableCell t12 = new TableCell();
t12.Text = sr.Products[i].NetAmount.ToString();
r.Cells.Add(t12);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Entry | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationid = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.GRNEntryRegister grn = new Entities.Register.GRNEntryRegister();
grn = Entities.Register.GRNEntryRegister.GetDetails(id, locationid);
dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationid);
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
lblSupName.Text = grn.Supplier;
lblCity.Text = c.City;
lblCompCountry.Text = c.Country;
lblCompState.Text = c.State;
lblSupCountry.Text = grn.BillingAddress[0].Country;
lblSupState.Text = grn.BillingAddress[0].State;
lblCompRegId.Text = c.RegId1;
lblSupTaxNo.Text = grn.SupplierTaxNo;
lblLocRegId.Text = grn.LocationRegId;
lblSupAddr1.Text = grn.BillingAddress[0].Address1;
lblSupAddr2.Text = grn.BillingAddress[0].Address2;
lblSupPhone.Text = grn.BillingAddress[0].Phone1;
lblComp.Text = c.Name;
lblCompaddr2.Text = c.Address2;
lblCompAddr1.Text = c.Address1;
lblCompPh.Text = c.Address1;
lblLocName.Text = grn.Location;
lblLocAddr1.Text = grn.LocationAddress1;
lblLocAddr2.Text = grn.LocationAddress2;
lblLocPhone.Text = grn.LocationPhone;
lblDate.Text = grn.EntryDateString;
lblInvoiceNo.Text = grn.InvoiceNo;
lblTax.Text = Convert.ToString(grn.TaxAmount);
lblNet.Text = Convert.ToString(grn.Net);
tAndC.Text = Entities.Application.Settings.GetSetting(143);
for (int i = 0; i < grn.Products.Count; i++)
{
TableRow r = new TableRow();
TableCell t1 = new TableCell();
t1.Text = (i + 1).ToString();
r.Cells.Add(t1);
TableCell t2 = new TableCell();
t2.Text = grn.Products[i].ItemCode;
r.Cells.Add(t2);
TableCell t3 = new TableCell();
t3.Text = grn.Products[i].Name;
r.Cells.Add(t3);
TableCell t4 = new TableCell();
t4.Text = grn.Products[i].CostPrice.ToString();
r.Cells.Add(t4);
TableCell t5 = new TableCell();
t5.Text = grn.Products[i].Quantity.ToString();
r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = grn.Products[i].ModifiedQuantity.ToString();
r.Cells.Add(t6);
TableCell t7 = new TableCell();
t7.Text = grn.Products[i].TaxPercentage.ToString();
r.Cells.Add(t7);
if (c.StateId == grn.BillingAddress[0].StateID)
{
TableCell t8 = new TableCell();
t8.Text = (Convert.ToDecimal(grn.Products[i].TaxAmount) / 2).ToString();
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = (Convert.ToDecimal(grn.Products[i].TaxAmount) / 2).ToString();
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = "0.00";
r.Cells.Add(t10);
}
else
{
TableCell t8 = new TableCell();
t8.Text = "0.00";
r.Cells.Add(t8);
TableCell t9 = new TableCell();
t9.Text = "0.00";
r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = grn.Products[i].TaxAmount.ToString();
r.Cells.Add(t10);
}
TableCell t11 = new TableCell();
t11.Text = grn.Products[i].NetAmount.ToString();
r.Cells.Add(t11);
listTable.Rows.Add(r);
}
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "GRN | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
int locationId = Convert.ToInt32(Request.QueryString["location"]);
if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
{
Entities.Register.SalesReturnRegister sq = new Entities.Register.SalesReturnRegister();
sq = Entities.Register.SalesReturnRegister.GetDetails(id, locationId);
dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
Entities.Master.Company c = new Entities.Master.Company();
c = Entities.Master.Company.GetDetailsByLocation(locationId);
Entities.Application.User use = new Entities.Application.User();
dynamic obj = Entities.Application.User.GetUserDetails(CPublic.GetuserID());
lblUserName.Text = obj.UserName;
lblDesignation.Text = obj.Designation;
lblCompanyContact.Text = obj.Mobile;
lblCompanyEmail.Text = obj.Email;
imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
imgLogo1.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
imgLogo2.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
imgLogo3.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
//lblCustName.Text = sq.CustomerName;
lblCompany.Text = sq.Company;
lblCustemail.Text = sq.CustomerEmail;
lblCustState.Text = sq.CustomerState + "," + sq.CustomerCountry;
//lblCompanyContact.Text = c.MobileNo1;
//lblCompanyEmail.Text = sq.CompanyEmail;
lblDate.Text = sq.EntryDateString;
//lblReference.Text = sq.CreditNoteNumber;
//tAndC.Text = sq.TermsandConditon;
//lblCustCompany.Text = sq.CustomerName;
for (int i = 0; i < sq.Products.Count; i++)
{
TableRow r = new TableRow();
//TableCell t1 = new TableCell();
//t1.Text = (i + 1).ToString();
//r.Cells.Add(t1);
TableCell t2 = new TableCell();
t2.Text = sq.Products[i].ItemCode;
r.Cells.Add(t2);
//TableCell t3 = new TableCell();
//t3.Text = sq.Products[i].Name;
//r.Cells.Add(t3);
if (setting.EnableDescription)//Enabled Description
{
TableCell t3 = new TableCell();
t3.Width = 500;
string itemName = "<b>";
itemName += sq.Products[i].Name;
itemName += "</b><br/>";
itemName += sq.Products[i].Description;
t3.Text = itemName;
r.Cells.Add(t3);
}
else
{
TableCell t3 = new TableCell();
t3.Text = sq.Products[i].Name;
r.Cells.Add(t3);
}
TableCell t4 = new TableCell();
t4.Text = sq.Products[i].Quantity.ToString();
r.Cells.Add(t4);
//TableCell t5 = new TableCell();
//t5.Text = sq.Products[i].MRP.ToString();
//r.Cells.Add(t5);
TableCell t6 = new TableCell();
t6.Text = sq.Products[i].SellingPrice.ToString();
r.Cells.Add(t6);
//TableCell t7 = new TableCell();
//t7.Text = sq.Products[i].TaxPercentage.ToString();
//r.Cells.Add(t7);
//TableCell t8 = new TableCell();
//t8.Text = sq.Products[i].Gross.ToString();
//r.Cells.Add(t8);
//TableCell t9 = new TableCell();
//t9.Text = sq.Products[i].TaxAmount.ToString();
//r.Cells.Add(t9);
TableCell t10 = new TableCell();
t10.Text = sq.Products[i].NetAmount.ToString();
r.Cells.Add(t10);
listTable.Rows.Add(r);
}
TableFooterRow tf = new TableFooterRow();
//TableCell tfc1 = new TableCell();
//tf.Cells.Add(tfc1);
//TableCell tfc2 = new TableCell();
//tf.Cells.Add(tfc2);
//TableCell tfc3 = new TableCell();
//tf.Cells.Add(tfc3);
//TableCell tfc4 = new TableCell();
//tf.Cells.Add(tfc4);
TableCell tfc5 = new TableCell();
tfc5.Text = "Total in " + setting.CurrencySymbol;
tfc5.ColumnSpan = 4;
tfc5.HorizontalAlign = HorizontalAlign.Right;
tf.Cells.Add(tfc5);
TableCell tfc6 = new TableCell();
tfc6.Text = Convert.ToString(sq.Gross);
tfc6.HorizontalAlign = HorizontalAlign.Right;
tf.Cells.Add(tfc6);
listTable.Rows.Add(tf);
TableFooterRow TaxAmountcell = new TableFooterRow();
TableCell tfc1 = new TableCell();
tfc1.Text = "VAT AMOUNT";
tfc1.ColumnSpan = 4;
tfc1.HorizontalAlign = HorizontalAlign.Right;
TaxAmountcell.Cells.Add(tfc1);
TableCell tfc2 = new TableCell();
tfc2.Text = Convert.ToString(sq.TaxAmount);
tfc2.HorizontalAlign = HorizontalAlign.Right;
TaxAmountcell.Cells.Add(tfc2);
listTable.Rows.Add(TaxAmountcell);
TableFooterRow TotalCell = new TableFooterRow();
TableCell tfc3 = new TableCell();
tfc3.Text = "Grand Total in " + setting.CurrencySymbol;
tfc3.ColumnSpan = 4;
tfc3.HorizontalAlign = HorizontalAlign.Right;
TotalCell.Cells.Add(tfc3);
TableCell tfc4 = new TableCell();
tfc4.Text = Convert.ToString(sq.NetAmount);
tfc4.HorizontalAlign = HorizontalAlign.Right;
TotalCell.Cells.Add(tfc4);
listTable.Rows.Add(TotalCell);
}
}
catch (Exception ex)
{
Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
Response.Write("<script> alert('" + ex.Message + "') </script>");
}
}
public HttpResponseMessage UpdateOrganizationProfile(Entities.Master.Company comp)
{
return(Request.CreateResponse(HttpStatusCode.OK, comp.Update()));
}