public async Task <int> DeleteProductPriceDetail(int id)
{
ProductPriceDetail productCategoryDetail = await _allInOneContext.ProductPriceDetail.FirstOrDefaultAsync(s => s.Id == id);
_allInOneContext.ProductPriceDetail.Remove(productCategoryDetail);
return(await _allInOneContext.SaveChangesAsync());
}
public async Task <ProductPriceDetailModel> GetProductPriceDetail(int id)
{
ProductPriceDetail productPriceDetail = await _productRepository.GetProductPriceDetail(id);
ProductPriceDetailModel productPriceDetailModel = new ProductPriceDetailModel();
return(productPriceDetailModel);
}
private bool checkRangeDateNhomVatTuNCC(ProductPriceHeader header, ProductPriceDetail data)
{
if (data.ngay_ap_dung > header.ngay_ket_thuc || data.ngay_ap_dung < header.ngay_ap_dung ||
data.ngay_ket_thuc > header.ngay_ket_thuc)
{
return(false);
}
return(true);
}
public async Task <List <ProductPriceDetailModel> > UpdateProductPriceDetail(ProductPriceDetailModel productPriceDetailModel)
{
ProductPriceDetail productPriceDetail = await _productRepository.GetProductPriceDetail(productPriceDetailModel.Id);
productPriceDetail.BuyOrSell = productPriceDetailModel.BuyOrSell;
productPriceDetail.ModifiedBy = 5;
productPriceDetail.ModifiedByTs = DateTime.Now;
productPriceDetail.Date = ConvertDate(productPriceDetailModel.Date);
productPriceDetail.IsActive = true;
productPriceDetail.ProductCategoryId = productPriceDetailModel.ProductCategoryId;
productPriceDetail.ProductId = productPriceDetailModel.ProductId;
productPriceDetail.Quantity = productPriceDetailModel.Quantity;
productPriceDetail.UnitPrice = productPriceDetailModel.UnitPrice;
productPriceDetail.Total = productPriceDetailModel.Total;
productPriceDetail.WeightType = productPriceDetailModel.WeightType;
await _productRepository.UpdateProductPriceDetail(productPriceDetail);
return(await GetProductPriceList());
}
private void DoBatchSave()
{
IList <string> entStrList = RequestData.GetList <string>("data");
string priceType = RequestData.Get <string>("PriceType");
string sql = string.Empty;
if (entStrList != null && entStrList.Count > 0)
{
for (int k = 0; k < entStrList.Count; k++)
{
Newtonsoft.Json.Linq.JObject objL = JsonHelper.GetObject <Newtonsoft.Json.Linq.JObject>(entStrList[k]);
IList <ProductPriceDetail> ppdEnts = ProductPriceDetail.FindAllByProperties("ProductId", objL.Value <string>("ProductId"), "PriceTypeName", priceType);
if (ppdEnts.Count > 0)
{
ppdEnts[0].Price = objL.Value <decimal>(priceType);
ppdEnts[0].DoUpdate();
}
else
{
ProductPriceDetail ppdEnt = new ProductPriceDetail();
string parentId = DataHelper.QueryValue("select EnumerationID from SHHG_AimPortal.dbo.SysEnumeration where Code='PriceType'").ToString();
SysEnumeration[] seEnts = SysEnumeration.FindAllByProperties("Name", priceType, "ParentID", parentId);
if (seEnts.Length > 0)
{
ppdEnt.EnumerationID = seEnts[0].EnumerationID;
}
ppdEnt.PriceTypeName = priceType;
ppdEnt.ProductId = objL.Value <string>("ProductId");
ppdEnt.ProductName = objL.Value <string>("产品名称");
ppdEnt.ProductCode = objL.Value <string>("产品型号");
ppdEnt.ProductPCN = objL.Value <string>("PCN");
ppdEnt.Price = objL.Value <decimal>(priceType);
ppdEnt.DoCreate();
}
}
}
}
public ActionResult ApproveList(string data)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
string[] separators = { "@@" };
var listid = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
foreach (var id in listid)
{
var datavendor = dbConn.FirstOrDefault <StatementVendorHeader>("ma_to_trinh_ncc ={0}".Params(id));
var datavendordetail = dbConn.Select <StatementVendorDetail>("ma_to_trinh_ncc ={0}".Params(id));
var databg = new ProductPriceHeader
{
nha_cung_cap_id = datavendor.nha_cung_cap_id,
ngay_ap_dung = datavendor.ngay_ap_dung,
ngay_bao_gia = datavendor.ngay_ap_dung,
ngay_ket_thuc = datavendor.ngay_ket_thuc,
ghi_chu = datavendor.ghi_chu,
trang_thai = "DANG_HOAT_DONG",
nguoi_tao = currentUser.ma_nguoi_dung,
ngay_tao = DateTime.Now
};
var isExist = dbConn.SingleOrDefault <ProductPriceHeader>("select * from ProductPriceHeader order by id desc");
var prefix = "CSG";
if (isExist != null)
{
var nextNo = int.Parse(isExist.ma_chinh_sach_gia.Substring(9, isExist.ma_chinh_sach_gia.Length - 9)) + 1;
databg.ma_chinh_sach_gia = prefix + DateTime.Now.ToString("yyMMdd") + String.Format("{0:00}", nextNo);
}
else
{
databg.ma_chinh_sach_gia = prefix + DateTime.Now.ToString("ddMMyy") + "01";
}
dbConn.Insert(databg);
foreach (var item in datavendordetail)
{
var detail = new ProductPriceDetail {
ma_chinh_sach_gia = databg.ma_chinh_sach_gia,
ma_vat_tu = item.ma_vat_tu,
gia_bao = item.gia_bao,
thue_vat = item.thue_vat,
gia_bao_gom_vat = item.gia_bao_gom_vat,
ngay_ap_dung = item.ngay_ap_dung,
ngay_ket_thuc = item.ngay_ket_thuc,
don_vi_tinh = item.don_vi_tinh,
sl_min = item.sl_min,
sl_max = item.sl_max,
nguoi_tao = currentUser.ma_nguoi_dung,
ngay_tao = DateTime.Now
};
dbConn.Insert(detail);
}
dbConn.Update <StatementVendorHeader>(set: "trang_thai={0}".Params(AllConstant.TRANGTHAI_DA_DUYET), where : "ma_to_trinh_ncc={0}".Params(id));
}
dbTrans.Commit();
return(Json(new { success = true }));
}
catch (Exception e)
{
dbTrans.Rollback();
return(Json(new { success = false, error = e.Message }));
}
}
}
public ActionResult Prices()
{
if (Session["userlogin"] == null)
{
return(Redirect(@SharedRess.SharedStrings.login));
//RedirectToAction("UserLogin", "FProduct");
}
ProductPriceModel model = new ProductPriceModel();
int pId = 0;
using (MainContext db = new MainContext())
{
if (RouteData.Values["id"] != null)
{
pId = Convert.ToInt32(RouteData.Values["id"]);
}
else
{
pId = db.ProductGroup.Where(x => x.TopProductId == 1 && x.Deleted == false).OrderByDescending(d => d.SortNumber).FirstOrDefault().ProductGroupId;
}
var groups = db.ProductGroup.Where(x => x.TopProductId == pId && x.Deleted == false).ToList();
int[] groupIds = groups.Select(x => x.ProductGroupId).ToArray();
List <ProductHeaders> productHeaders = db.ProductHeaders.Where(x => groupIds.Contains(x.CategoryId)).ToList();
List <Product> products = db.Product.Where(x => x.TopProductGroupId == pId && x.Deleted == false && x.Online == true).OrderBy(x => x.SortNumber).ToList();
int[] prIds = db.Product.Select(x => x.ProductId).ToArray();
List <ProductInformation> procudtDetails = db.ProductInformation.Where(x => prIds.Contains(x.ProductId)).ToList();
foreach (var item in products)
{
ProductPriceDetail detail = new ProductPriceDetail();
detail.ProductName = item.Name;
detail.CategoryId = item.ProductGroupId;
detail.ProductId = item.ProductId;
detail.PageSlug = item.PageSlug;
detail.headers = productHeaders.FirstOrDefault(x => x.CategoryId == detail.CategoryId);
detail.productsinfo = procudtDetails.Where(x => x.ProductId == detail.ProductId).ToList();
model.Info.Add(detail);
}
var grps = ProductManager.GetProductGroupListForFront(lang);
model.prodgroups = new List <ProductGroup>();
foreach (var item in grps)
{
ProductGroup pg = new ProductGroup();
pg.GroupName = item.GroupName;
pg.ProductGroupId = item.ProductGroupId;
pg.PageSlug = item.PageSlug;
pg.TopProductId = item.TopProductId;
model.prodgroups.Add(pg);
}
ViewBag.ProductGroup = ProductManager.GetProductGroupItem(pId);
if (Session["userlogin"] != null)
{
ViewBag.userloginemail = Session["userlogin"];
}
else
{
ViewBag.userloginemail = "";
}
return(View(model));
}
//List<ProductHeaders> headerlist = d
//return View(ProductManager.GetProductListFront(pId).ToList());
return(View());
}
public async Task <int> SaveProductPriceDetail(ProductPriceDetail productPriceDetail)
{
await _allInOneContext.ProductPriceDetail.AddAsync(productPriceDetail);
return(await _allInOneContext.SaveChangesAsync());
}
public ActionResult CreateUpdateDetail(ProductPriceDetail data)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
try
{
if (data.id > 0)
{
//if (accessDetail.sua && ModelState.IsValid)
//{
var exist = dbConn.SingleOrDefault <ProductPriceDetail>("id ={0}", data.id);
if (data.ngay_ap_dung > data.ngay_ket_thuc)
{
return(Json(new { success = false, error = "Ngày kết thúc phải >= ngày áp dụng chính sách giá" }));
}
var csGiaNCC = dbConn.Select <ProductPriceHeader>(p => p.ma_chinh_sach_gia == data.ma_chinh_sach_gia).FirstOrDefault();
if (!checkRangeDateNhomVatTuNCC(csGiaNCC, data))
{
return(Json(new { success = false, error = "Thời gian áp dụng Chính sách giá được phép trong khoảng từ {0} đến {1}".Params(csGiaNCC.ngay_ap_dung, csGiaNCC.ngay_ket_thuc) }));
}
data.nguoi_cap_nhat = currentUser.ma_nguoi_dung;
data.ngay_cap_nhat = DateTime.Now;
data.trang_thai = data.trang_thai;
dbConn.Update(data);
//}
//else
//{
// return Json(new { success = false, error = "Bạn không có quyền cập nhập." });
//}
}
else
{
// if (accessDetail.them && ModelState.IsValid)
// {
var isExist = dbConn.Select <ProductPriceDetail>(p => p.ma_chinh_sach_gia == data.ma_chinh_sach_gia && p.ma_vat_tu == data.ma_vat_tu).FirstOrDefault();
if (isExist != null)
{
return(Json(new { success = false, error = "Nhóm vật tư đã có trong chính sách giá NCC" }));
}
if (data.ngay_ap_dung > data.ngay_ket_thuc)
{
return(Json(new { success = false, error = "Ngày kết thúc phải >= ngày áp dụng chính sách giá" }));
}
var csGiaNCC = dbConn.Select <ProductPriceHeader>(p => p.ma_chinh_sach_gia == data.ma_chinh_sach_gia).FirstOrDefault();
if (!checkRangeDateNhomVatTuNCC(csGiaNCC, data))
{
return(Json(new { success = false, error = "Thời gian áp dụng Chính sách giá được phép trong khoảng từ {0} đến {1}".Params(csGiaNCC.ngay_ap_dung, csGiaNCC.ngay_ket_thuc) }));
}
data.trang_thai = data.trang_thai;
data.ngay_tao = DateTime.Now;
data.nguoi_tao = User.Identity.Name;
data.ngay_cap_nhat = DateTime.Parse("1900-01-01");
dbConn.Insert(data);
//}
//else
//{
// return Json(new { success = false, error = "Bạn không có quyền thêm dữ liệu" });
//}
}
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
return(Json(new { success = true }));
}
}
