public async Task <IHttpActionResult> Update(int donGiaID, [FromBody] DonGia donGia)
{
if (donGia.DonGiaID != donGiaID)
{
return(BadRequest("Id mismatch"));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var db = new ApplicationDbContext())
{
db.Entry(donGia).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException ducEx)
{
bool exists = db.DonGia.Count(o => o.DonGiaID == donGiaID) > 0;
if (!exists)
{
return(NotFound());
}
else
{
throw ducEx;
}
}
return(Ok(donGia));
}
}
public async Task Update(DonGia entity)
{
var gias = await getAll(entity.LinhKienId);
if (entity.ApDung == true)
{
foreach (var gia in gias)
{
if (gia.Id != entity.Id && gia.ApDung == true)
{
gia.ApDung = false;
_context.DonGias.Update(gia);
await _context.SaveChangesAsync();
}
}
}
else
{
if (!checkApDung(gias))
{
var gia = gias.FirstOrDefault();
gia.ApDung = true;
_context.DonGias.Update(gia);
await _context.SaveChangesAsync();
}
}
_context.DonGias.Update(entity);
await _context.SaveChangesAsync();
}
public DonGiaViewModel(DonGia obj)
{
MaVL_NC_MTC = obj.MaVL_NC_MTC;
MaKV = obj.MaKV;
Ten = obj.Ten;
DonVi = obj.DonVi;
Gia = obj.Gia;
}
public override string Tostring(string XuongDong)
{
string kq = "";
XuongDong = "</br>";
kq = string.Format(@"Số hiệu máy tính: {1}{0}Hãng sản xuất: {2}{0}Đơn giá: {3}{0}Thông tin CPU: {4}{0}RAM: {5}{0}",
XuongDong, SoHieu, HangSanXuat, DonGia.ToString("#,##0 VND"), CPU, RAM);
return(kq);
}
public override string Tostring(string XuongDong)
{
string kq = "";
XuongDong = "</br>";
kq = string.Format(@"Số hiệu máy tính: {1}{0}Hãng sản xuất: {2}{0}Đơn giá: {3}{0}Trọng lượng: {4}{0}Thời gian PIN: {5}{0}Kích thước màn hình: {6}{0}",
XuongDong, SoHieu, HangSanXuat, DonGia.ToString("#,##0 VND"), TrongLuong, ThoigianPIN, KichThuocManHinh);
return(kq);
}
public virtual string Tostring(string XuongDong)
{
string kq = "";
XuongDong = "</br>";
kq = string.Format(@"Số hiệu máy tính: {1}{0}Hãng sản xuất: {2}{0}Đơn giá: {3}{0}",
XuongDong, SoHieu, HangSanXuat, DonGia.ToString("#,##0 VND"));
return(kq);
}
public void TestAddAndDelete()
{
TuyenDi td1 = new TuyenDi("BL-HCM", "BL", "HCM");
tDManager.add(td1);
DonGia t1 = new DonGia("DG07", "BL-HCM", 210000);
Assert.AreEqual(true, manager.add(t1));
Assert.AreEqual(false, manager.add(t1));
Assert.AreEqual(true, manager.delete("DG07"));
tDManager.delete("BL-HCM");
}
public async Task Delete(DonGia entity)
{
_context.DonGias.Remove(entity);
await _context.SaveChangesAsync();
var gias = await getAll(entity.LinhKienId);
if (!checkApDung(gias))
{
var gia = gias.FirstOrDefault();
gia.ApDung = true;
_context.DonGias.Update(gia);
await _context.SaveChangesAsync();
}
}
private void DonGia_TextChanged(object sender, EventArgs e)
{
if (DonGia.Text != "")
{
try
{
float check = float.Parse(DonGia.Text.ToString());
}
catch
{
MessageBox.Show(" Đơn giá thuốc chưa đúng định dạng, vui lòng nhập lại !", "Cảnh báo");
DonGia.Focus();
}
}
}
public void TestUpdate()
{
TuyenDi td1 = new TuyenDi("BL-HCM", "BL", "HCM");
tDManager.add(td1);
DonGia t1 = new DonGia("DG07", "BL-HCM", 210000);
manager.add(t1);
DonGia t2 = new DonGia("DG07", "BL-HCM", 220000);
Assert.AreEqual(true, manager.update(t2));
Assert.AreEqual(true, manager.update(t1));
Assert.AreEqual(true, manager.delete("DG07"));
tDManager.delete("BL-HCM");
}
public static GiaEditViewModel editMap(this DonGia dongia)
{
var ApDung = "1";
if (dongia.ApDung == true)
{
ApDung = "0";
}
return(new GiaEditViewModel
{
Id = dongia.Id,
DonGiaBan = dongia.DonGiaBan,
Ngay = dongia.Ngay,
ApDung = ApDung,
LinhKienId = dongia.LinhKienId,
GiamGia = dongia.GiamGia
});
}
// ĐƠN GIÁ
private void btnThemDonGia_Click(object sender, RoutedEventArgs e)
{
try
{
var dg = new DonGia {
MaDonGia = txtDonGia.Text, DenKw = Double.Parse(txtDenKw.Text), TuKw = Double.Parse(txtTuKwt.Text), SoTien = Int32.Parse(txtSoTien.Text), GhiChu = txtGhiChuDonGia.Text
};
db.DbDonGia.Add(dg);
db.SaveChanges();
MessageBox.Show("Thêm thành công");
dgrDonGia.ItemsSource = db.DbDonGia.ToList();
cbMaDonGia.ItemsSource = (from p in db.DbDonGia select p.MaDonGia).ToList();
txtDonGia.Text = txtDenKw.Text = txtTuKwt.Text = txtSoTien.Text = txtGhiChuDonGia.Text = "";
}
catch
{
MessageBox.Show("Không được bỏ trống thông tin");
}
}
public async Task <IHttpActionResult> Insert([FromBody] DonGia donGia)
{
if (donGia.DonGiaID != 0)
{
return(BadRequest("Invalid DonGiaID"));
}
using (var db = new ApplicationDbContext())
{
var donGiaDaCo = db.DonGia.FirstOrDefault(x => x.HinhThucGiatID == donGia.HinhThucGiatID && x.DoGiatID == donGia.DoGiatID);
if (donGiaDaCo != null)
{
return(BadRequest("Đơn giá đã tồn tại"));
}
db.DonGia.Add(donGia);
await db.SaveChangesAsync();
}
return(Ok(donGia));
}
private void gdvChiTiet_RowEnter(object sender, DataGridViewCellEventArgs e)
{
int dong = e.RowIndex;
if (dong != 0)
{
if (!TenSach.Equals("") && !SoLuong.Equals("") && !DonGia.Equals(""))
{
if (!String.IsNullOrEmpty(Convert.ToString(gdvChiTiet.Rows[dong - 1].Cells[1].Value)) && !String.IsNullOrEmpty(Convert.ToString(gdvChiTiet.Rows[dong - 1].Cells[2].Value)))
{
lbTongTien.Text = Tongtien(dong - 1) + "";
}
else
{
MessageBox.Show("số lượng và đơn giá không được để trống");
}
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin trên dòng");
}
}
}
public override string ToString()
{
return($"{MaHang} - {TenHangHoa}: {DonGia.ToString("#,###0")} đ");
}
public async Task Add(DonGia entity)
{
_context.DonGias.Add(entity);
await _context.SaveChangesAsync();
}
public async Task <IActionResult> AddPost([FromForm] ProductAddViewModel dto)
{
if (!ModelState.IsValid)
{
//Get All Category
var categorys = await _llkRepository.getAll();
var categoryDTO = _mapper.Map <List <LoaiLinhKienDTO> >(categorys);
ViewBag.Category = categoryDTO;
//Get All Manufactuer
var manufactuers = await _nccRepository.getAll();
var manuDTO = _mapper.Map <List <NhaCungCapDTO> >(manufactuers);
ViewBag.Manu = manuDTO;
return(View("~/Views/Admin/Product/Add.cshtml", dto));
}
//Lưu Hình vào Server
string contentRootPath = _webHostEnvironment.ContentRootPath;
string pathS = "";
Random rnd = new Random();
pathS = Path.Combine(contentRootPath, "images");
pathS = Path.Combine(pathS, "products");
string Hinh = "";
foreach (var formFile in dto.files)
{
if (formFile.Length > 0)
{
try
{
string fileName = dto.MaLK + rnd.Next(1, 100000) + Path.GetExtension(formFile.FileName);
string _path = Path.Combine(contentRootPath, "wwwroot\\images");
_path = Path.Combine(_path, "products");
_path = Path.Combine(_path, fileName);
using (var fileStream = new FileStream(_path, FileMode.Create))
{
await formFile.CopyToAsync(fileStream);
}
Hinh += fileName + ",";
}
catch
{
//Get All Category
var categorys = await _llkRepository.getAll();
var categoryDTO = _mapper.Map <List <LoaiLinhKienDTO> >(categorys);
ViewBag.Category = categoryDTO;
//Get All Manufactuer
var manufactuers = await _nccRepository.getAll();
var manuDTO = _mapper.Map <List <NhaCungCapDTO> >(manufactuers);
ViewBag.Manu = manuDTO;
ModelState.AddModelError("Hinh", "Upload hình không thành công");
return(View("~/Views/Admin/Product/Add.cshtml", dto));
}
}
}
Hinh = Hinh.Remove(Hinh.Length - 1);
//Create Entity
LinhKien lk = new LinhKien();
lk.TenLK = dto.TenLK;
lk.MaLK = dto.MaLK;
lk.MoTa = dto.MoTa;
lk.TGBH = dto.TGBH;
lk.SLTonKho = dto.SLTonKho;
DonGia donGia = new DonGia();
donGia.DonGiaBan = (decimal)dto.Gia;
donGia.GiamGia = dto.GiamGia;
donGia.ApDung = true;
donGia.Ngay = DateTime.Now.Date;
List <DonGia> donGias = new List <DonGia>();
donGias.Add(donGia);
lk.DonGias = donGias;
var loaillk = await _llkRepository.getById(dto.Loai);
var ncc = await _nccRepository.getById(dto.NCC);
lk.Loai = loaillk;
lk.NCC = ncc;
lk.Hinh = Hinh;
await _linhKienRepository.Add(lk);
return(Redirect("/admin/product"));
}
public ActionResult About(HttpPostedFileBase file)
{
DataSet ds = new DataSet();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension =
System.IO.Path.GetExtension(Request.Files["file"].FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
string fileLocation = Server.MapPath("~/Upload/") + Request.Files["file"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);
string excelConnectionString = string.Empty;
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
//connection String for xls file format.
if (fileExtension == ".xls")
{
excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
//connection String for xlsx file format.
else if (fileExtension == ".xlsx")
{
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
//Create Connection to Excel work book and add oledb namespace
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
DataTable dt = new DataTable();
dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return(null);
}
String[] excelSheets = new String[dt.Rows.Count];
int t = 0;
//excel data saves in temp file here.
foreach (DataRow row in dt.Rows)
{
excelSheets[t] = row["TABLE_NAME"].ToString();
t++;
}
OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString);
string query = string.Format("Select * from [{0}]", excelSheets[0]);
using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1))
{
dataAdapter.Fill(ds);
}
}
if (fileExtension.ToString().ToLower().Equals(".xml"))
{
string fileLocation = Server.MapPath("~/Upload/") + Request.Files["FileUpload"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["FileUpload"].SaveAs(fileLocation);
XmlTextReader xmlreader = new XmlTextReader(fileLocation);
// DataSet ds = new DataSet();
ds.ReadXml(xmlreader);
xmlreader.Close();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var dongia = new DonGia();
dongia.MaKV = ds.Tables[0].Rows[i][0].ToString();
dongia.MaVL_NC_MTC = ds.Tables[0].Rows[i][1].ToString();
dongia.Ten = ds.Tables[0].Rows[i][2].ToString();
dongia.DonVi = ds.Tables[0].Rows[i][3].ToString();
dongia.Gia = Convert.ToDecimal(ds.Tables[0].Rows[i][4].ToString());
_db.DonGias.InsertOnSubmit(dongia);
}
_db.SubmitChanges();
}
return(View());
}
public void Print()
{
base.Print();
Console.WriteLine($"\n\nSo luong ton kho: {SoLuongTonKho}, so luong co the ban: {SoLuongCoTheBan}, moi san pham co gia la: {DonGia.ToString("N2")} vnd/{DonViTinh}");
Console.WriteLine($"\n\n======================== End Thong Tin San Pham ========================\n\n");
}
public override string ToString() //ghi de cua tinh da hinh poly morphism
{
return($"{MaHangHoa} - {TenHangHoa} : {DonGia.ToString("#,###0")} d");
}
