internal static Product_POCO Map(Product_DTO dto) =>
new Product_POCO
{
ProductID = dto.ProductID,
ProductName = dto.ProductName,
UnitPrice = dto.UnitPrice
};
private Products_CRUD_ViewModel Get_Products_CRUD_ViewModel(Product_DTO _product)
{
var model = new Products_CRUD_ViewModel();
var product = _product;
if (product != null && _product.Product_ID != 0)
{
product = new Product_DTO();
product = this._IProductService.Get_Product_ById(_product.Product_ID)?.Results;
var listImages = this.Get_ListImage_By_Product_GroupId(product.Product_ID.ToString());
model.ListImgJson = JsonConvert.SerializeObject(listImages);
model.Product_ID = product.Product_ID;
model.Product_Group_ID = product.Product_Group_ID ?? 0;
model.Product_Name = product?.Product_Name;
model.Sale_Price = product?.Sale_Price.ToString();
model.Org_Price = product?.Org_Price.ToString();
model.Quantity = product?.Quantity.ToString();
model.Unit_ID = product?.Unit_ID;
model.Description = product?.Description;
}
model.UnitList = Get_Units_SelectList(product?.Unit_ID);
model.Product_Group_List = Get_Products_Group_SelectList(product?.Product_Group_ID);
model.Product_Type_List = new List <SelectListItem>()
{
new SelectListItem {
Value = "", Text = "Chọn"
}
};
model.Product_Type_List = Get_Product_Types_SelectList(product?.Product_Type_ID);
return(model);
}
public HttpResponseMessage SaveProjects(Product_DTO product)
{
product = ProductRepository.Add(product);
var response = Request.CreateResponse <Product_DTO>(HttpStatusCode.Created, product);
// response.ReasonPhrase = Convert.ToString(product.ProID); // Return the output Id of the procedure in response.
return(response);
}
internal static ProductViewModel Map(Product_DTO dto)
{
return(new ProductViewModel
{
ProductID = dto.ProductID,
ProductName = dto.ProductName,
UnitPrice = dto.UnitPrice
});
}
public HttpResponseMessage PutMST_Projects(Product_DTO product)
{
if (!ProductRepository.Update(product))
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found"));
}
else
{
var response = Request.CreateResponse(HttpStatusCode.OK);
//response.ReasonPhrase = Convert.ToString(product.ProID; // Return the output Id of the procedure in response.
return(response);
}
}
public HttpResponseMessage GetProduct(string ProIDStr)
{
Product_DTO product = ProductRepository.Get(ProIDStr);
if (product == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found"));
}
else
{
return(Request.CreateResponse <Product_DTO>(product));
}
}
public Product_DTO Add(Product_DTO product)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
if (product == null)
{
throw new ArgumentNullException("item");
}
DB.Sp_InsertUpdateProduct("", product.ProName, product.ProExpDate, 1);
DB.SaveChanges();
// product.ProID = Convert.ToInt32(OutputParamValue.Value);
return(product);
}
}
public static List <Product_DTO> LoadProduct()
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_getProductList]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
List <Product_DTO> listProduct = new List <Product_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Product_DTO product = new Product_DTO();
product.ProductID = dt.Rows[i]["ProductID"].ToString();
product.ProductName = dt.Rows[i]["ProductName"].ToString();
product.VendorID = dt.Rows[i]["VendorID"].ToString();
product.VendorName = dt.Rows[i]["VendorName"].ToString();
product.ProductCategoryID = dt.Rows[i]["ProductCategoryID"].ToString();
product.ProductCategoryName = dt.Rows[i]["ProductCategoryName"].ToString();
product.PercentRevenue = float.Parse(dt.Rows[i]["PercentRevenue"].ToString());
product.UnitID = dt.Rows[i]["UnitID"].ToString();
product.UnitName = dt.Rows[i]["UnitName"].ToString();
product.ImportPrice = float.Parse(dt.Rows[i]["ImportPrice"].ToString());
product.Weight = dt.Rows[i]["Weight"].ToString();
product.Quantity = Convert.ToInt32(dt.Rows[i]["Quantity"].ToString());
listProduct.Add(product);
}
DataProvider.CloseConnection(con);
return(listProduct);
}
public ActionResult Search(string search)
{
try
{
var client = new HttpClient();
var modelGrid = client.GetAsync(ConfigurationManager.AppSettings["APIURL"] + "api/ProductAPI/SearchProduct/" + search).Result
.Content.ReadAsAsync <List <Product_DTO> >().Result;
var model = new Product_DTO
{
ProductGrid = modelGrid.OrderByDescending(item => item.ProID),
ProductEdit = null
};
return(PartialView("_PartialProductGrid", model));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SuaSanPhamCH(Product_DTO product)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("SuaSPCH", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@MaSPCH", product.ProductID);
cmd.Parameters.Add(p);
p = new SqlParameter("@TenSP", product.ProductName);
cmd.Parameters.Add(p);
p = new SqlParameter("@DonVi", product.VendorID);
cmd.Parameters.Add(p);
p = new SqlParameter("@Gia", product.ProductCategoryID);
cmd.Parameters.Add(p);
p = new SqlParameter("@SoLuong", product.ImportPrice);
cmd.Parameters.Add(p);
p = new SqlParameter("@HinhAnh", product.ImageUrl);
cmd.Parameters.Add(p);
p = new SqlParameter("@ThongSo", product.Weight);
cmd.Parameters.Add(p);
p = new SqlParameter("@BanLe", product.Quantity);
cmd.Parameters.Add(p);
//p = new SqlParameter("@SoLuongLe", product.SoLuongLe);
//cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
public ActionResult Save(Product_DTO product)
{
try
{
var client = new HttpClient();
if (product.ProductEdit.ProID == "")
{
product.ProductEdit.UserID = 1;
var response = client.PostAsJsonAsync(ConfigurationManager.AppSettings["APIURL"] + "api/ProductAPI/SaveProduct", product.ProductEdit).Result;
if (response.IsSuccessStatusCode)
{
TempData["ErrorProductExist"] = "Success";
if (response.ReasonPhrase == "-11")
{
TempData["ErrorProductExist"] = "IsExist";
}
}
return(RedirectToAction("Product"));
}
else
{
product.ProductEdit.UserID = 1;
var response = client.PutAsJsonAsync(ConfigurationManager.AppSettings["APIURL"] + "api/ProductAPI/UpdateProduct", product.ProductEdit).Result;
if (response.IsSuccessStatusCode)
{
TempData["ErrorProductExist"] = "Success";
if (response.ReasonPhrase == "-11")
{
TempData["ErrorProductExist"] = "IsExist";
}
}
return(RedirectToAction("Product"));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool XoaSPCH(Product_DTO product)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("XoaSPCH", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@MaSPCH", product.ProductID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
public Product_DTO Edit(string ProIDStr)
{
try
{
var client = new HttpClient();
var modelGrid = client.GetAsync(ConfigurationManager.AppSettings["APIURL"] + "api/ProductAPI/GetProduct").Result
.Content.ReadAsAsync <List <Product_DTO> >().Result;
if (ProIDStr != null && ProIDStr != "")
{
var modelEdit = client.GetAsync(ConfigurationManager.AppSettings["APIURL"] + "aapi/ProductAPI/GetProduct" + ProIDStr).Result
.Content.ReadAsStringAsync().Result;
var ss = JsonConvert.DeserializeObject <Product_DTO>(modelEdit);
var model1 = new Product_DTO
{
ProductGrid = modelGrid.OrderByDescending(item => item.ProID),
ProductEdit = ss
};
ViewBag.coInit = "<script type='text/javascript'>checkPosition();</script>";
return(model1);
}
else
{
var model = new Product_DTO()
{
ProductGrid = modelGrid.OrderByDescending(item => item.ProID),
ProductEdit = null
};
return(model);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ItemDetailViewModel()
{
List_Similar_Item = new List <Product_DTO>();
List_All_Sale_Item = new List <Product_DTO>();
Item = new Product_DTO();
}
public static bool XoaSPCH(Product_DTO sanpham)
{
return(Product_DAL.XoaSPCH(sanpham));
}
public static bool SuaSPCH(Product_DTO sanpham)
{
return(Product_DAL.SuaSanPhamCH(sanpham));
}
public ActionResult Product_Edit_Form(Product_DTO product)
{
var model = Get_Products_CRUD_ViewModel(product);
return(View("~/Views/Admin/PRODUCT/Product_Crud_Form.cshtml", model));
}
