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