private bool CheckExists(KhachHangModel KhachHang, HMSEntities db) { H_KhachHang obj = null; if (!string.IsNullOrEmpty(KhachHang.Ma)) { obj = db.H_KhachHang.FirstOrDefault(x => !x.IsDeleted && x.Id != KhachHang.Id && x.Code.Trim().ToUpper().Equals(KhachHang.Ma.Trim().ToUpper())); } return(obj != null ? true : false); }
//public SellReceiptModel GetByCode(string connectString,string code) //{ // using (var db = new HMSEntities(connectString)) // { // try // { // return (from x in db.H_SellReceipt // where !x.IsDeleted && x.Code.Trim().ToUpper() == code.Trim().ToUpper() // select new SellReceiptModel() // { // Id = x.Id, // Ma = x.Code, // Ten = x.Name, // NSinh = x.Birthday, // GTinh = x.Gender, // DThoai = x.Phone, // DChi = x.Address, // TPho = x.City, // Huyen = x.District, // Phuong = x.Wards, // strModel = (x.H_Model != null ? x.H_Model.Note : ""), // ModelId = x.ModelId, // Note = x.Note, // BienSo = x.LicenseNumber, // SoMay = x.MachineNumber, // SoSuon = x.ChassisNumber, // Km = x.Km, // NNghiep = (x.H_NgheNghiep != null ? x.H_NgheNghiep.Code : ""), // JobId = x.JobId // }).FirstOrDefault(); // } // catch (Exception ex) // { // throw ex; // } // } //} //public List<ModelSelectItem> GetLookUp(string connectString, int loaiNV) //{ // using (var db = new HMSEntities(connectString)) // { // //if (loaiNV != 0) // // return db.H_SellReceipt.Where(x => !x.IsDeleted && !x.H_LoaiNhanVien.IsDeleted && x.LoaiNVId == loaiNV).Select(x => new ModelSelectItem() { Id = x.Id, Name = x.Code }).ToList(); // return db.H_SellReceipt.Where(x => !x.IsDeleted).Select(x => new ModelSelectItem() { Id = x.Id, Name = x.Code }).ToList(); // } //} public ResponseModel Insert(string connectString, SellReceiptModel model) { var result = new ResponseModel(); result.IsSuccess = true; using (var db = new HMSEntities(connectString)) { if (!CheckExists(model, db)) { H_SellReceipt sellInfo; double gt = 0; if (model.ChietKhau == 0) { gt = model.GiaBan; } else { gt = (model.GiaBan - ((model.GiaBan * model.ChietKhau) / 100)); } H_KhachHang khObj = null; if (model.Id == 0) { khObj = new H_KhachHang() { Code = model.Ma, Name = model.Ten, Gender = model.GTinh, Birthday = model.NSinh, Phone = model.DThoai, Address = model.DChi, City = model.TPho, District = model.Huyen, Wards = model.Phuong, JobId = model.JobId, Note = model.GhiChu }; khObj.H_SellReceipt = new List <H_SellReceipt>(); } sellInfo = new H_SellReceipt() { KHId = model.Id, H_KhachHang = khObj, SoPhieu = model.SoPhieu, ModelId = model.ModelId, LicenseNumber = model.BienSo, MachineNumber = model.SoMay, ChassisNumber = model.SoKhung, NV_TuVan = model.TuVanId, Price = model.GiaBan, Discount = model.ChietKhau, Total = gt, Note = model.Note, CreatedDate = (model.Ngay.Year == 1 ? DateTime.Now : model.Ngay), Index = model.Index, WorkTypeId = model.WorkTypeId, GuaranteeNumber = model.SoBaoHanh }; db.H_SellReceipt.Add(sellInfo); if (result.IsSuccess) { db.SaveChanges(); } } else { result.IsSuccess = false; result.sms = "Số phiếu này đã tồn tại trong hệ thống. Vui lòng nhập lại số phiếu khác."; } return(result); } }
public ResponseModel InsertOrUpdate(string connectString, KhachHangModel model) { var result = new ResponseModel(); result.IsSuccess = true; using (var db = new HMSEntities(connectString)) { if (!CheckExists(model, db)) { H_KhachHang nv; if (model.Id == 0) { //var last = db.H_KhachHang.OrderByDescending(x => x.Index).FirstOrDefault(); //int _index = 1; //if (last != null) // _index = last.Index + 1; //string code = "KH-" + DateTime.Now.ToString("ddMMyy") + "-" + getNumber(_index); nv = new H_KhachHang() { Code = model.Ma, Name = model.Ten, Gender = model.GTinh, Birthday = model.NSinh, Phone = model.DThoai, Address = model.DChi, City = model.TPho, District = model.Huyen, Wards = model.Phuong, JobId = model.JobId, Note = model.Note }; //if (!string.IsNullOrEmpty(model.TaiKhoan) && !string.IsNullOrEmpty(model.MatKhau)) //{ // H_Account acc = new H_Account() { AccName = model.TaiKhoan, Password = GlobalFunction.EncryptMD5(model.MatKhau) }; // acc.H_KhachHang = nv; // nv.H_Account = new List<H_Account>(); // nv.H_Account.Add(acc); //} db.H_KhachHang.Add(nv); } else { nv = db.H_KhachHang.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (nv != null) { nv.Code = model.Ma; nv.Name = model.Ten; nv.Gender = model.GTinh; nv.Birthday = model.NSinh; nv.Address = model.DChi; nv.Phone = model.DThoai; nv.Note = model.Note; nv.City = model.TPho; nv.District = model.Huyen; nv.Wards = model.Phuong; nv.JobId = model.JobId; } else { result.IsSuccess = false; result.sms = "Khách hàng đã bị xóa hoặc không tồn tại trong hệ thống.!"; } } if (result.IsSuccess) { result.Data = nv.Id; db.SaveChanges(); } } else { result.IsSuccess = false; result.sms = "Mã này đã tồn tại trong hệ thống. Vui lòng chọn lại mã khác."; } return(result); } }
public ResponseModel Insert(string connectString, PhieuModel model) { var result = new ResponseModel(); result.IsSuccess = true; using (var db = new HMSEntities(connectString)) { if (!CheckExists(model, db)) { try { H_Receiption receiptInfo; H_KhachHang khObj = null; receiptInfo = new H_Receiption(); if (model.Id == 0) { khObj = new H_KhachHang() { Code = model.Ma, Name = model.Ten, Gender = model.GTinh, Birthday = model.NSinh, Phone = model.DThoai, Address = model.DChi, City = model.TPho, District = model.Huyen, Wards = model.Phuong, JobId = model.JobId, Note = model.Note }; khObj.H_Receiption = new List <H_Receiption>(); } receiptInfo.KHId = model.Id; receiptInfo.H_KhachHang = khObj; receiptInfo.Code = model.SoPhieu; receiptInfo.ModelId = model.ModelId; receiptInfo.LicenseNumber = model.BienSo; receiptInfo.MachineNumber = model.SoMay; receiptInfo.ChassisNumber = model.SoKhung; receiptInfo.New_Km = model.Km; receiptInfo.Required = model.Yeucau; receiptInfo.CheckResult = model.Nhanxet; receiptInfo.StatusBefore = model.Trangthai; receiptInfo.Note = model.GhiChu; receiptInfo.WorkTypeId = model.WTypeId; receiptInfo.CreatedDate = DateTime.Now; receiptInfo.Date = (model.Ngay.Year == 1 ? DateTime.Now : model.Ngay); receiptInfo.QMSServiceId = model.QMSServiceId; receiptInfo.Index = model.Index; if (model.XeId > 0) { receiptInfo.SellReceiptId = model.XeId; var xe = db.H_SellReceipt.FirstOrDefault(x => !x.IsDeleted && x.Id == model.XeId); if (xe != null) { xe.LicenseNumber = model.BienSo; } } db.H_Receiption.Add(receiptInfo); if (result.IsSuccess) { db.SaveChanges(); } } catch (Exception ex) { } } else { result.IsSuccess = false; result.sms = "Số phiếu này đã tồn tại trong hệ thống. Vui lòng nhập lại số phiếu khác."; } return(result); } }