public IActionResult Duyet(int maHD)
{
bool check = true;
var chiTietHoaDon = _mb.ChiTietHoaDon.Where(ct => ct.MaHD == maHD).ToList();
if (ModelState.IsValid)
{
string location = "";
foreach (var chiTiet in chiTietHoaDon)
{
for (int i = 0; i < chiTiet.SoLuong; i++)
{
location = chiTiet.MaDT.ToString() + i.ToString();
string IMEI = Request.Form[location];
if (_mb.IMEI_DienThoai.Where(im => im.IMEI == IMEI).SingleOrDefault() != null)
{
check = false;
TempData[location] = "Trùng IMEI vui lòng thử lại";
}
else
{
TempData[location] = IMEI;
_mb.SaveChangesAsync();
}
}
}
try
{
if (!check)
{
throw new Exception();
}
foreach (var chiTiet in chiTietHoaDon)
{
for (int i = 0; i < chiTiet.SoLuong; i++)
{
location = chiTiet.MaDT.ToString() + i.ToString();
string IMEI = Request.Form[location];
IMEI_DienThoai iMEI_DienThoai = new IMEI_DienThoai()
{
IMEI = IMEI,
MaDT = chiTiet.MaDT,
MaHD = chiTiet.MaHD
};
_mb.Add(iMEI_DienThoai);
}
}
_mb.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch
{
TempData["message"] = "Fail";
TempData.Keep();
TempData[location] = "Trùng IMEI vui lòng thử lại";
return(RedirectToAction("Duyet", new { maHD }));
}
}
return(RedirectToAction("Duyet", new { maHD }));
}
public async Task <IActionResult> Create(TaiKhoanAdmin taiKhoanAdmin)
{
if (ModelState.IsValid)
{
var checkUser = _mb.TaiKhoanAdmin.Where(tk => tk.User == taiKhoanAdmin.User).SingleOrDefault();
var CheckEmail = _mb.TaiKhoanAdmin.Where(tk => tk.Email == taiKhoanAdmin.Email).SingleOrDefault();
if (checkUser != null)
{
ModelState.AddModelError("", "User đã tồn tại vui lòng nhập lại!");
return(View(taiKhoanAdmin));
}
if (CheckEmail != null)
{
if (Compare.CompareString(CheckEmail.Email, taiKhoanAdmin.Email))
{
ViewBag.khachHangAndDonHangs = News.SendName(_mb);
ModelState.AddModelError("", "Email đã tồn tại vui lòng nhập lại!");
return(View(taiKhoanAdmin));
}
}
taiKhoanAdmin.Pass = MD5.GetMD5(taiKhoanAdmin.Pass);
_mb.Add(taiKhoanAdmin);
await _mb.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewBag.khachHangAndDonHangs = News.SendName(_mb);
return(View(taiKhoanAdmin));
}
public IActionResult Order(int phone_id, string user, string address, string phone)
{
var result = new object();
if (phone_id != 0 && phone != null)
{
Order order = new Order()
{
PhoneId = phone_id,
User = user,
Address = address,
ContactPhone = phone,
DateTime = DateTime.Now
};
_context.Add(order);
_context.SaveChanges();
result = new { message = "success" };
}
else
{
result = new { message = "error" };
}
return(Ok(result));
}
public Companies InsertCompanies(Companies companies, out string errorMessage)
{
try
{
errorMessage = string.Empty;
using (MobileContext context = new MobileContext())
{
var _code = context.Companies.Max(x => x.CompanyCode) ?? "0";
companies.CompanyCode = (Convert.ToInt32(_code) + 1).ToString();
companies.Active = "Y";
companies.AddDate = DateTime.Now;
context.Add(companies);
if (context.SaveChanges() > 0)
{
return(companies);
}
errorMessage = "failed to create client.";
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Duyet(int maDH)
{
if (ModelState.IsValid)
{
var donHangFromMb = await _mb.DonHang.Include(dh => dh.KhachHang).Where(m => m.MaDH == maDH).FirstOrDefaultAsync();
HoaDon hoaDon = new HoaDon()
{
MaDH = donHangFromMb.MaDH,
MaKH = donHangFromMb.MaKH,
NgayLapHD = DateTime.Now,
TenKH = donHangFromMb.KhachHang.TenKH,
SoDT = donHangFromMb.KhachHang.SoDienThoai,
GioiTinh = donHangFromMb.KhachHang.GioiTinh,
DiaChi = donHangFromMb.KhachHang.DiaChi
};
_mb.Add(hoaDon);
_mb.SaveChanges();
var chiTiet = _mb.ChiTietDonHang.Where(ct => ct.MaDH == maDH).ToList();
foreach (var chiTietDonHang in chiTiet)
{
int soLuong = Convert.ToInt32(Request.Form[chiTietDonHang.MaDT.ToString()]);
if (soLuong != 0)
{
ChiTietHoaDon ct = new ChiTietHoaDon()
{
MaHD = hoaDon.MaHD,
MaDT = chiTietDonHang.MaDT,
SoLuong = soLuong,
TongGia = chiTietDonHang.TongGia / chiTietDonHang.SoLuong * soLuong,
};
_mb.Add(ct);
}
hoaDon.TongThanhToan = hoaDon.TongThanhToan + chiTietDonHang.TongGia / chiTietDonHang.SoLuong * soLuong;
_mb.Update(hoaDon);
_mb.SaveChanges();
}
;
return(RedirectToAction("Duyet", "HoaDons", new { hoaDon.MaHD }));
}
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> Create(Product product)
{
if (ModelState.IsValid)
{
_context.Add(product);
await _context.SaveChangesAsync();
return(await Connection("Create", product));
}
return(View(product));
}
public async Task <IActionResult> Create([Bind("Id_student,Imie,Nazwisko,Ulica,Kod_pocztowy,Miejscowosc,Email,Password")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Vid,Vname,Vmobile")] Vender vender)
{
if (ModelState.IsValid)
{
_context.Add(vender);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vender));
}
public async Task <IActionResult> Create([Bind("Id,Login,Password")] User user)
{
if (ModelState.IsValid)
{
_context.Add(user);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(user));
}
public async Task <IActionResult> Create([Bind("Id,Category,Name,Company,Price")] Phone phone)
{
if (ModelState.IsValid)
{
_context.Add(phone);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(phone));
}
public async Task <IActionResult> Create(Hang hang)
{
if (ModelState.IsValid)
{
ViewBag.khachHangAndDonHangs = News.SendName(_mb);
_mb.Add(hang);
await _mb.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(hang));
}
public async Task <IActionResult> Create([Bind("Id_oceny,Ocena,Ocena_slownie,Id_student")] Student_Oceny student_Oceny)
{
if (ModelState.IsValid)
{
_context.Add(student_Oceny);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Id_student"] = new SelectList(_context.Students, "Id_student", "Id_student", student_Oceny.Id_student);
return(View(student_Oceny));
}
public async Task <IActionResult> Create([Bind("OrderId,User,Address,ContactPhone,PhoneId")] Order order)
{
if (ModelState.IsValid)
{
_context.Add(order);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PhoneId"] = new SelectList(_context.Phones, "Id", "Id", order.PhoneId);
return(View(order));
}
public async Task <IActionResult> Create([Bind("CustomerId,CustomerName,CustomerNo")] Customer customer)
{
customer.Date = DateTime.Now.Date;
if (ModelState.IsValid)
{
_context.Add(customer);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(customer));
}
public async Task <IActionResult> Create([Bind("CatagoryId,CatagoryName")] Catagory catagory)
{
catagory.Date = DateTime.Today.Date;
if (ModelState.IsValid)
{
_context.Add(catagory);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(catagory));
}
public async Task <IActionResult> Create(Phone phone)
{
if (ModelState.IsValid)
{
phone.CurrentDate = DateTime.Now;
phone.CreatedDate = DateTime.Now;
_context.Add(phone);
await _context.SaveChangesAsync();
return(await Connection("Create", phone));
}
return(View(phone));
}
public async Task <IActionResult> Create([Bind("Id,Name,Company,Price,ImageFile")] Phone phone)
{
if (ModelState.IsValid)
{
if (phone.ImageFile != null)
{
string folderPath = Path.Combine(_webHostEnvironment.WebRootPath, "images", "phone_images");
string fileName = $"{Guid.NewGuid().ToString()}_{phone.ImageFile.FileName}";
string filePath = Path.Combine(folderPath, fileName);
using (var stream = new FileStream(filePath, FileMode.Create))
{
phone.ImageFile.CopyTo(stream);
}
phone.ImageName = fileName;
}
_context.Add(phone);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(phone));
}
public async Task <IActionResult> Create([Bind("PurchaseId,VenderId,ItemsId,Pquanity,PricePerUnit,TotalPrice,Date")] Purchase purchase)
{
Items oitem = _context.Items.Where(abc => abc.ItemsId == Convert.ToInt32(purchase.ItemsId)).FirstOrDefault <Items>();
int a = Convert.ToInt32(oitem.Quantity) + Convert.ToInt32(purchase.Pquanity);
oitem.Quantity = a;
_context.Items.Update(oitem);
if (ModelState.IsValid)
{
_context.Add(purchase);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ItemsId"] = new SelectList(_context.Items, "ItemsId", "ItemsId", purchase.ItemsId);
ViewData["VenderId"] = new SelectList(_context.Vender, "Vid", "Vid", purchase.VenderId);
return(View(purchase));
}
public async Task <IActionResult> Create([Bind("SalesId,CustomerId,ItemsId,Quantity,PricePerUnit,TotalPrice,TrDate")] Sales sales)
{
Items oitem = _context.Items.Where(abc => abc.ItemsId == Convert.ToInt32(sales.ItemsId)).FirstOrDefault <Items>();
int a = Convert.ToInt32(oitem.Quantity) - Convert.ToInt32(sales.Quantity);
oitem.Quantity = a;
sendMail(sales);
_context.Items.Update(oitem);
if (ModelState.IsValid)
{
_context.Add(sales);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CustomerId"] = new SelectList(_context.Customer, "CustomerId", "CustomerId", sales.CustomerId);
ViewData["ItemsId"] = new SelectList(_context.Items, "ItemsId", "ItemsId", sales.ItemsId);
return(View(sales));
}
public async Task <IActionResult> New(FilmViewModel model)
{
if (ModelState.IsValid)
{
string uniqueFileName = UploadedFile(model);
Film film = new Film
{
Title = model.Title,
Description = model.Description,
Year = model.Year,
Director = model.Director,
Poster = uniqueFileName,
};
_context.Add(film);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public Visit InsertVisit(string employeeCode, Visit visit, string visitType)
{
try
{
using (MobileContext context = new MobileContext())
{
visit.VisitType = visitType;
visit.VisitedEmployee = employeeCode;
visit.AddDate = DateTime.Now;
context.Add(visit);
if (context.SaveChanges() > 0)
{
return(visit);
}
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Create(TaiKhoanAdmin taiKhoanAdmin)
{
if (ModelState.IsValid)
{
if (_mb.TaiKhoanAdmin.Where(tk => tk.User == taiKhoanAdmin.User).SingleOrDefault() != null)
{
ModelState.AddModelError("", "User đã tồn tại vui lòng nhập lại!");
}
else if (_mb.TaiKhoanAdmin.Where(tk => tk.Email.Equals(taiKhoanAdmin.Email)).SingleOrDefaultAsync() != null)
{
ModelState.AddModelError("", "Email đã tồn tại vui lòng nhập lại!");
}
else
{
taiKhoanAdmin.Pass = MD5.GetMD5(taiKhoanAdmin.Pass);
_mb.Add(taiKhoanAdmin);
await _mb.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
ViewBag.khachHangAndDonHangs = News.SendName(_mb);
return(View(taiKhoanAdmin));
}
public async Task <IActionResult> Create([Bind("ItemsId,CatagoryId,CatagoryName,ItemsName,Description,Quantity,Price,Image,Model,Color")] Items items, ICollection <IFormFile> Image)
{
string wwwrootPath = env.WebRootPath;
string PPFolderPath = wwwrootPath + "/ItemsImage/";
foreach (var file in Image)
{
string Name = file.Name;
string FileName = file.FileName;
long FileLength = file.Length;
string FileNameWithoutExtension = Path.GetFileNameWithoutExtension(FileName);
Random r = new Random();
FileNameWithoutExtension = DateTime.Now.ToString("ddMMyyyyhhmm") + r.Next(1, 1000).ToString();
string Extension = Path.GetExtension(FileName);
FileStream fs = new FileStream(PPFolderPath + FileNameWithoutExtension + Extension, FileMode.CreateNew);
file.CopyTo(fs);
fs.Close();
fs.Dispose();
items.Image = "~/ItemsImage/" + FileNameWithoutExtension + Extension;
}
if (ModelState.IsValid)
{
_context.Add(items);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(items));
}
public MobileItems AddMobileDL(MobileItems mobile)
{
_context.Add(mobile);
_context.SaveChanges();
return(mobile);
}
public async Task <IActionResult> EditOrCreate(string id)
{
bool check = true;
if (ModelState.IsValid)
{
CTHoaDonViewIMEIVM.chiTietHoaDon = await _mb.ChiTietHoaDon.SingleOrDefaultAsync(ct => (ct.MaHD.ToString() + ct.MaDT.ToString()).Equals(id));
CTHoaDonViewIMEIVM.iMEI_DienThoais = await _mb.IMEI_DienThoai.Where(ct => (ct.MaHD.ToString() + ct.MaDT.ToString()).Equals(id)).ToListAsync();
foreach (var im in CTHoaDonViewIMEIVM.iMEI_DienThoais)
{
_mb.Attach(im);
_mb.Remove(im);
}
string location = "";
for (int i = 0; i < CTHoaDonViewIMEIVM.chiTietHoaDon.SoLuong; i++)
{
location = CTHoaDonViewIMEIVM.chiTietHoaDon.MaDT.ToString() + i.ToString();
string IMEI = Request.Form[location];
if (_mb.IMEI_DienThoai.Where(im => (im.IMEI == IMEI) && !(im.MaHD.ToString() + im.MaDT.ToString()).Equals(id)).SingleOrDefault() != null)
{
check = false;
TempData[location] = "Trùng IMEI vui lòng thử lại";
}
else
{
TempData[location] = IMEI;
}
}
try
{
if (!check)
{
throw new Exception();
}
for (int i = 0; i < CTHoaDonViewIMEIVM.chiTietHoaDon.SoLuong; i++)
{
location = CTHoaDonViewIMEIVM.chiTietHoaDon.MaDT.ToString() + i.ToString();
string IMEI = Request.Form[location];
IMEI_DienThoai iMEI_DienThoai = new IMEI_DienThoai()
{
IMEI = IMEI,
MaDT = CTHoaDonViewIMEIVM.chiTietHoaDon.MaDT,
MaHD = CTHoaDonViewIMEIVM.chiTietHoaDon.MaHD
};
_mb.Add(iMEI_DienThoai);
}
await _mb.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch
{
TempData["message"] = "Fail";
TempData[location] = "Trùng IMEI vui lòng thử lại";
return(RedirectToAction("Edit", new { id }));
}
}
return(RedirectToAction("Edit", new { id }));
}