Ejemplo n.º 1
0
 public static string Export(string storeId, string exportCode, int quantity, string productId, SqlTransaction tran)
 {
     try
     {
         DataTable storeProductTable = productStoreDT.GetByCond("ProductID=" + productId + " AND StoreID = " + storeId + " AND Quantity >0 ", "OrderNum ASC", tran);
         int       tmpQuantity       = 0;
         var       totalQuantity     = storeProductTable.Compute("SUM(Quantity)", "");
         if (Converter.ToInt32(totalQuantity) < quantity)
         {
             return("Lỗi: Sản phẩm trong kho không đủ để xuất");
         }
         else
         {
             foreach (DataRow row in storeProductTable.Rows)
             {
                 LogProductexportContract productExportDTO = new LogProductexportContract();
                 string storeProductId = row["ID"].ToString();
                 tmpQuantity += Converter.ToInt32(row["Quantity"]);
                 if (tmpQuantity < quantity)
                 {
                     productExportDTO.Storeid     = storeId;
                     productExportDTO.Productid   = productId;
                     productExportDTO.Importcode  = row["ImportCode"].ToString();
                     productExportDTO.Quantity    = row["Quantity"].ToString();
                     productExportDTO.Exportdate  = DateTime.Now.ToString("dd/MM/yyyy");
                     productExportDTO.Exportcode  = exportCode;
                     productExportDTO.Importprice = row["Price"].ToString();
                     productExportDTO.Exportprice = productId;
                     productExportDT.Insert(productExportDTO, tran);
                     productStoreDT.Update(new string[] { "Quantity" }, new string[] { "0" }, " ID=" + storeProductId, tran);
                 }
                 else
                 {
                     int exportQuantity       = Converter.ToInt32(row["Quantity"]) - (tmpQuantity - quantity);
                     int productStoreQuantity = Converter.ToInt32(row["Quantity"]) - exportQuantity;
                     productExportDTO.Storeid     = storeId;
                     productExportDTO.Productid   = productId;
                     productExportDTO.Importcode  = row["ImportCode"].ToString();
                     productExportDTO.Quantity    = exportQuantity.ToString();
                     productExportDTO.Exportdate  = DateTime.Now.ToString("dd/MM/yyyy");
                     productExportDTO.Exportcode  = exportCode;
                     productExportDTO.Importprice = row["Price"].ToString();
                     productExportDTO.Exportprice = productId;
                     productExportDT.Insert(productExportDTO, tran);
                     productStoreDT.Update(new string[] { "Quantity" }, new string[] { productStoreQuantity.ToString() }, " ID=" + storeProductId, tran);
                     break;
                 }
             }
         }
     }
     catch (Exception e)
     {
         throw e;
     }
     return("");
 }
Ejemplo n.º 2
0
        public HttpResponseMessage Save(string catproductstoreJson)
        {
            string errMessage = string.Empty;

            try
            { CatProductStoreContract catproductstore = JsonConvert.DeserializeObject <CatProductStoreContract>(catproductstoreJson);
              businessRule.RegistInstants(catproductstore);
              if (catproductstore.Id == 0)
              {
                  businessRule.RegistRule("Insert");
                  if (businessRule.CheckRules(out errMessage))
                  {
                      return(Request.CreateResponse <string>(HttpStatusCode.OK, dta.Insert(catproductstore)));
                  }
                  else
                  {
                      return(handleBRFailed(errMessage));
                  }
              }
              else
              {
                  businessRule.RegistRule("Update");
                  if (businessRule.CheckRules(out errMessage))
                  {
                      return(Request.CreateResponse <string>(HttpStatusCode.OK, dta.Update(catproductstore)));
                  }
                  else
                  {
                      return(handleBRFailed(errMessage));
                  }
              } }
            catch (Exception e)
            {
                ExceptionHandler.Log(e);
                return(Request.CreateResponse <string>(HttpStatusCode.OK, "Có lỗi xảy ra trên chương trình."));
            }
        }