public ActionResult AddVoucher(int?id) { if (Session["LOGGEDIN"] != null) { objvoucherVM = new LP_Voucher_ViewModel(); if (objvoucherVM.idx > 0) { } else { objvoucherVM.date_created = DateTime.Now; objvoucherVM.vouchertypelist = Helper.ConvertDataTable <LP_Transaction_Type_Property>(GetAllTransactionType()); objvoucherVM.voucher_amount = 0.00m; objvoucherVM.description = ""; objvoucherVM.banklist = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks()); objvoucherVM.vendorlist = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors()); LP_GenerateTransNumber_Property objtransnumber = new LP_GenerateTransNumber_Property(); objtransnumber.TableName = "Voucher"; objtransnumber.Identityfieldname = "idx"; objtransnumber.userid = Session["UID"].ToString(); objVoucherBll = new LP_Voucher_BLL(); objvoucherVM.voucher_no = objVoucherBll.GenerateTransNo(objtransnumber); } return(View("_AddVoucher", objvoucherVM)); } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddNewVendors(int?id) { objVendorsProperty = new Vendors_Property(); objVendorsProperty.idx = Convert.ToInt32(id); //objVendorsProperty.branchIdx = 1;//It will have the value of session branchIdx objVendorsBLL = new Vendors_BLL(objVendorsProperty); DataTable categories = objVendorsBLL.ddlCategory(); List <Vendor_Category_Property> catLST = new List <Vendor_Category_Property>(); DataTable VendorTypes = objVendorsBLL.ddlVendorsType(); List <VendorType_Property> VendorTypeLST = new List <VendorType_Property>(); foreach (DataRow dr in categories.Rows) { Vendor_Category_Property objVendorsCat = new Vendor_Category_Property(); objVendorsCat.vendorCategory = dr["vendorCategory"].ToString(); objVendorsCat.idx = Convert.ToInt32(dr["idx"].ToString()); catLST.Add(objVendorsCat); } ViewBag.catLST = catLST; foreach (DataRow dr in VendorTypes.Rows) { VendorType_Property objVendorsCat = new VendorType_Property(); objVendorsCat.vendorType = dr["vendorType"].ToString(); objVendorsCat.idx = Convert.ToInt32(dr["idx"].ToString()); VendorTypeLST.Add(objVendorsCat); } ViewBag.VendorsTypeLST = VendorTypeLST; if (id != null && id != 0) { var dt = objVendorsBLL.GetById(id); //objVendorsProperty.companyIdx = 1; objVendorsProperty.idx = int.Parse(dt.Rows[0]["idx"].ToString()); objVendorsProperty.vendorTypeIdx = int.Parse(dt.Rows[0]["vendorTypeIdx"].ToString()); objVendorsProperty.vendorCatIdx = int.Parse(dt.Rows[0]["vendorCatIdx"].ToString()); objVendorsProperty.contact = (dt.Rows[0]["contact"].ToString()); objVendorsProperty.vendorCode = (dt.Rows[0]["vendorCode"].ToString()); objVendorsProperty.vendorName = (dt.Rows[0]["vendorName"].ToString()); objVendorsProperty.address = (dt.Rows[0]["address"].ToString()); return(PartialView("_AddNewVendors", objVendorsProperty)); } else { objVendorsProperty.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); objVendorsBLL = new Vendors_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "vendors"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objVendorsProperty.vendorCode = objVendorsBLL.GenerateSO(objtrans); return(PartialView("_AddNewVendors", objVendorsProperty)); } }
public ActionResult AddNewMRN(int?id) { if (Session["LOGGEDIN"] != null) { objMRNVM_Property = new MRNVM_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(); //objMRNVM_Property.VendorLST = Helper.ConvertDataTable<Vendors_Property>(objvendorbll.ViewAll()); objMRNVM_Property.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll()); objMRNVM_Property.WareHouseList = Helper.ConvertDataTable <WareHouse_Property>(ViewWareHouses()); objMRNVM_Property.mrnDate = DateTime.Now.ToString("yyyy-MM-dd"); if (id > 0) { //update LP_MRN_Detail_Property objmrndetail; objMRNProperty = new LP_MRN_Master_Property(); objMRNProperty.idx = Convert.ToInt16(id); objMRNBll = new LP_MRN_BLL(objMRNProperty); DataTable dt = objMRNBll.SelectById(); objMRNVM_Property.idx = Convert.ToInt16(dt.Rows[0]["mrnIdx"].ToString()); objMRNVM_Property.description = dt.Rows[0]["description"].ToString(); objMRNVM_Property.WarerHouseID = Convert.ToInt32(dt.Rows[0]["WarerHouseID"].ToString()); objMRNVM_Property.mrNumber = dt.Rows[0]["mrNumber"].ToString(); objMRNVM_Property.mrnDate = DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd"); //foreach(DataRow dr in dt.Rows) //{ // objmrndetail //} ViewBag.DetailData = Helper.ConvertDataTable <MRNVM_Property>(dt); return(View("AddNewMRN", objMRNVM_Property)); } else { objMRNBll = new LP_MRN_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "MRN"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objMRNVM_Property.mrNumber = objMRNBll.GenerateMRNNo(objtrans); return(View("AddNewMRN", objMRNVM_Property)); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddNewGRN(int?id) { if (Session["LOGGEDIN"] != null) { objGRNVM_Property = new LP_GRN_ViewModel(); objpurchaseBll = new LP_Purchase_BLL(); objGRNBll = new LP_GRN_BLL(); objGRNVM_Property.POList = Helper.ConvertDataTable <LP_Purchase_Master_Property>(objpurchaseBll.SelectAll()); //objGRNVM_Property.Doc_No = "GRN-001"; if (id > 0) { //update LP_GRN_Detail_Property objdetail; objGRNProperty = new LP_GRN_Master_Property(); objGRNProperty.ID = Convert.ToInt16(id); objGRNBll = new LP_GRN_BLL(objGRNProperty); DataTable dt = objGRNBll.SelectOne(); objGRNVM_Property.ID = Convert.ToInt16(dt.Rows[0]["ID"].ToString()); //objGRNVM_Property.vendorIdx = Convert.ToInt16(dt.Rows[0]["vendorIdx"].ToString()); objGRNVM_Property.Doc_No = dt.Rows[0]["Doc_No"].ToString(); objGRNVM_Property.Narration = dt.Rows[0]["Narration"].ToString(); objGRNVM_Property.Parent_DocID = Convert.ToInt16(dt.Rows[0]["Parent_DocID"].ToString()); objGRNVM_Property.Total_Amount = Convert.ToDecimal(dt.Rows[0]["Total_Amount"].ToString()); //objPurchaseVM_Property.purchaseDate = DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd"); //foreach(DataRow dr in dt.Rows) //{ // objmrndetail //} ViewBag.DetailData = Helper.ConvertDataTable <LP_GRN_ViewModel>(dt); //update return(View("_AddNewGRN", objGRNVM_Property)); } else { LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "GRN_Master"; objtrans.Identityfieldname = "ID"; objtrans.userid = Session["UID"].ToString(); objGRNVM_Property.Doc_No = objGRNBll.GenerateMRNNo(objtrans); return(View("_AddNewGRN", objGRNVM_Property)); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult opening() { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); string pagename = @"/" + controllerName + @"/" + actionName; var page = (List <LP_Pages_Property>)Session["PageList"]; if (Session["LoggedIn"] != null && Helper.CheckPageAccess(pagename, page) && Session["ISADMIN"] != null && Convert.ToBoolean(Session["ISADMIN"].ToString()) == true) { OpenigEntryVM objOpeningVM = new OpenigEntryVM(); if (objOpeningVM.idx > 0) { } else { LP_Opening_BLL objbll = new LP_Opening_BLL(objOpeningVM); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "accountMasterGL"; objtrans.Identityfieldname = "idxx"; objtrans.userid = (Session["UID"].ToString()); objOpeningVM.voucherNo = objbll.GenerateSO(objtrans); objOpeningVM.voucherDate = DateTime.Now.ToString("yyyy-MM-dd"); objOpeningVM.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); } return(View("opening", objOpeningVM)); } else { if (Session["LoggedIn"] == null) { return(RedirectToAction("Login", "Account")); } else { return(RedirectToAction("NotAuthorized", "Account")); } } }
public string GeneratePO(LP_GenerateTransNumber_Property objtransno) { string TransactionNumber = ""; _objPurchaseDAL = new LP_Quotation_DAL(); DataTable dt = _objPurchaseDAL.GeneratePONo(objtransno); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TransactionNumber = dr["TransNumber"].ToString(); TransactionNumber = "QS-00" + (int.Parse(TransactionNumber) + 1) + "-" + objtransno.userid; } return(TransactionNumber); } else { TransactionNumber = "QS-001-" + objtransno.userid; return(TransactionNumber); } }
public ActionResult AddVoucher(int?id) { if (Session["LOGGEDIN"] != null) { objvoucherVM = new LP_Voucher_ViewModel(); if (objvoucherVM.idx > 0) { } else { LP_PInvoice_BLL objbll = new LP_PInvoice_BLL(); objvoucherVM.PInvoiceLST = Helper.ConvertDataTable <LP_P_Invoice_Property>(objbll.SelectAll()); //JsonConvert.SerializeObject(GetAllPIByDate(objsearchPI)); thirdTier_BLL subheadBLL = new thirdTier_BLL(); var allSubhead = subheadBLL.ViewAll(); objvoucherVM.date_created = DateTime.Now; objvoucherVM.vouchertypelist = Helper.ConvertDataTable <thirdTier_Property>(subheadBLL.ViewAll()); objvoucherVM.voucher_amount = 0.00m; objvoucherVM.description = ""; objvoucherVM.banklist = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks()); objvoucherVM.vendorlist = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors()); LP_GenerateTransNumber_Property objtransnumber = new LP_GenerateTransNumber_Property(); objtransnumber.TableName = "Voucher"; objtransnumber.Identityfieldname = "idx"; objtransnumber.userid = Session["UID"].ToString(); objVoucherBll = new LP_Voucher_BLL(); objvoucherVM.voucher_no = objVoucherBll.GenerateTransNo(objtransnumber); } return(View("_AddVoucher", objvoucherVM)); } else { return(RedirectToAction("Login", "Account")); } }
public string GeneratePINo(LP_GenerateTransNumber_Property objtransno) { string TransactionNumber = ""; objDAL = new LP_Purchase_Invoice_DAL(); DataTable dt = objDAL.GeneratePINo(objtransno); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TransactionNumber = dr["TransNumber"].ToString(); TransactionNumber = "PI-00" + TransactionNumber + "-" + objtransno.userid; } return(TransactionNumber); } else { TransactionNumber = "PI-001-" + objtransno.userid; return(TransactionNumber); } //return _objMRNDAL.GenerateMRNNo(objtransno); }
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")); } }
public ActionResult AddNewGRN(int?id) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); string pagename = @"/" + controllerName + @"/" + actionName; var page = (List <LP_Pages_Property>)Session["PageList"]; if (Session["LoggedIn"] != null && Helper.CheckPageAccess(pagename, page) && Session["ISADMIN"] != null && Convert.ToBoolean(Session["ISADMIN"].ToString()) == true) { objGRNVM_Property = new LP_GRN_ViewModel(); objpurchaseBll = new LP_Purchase_BLL(); objGRNBll = new LP_GRN_BLL(); objGRNVM_Property.POList = Helper.ConvertDataTable <LP_Purchase_Master_Property>(objpurchaseBll.SelectAll()); //objGRNVM_Property.Doc_No = "GRN-001"; if (id > 0) { //update LP_GRN_Detail_Property objdetail; objGRNProperty = new LP_GRN_Master_Property(); objGRNProperty.ID = Convert.ToInt16(id); objGRNBll = new LP_GRN_BLL(objGRNProperty); DataTable dt = objGRNBll.SelectOne(); objGRNVM_Property.ID = Convert.ToInt16(dt.Rows[0]["ID"].ToString()); //objGRNVM_Property.vendorIdx = Convert.ToInt16(dt.Rows[0]["vendorIdx"].ToString()); objGRNVM_Property.Doc_No = dt.Rows[0]["Doc_No"].ToString(); objGRNVM_Property.Narration = dt.Rows[0]["Narration"].ToString(); objGRNVM_Property.Parent_DocID = Convert.ToInt16(dt.Rows[0]["Parent_DocID"].ToString()); objGRNVM_Property.Total_Amount = Convert.ToDecimal(dt.Rows[0]["Total_Amount"].ToString()); //objPurchaseVM_Property.purchaseDate = DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd"); //foreach(DataRow dr in dt.Rows) //{ // objmrndetail //} ViewBag.DetailData = Helper.ConvertDataTable <LP_GRN_ViewModel>(dt); //update return(View("_AddNewGRN", objGRNVM_Property)); } else { LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "GRN_Master"; objtrans.Identityfieldname = "ID"; objtrans.userid = Session["UID"].ToString(); objGRNVM_Property.Doc_No = objGRNBll.GenerateMRNNo(objtrans); return(View("_AddNewGRN", objGRNVM_Property)); } } else { if (Session["LoggedIn"] == null) { return(RedirectToAction("Login", "Account")); } else { return(RedirectToAction("NotAuthorized", "Account")); } } }
public ActionResult AddNewPI(int?id) { if (Session["LOGGEDIN"] != null) { objPInvoiceVM = new LP_PI_ViewModel(); objPIBLL = new LP_PInvoice_BLL(); objPurchaseBLL = new LP_Purchase_BLL(); objPInvoiceVM.POLIST = Helper.ConvertDataTable <LP_Purchase_Master_Property>(objPurchaseBLL.SelectAll()); objPInvoiceVM.TaxesList = Helper.ConvertDataTable <Taxes_Property>(GetAllTaxes()); objPInvoiceVM.VendorList = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors()); objPInvoiceVM.ProductList = Helper.ConvertDataTable <Product_Property>(ViewAllProducts()); objPInvoiceVM.BankList = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks()); //objGRNVM_Property.Doc_No = "GRN-001"; if (id > 0) { //update objPIProperty = new LP_P_Invoice_Property(); objPIProperty.idx = Convert.ToInt16(id); objPIBLL = new LP_PInvoice_BLL(objPIProperty); DataSet DS = objPIBLL.SelectByID(); objPInvoiceVM.InvoiceProperty = Helper.ConvertDataTable <LP_P_Invoice_Property>(DS.Tables[0]); objPInvoiceVM.InvoiceDetails = Helper.ConvertDataTable <LP_P_Invoice_Details>(DS.Tables[1]); objPInvoiceVM.PITAXLIST = Helper.ConvertDataTable <LP_PI_Taxes_Property>(DS.Tables[2]); // objPInvoiceVM.ParentDocID = objPInvoiceVM.InvoiceProperty[0].ParentDocID; objPInvoiceVM.InvoiceNo = objPInvoiceVM.InvoiceProperty[0].InvoiceNo; objPInvoiceVM.VendorID = objPInvoiceVM.InvoiceProperty[0].VendorID; objPInvoiceVM.CreatedDate = objPInvoiceVM.InvoiceProperty[0].CreatedDate; objPInvoiceVM.Reference = objPInvoiceVM.InvoiceProperty[0].Reference; objPInvoiceVM.Description = objPInvoiceVM.InvoiceProperty[0].Description; objPInvoiceVM.NetAmount = objPInvoiceVM.InvoiceProperty[0].NetAmount; objPInvoiceVM.TotalAmount = objPInvoiceVM.InvoiceProperty[0].TotalAmount; objPInvoiceVM.TaxAmount = objPInvoiceVM.InvoiceProperty[0].TaxAmount; objPInvoiceVM.BalanceAmount = objPInvoiceVM.InvoiceProperty[0].BalanceAmount; objPInvoiceVM.PaidAmount = objPInvoiceVM.InvoiceProperty[0].PaidAmount; objPInvoiceVM.PaymentType = objPInvoiceVM.InvoiceProperty[0].PaymentType; objPInvoiceVM.bankIdx = objPInvoiceVM.InvoiceProperty[0].BankId; objPInvoiceVM.accorChequeNumber = objPInvoiceVM.InvoiceProperty[0].AccountChequeNo; ViewBag.update = true; return(PartialView("_AddNewPI", objPInvoiceVM)); } else { objPInvoiceVM.InvoiceProperty = Helper.ConvertDataTable <LP_P_Invoice_Property>(new DataTable()); objPInvoiceVM.InvoiceDetails = Helper.ConvertDataTable <LP_P_Invoice_Details>(new DataTable()); objPInvoiceVM.PITAXLIST = Helper.ConvertDataTable <LP_PI_Taxes_Property>(new DataTable()); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "P_Invoice"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objPInvoiceVM.InvoiceNo = objPIBLL.GeneratePINo(objtrans); //objPInvoiceVM.CreatedDate =DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy")); return(PartialView("_AddNewPI", objPInvoiceVM)); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddNewConsigment(int?id) { if (Session["LOGGEDIN"] != null) { objConsigmentVm = new LP_Consigment_ViewModel(); Vendors_Property vendor = new Vendors_Property(); Product_Property product = new Product_Property(); Vendors_BLL objvendorbll = new Vendors_BLL(); Product_BLL objProductbll = new Product_BLL(); objpurchaseBll = new LP_PI_BLL(); // objPurchaseVM_Property.VendorLST = Helper.ConvertDataTable<Vendors_Property>(objvendorbll.ViewAll()); // objPurchaseVM_Property.DepartmentList = Helper.ConvertDataTable<Departments_property>(GetAllDepartments()); // objPurchaseVM_Property.PurchaseType_List = Helper.ConvertDataTable<LP_Purchase_Type>(GetAllPurchaseType()); objConsigmentVm.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll()); objConsigmentVm.CIPO = Helper.ConvertDataTable <LP_CI_PurchaseOrder_Property>(objpurchaseBll.SelectAllCIPO()); objConsigmentVm.Invoicedate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //objPurchaseVM_Property.poNumber = "Po-001"; if (id > 0) { //LP_Purchase_Detail_Property objmpurchasedetail; //objPurchaseProperty = new LP_Performa_Invoice_Property(); //objPurchaseProperty.idx = Convert.ToInt16(id); //objpurchaseBll = new LP_PI_BLL(); //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.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("AddNewConsigment", objConsigmentVm)); } else { //objPurchaseProperty = new LP_Purchase_Master_Property(); objConsigmentVm.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); objpurchaseBll = new LP_PI_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "consigment"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objConsigmentVm.InvoiceNo = objpurchaseBll.GenerateCINo(objtrans); //objCIPOVm.CDPercntage = 20; //objCIPOVm.RDPercentage = 20; //objCIPOVm.ACDPercentage = 20; //objCIPOVm.STPercentage = 20; //objCIPOVm.ITPercentage = 20; //objCIPOVm.TDTax = 0.00m; //objCIPOVm.CleaningPrice = 0.00m; //objCIPOVm.TotalPrice = 0.00m; //objCIPOVm.ASTPercentage = 20; //objCIPOVm.CleaningPrice = 20; //objPurchaseProperty.poNumber = ""; //objpurchaseBll = new LP_Purchase_BLL(objPurchaseProperty); //objPurchaseVM_Property.poNumber = objpurchaseBll.GeneratePO();// "PO-001"; // string po = objpurchaseBll.GeneratePO(); return(View("AddNewConsigment", objConsigmentVm)); } } else { return(RedirectToAction("Login", "Account")); } }
//public string GeneratePO() //{ // SqlCommand cmdToExecute = new SqlCommand(); // cmdToExecute.CommandText = "dbo.[sp_GeneratePONumber]"; // cmdToExecute.CommandType = CommandType.StoredProcedure; // // Use base class' connection object // cmdToExecute.Connection = _mainConnection; // try // { // //cmdToExecute.Parameters.Add(new SqlParameter("@tablename", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, ObjDepartmentProperty.TableName)); // //cmdToExecute.Parameters.Add(new SqlParameter("@coulmn", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed,"'"+ ObjDepartmentProperty.ColumnName+"'")); // cmdToExecute.Parameters.Add(new SqlParameter("@userid", SqlDbType.Int, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, _objPOMasterProperty.createdByUserIdx)); // // cmdToExecute.Parameters.Add(new SqlParameter("@PoNumber", SqlDbType.NVarChar, 32, ParameterDirection.Output, true, 10, 0, "", DataRowVersion.Proposed, _objPOMasterProperty.poNumber)); // if (_mainConnectionIsCreatedLocal) // { // // Open connection. // _mainConnection.Open(); // } // else // { // if (_mainConnectionProvider.IsTransactionPending) // { // cmdToExecute.Transaction = _mainConnectionProvider.CurrentTransaction; // } // } // // Execute query. // // _errorCode = (Int32)cmdToExecute.Parameters["@iErrorCode"].Value; // //if (_errorCode != (int)LLBLError.AllOk) // //{ // // // Throw error. // // throw new Exception("Stored Procedure 'pr_PRODUCT_SETUP_SelectAll' reported the ErrorCode: " + _errorCode); // //} // //_rowsAffected = Convert.ToInt32(cmdToExecute.ExecuteScalar()); // return cmdToExecute.Parameters["@PoNumber"].Value.ToString(); //_rowsAffected; // } // catch (Exception ex) // { // // some error occured. Bubble it to caller and encapsulate Exception object // throw new Exception("PRODUCT_SETUP::SelectAll::Error occured.", ex); // } // finally // { // if (_mainConnectionIsCreatedLocal) // { // // Close connection. // _mainConnection.Close(); // } // cmdToExecute.Dispose(); // } //} public DataTable GenerateVoucherNo(LP_GenerateTransNumber_Property objTranNo) { SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "dbo.[sp_GenerateTransNo]"; cmdToExecute.CommandType = CommandType.StoredProcedure; DataTable toReturn = new DataTable("Po"); SqlDataAdapter adapter = new SqlDataAdapter(cmdToExecute); // Use base class' connection object cmdToExecute.Connection = _mainConnection; try { cmdToExecute.Parameters.Add(new SqlParameter("@tablename", SqlDbType.VarChar, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objTranNo.TableName)); cmdToExecute.Parameters.Add(new SqlParameter("@identityfieldname", SqlDbType.NVarChar, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objTranNo.Identityfieldname)); cmdToExecute.Parameters.Add(new SqlParameter("@userid", SqlDbType.Int, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objTranNo.userid)); if (_mainConnectionIsCreatedLocal) { // Open connection. _mainConnection.Open(); } else { if (_mainConnectionProvider.IsTransactionPending) { cmdToExecute.Transaction = _mainConnectionProvider.CurrentTransaction; } } // Execute query. adapter.Fill(toReturn); if (toReturn.Rows.Count > 0) { //ObjDepartmentProperty.Department_Id = (Int32)toReturn.Rows[0]["ID"]; //ObjDepartmentProperty.DepartmentName = (string)toReturn.Rows[0]["DepartmentName"]; //objBankProperty.idx = Convert.ToInt32(toReturn.Rows[0]["idx"]);// == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["idx"]); //objBankProperty.bankName = (toReturn.Rows[0]["bankName"].ToString());// == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["bankName"]).ToString(); //objBankProperty.creationDate = Convert.ToDateTime((toReturn.Rows[0]["creationDate"]));// == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["creationDate"])); //objBankProperty.visible = (int)toReturn.Rows[0]["visible"]; //objBankProperty.createdByUserIdx = (int)toReturn.Rows[0]["createdByUserIdx"]; // ObjDepartmentProperty.ISActive = (bool)toReturn.Rows[0]["IsActive"]; // //toReturn.Rows[0]["Product_Form_ID"] == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["Product_Form_ID"]; // ObjDepartmentProperty.UserId = (int)toReturn.Rows[0]["UserID"]; //string a= (toReturn.Rows[0]["bankName"] == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["bankName"]).ToString(); // ObjDepartmentProperty.CreatedDate = (DateTime)toReturn.Rows[0]["DateCreated"]; // ObjDepartmentProperty.CustomerAddress = (string)toReturn.Rows[0]["Address"]; // toReturn.Rows[0]["Product_Parent_Code"] == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["Product_Parent_Code"]; } return(toReturn); } catch (Exception ex) { // some error occured. Bubble it to caller and encapsulate Exception object throw new Exception("PRODUCT_SETUP::SelectOne::Error occured.", ex); } finally { if (_mainConnectionIsCreatedLocal) { // Close connection. _mainConnection.Close(); } cmdToExecute.Dispose(); adapter.Dispose(); } }
public ActionResult AddNewCustomer(int?id) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); string pagename = @"/" + controllerName + @"/" + actionName; var page = (List <LP_Pages_Property>)Session["PageList"]; if (Session["LoggedIn"] != null && Helper.CheckPageAccess(pagename, page) && Session["ISADMIN"] != null && Convert.ToBoolean(Session["ISADMIN"].ToString()) == true) { int customerTypeIdx; objCustomerProperty = new Customers_Property(); objCustomerProperty.idx = Convert.ToInt32(id); objCustomer = new Customers_BLL(objCustomerProperty); DataTable customerTypes = objCustomer.GetCustomerType(); List <CustomerType_Property> CustomersLST = new List <CustomerType_Property>(); foreach (DataRow dr in customerTypes.Rows) { CustomerType_Property objVendorsCat = new CustomerType_Property(); objVendorsCat.customerType = dr["customerType"].ToString(); objVendorsCat.idx = Convert.ToInt32(dr["idx"].ToString()); CustomersLST.Add(objVendorsCat); } ViewBag.CustomersLST = CustomersLST; if (id != null || id > 0) { var dt = objCustomer.GetCustomerById(); objCustomerProperty.idx = int.Parse(dt.Rows[0]["idx"].ToString()); int.TryParse(dt.Rows[0]["customerTypeIdx"].ToString(), out customerTypeIdx); objCustomerProperty.customerTypeIdx = customerTypeIdx; //objCustomerProperty.vendorCatIdx = int.Parse(dt.Rows[0]["vendorCatIdx"].ToString()); //objVendorsProperty.unitIdx = int.Parse(dt.Rows[0]["unitIdx"].ToString()); objCustomerProperty.contact = (dt.Rows[0]["contact"].ToString()); objCustomerProperty.customerCode = (dt.Rows[0]["customerCode"].ToString()); objCustomerProperty.customerName = (dt.Rows[0]["customerName"].ToString()); objCustomerProperty.address = (dt.Rows[0]["address"].ToString()); return(View(objCustomerProperty)); } else { objCustomerProperty.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); objCustomer = new Customers_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "customers"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objCustomerProperty.customerCode = objCustomer.GenerateSO(objtrans); return(View(objCustomerProperty)); } } else { if (Session["LoggedIn"] == null) { return(RedirectToAction("Login", "Account")); } else { return(RedirectToAction("NotAuthorized", "Account")); } } }
public ActionResult AddNewSalesOrder(int?id) { if (Session["LOGGEDIN"] != null) { objSalesOrderVM_Property = new SalesOrderVM_Property(); Customers_Property vendor = new Customers_Property(); Product_Property product = new Product_Property(); Customers_BLL objcustomerbll = new Customers_BLL(); Product_BLL objProductbll = new Product_BLL(); LP_Quotation_BLL objQuotationbll = new LP_Quotation_BLL(); WareHouse_BLL objWareHouseBLL = new WareHouse_BLL(); objSalesOrderVM_Property.QSList = Helper.ConvertDataTable <LP_Quotation_Master_Property>(objQuotationbll.SelectQS()); objSalesOrderVM_Property.CustomerLST = Helper.ConvertDataTable <Customers_Property>(objcustomerbll.ViewAllCustomers()); objSalesOrderVM_Property.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll()); objSalesOrderVM_Property.BankList = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks()); objSalesOrderVM_Property.wareHouseList = Helper.ConvertDataTable <WareHouse_Property>(objWareHouseBLL.SelectAll()); objSalesOrderVM_Property.salesorderDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); Taxes_Property obj = new Taxes_Property(); Taxes_BLL objtaxBLL = new Taxes_BLL(obj); ViewBag.TaxList = Helper.ConvertDataTable <Taxes_Property>(objtaxBLL.GetTaxesForCheckBox()); //objSalesOrderVM_Property.poNumber = "Po-001"; if (id > 0) { LP_SalesOrder_Detail_Property objmSalesOrderdetail; objSalesOrderProperty = new LP_SalesOrder_Master_Property(); objSalesOrderProperty.idx = Convert.ToInt16(id); objSalesOrderBll = new LP_SalesOrder_BLL(objSalesOrderProperty); DataTable dt = objSalesOrderBll.SelectOne(); objSalesOrderVM_Property.idx = Convert.ToInt16(dt.Rows[0]["salesorderIdx"].ToString()); objSalesOrderVM_Property.customerIdx = Convert.ToInt32(dt.Rows[0]["customerIdx"].ToString()); objSalesOrderVM_Property.soNumber = dt.Rows[0]["soNumber"].ToString(); objSalesOrderVM_Property.description = dt.Rows[0]["description"].ToString(); objSalesOrderVM_Property.qsIdx = Convert.ToInt16(dt.Rows[0]["qsIdx"].ToString()); objSalesOrderVM_Property.totalAmount = Convert.ToDecimal(dt.Rows[0]["totalAmount"].ToString()); string pdate = (dt.Rows[0]["salesorderdate"].ToString()).ToString(); string ndate = DateTime.Parse(pdate).ToString("yyyy-MM-dd"); objSalesOrderVM_Property.salesorderDate = 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 <SalesOrderVM_Property>(dt); //update return(View("AddNewSalesOrder", objSalesOrderVM_Property)); } else { //objSalesOrderProperty = new LP_SalesOrder_Master_Property(); objSalesOrderVM_Property.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); objSalesOrderBll = new LP_SalesOrder_BLL(); LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "SalesOrder"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objSalesOrderVM_Property.soNumber = objSalesOrderBll.GenerateSO(objtrans); //objSalesOrderProperty.poNumber = ""; //objSalesOrderBll = new LP_SalesOrder_BLL(objSalesOrderProperty); //objSalesOrderVM_Property.poNumber = objSalesOrderBll.GeneratePO();// "PO-001"; // string po = objSalesOrderBll.GeneratePO(); return(View("AddNewSalesOrder", objSalesOrderVM_Property)); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddNewProduct(int?id) { if (Session["LOGGEDIN"] != null) { objProductProperty = new Product_Property(); objProductProperty.idx = Convert.ToInt32(id); //objProductProperty.branchIdx = 1;//It will have the value of session branchIdx objProductBLL = new Product_BLL(objProductProperty); DataTable categories = objProductBLL.ddlCategory(); List <Product_Category_Property> catLST = new List <Product_Category_Property>(); DataTable subCategories = objProductBLL.ddlSubCategory(); List <Product_SubCategory_Property> subCatLST = new List <Product_SubCategory_Property>(); DataTable productTypes = objProductBLL.ddlProductType(); List <Product_Type_Property> productTypeLST = new List <Product_Type_Property>(); DataTable units = objProductBLL.ddlUnit(); List <itemUnit_Property> unitLST = new List <itemUnit_Property>(); foreach (DataRow dr in categories.Rows) { Product_Category_Property objProductCat = new Product_Category_Property(); objProductCat.Category = dr["category"].ToString(); objProductCat.idx = Convert.ToInt32(dr["idx"].ToString()); catLST.Add(objProductCat); } ViewBag.catLST = catLST; foreach (DataRow dr in subCategories.Rows) { Product_SubCategory_Property objProductCat = new Product_SubCategory_Property(); objProductCat.subCategory = dr["subCategory"].ToString(); objProductCat.idx = Convert.ToInt32(dr["idx"].ToString()); subCatLST.Add(objProductCat); } ViewBag.subCatLST = subCatLST; foreach (DataRow dr in productTypes.Rows) { Product_Type_Property objProductCat = new Product_Type_Property(); objProductCat.productType = dr["productType"].ToString(); objProductCat.idx = Convert.ToInt32(dr["idx"].ToString()); productTypeLST.Add(objProductCat); } ViewBag.productTypeLST = productTypeLST; foreach (DataRow dr in units.Rows) { itemUnit_Property objProductCat = new itemUnit_Property(); objProductCat.itemUnit = dr["itemUnit"].ToString(); objProductCat.idx = Convert.ToInt32(dr["idx"].ToString()); unitLST.Add(objProductCat); } ViewBag.unitLST = unitLST; if (id != null && id != 0) { decimal cp, sp, pt; var dt = objProductBLL.GetById(id); //objProductProperty.companyIdx = 1; objProductProperty.idx = int.Parse(dt.Rows[0]["idx"].ToString()); objProductProperty.productTypeIdx = int.Parse(dt.Rows[0]["productTypeIdx"].ToString()); objProductProperty.productCatIdx = int.Parse(dt.Rows[0]["productCatIdx"].ToString()); objProductProperty.productSubCatIdx = int.Parse(dt.Rows[0]["productSubCatIdx"].ToString()); objProductProperty.unitIdx = int.Parse(dt.Rows[0]["unitIdx"].ToString()); objProductProperty.HSCODE = (dt.Rows[0]["HSCODE"].ToString()); objProductProperty.itemCode = (dt.Rows[0]["itemCode"].ToString()); objProductProperty.itemName = (dt.Rows[0]["itemName"].ToString()); objProductProperty.description = (dt.Rows[0]["description"].ToString()); //objProductProperty.costPrice = 0.00m; string costPrice = (dt.Rows[0]["costPrice"].ToString()); decimal.TryParse(costPrice, out cp); objProductProperty.costPrice = cp; string salePrice = (dt.Rows[0]["salePrice"].ToString()); decimal.TryParse(salePrice, out sp); objProductProperty.salePrice = sp; string productTax = (dt.Rows[0]["productTax"].ToString()); decimal.TryParse(productTax, out pt); objProductProperty.productTax = pt; //objProductProperty.product_catIdx = int.Parse(dt.Rows[0]["product_catIdx"].ToString()); //objProductProperty.subCategory = dt.Rows[0]["subCategory"].ToString(); //objProductProperty.HS_CodeSub = dt.Rows[0]["HS_CodeSub"].ToString(); ////objProductProperty.firstName = dt.Rows[0]["firstName"].ToString(); //objProductProperty.lastName = dt.Rows[0]["lastName"].ToString(); //objProductProperty.CNIC = (dt.Rows[0]["CNIC"].ToString()); //objProductProperty.cellNumber = (dt.Rows[0]["cellNumber"].ToString()); //objProductProperty.loginId = (dt.Rows[0]["loginId"].ToString()); //objProductProperty.password = dt.Rows[0]["password"].ToString(); } else { LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "products"; objtrans.Identityfieldname = "idx"; objtrans.userid = Session["UID"].ToString(); objProductProperty.itemCode = objProductBLL.GenerateProductCode(objtrans); } return(PartialView("_AddNewProduct", objProductProperty)); } else { return(RedirectToAction("Login", "Account")); } }
// GET: Finance public ActionResult GeneralVoucher(int?id) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); string pagename = @"/" + controllerName + @"/" + actionName; var page = (List <LP_Pages_Property>)Session["PageList"]; if (Session["LoggedIn"] != null && Helper.CheckPageAccess(pagename, page) && Session["ISADMIN"] != null && Convert.ToBoolean(Session["ISADMIN"].ToString()) == true) { objGV = new LP_GeneralVoucher_Property(); objGVBLL = new LP_GeneralVoucher_BLL(); fourthTier_Property objPropertyChildHead = new fourthTier_Property(); fourthTier_BLL objLastBLL = new fourthTier_BLL(objPropertyChildHead); objGV.AccountLST = Helper.ConvertDataTable <fourthTier_Property>(objLastBLL.ViewAll()); objSalesOrderVM_Property = new SalesOrderVM_Property(); if (id > 0) { LP_SalesOrder_Detail_Property objmSalesOrderdetail; objSalesOrderProperty = new LP_SalesOrder_Master_Property(); objSalesOrderProperty.idx = Convert.ToInt16(id); objSalesOrderBll = new LP_SalesOrder_BLL(objSalesOrderProperty); DataTable dt = objSalesOrderBll.SelectOne(); objSalesOrderVM_Property.idx = Convert.ToInt16(dt.Rows[0]["salesorderIdx"].ToString()); objSalesOrderVM_Property.customerIdx = Convert.ToInt32(dt.Rows[0]["customerIdx"].ToString()); objSalesOrderVM_Property.soNumber = dt.Rows[0]["soNumber"].ToString(); objSalesOrderVM_Property.description = dt.Rows[0]["description"].ToString(); objSalesOrderVM_Property.qsIdx = Convert.ToInt16(dt.Rows[0]["qsIdx"].ToString()); objSalesOrderVM_Property.totalAmount = Convert.ToDecimal(dt.Rows[0]["totalAmount"].ToString()); string pdate = (dt.Rows[0]["salesorderdate"].ToString()).ToString(); string ndate = DateTime.Parse(pdate).ToString("yyyy-MM-dd"); objSalesOrderVM_Property.salesorderDate = Convert.ToDateTime(ndate);// DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd"); ViewBag.DetailData = Helper.ConvertDataTable <SalesOrderVM_Property>(dt); //update return(View("AddNewSalesOrder", objSalesOrderVM_Property)); } else { LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property(); objtrans.TableName = "accountMasterGL"; objtrans.Identityfieldname = "idxx"; objtrans.userid = Session["UID"].ToString(); objGV.voucherNo = objGVBLL.GenerateSO(objtrans); objGV.voucherDate = DateTime.Now.ToString("yyyy-MM-dd"); objSalesOrderVM_Property.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString()); return(View("GeneralVoucher", objGV)); } } else { if (Session["LoggedIn"] == null) { return(RedirectToAction("Login", "Account")); } else { return(RedirectToAction("NotAuthorized", "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")); } }