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