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