private void BindQuotation()
{
try
{
quotObj = new QuotationClass();
quotObj.quotId = Convert.ToInt32(Request.QueryString["qid"]);
DataSet dsQuot = quotObj.GetQuotationDetailsByQuotId();
if (dsQuot.Tables[0].Rows.Count > 0)
{
lblCustomerName.Text = dsQuot.Tables[0].Rows[0]["custName"].ToString();
lblQuotationNo.Text = "Q" + dsQuot.Tables[0].Rows[0]["quotNo"].ToString();
lblQuotationDate.Text = Convert.ToDateTime(dsQuot.Tables[0].Rows[0]["quotDate"].ToString()).ToString("dd-MM-yyyy");
rptQuotationDetails.DataSource = dsQuot.Tables[1];
rptQuotationDetails.DataBind();
lblVat1.Text = lblVat2.Text = dsQuot.Tables[2].Rows[0]["vatPer"].ToString();
lblAmtExVatSR.Text = dsQuot.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[0];
lblAmtExVatH.Text = dsQuot.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[1];
lblVatAmtSR.Text = dsQuot.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[0];
lblVatAmtH.Text = dsQuot.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[1];
lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(dsQuot.Tables[2].Rows[0]["totalInTax"]));
lblAmtInVatSR.Text = dsQuot.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[0];
lblAmtInVatH.Text = dsQuot.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[1];
lblTermsAndConditions.Text = dsQuot.Tables[2].Rows[0]["termsAndContions"].ToString();
//printQuotation(dsQuot);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
private void BindQuotationDetails()
{
quotObj = new QuotationClass();
DataTable dtQout = quotObj.GetAllQuotationDetails();
rptQuotationView.DataSource = dtQout.Rows.Count > 0 ? dtQout : null;
rptQuotationView.DataBind();
}
protected void lblView_Click(object sender, EventArgs e)
{
try
{
quotObj = new QuotationClass();
quotObj.quotId = Convert.ToInt32(((LinkButton)sender).CommandArgument);
Response.Redirect("~/Windows/Default.aspx?uc=9&qid=" + quotObj.quotId);
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
try
{
quotObj = new QuotationClass();
quotObj.quotId = Convert.ToInt32(Request.QueryString["qid"]);
Response.Redirect("~/Windows/Default.aspx?uc=8&qid=" + quotObj.quotId);
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
private void BindDescription()
{
quotObj = new QuotationClass();
DataTable dtProd = quotObj.GetproductDetailsForQuoAndIn();
if (dtProd.Rows.Count > 0)
{
ddlDescription.DataSource = dtProd;
ddlDescription.DataValueField = "prodId";
ddlDescription.DataTextField = "description";
ddlDescription.DataBind();
ddlDescription.Items.Insert(0, new ListItem("-- Select Description --", "0"));
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{
quotObj = new QuotationClass();
quotObj.quotId = Convert.ToInt32(Request.QueryString["qid"]);
DataSet dsQuot = quotObj.GetQuotationDetailsByQuotId();
if (dsQuot.Tables[0].Rows.Count > 0)
{
printQuotation(dsQuot);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
public int UpdateQuotation(string _quotation)
{
quotObj = new QuotationClass();
quotationArray qa = JsonConvert.DeserializeObject <quotationArray>(_quotation);
if (!ValidateQuotationNo(qa.quotationNo.Replace("Q", ""), qa.quotId.ToString()))
{
quotObj.quotId = qa.quotId;
quotObj.quotNo = qa.quotationNo.Replace("Q", "");
quotObj.quotDate = Convert.ToDateTime(qa.quotaionDate).ToString("yyyy-MM-dd");
quotObj.custId = qa.custId;
quotObj.custName = qa.custName;
if (quotObj.UpdateQuotationMaster())
{
if (quotObj.QuotationDetailsDeleteByQuotId())
{
for (int i = 0; i < qa.quotationDetailsArray.Count; i++)
{
quotObj.prodId = qa.quotationDetailsArray[i].prodId;
quotObj.prodDescription = qa.quotationDetailsArray[i].product;
quotObj.qty = qa.quotationDetailsArray[i].qty;
quotObj.prodPrice = qa.quotationDetailsArray[i].unitPrice;
quotObj.totalPrice = qa.quotationDetailsArray[i].totalPrice;
quotObj.SaveQuotationDetails();
}
}
quotObj.totalExVat = qa.totExVat;
quotObj.vatPer = qa.vatPer;
quotObj.vatAmt = qa.vatAmt;
quotObj.totalInTax = qa.totInVat;
quotObj.termsAndConditions = qa.termsAndConditions;
quotObj.UpdatequotationPaymentDetails();
return(quotObj.quotId);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
public int SaveQuotation(string _quotation)
{
quotObj = new QuotationClass();
quotationArray qa = JsonConvert.DeserializeObject <quotationArray>(_quotation);
quotObj.quotNo = qa.quotationNo.Replace("Q", "");
if (!ValidateQuotationNo(qa.quotationNo.Replace("Q", ""), "0"))
{
quotObj.quotNo = qa.quotationNo.Replace("Q", "");
quotObj.quotDate = "2018-08-23";
quotObj.custId = qa.custId;
quotObj.custName = qa.custName;
quotObj.quotId = Convert.ToInt32(quotObj.SaveQuotationMaster().Rows[0][0]);
if (quotObj.quotId > 0)
{
for (int i = 0; i < qa.quotationDetailsArray.Count; i++)
{
quotObj.prodId = qa.quotationDetailsArray[i].prodId;
quotObj.prodDescription = qa.quotationDetailsArray[i].product;
quotObj.qty = qa.quotationDetailsArray[i].qty;
quotObj.prodPrice = qa.quotationDetailsArray[i].unitPrice;
quotObj.totalPrice = qa.quotationDetailsArray[i].totalPrice;
quotObj.SaveQuotationDetails();
}
quotObj.totalExVat = qa.totExVat;
quotObj.vatPer = qa.vatPer;
quotObj.vatAmt = qa.vatAmt;
quotObj.totalInTax = qa.totInVat;
quotObj.termsAndConditions = qa.termsAndConditions;
quotObj.SavequotationPaymentDetails();
return(quotObj.quotId);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
public string EditQuotation(string _qid)
{
quotObj = new QuotationClass();
quotObj.quotId = Convert.ToInt32(_qid);
DataSet dsQuot = quotObj.GetQuotationDetailsByQuotId();
if (dsQuot.Tables[0].Rows.Count > 0)
{
dsQuot.Tables[1].Columns["prodDescription"].ColumnName = "product";
dsQuot.Tables[1].Columns["prodPrice"].ColumnName = "unitPrice";
dsQuot.Tables[1].Columns.Add("arrId");
string json = JsonConvert.SerializeObject(dsQuot, Newtonsoft.Json.Formatting.Indented);
return(json);
}
else
{
return("");
}
}
public bool ValidateQuotationNo(string _quotationNo, string _quotId)
{
if (!string.IsNullOrEmpty(_quotationNo))
{
quotObj = new QuotationClass();
quotObj.quotNo = _quotationNo;
quotObj.quotId = Convert.ToInt32(_quotId);
if (quotObj.ValidateQuotationNo())
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private void GetNextQuotationNo()
{
quotObj = new QuotationClass();
txtQuotationNo.Text = quotObj.GetNextQuotationNo();
}
