public JsonResult GetAllVendors() { try { objVendorsProperty = new Vendors_Property(); //objVendorsProperty.branchIdx = 1;//user logged in session branchIdx objVendorsBLL = new Vendors_BLL(objVendorsProperty); var Data = JsonConvert.SerializeObject(objVendorsBLL.ViewAll()); 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 DataTable GetAllVendors() { if (Session["LOGGEDIN"] != null) { try { Vendors_BLL objvendorbll = new Vendors_BLL(); return(objvendorbll.ViewAll()); } catch (Exception ex) { return(new DataTable()); } } else { return(new DataTable()); } }
public ActionResult AddNewVendorBank(int?id) { if (Session["LOGGEDIN"] != null) { objVendorBanksProperty = new LP_VendorBanks_Property(); Bank_BLL objBanlBLL = new Bank_BLL(); Vendors_BLL objVendorBLL = new Vendors_BLL(); objVendorBanksProperty.BankList = Helper.ConvertDataTable <Bank_Property>(objBanlBLL.ViewAll()); objVendorBanksProperty.VendorList = Helper.ConvertDataTable <Vendors_Property>(objVendorBLL.ViewAll()); if (id > 0) { objVendorBanksProperty.idx = Convert.ToInt32(id); objVendorBanksBLL = new LP_VendorBanks_BLL(objVendorBanksProperty); DataTable dt = objVendorBanksBLL.SelectOne(); objVendorBanksProperty.bankIdx = int.Parse(dt.Rows[0]["bankIdx"].ToString()); objVendorBanksProperty.vendorIdx = int.Parse(dt.Rows[0]["vendorIdx"].ToString()); objVendorBanksProperty.accountTitle = dt.Rows[0]["accountTitle"].ToString(); objVendorBanksProperty.accountNumber = dt.Rows[0]["accountNumber"].ToString(); objVendorBanksProperty.ibanNumber = dt.Rows[0]["ibanNumber"].ToString(); return(PartialView("AddNewVendorBank", objVendorBanksProperty)); } else { return(PartialView("AddNewVendorBank", objVendorBanksProperty)); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddNewPurchase(int?id) { if (Session["LOGGEDIN"] != null) { objPurchaseVM_Property = new PurchaseVM_Property(); Vendors_Property vendor = new Vendors_Property(); Product_Property product = new Product_Property(); Vendors_BLL objvendorbll = new Vendors_BLL(); Product_BLL objProductbll = new Product_BLL(); LP_MRN_BLL objMRNbll = new LP_MRN_BLL(); objPurchaseVM_Property.MRList = Helper.ConvertDataTable <LP_MRN_Master_Property>(objMRNbll.SelectMRN()); objPurchaseVM_Property.VendorLST = Helper.ConvertDataTable <Vendors_Property>(objvendorbll.ViewAll()); objPurchaseVM_Property.DepartmentList = Helper.ConvertDataTable <Departments_property>(GetAllDepartments()); objPurchaseVM_Property.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll()); objPurchaseVM_Property.purchaseDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //objPurchaseVM_Property.poNumber = "Po-001"; if (id > 0) { LP_Purchase_Detail_Property objmpurchasedetail; objPurchaseProperty = new LP_Purchase_Master_Property(); objPurchaseProperty.idx = Convert.ToInt16(id); objpurchaseBll = new LP_Purchase_BLL(objPurchaseProperty); DataTable dt = objpurchaseBll.SelectOne(); objPurchaseVM_Property.idx = Convert.ToInt16(dt.Rows[0]["purchaseIdx"].ToString()); objPurchaseVM_Property.vendorIdx = Convert.ToInt16(dt.Rows[0]["vendorIdx"].ToString()); objPurchaseVM_Property.poNumber = dt.Rows[0]["poNumber"].ToString(); objPurchaseVM_Property.description = dt.Rows[0]["description"].ToString(); objPurchaseVM_Property.MRNIdx = Convert.ToInt16(dt.Rows[0]["MRNIdx"].ToString()); objPurchaseVM_Property.DepartmentID = Convert.ToInt16(dt.Rows[0]["DepartmentID"].ToString()); objPurchaseVM_Property.totalAmount = Convert.ToDecimal(dt.Rows[0]["totalAmount"].ToString()); string pdate = (dt.Rows[0]["purchaseDate"].ToString()).ToString(); string ndate = DateTime.Parse(pdate).ToString("yyyy-MM-dd"); objPurchaseVM_Property.purchaseDate = 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 <PurchaseVM_Property>(dt); //update return(View("AddNewPurchase", objPurchaseVM_Property)); } else { //objPurchaseProperty = new LP_Purchase_Master_Property(); objPurchaseVM_Property.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); objpurchaseBll = new LP_Purchase_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "purchase"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objPurchaseVM_Property.poNumber = objpurchaseBll.GeneratePO(objtrans); //objPurchaseProperty.poNumber = ""; //objpurchaseBll = new LP_Purchase_BLL(objPurchaseProperty); //objPurchaseVM_Property.poNumber = objpurchaseBll.GeneratePO();// "PO-001"; // string po = objpurchaseBll.GeneratePO(); return(View("AddNewPurchase", objPurchaseVM_Property)); } } else { return(RedirectToAction("Login", "Account")); } }