public async Task <HttpResponseMessage> Get(int id) { try { id = stockService.GetSTOCKS().Take(1).FirstOrDefault().ID; STOCK infoStock = stockService.GetSTOCK(id); return(Request.CreateResponse(HttpStatusCode.OK, infoStock)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
// DELETE: api/Stock/5 public void Delete(int id) { try { STOCK result = db.STOCK.Where(x => x.Code == id.ToString()).FirstOrDefault(); result.IdState = 2; db.SaveChanges(); } catch (Exception ex) { throw ex; } }
public ActionResult Create([Bind(Include = "STOCK_ID,BATCH_ID,PLAN_ID,EXPENSE_ID,STOCK_NUM,STOCK_DATE")] STOCK sTOCK) { if (ModelState.IsValid) { db.STOCK.Add(sTOCK); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sTOCK.EXPENSE_ID); ViewBag.PLAN_ID = new SelectList(db.PLAN, "PLAN_ID", "PRODUCT_ID", sTOCK.PLAN_ID); ViewBag.BATCH_ID = new SelectList(db.PRODUCT, "BATCH_ID", "PRODUCT_ID", sTOCK.BATCH_ID); return(View(sTOCK)); }
// GET: STOCKs/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } STOCK sTOCK = db.STOCK.Find(id); if (sTOCK == null) { return(HttpNotFound()); } return(View(sTOCK)); }
public void Load_Data(STOCK obj) { objstock = obj; txtMa.Text = obj.Stock_ID; txtkihieu.Text = obj.Mobi; txtten.Text = obj.Stock_Name; txtnguoilienhe.Text = obj.Contact; txtdiachi.Text = obj.Address; txtDienthoai.Text = obj.Telephone; txtFax.Text = obj.Fax; txtEmail.Text = obj.Email; txtdiengiai.Text = obj.Description; chkquanli.Checked = obj.Active; looknguoiquanli.EditValue = obj.Manager; }
public async Task <StockModel> AddStock(StockModel stockModel, CancellationToken cancellationToken) { var stock = new STOCK { SECTOR_ID = stockModel.SectorId, NAME = stockModel.Name, SYMBOL = stockModel.Symbol }; dbContext.Stocks.Add(stock); await dbContext.SaveChangesAsync(cancellationToken); //TODO: just return the stock object converted to domain model return(await GetStock(stockModel.Symbol, cancellationToken)); }
/// <summary> /// 判断指定主键Id的记录是否存在——在IIS缓存或数据库中查找 /// </summary> /// <param name="id">主键Id</param> /// <returns></returns> public bool Exist(int id) { if (id <= 0) { return(false); } //判断是否启用缓存 if (CommonBll.IsUseCache()) { return(Exist(x => x.Id == id)); } //从数据库中查找 return(STOCK.Exists(x => x.Id == id)); }
// GET: STOCKs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } STOCK sTOCK = db.STOCK.Find(id); if (sTOCK == null) { return(HttpNotFound()); } ViewBag.CODIGOARTESANO = new SelectList(db.ARTESANO, "CODIGOARTESANO", "CI_RUC_RISE", sTOCK.CODIGOARTESANO); ViewBag.CODIGOPRODUCTO = new SelectList(db.PRODUCTO, "CODIGOPRODUCTO", "NOMBREPRODUCTO", sTOCK.CODIGOPRODUCTO); return(View(sTOCK)); }
// GET: STOCKs/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } STOCK sTOCK = db.STOCK.Find(id); if (sTOCK == null) { return(HttpNotFound()); } ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sTOCK.EXPENSE_ID); ViewBag.PLAN_ID = new SelectList(db.PLAN, "PLAN_ID", "PRODUCT_ID", sTOCK.PLAN_ID); ViewBag.BATCH_ID = new SelectList(db.PRODUCT, "BATCH_ID", "PRODUCT_ID", sTOCK.BATCH_ID); return(View(sTOCK)); }
/// <summary> /// /// </summary> /// <param name="stock"></param> /// <param name="context"></param> /// <param name="productId"></param> /// <returns></returns> //private JArray MapFiles(STOCK stock, SqlConnection connection, int productId = 0) //{ // JArray ja = new JArray(); // string location = FileConverter.REP_FILES_LOCATION + stock.S_ID.TrimEnd(); // //string[] dirs = Directory.GetFiles(location); // DirectoryInfo directorySelected = new DirectoryInfo(location); // foreach (FileInfo fileToCompress in directorySelected.GetFiles()) // { // string path = location + "\\" + fileToCompress.Name; // ja.Add(ParserJSon.GetProductFileJson(fileToCompress.Name, FileConverter.ConvertFileToB64(path), productId)); // //File.Delete(path); // } // return ja; //} /// <summary> /// ! Specifications have to be synchronized first (S_CAT) ! /// Map the Mercator's Stock's S_CAT with Nop's Products's Specs /// </summary> /// <param name="stock"></param> /// <param name="productId"></param> /// <param name="specopts"></param> private JArray MapSpecs(STOCK stock, IDictionary <String, int> specopts, int productId = 0) { JArray ja = new JArray(); string typesResult = WebService.Get(new UrlBuilder("GenericAttribute") .FilterEq("KeyGroup", "SpecificationAttribute") .FilterEq("Key", "Type") .BuildQuery()); JToken[] types = ParserJSon.ParseResultToJTokenList(typesResult); int type1 = types.Where(x => (int)x["Value"] == 1).Select(x => (int)x["EntityId"]).FirstOrDefault(); int type2 = types.Where(x => (int)x["Value"] == 2).Select(x => (int)x["EntityId"]).FirstOrDefault(); int type3 = types.Where(x => (int)x["Value"] == 3).Select(x => (int)x["EntityId"]).FirstOrDefault(); if (type1 != 0) { AddSpec(ja, specopts, stock.S_CAT1, type1, productId); } if (type2 != 0) { AddSpec(ja, specopts, stock.S_CAT2, type2, productId); } if (type3 != 0) { AddSpec(ja, specopts, stock.S_CAT3, type3, productId); } //JToken[] prod = ParserJSon.ParseResultToJTokenList(WebService.Get(String.Format(WebServiceUrls.GET_PRODUCT_BY_MERCATOR_ID,stock.S_ID.TrimEnd()))); JToken[] toDelete = ParserJSon.ParseResultToJTokenList(WebService.Get(new UrlBuilder("ProductSpecificationAttribute") .FilterEq("ProductId", productId) .BuildQuery())); //TODO: revoir delete //foreach (JToken j in toDelete) //{ // if ((int)j["SpecificationAttributeOptionId"] != value) // { // WebService.Delete(String.Format(WebServiceUrls.PRODUCT_SPEC_ATT_BY_ID, (int)j["Id"])); // WebService.Delete(String.Format(WebServiceUrls.SPEC_ATT_OPT_BY_ID, (int)j["SpecificationAttributeOptionId"])); // } //} return(ja); }
public async Task <HttpResponseMessage> Update(STOCK stock1) { try { if (stock1 == null) { int id = stockService.GetSTOCKS().Take(1).FirstOrDefault().ID; stock1 = stockService.GetSTOCK(id); stock1.QUANTITY = "963"; } bool IsModified = stockService.Modifier(stock1); return(Request.CreateResponse(HttpStatusCode.OK, IsModified)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
/// <summary> /// Link product to picture /// </summary> /// <param name="stock"></param> /// <returns></returns> public JArray Sync(STOCK stock, OptionsMercator om, int productId = 0) { this.om = om; JArray picturesLinks = new JArray(); if (productId != 0) { //check if product already has picture JObject productPicture = JObject.Parse(WebService.Get(new UrlBuilder("ProductPicture").FilterEq("ProductId", productId).BuildQuery())); JToken[] pp = productPicture["value"].ToArray(); foreach (JToken p in pp) { //Product has picture if ((int)p["ProductId"] == productId) { //Delete pictures int pictureId = (int)p["PictureId"]; //Delete link WebService.Delete(new UrlBuilder("ProductPicture").Id((int)p["Id"]).BuildQuery()); //Delete picture WebService.Delete(urlBuilder.Id((int)p["PictureId"]).BuildQuery()); } } } //To do for every S_IMAGE SyncPic(stock.S_IMAGE1, picturesLinks, productId); //SyncPic(stock.S_IMAGE2, picturesLinks, productId); //SyncPic(stock.S_IMAGE3, picturesLinks, productId); //SyncPic(stock.S_IMAGE4, picturesLinks, productId); //SyncPic(stock.S_IMAGE5, picturesLinks, productId); //SyncPic(stock.S_IMAGE6, picturesLinks, productId); //SyncPic(stock.S_IMAGE7, picturesLinks, productId); //SyncPic(stock.S_IMAGE8, picturesLinks, productId); //SyncPic(stock.S_IMAGE9, picturesLinks, productId); //SyncPic(stock.S_IMAGE10, picturesLinks, productId); //SyncPic(stock.S_IMAGE11, picturesLinks, productId); //SyncPic(stock.S_IMAGE12, picturesLinks, productId); return(picturesLinks); }
public ActionResult CONSULTERSTOCK(String Id) { using (IDAL dal = new Dal()) { if (dal.VerifierAccesParUtilisateurIdParPrivilegePeut(HttpContext.User.Identity.Name, "CONSULTER_STOCK")) { StockVM2 tempStockVM = new StockVM2(); STOCK Stock = dal.ObtenirStockParId(CRYPTAGE.StringHelpers.Encrypt(Id)); tempStockVM = dal.ConvertirStockStockVM2(Stock); return(View("ConsulterStock", tempStockVM)); } else { ViewBag.ErrorMessage = dal.getErrorMessageFailedAuthorization(); return(View("Error")); } } }
public ActionResult APPROVISIONNERPRODUITS() { using (IDAL dal = new Dal()) { if (dal.VerifierAccesParUtilisateurIdParPrivilegePeut(HttpContext.User.Identity.Name, "APPROVISIONNER_PRODUITS")) { ApprovisionnementStockVM ApprovisionnementVM = new ApprovisionnementStockVM(); STOCK StockPrincipal = dal.ObtenirStockPrincipal(); if (StockPrincipal != null) { ApprovisionnementVM.NomStock = CRYPTAGE.StringHelpers.Decrypt(StockPrincipal.Nom); ApprovisionnementVM.StockId = StockPrincipal.StockID; List <PRODUIT> ListeProduit = dal.ObtenirProduitParStockId(StockPrincipal.StockID); List <ProduitVM> ListeProduitVM = new List <ProduitVM>(); if (ListeProduit != null) { foreach (var produit in ListeProduit) { ListeProduitVM.Add(dal.ConvertirProduitProduitVM(produit)); } } ApprovisionnementVM.Produits = ListeProduitVM; return(View("FormulaireApprovisionnementStock", ApprovisionnementVM)); } else { ViewBag.ErrorMessage = "Verifiez si vous avez defini le Magasin comme stock Principal svp. "; return(View("Error")); } } else { ViewBag.ErrorMessage = dal.getErrorMessageFailedAuthorization(); return(View("Error")); } } }
// [Authorize] public async Task <HttpResponseMessage> Update(COMMANDE cmd) { try { var stockBD = stockService.GetSTOCKS(); STOCK s = null; var CmdBd = commandeService.GetCOMMANDE(cmd.ID); if (CmdBd == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } CmdBd.DATECOMMANDE = cmd.DATECOMMANDE; CmdBd.QUANTITYDEMANDE = cmd.QUANTITYDEMANDE; CmdBd.ID_LABORATOIRE = cmd.ID_LABORATOIRE; CmdBd.ID_PRODUCT = cmd.ID_PRODUCT; CmdBd.RECEIVED = cmd.RECEIVED; CmdBd.QUNTITYRECIEVED = cmd.QUNTITYRECIEVED; CmdBd.DATERECEIVED = cmd.DATERECEIVED; bool IsAdded = commandeService.Modifier(cmd); if (cmd.RECEIVED.Equals("Oui")) { foreach (STOCK n in stockBD) { if (n.ID_PRODUCT == cmd.ID_PRODUCT) { s = n; int result = 0; result = int.Parse(n.QUANTITY) + int.Parse(cmd.QUNTITYRECIEVED); s.QUANTITY = result.ToString(); } } bool IsModified = stockService.Modifier(s); } return(Request.CreateResponse(HttpStatusCode.OK, true)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
/// <summary> /// Add taxes to products (i.e product attributes) (e.g ecotaxe) /// </summary> /// <param name="stock"></param> /// <param name="productId"></param> //private static JArray syncTaxAndCondit(STOCK stock, int productId = 0) //{ // JArray ja = new JArray(); // JObject attributeMapping; // JArray attributeValues; // string productVAttributeId; // //Attributes // foreach (ARTLIENS a in stock.ARTLIENS) // { // if (a.VEN) // { // int attributeId = 0; // productVAttributeId = ""; // //Create attribute if it doesn't exist yet // JObject paO = JObject.Parse(WebService.Get(WebServiceUrls.PRODUCT_ATTRIBUTE + "?$filter=Name+eq+'" + a.STOCK1.S_MODELE.TrimEnd() + "'")); // var pa = paO["value"].ToArray(); // if (pa.Count() == 0) // { // string result = WebService.Post(WebServiceUrls.PRODUCT_ATTRIBUTE, ParserJSon.ParseTaxToProductAttribute(a.STOCK1.S_MODELE.TrimEnd())); // JObject idO = JObject.Parse(result); // attributeId = (int)idO["Id"]; // } // else // { // attributeId = (int)pa[0]["Id"]; // } // attributeMapping = ParserJSon.ParseArtLien1ToProductVariantAttribute(attributeId, productId); // //Add value to attribute // attributeValues = new JArray(); // //JObject pvavO = JObject.Parse(WebService.Get(WebServiceUrls.PRODUCT_VARIANT_ATTRIBUTE_VALUE + "?$filter=ProductAttributeMappingId+eq+" + productVAttributeId)); // //var pvav = pvavO["value"].ToArray(); // attributeValues.Add(ParserJSon.ParseArtLien1ToProductVariantAttributeValue(a.STOCK1.S_MODELE.TrimEnd(), a.STOCK1.S_PRIX_TI)); // attributeMapping.Add("ProductAttributeValues", attributeValues); // ja.Add(attributeMapping); // } // } // if (stock.S_CONDIT_V > 1) // { // attributeMapping = ParserJSon.ParseArtLien1ToProductVariantAttribute(1, productId); // attributeValues = new JArray(); // attributeValues.Add(ParserJSon.ParseArtLien1ToProductVariantAttributeValue(stock.S_CONDIT_V.ToString() + " PC", 0)); // attributeMapping.Add("ProductAttributeValues", attributeValues); // ja.Add(attributeMapping); // } // return ja; //} /// <summary> /// Map product to tier prices (Tarifs in Mercator) /// </summary> /// <param name="stock"></param> /// <param name="productId"></param> /// <param name="connection"></param> //private static JArray MapTierPrices(STOCK stock, SqlConnection connection, int productId) //{ // JArray array = new JArray(); // string json = WebService.Get("TierPrice?$filter=ProductId+eq+" + productId); // JToken[] valuesTP = ParserJSon.ParseResultToJTokenList(json); // List<String> tpToKeep = new List<String>(); // //Get existing customer roles // string jsonCR = WebService.Get("CustomerRole?$filter=IsSystemRole+eq+false"); // JToken[] valuesCR = ParserJSon.ParseResultToJTokenList(jsonCR); // //CustomerRoleID => Price in Nop // IDictionary<String, String> tpMap = new Dictionary<String, String>(); // foreach (JToken v in valuesTP) // { // tpMap.Add(v["CustomerRoleId"].ToString()+"KEY", v["Id"].ToString()); // tpMap.Add(v["CustomerRoleId"].ToString(), v["Price"].ToString()); // } // foreach (JToken v in valuesCR) // { // string tarId = v["SystemName"].ToString().Split('_').Last(); // double tarti = (double)connection.Entry(stock).Property("S_PRIXHT" + tarId).CurrentValue; // decimal remise = GetRemise(stock,connection,tarId); // string concernedPrice; // tpMap.TryGetValue(v["Id"].ToString(), out concernedPrice); // //If TierPrice contains customer role's id => Check if it's the same price // if (concernedPrice != null) // { // //Price have changed => Patch // if (tarti.ToString() != concernedPrice) // { // array.Add(ParserJSon.GetTierPriceJson((int)v["Id"], tarti, remise, productId)); // } // } // //If it's not in it, we add it // else // { // array.Add(ParserJSon.GetTierPriceJson((int)v["Id"], tarti, remise, productId)); // } // } // return array; // //DELETE DONE AUTOMATICALLY WHEN TARIF IS REMOVED //} /// <summary> /// Get remise by stock and tarif /// </summary> /// <param name="stock"></param> /// <param name="context"></param> /// <param name="tarId"></param> /// <returns></returns> //private static decimal GetRemise(STOCK stock, SqlConnection connection, string tarId) //{ // string scat2 = stock.S_CAT2; // var cats = from c in context.CAT_STCK // where c.NOM.TrimEnd() == scat2.TrimEnd() // select c; // if(cats.FirstOrDefault() != null) // { // CAT_STCK cs = cats.FirstOrDefault(); // object tarti = context.Entry(cs).Property("CAT" + tarId).CurrentValue; // return (decimal)(double)tarti; // } // return 0; //} /// <summary> /// Add a new entry in Nop Product_Category_Mapping Table /// </summary> private JArray MapCategory(STOCK stock, IDictionary <string, int> categories, int productId = 0) { string ray = stock.S_ID_RAYON.TrimEnd(); string fam = stock.S_ID_FAMIL.TrimEnd(); string ssfam = stock.S_ID_SSFAM.TrimEnd(); //Get CatId string rfsId = (ssfam == "") ? ((fam == "") ? ray : fam) : ssfam; int catId; bool catExists = categories.TryGetValue(rfsId, out catId); //If catID is empty, the rfs have not been syncrhonised. Sync it or do nothing ? if (catExists) { JArray cats = new JArray(); cats.Add(ParserJSon.getProductCategoryJson(catId, productId)); return(cats); } return(null); }
public ActionResult Create([Bind(Include = "CODIGOARTESANO,CODIGOPRODUCTO,CANTIDADPRODUCTO")] STOCK sTOCK) { if (ModelState.IsValid) { try { db.STOCK.Add(sTOCK); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { ModelState.AddModelError("Error al ingreso de datos: ", e.Message); } } ViewBag.CODIGOARTESANO = new SelectList(db.ARTESANO, "CODIGOARTESANO", "CI_RUC_RISE", sTOCK.CODIGOARTESANO); ViewBag.CODIGOPRODUCTO = new SelectList(db.PRODUCTO, "CODIGOPRODUCTO", "NOMBREPRODUCTO", sTOCK.CODIGOPRODUCTO); return(View(sTOCK)); }
/// <summary> /// 获取数据表中的某个值——从数据库中查询,如果使用了缓存,删除成功后会清空本表的所有缓存记录,然后重新加载进缓存 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="expression">条件语句</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Delete(Page page, Expression <Func <STOCK, bool> > expression, bool isAddUseLog = true) { //执行删除 STOCK.Delete(expression); //判断是否启用缓存 if (CommonBll.IsUseCache()) { //清空当前表所有缓存记录 DelAllCache(); //重新载入缓存 GetList(); } if (isAddUseLog) { //添加用户操作记录 UseLogBll.GetInstence().Save(page, "{0}删除了STOCK表记录!"); } }
public async Task <HttpResponseMessage> Delete(int Id) { try { if (Id > 0) { //int id = produitService.GetUsers().Take(1).FirstOrDefault().ID; STOCK stock1 = stockService.GetSTOCK(Id); bool IsDeleted = stockService.Supprimer(stock1); return(Request.CreateResponse(HttpStatusCode.OK, IsDeleted)); } else { return(Request.CreateResponse(HttpStatusCode.OK, false)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
/// <summary> /// Url format : {Rayon}-{Modele}-{Id} /// </summary> /// <param name="s"></param> /// <returns></returns> public static string BuildProductUrl(STOCK s, SqlConnection connection) { string finalUrl = ""; List <string> urlMembers = new List <string>(); string firstMember = RFS.GetRFSNameById(RFS.TYPE.RAYON, s.S_ID_RAYON, connection); if (!String.IsNullOrWhiteSpace(firstMember)) { urlMembers.Add(firstMember); } string secondMember = s.S_MODELE.TrimEnd(); if (!String.IsNullOrWhiteSpace(secondMember)) { urlMembers.Add(secondMember); } string thirdMember = s.S_ID.TrimEnd(); urlMembers.Add(thirdMember); foreach (string u in urlMembers) { if (u == urlMembers.First()) { finalUrl = u; } else if (!String.IsNullOrWhiteSpace(u)) { finalUrl += " " + u; } } finalUrl = Utils.Utils.GetFriendlyUrl(finalUrl); return(finalUrl); }
/// <summary> /// Add or edit a product /// </summary> /// <param name="stock"></param> /// <param name="context"></param> /// <param name="productsMIdMtag"></param> /// <param name="productsToUpdate"></param> /// <param name="products"></param> /// <param name="s_id"></param> /// <returns>The last modiftag</returns> private void ProcessProduct(STOCK stock, SqlConnection connection, List <ProductDatas> productsMIdMtag, Dictionary <string, int> specopts, JArray products, int reapproCategory = 0) { JObject product = new JObject(); List <ProductDatas> pId = productsMIdMtag.Where(x => x.MercatorId == stock.S_ID.TrimEnd()).ToList(); int productId = pId.Count > 0 ? pId.First().Id : 0; //Product exists, check if it needs to be edited //if (existingUrlRecordsSlugAndProductId.ContainsKey(mID + WebServiceUrls.SLUG)) if (productId != 0) { if (IsProductToUpdate(stock, productsMIdMtag)) { //EDIT PRODUCT product = GetProduct(stock, Categories, connection, specopts, productId); if (product != null) { products.Add(product); //IS this needed? //productsToUpdate.Remove(stock.S_ID.TrimEnd()); Console.WriteLine("Produit : " + stock.S_MODELE.TrimEnd() + " mis à jour"); count++; } } } else { //ADD PRODUCT product = GetProduct(stock, Categories, connection, specopts); product.Remove("Id"); products.Add(product); Program.WriteLine("Produit : " + stock.S_MODELE.TrimEnd() + " prêt"); count++; } }
public ActionResult Detail(int id) { STOCK _stockDetail = db.STOCKS.Find(id); List <StockModifyModel> vm = new List <StockModifyModel>(); string _productname = ""; if (_stockDetail.TYPE == 1 || _stockDetail.TYPE == 2) { _productname = db.FERTILIZERs.Where(s => s.OBJECTID == _stockDetail.PRODUCT_ID).FirstOrDefault().NAME; } if (_stockDetail.TYPE == 3) { TechnicalSPEC techSpec = JsonConvert.DeserializeObject <TechnicalSPEC>(_stockDetail.SPEC); _productname = db.TECHNIQUES.Where(s => s.OBJECTID == _stockDetail.PRODUCT_ID).FirstOrDefault().NAME + " " + techSpec.licenseplate; } if (_stockDetail.TYPE == 4 || _stockDetail.TYPE == 5) { CropSPEC cropSpec = JsonConvert.DeserializeObject <CropSPEC>(_stockDetail.SPEC); string CropName = db.CROP_SORT.Where(w => w.OBJECTID == cropSpec.CropSortID).FirstOrDefault().NAME; string CropRepreduktion = db.CROP_REPRODUCTION.Where(s => s.OBJECTID == cropSpec.CropRepreducsiya).FirstOrDefault().NAME; _productname = db.CROPs.Where(s => s.OBJECTID == _stockDetail.PRODUCT_ID).FirstOrDefault().NAME + " - " + CropName + " (" + CropRepreduktion + ")"; } foreach (var item in db.STOCKMODIFies.Where(s => s.STOCKITEMID == _stockDetail.OBJECTID).ToList()) { vm.Add(new StockModifyModel() { OBJECTID = item.OBJECTID, PRODUCTNAME = _productname, DESTINATIONSTATUS = (item.STATUSID == 1) ? "Medaxil" : "Mexaric", MODIFYDATE = item.MODIFYDATE.Value.ToString("MM-dd-yyyy HH:mm"), QUANTITY = item.QUANTITY.ToString(), PLACENAME = item.STOCKPLACE.NAME, WORKERNAME = item.Worker.Name + " " + item.Worker.Surname }); } return(View(vm)); }
public ActionResult CONSULTERLISTEPRODUITS() { using (IDAL dal = new Dal()) { if (dal.VerifierAccesParUtilisateurIdParPrivilegePeut(HttpContext.User.Identity.Name, "CONSULTER_LISTE_PRODUITS")) { List <ProduitVM2> tempListeProduitVM = new List <ProduitVM2>(); STOCK StockPharmacie = dal.ObtenirStockPharmacie(); if (StockPharmacie != null) { List <PRODUIT> tempListeProduit = dal.ObtenirProduitParStockId(StockPharmacie.StockID); ProduitVM2 prodVM; foreach (var p in tempListeProduit) { prodVM = new ProduitVM2(); prodVM = dal.ConvertirProduitProduitVM2(p); tempListeProduitVM.Add(prodVM); } return(View("ConsulterListeProduits", tempListeProduitVM)); } else { ViewBag.ErrorMessage = "Verifiez si vous avez bien definit un stock de la Pharmacie."; return(View("Error")); } } else { ViewBag.ErrorMessage = dal.getErrorMessageFailedAuthorization(); return(View("Error")); } } }
public int STOCK_Insert(STOCK obj) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_Insert", obj.Stock_ID, obj.Stock_Name, obj.Contact, obj.Address, obj.Email, obj.Telephone, obj.Fax, obj.Mobi, obj.Manager, obj.Description, obj.Active )); } catch { //throw ex; return(-1); } }
/// <summary> /// 将STOCK记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.STOCK) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.STOCK</returns> public DataAccess.Model.STOCK Transform(STOCK model) { if (model == null) { return(null); } return(new DataAccess.Model.STOCK { Id = model.Id, SHOP_ID = model.SHOP_ID, STOCK_ID = model.STOCK_ID, STOCK_NAME = model.STOCK_NAME, IsDefBill = model.IsDefBill, IsBool = model.IsBool, Memo = model.Memo, CRT_DATETIME = model.CRT_DATETIME, CRT_USER_ID = model.CRT_USER_ID, MOD_DATETIME = model.MOD_DATETIME, MOD_USER_ID = model.MOD_USER_ID, LAST_UPDATE = model.LAST_UPDATE, Stock_Kind = model.Stock_Kind, }); }
public int Update(STOCK STOCK) { var stock = new STOCK(); return(stock.Update(STOCK.CODE, STOCK.NAME, STOCK.PRICE)); }
public int Remove(STOCK STOCK) { var stock = new STOCK(); return(stock.Delete(STOCK.CODE)); }
// [Authorize] public async Task <HttpResponseMessage> Update(VENTE Vent) { try { bool IsModified = false; STOCK x = null; var stockBD = stockService.GetSTOCKS(); STOCK s = null; var CmdBd = venteService.GetVente(Vent.ID); if (CmdBd == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } foreach (STOCK a in stockBD) { if (a.ID_PRODUCT == CmdBd.ID_PRODUCT) { x = a; } } if (int.Parse(x.QUANTITY) < int.Parse(Vent.QUANTITY)) { IsModified = false; } else { CmdBd.DATEVENTE = Vent.DATEVENTE; CmdBd.QUANTITY = Vent.QUANTITY; CmdBd.ID_PRODUCT = Vent.ID_PRODUCT; IsModified = venteService.Modifier(CmdBd); s = x; int result = 0; result = int.Parse(x.QUANTITY) - int.Parse(Vent.QUANTITY); s.QUANTITY = result.ToString(); } if (IsModified == true) { bool IsModif = stockService.Modifier(s); } /* foreach (STOCK n in stockBD) * { * if (n.ID_PRODUCT == Vent.ID_PRODUCT) * { * s = n; * int result = 0; * result = int.Parse(n.QUANTITY) - int.Parse(Vent.QUANTITY); * s.QUANTITY = result.ToString(); * * } * } */ /* if (Vent == null) * { * int id = venteService.GetVentes().Take(1).FirstOrDefault().ID; * Vent = venteService.GetVente(id); * Vent.QUANTITY = "852"; * * }*/ //bool IsModif = stockService.Modifier(s); if (IsModified == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, IsModified)); } else { return(Request.CreateResponse(HttpStatusCode.OK, IsModified)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult Edit([Bind(Include = "ID,NAME,PRICE,REGION")] COMMODITY cOMMODITY, [Bind(Include = "ID,NAME,PRICE,QUONTITY,SUBTOTAL,UPDATEHISTORY")] STOCK sTOCK) { if (ModelState.IsValid) { db.Entry(cOMMODITY).State = EntityState.Modified; sTOCK.NAME = cOMMODITY.NAME; sTOCK.PRICE = cOMMODITY.PRICE; sTOCK.QUONTITY = (from x in db.STOCK where x.ID == cOMMODITY.ID select x.QUONTITY).Single(); sTOCK.SUBTOTAL = sTOCK.PRICE * sTOCK.QUONTITY; sTOCK.UPDATEHISTORY = DateTime.Now; db.Entry(sTOCK).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cOMMODITY)); }
public UC_KetThucNhap(DataTable _table, int tuychon, int khuvuc) { InitializeComponent(); luachon = tuychon; loai = khuvuc; import = _table; if (khuvuc == 0)//khu vực { CUSTOMER_GROUP objcustomer = new CUSTOMER_GROUP(); foreach (DataRow datarow in import.Rows) { try { objcustomer.Customer_Group_ID = datarow["Mã Khu Vực"].ToString().Trim(); objcustomer.Customer_Group_Name = datarow["Tên Khu Vực"].ToString().Trim(); objcustomer.Description = datarow["Ghi Chú"].ToString().Trim(); objcustomer.Active = true; int rs = new CUSTOMER_GROUPController().ThemCUSTOMER_GROUP(objcustomer); listBoxControl1.Items.Add("Khu Vực " + datarow["Mã Khu Vực"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Khu Vực " + datarow["Mã Khu Vực"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 1)//khách hàng { CUSTOMER objcustomer = new CUSTOMER(); foreach (DataRow datarow in import.Rows) { try { objcustomer.Customer_ID = datarow["Mã Khách Hàng"].ToString().Trim(); objcustomer.CustomerName = datarow["Tên Khách Hàng"].ToString().Trim(); objcustomer.CustomerAddress = datarow["Địa Chỉ"].ToString().Trim(); objcustomer.Tax = datarow["Mã Số Thuế"].ToString().Trim(); objcustomer.Tel = datarow["Điện Thoại Bàn"].ToString().Trim(); objcustomer.Mobile = datarow["Di Động"].ToString().Trim(); objcustomer.Email = datarow["Email"].ToString().Trim(); objcustomer.Fax = datarow["Fax"].ToString().Trim(); objcustomer.BankAccount = datarow["Số Tài Khoản"].ToString().Trim(); objcustomer.BankName = datarow["Tên Ngân Hàng"].ToString().Trim(); objcustomer.Contact = datarow["Người Liên Hệ"].ToString().Trim(); objcustomer.Position = datarow["Chức Vụ"].ToString().Trim(); objcustomer.Description = datarow["Ghi Chú"].ToString().Trim(); objcustomer.Website = datarow["Website"].ToString().Trim(); objcustomer.Barcode = datarow["Mã Vạch"].ToString().Trim(); objcustomer.CreditLimit = double.Parse(datarow["Giới Hạn Nợ"].ToString().Trim()); objcustomer.Discount = double.Parse(datarow["Chiết Khấu"].ToString().Trim()); objcustomer.NickYM = datarow["Nick Yahoo"].ToString().Trim(); objcustomer.NickSky = datarow["Nick Skype"].ToString().Trim(); objcustomer.Active = true; int rs = new CUSTOMERController().ThemCUSTOMER(objcustomer); listBoxControl1.Items.Add("Khách Hàng " + datarow["Mã Khách Hàng"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Khách Hàng " + datarow["Mã Khách Hàng"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 2)// nhà phân phối { PROVIDER objprovider = new PROVIDER(); foreach (DataRow datarow in import.Rows) { try { objprovider.Customer_ID = datarow["Mã Nhà Cung Cấp"].ToString().Trim(); objprovider.Barcode = datarow["Mã Vạch"].ToString().Trim(); objprovider.OrderID = 0; objprovider.CustomerName = datarow["Tên Nhà Cung Cấp"].ToString().Trim(); objprovider.Customer_Type_ID = "0"; //objprovider.Customer_Group_ID = datarow["Mã Khách Hàng"].ToString().Trim(); objprovider.CustomerAddress = datarow["Địa Chỉ"].ToString().Trim(); objprovider.Tax = datarow["Mã Số Thuế"].ToString().Trim(); objprovider.Fax = datarow["Fax"].ToString().Trim(); objprovider.Tel = datarow["Điện Thoại Bàn"].ToString().Trim(); objprovider.Mobile = datarow["Di Động"].ToString().Trim(); objprovider.Contact = datarow["Người Liên Hệ"].ToString().Trim(); objprovider.Website = datarow["Website"].ToString().Trim(); objprovider.BankAccount = datarow["Số Tài Khoản"].ToString().Trim(); objprovider.BankName = datarow["Tên Ngân Hàng"].ToString().Trim(); objprovider.CreditLimit = double.Parse(datarow["Giới Hạn Nợ"].ToString().Trim()); objprovider.Discount = double.Parse(datarow["Chiết Khấu"].ToString().Trim()); objprovider.Position = datarow["Chức Vụ"].ToString().Trim(); objprovider.Email = datarow["Email"].ToString().Trim(); objprovider.Description = datarow["Ghi Chú"].ToString().Trim(); objprovider.Active = true; int rs = new PROVIDERController().PROVIDER_Insert(objprovider); listBoxControl1.Items.Add("Khách Hàng " + datarow["Mã Nhà Cung Cấp"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Khách Hàng " + datarow["Mã Nhà Cung Cấp"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 3)// nhóm hàng { PRODUCT_GROUP objproduct = new PRODUCT_GROUP(); foreach (DataRow datarow in import.Rows) { try { objproduct.ProductGroup_ID = datarow["Mã Nhóm Hàng"].ToString().Trim(); objproduct.ProductGroup_Name = datarow["Tên Nhóm Hàng"].ToString().Trim(); objproduct.Description = datarow["Ghi Chú"].ToString().Trim(); objproduct.Active = true; int rs = new PRODUCT_GROUPController().PRODUCT_GROUP_Insert(objproduct); listBoxControl1.Items.Add("Nhóm Hàng " + datarow["Mã Nhóm Hàng"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Nhóm Hàng " + datarow["Mã Nhóm Hàng"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 4)// kho hàng { STOCK objstock = new STOCK(); foreach (DataRow datarow in import.Rows) { try { objstock.Stock_ID = datarow["Mã Kho"].ToString().Trim(); objstock.Stock_Name = datarow["Tên Kho"].ToString().Trim(); objstock.Mobi = datarow["Di Động"].ToString().Trim(); objstock.Contact = datarow["Người Liên Hệ"].ToString().Trim(); objstock.Address = datarow["Địa Chỉ"].ToString().Trim(); objstock.Telephone = datarow["Điện Thoại Bàn"].ToString().Trim(); objstock.Fax = datarow["Fax"].ToString().Trim(); objstock.Email = datarow["Email"].ToString().Trim(); objstock.Description = datarow["Ghi Chú"].ToString().Trim(); objstock.Manager = datarow["Người Quản Lý"].ToString().Trim(); objstock.Manager = "NV000001"; objstock.Active = true; int rs = new STOCKController().STOCK_Insert(objstock); listBoxControl1.Items.Add("Kho Hàng " + datarow["Mã Kho"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Kho Hàng " + datarow["Mã Kho"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 5)// đơn vị { UNIT objunit = new UNIT(); foreach (DataRow datarow in import.Rows) { try { objunit.Unit_ID = datarow["Mã Đơn Vị"].ToString().Trim(); objunit.Unit_Name = datarow["Tên Đơn Vị"].ToString().Trim(); objunit.Description = datarow["Ghi Chú"].ToString().Trim(); objunit.Active = true; int rs = new UNITController().UNIT_Insert(objunit); listBoxControl1.Items.Add("Đơn Vị " + datarow["Mã Đơn Vị"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Đơn Vị " + datarow["Mã Đơn Vị"].ToString().Trim() + " Nhập Thất Bại"); break; } } } else if (khuvuc == 6)// hàng hóa { PRODUCT objproduct = new PRODUCT(); byte[] buff = { 1 }; objproduct.Photo = buff; foreach (DataRow datarow in import.Rows) { try { //objproduct.Product_Type_ID = datarow["Mã Đơn Vị"].ToString().Trim(); //objproduct.Provider_ID = datarow["Mã Đơn Vị"].ToString().Trim(); //objproduct.Product_Group_ID = datarow["Mã Đơn Vị"].ToString().Trim(); //objproduct.Product_ID = datarow["Mã Đơn Vị"].ToString().Trim(); //objproduct.Barcode = txtbarcode.Text; //objproduct.Product_Name = txtten.Text; //objproduct.Unit = (new UNITController().UNIT_GetByName(lookdonvi.Text)).Unit_ID; //objproduct.Origin = txtxuatxu.Text; //objproduct.MinStock = double.Parse(caltoithieu.Text); //objproduct.Customer_ID = (new PROVIDERController().PROVIDER_GetByName(looknhacungcap.Text)).Customer_ID; //objproduct.Org_Price = double.Parse(calcgiamua.Text); //objproduct.Sale_Price = double.Parse(calcgiasi.Text); //objproduct.Retail_Price = double.Parse(calcgiale.Text); //objproduct.UnitRate = 1; //objproduct.Customer_Name = looknhacungcap.Text; //objproduct.ExchangeRate = 1; //objproduct.Active = true; //objproduct.UserID = "US000001"; //objproduct.Currency_ID = "VND"; //int rs = new PRODUCTController().PRODUCT_Insert_Photo(objproduct); listBoxControl1.Items.Add("Đơn Vị " + datarow["Mã Đơn Vị"].ToString().Trim() + " Nhập Thành Công"); } catch { listBoxControl1.Items.Add("Đơn Vị " + datarow["Mã Đơn Vị"].ToString().Trim() + " Nhập Thất Bại"); break; } } } }