/// <summary>
/// 创建产品索引
/// </summary>
private void CreateProductIndex(string indexPath)
{
Product_BLL productBll = new Product_BLL();
LuceneNet lucene = new LuceneNet(indexPath);
var products = productBll.GetProduct();
#region 需要添加到索引的字段
var needCreateField = new Dictionary <string, bool>();
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.PID), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.Description), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.Name), true);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.IsBest), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.IsHot), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.IsNew), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.IsRecommend), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.MarketPrice), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.OfficialGuarantee), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.SaleCount), false);
needCreateField.Add(Utilities.GetPropertyName <Product>(f => f.ShowImg), false);
#endregion
var isCreateSuccess = lucene.CreateIndexByData <Product>(products, needCreateField, true);
if (!isCreateSuccess)
{
//如果索引没有创建成功通知管理员
}
}
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 ReturnSales(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.idx = Convert.ToInt32(id);
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());
//objPInvoiceVM = new LP_PI_ViewModel();
//objPIProperty = new LP_P_Invoice_Property();
//objPIProperty.idx = Convert.ToInt32(id);
//objPIBLL = new LP_PInvoice_BLL(objPIProperty);
//objPInvoiceVM.TaxesList = Helper.ConvertDataTable<Taxes_Property>(GetAllTaxes());
//objPInvoiceVM.ProductList = Helper.ConvertDataTable<Product_Property>(ViewAllProducts());
//objPInvoiceVM.BankList = Helper.ConvertDataTable<Company_Bank_Property>(GetAllCompanyBanks());
DataSet DS = objSalesOrderBll.SelectSIWithDetailData(objSalesOrderVM_Property.idx);
//DataSet DS = objPIBLL.SelectPIWithDetailData(objPIProperty.idx);
if (DS.Tables.Count > 0)
{
ViewBag.isReturn = 1;
objSalesOrderVM_Property.SalesOrderDetailLST = Helper.ConvertDataTable <SalesOrdersDetails_Property>(DS.Tables[0]);
if (DS.Tables[1].Rows.Count > 0)
{
objSalesOrderVM_Property.salesTaxesLST = Helper.ConvertDataTable <LP_salesTaxes_Property>(DS.Tables[1]);
}
}
return(View("AddNewSalesOrder", objSalesOrderVM_Property));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public JsonResult AddUpdate(Product_Property objProductCategory)
{
if (Session["LOGGEDIN"] != null)
{
try
{ if (objProductCategory.productTypeIdx == 2)
{
objProductCategory.DetailData = Helper.ToDataTable <LP_ProductDetailsForCombo_Property>(objProductCategory.ProductDetailLST);
}
if (objProductCategory.idx > 0)
{
objProductCategory.lastModifiedByUserIdx = Convert.ToInt32(Session["UID"].ToString());
objProductCategory.lastModificationDate = DateTime.Now.ToString("dd/MM/yyyy");
objProductBLL = new Product_BLL(objProductCategory);
bool flag = objProductBLL.Update();
return(Json(new { data = "Updated", success = flag, statuscode = 200 }, JsonRequestBehavior.AllowGet));
}
else
{
//objProductCategory.companyIdx = 1;
objProductCategory.createdByUserIdx = Convert.ToInt32(Session["UID"].ToString());
objProductCategory.TableName = "productDetailsForCombo";
objProductBLL = new Product_BLL(objProductCategory);
//if (objProductCategory.isMainBranch == 1)
//{
// var check = objProductCategory.MainBranch();
// if (check.Rows.Count > 0)
// {
// return Json(new { data = "Main Branch Already Exist", success = false, statuscode = 500 }, JsonRequestBehavior.AllowGet);
// }
//}
bool flag = objProductBLL.Insert();
return(Json(new { data = "Inserted", success = flag, statuscode = 200 }, JsonRequestBehavior.AllowGet));
} }
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { data = "Session Expired", success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(int?id)
{
if (Session["LOGGEDIN"] != null)
{
try
{
if (id > 0)
{
Product_Property branchProperty = new Product_Property();
branchProperty.idx = int.Parse(id.ToString());
objProductBLL = new Product_BLL(id);
Product_BLL branhcBll = new Product_BLL(branchProperty);
var flag1 = branhcBll.Delete(id);
//if (flag1.Rows.Count > 0)
//{
if (true)
{
bool flag = objProductBLL.Delete(id);
return(Json(new { data = "Deleted", success = flag, statuscode = 200 }, JsonRequestBehavior.AllowGet));
}
//else
//{
// return Json(new { data = "Mian Branch Cannot be Delete ", success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet);
//}
//}
// return Json(new { data = "Process Completed ", success = true, statuscode = 200 }, JsonRequestBehavior.AllowGet);
}
else
{
return(Json(new { data = "Error Occur", success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { data = "Session Expired", success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
//public DataTable GetAllHSCodes()
//{
// objProduct = new Product_BLL();
// return objProduct.ViewAll();
//}
public DataTable ViewAllProduct()
{
if (Session["LOGGEDIN"] != null)
{
try
{
Product_Property objProductProperty = new Product_Property();
//objProductProperty.branchIdx = 1;//user logged in session branchIdx
Product_BLL objProductBLL = new Product_BLL(objProductProperty);
return(objProductBLL.ViewAll());
}
catch (Exception ex)
{
return(new DataTable());
}
}
else
{
return(new DataTable());
}
}
public JsonResult GetAllProducts()
{
if (Session["LOGGEDIN"] != null)
{
try
{
objProductProperty = new Product_Property();
//objProductProperty.branchIdx = 1;//user logged in session branchIdx
objProductBLL = new Product_BLL(objProductProperty);
var Data = JsonConvert.SerializeObject(objProductBLL.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));
}
}
else
{
return(Json(new { data = "Session Expired", 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"));
}
}
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"));
}
}
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"));
}
}
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"));
}
}