public JsonResult AddUpdate(QuotationVM_Property objquotation)
{
try
{
bool flag = false;
objQuotationProperty = new LP_Quotation_Master_Property();
objQuotationProperty.qsNumber = objquotation.qsNumber;
objQuotationProperty.customerIdx = objquotation.customerIdx;
objQuotationProperty.quotationDate = objquotation.quotationDate;
objQuotationProperty.description = objquotation.description;
objQuotationProperty.totalAmount = objquotation.totalAmount;
objQuotationProperty.netAmount = objquotation.netAmount;
objQuotationProperty.paidAmount = objquotation.paidAmount;
objQuotationProperty.balanceAmount = objquotation.balanceAmount;
objQuotationProperty.taxAount = objquotation.taxAount;
objQuotationProperty.reference = objquotation.reference;
objQuotationProperty.shippingCost = objquotation.shippingCost;
objQuotationProperty.discount = objquotation.discount;
// objPurchaseProperty.paidDate = ;// objpurchase.paidDate;
objQuotationProperty.DetailData = Helper.ToDataTable <QuotationDetails_Property>(objquotation.QuotationDetailLST);
objQuotationProperty.SalesTaxData = Helper.ToDataTable <LP_salesTaxes_Property>(objquotation.salesTaxesLST);
if (objquotation.idx > 0)
{
objQuotationProperty.idx = objquotation.idx;
objQuotationProperty.creationDate = DateTime.Now;
objQuotationProperty.visible = 1;
objQuotationProperty.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString());
objQuotationProperty.visible = 1;
objQuotationProperty.status = "0";
objQuotationProperty.TableName = "quotaionDetails";
objquotationBll = new LP_Quotation_BLL(objQuotationProperty);
flag = objquotationBll.Insert();
//update
}
else
{
//add
objQuotationProperty.creationDate = DateTime.Now;
objQuotationProperty.visible = 1;
objQuotationProperty.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString());
objQuotationProperty.visible = 1;
objQuotationProperty.status = "0";
objQuotationProperty.TableName = "quotationDetails";
objquotationBll = new LP_Quotation_BLL(objQuotationProperty);
flag = objquotationBll.Insert();
return(GenerateReport(objQuotationProperty.idx, 4, "SaleQouteReport"));
}
return(Json(new { data = "", success = flag, msg = flag == true ? "Successfull" : "Failed", statuscode = flag == true ? 200 : 401 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetAllQuotation()
{
try
{
objQuotationVM_Property = new QuotationVM_Property();
objquotationBll = new LP_Quotation_BLL(objQuotationProperty);
var Data = JsonConvert.SerializeObject(objquotationBll.SelectAll());
return(Json(new { data = Data, success = true, statuscode = 200, count = Data.Length }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddQuotaion(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objQuotationVM_Property = new QuotationVM_Property();
Customers_Property customer = new Customers_Property();
Product_Property product = new Product_Property();
Customers_BLL objcustomerbll = new Customers_BLL();
Product_BLL objProductbll = new Product_BLL();
objQuotationVM_Property.CustomerLST = Helper.ConvertDataTable <Customers_Property>(objcustomerbll.ViewAllCustomers());
objQuotationVM_Property.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll());
Taxes_Property obj = new Taxes_Property();
Taxes_BLL objtaxBLL = new Taxes_BLL(obj);
ViewBag.TaxList = Helper.ConvertDataTable <Taxes_Property>(objtaxBLL.GetTaxesForCheckBox());
//objQuotationVM_Property.QuotationDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
////objQuotationVM_Property.poNumber = "Po-001";
if (id > 0)
{
LP_Quotation_Detail_Property objmQuotationdetail;
objQuotationProperty = new LP_Quotation_Master_Property();
objQuotationProperty.idx = Convert.ToInt16(id);
objquotationBll = new LP_Quotation_BLL(objQuotationProperty);
DataTable dt = objquotationBll.SelectOne();
objQuotationVM_Property.idx = Convert.ToInt16(dt.Rows[0]["quotationIdx"].ToString());
objQuotationVM_Property.customerIdx = Convert.ToInt16(dt.Rows[0]["customerIdx"].ToString());
objQuotationVM_Property.qsNumber = dt.Rows[0]["qsNumber"].ToString();
objQuotationVM_Property.description = dt.Rows[0]["description"].ToString();
objQuotationVM_Property.totalAmount = Convert.ToDecimal(dt.Rows[0]["totalAmount"].ToString());
string pdate = (dt.Rows[0]["quotationDate"].ToString()).ToString();
string ndate = DateTime.Parse(pdate).ToString("yyyy-MM-dd");
objQuotationVM_Property.quotationDate = Convert.ToDateTime(ndate);// DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd");
//DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd");
//foreach(DataRow dr in dt.Rows)
//{
// objmrndetail
//}
ViewBag.DetailData = Helper.ConvertDataTable <QuotationVM_Property>(dt);
//update
return(View("AddQuotaion", objQuotationVM_Property));//objQuotationVM_Property
}
else
{
objQuotationVM_Property.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString());
objquotationBll = new LP_Quotation_BLL();
LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property();
objtrans.TableName = "quotation";
objtrans.Identityfieldname = "idx";
objtrans.userid = Session["UID"].ToString();
objQuotationVM_Property.qsNumber = objquotationBll.GeneratePO(objtrans);
return(View("AddQuotaion", objQuotationVM_Property));//, objQuotationVM_Property
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
