public void Update(SupplierGroup group) { var sqlSupplierGroup = SqlSupplierGroup.FromSupplierGroup(group); context.SetModified(sqlSupplierGroup); context.SaveChanges(); }
public void EditSupplier( Code code , Name name , Email email , Phone phone , SupplierGroup supplierGroup , PaymentTerm paymentTerm , GeneralText notes , bool isInformalSupplier , string rnc , string homeOrApartment , string city , string street , Country country , EntityStatus status) { Code = code; Name = name; Email = email; Phone = phone; Rnc = rnc; HomeOrApartment = homeOrApartment; City = city; Street = street; SupplierGroup = supplierGroup; PaymentTerm = paymentTerm; Notes = notes; IsInformalSupplier = isInformalSupplier; Country = country; Status = status; Modified = DateTime.Now; }
public List <Supplier> QuerySuppliersByGroupID(int _groupID) { SupplierGroup _supGroup = QueryByID(_groupID); List <Supplier> _suppliers = new List <Supplier>(); string _supplierIDs = _supGroup.SupplierIDs; if (!string.IsNullOrEmpty(_supplierIDs)) { if (!string.IsNullOrEmpty(_supplierIDs.Trim())) { var _supidArray = _supplierIDs.Split('|'); foreach (var _id in _supidArray) { if (!string.IsNullOrEmpty(_id.Trim())) { try { Supplier _supplier = _context.Suppliers.ToList().Where(s => s.SupplierID == Convert.ToInt32(_id)).FirstOrDefault(); if (_supplier != null) { _suppliers.Add(_supplier); } continue; } catch { } } } } } return(_suppliers); }
public void Create(SupplierGroup group) { var sqlSupplierGroup = SqlSupplierGroup.FromSupplierGroup(group); context.Groups.Add(sqlSupplierGroup); context.SaveChanges(); }
public async Task <IActionResult> Edit(int id, [Bind("SupplierGroupId,Code,Name,CreateBy,CreateDate,UpdateBy,UpdateDate,IsActive,IsDelete")] SupplierGroup supplierGroup) { if (id != supplierGroup.SupplierGroupId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(supplierGroup); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SupplierGroupExists(supplierGroup.SupplierGroupId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(supplierGroup)); }
public async Task <ApiResult <PagedResult <AccountsDto> > > GetAccountsPagingAsync(int pageIndex, int pageSize) { var accounts = await(from au in _context.AppUsers join emp in _context.Employees on au.Id equals emp.AppuserId into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join cus in _context.Customers on au.Id equals cus.AppUserId into CustomerGroup from c in CustomerGroup.DefaultIfEmpty() join sup in _context.Suppliers on au.Id equals sup.AppUserId into SupplierGroup from s in SupplierGroup.DefaultIfEmpty() select new AccountsDto() { Id = au.Id, UserName = au.UserName, Email = au.Email, EmployeeName = e.Name, CustomerName = c.Name, SupplierName = s.Name, PhoneNumber = au.PhoneNumber }).GetPagedAsync(pageIndex, pageSize); return(new ApiResult <PagedResult <AccountsDto> >(HttpStatusCode.OK, accounts)); }
public Supplier(Code code , Name name , Email email , Phone phone , string rnc , string homeOrApartment , string city , string street , Country country , SupplierGroup supplierGroup , PaymentTerm paymentTerm , GeneralText notes , bool isInformalSupplier , DateTime created , DateTime? modified = null , EntityStatus status = EntityStatus.Active) { Code = code; Name = name; Email = email; Phone = phone; Rnc = rnc; HomeOrApartment = homeOrApartment; City = city; Street = street; Country = country; SupplierGroup = supplierGroup; PaymentTerm = paymentTerm; Notes = notes; IsInformalSupplier = isInformalSupplier; Created = created == DateTime.MinValue ? DateTime.Now : created; Modified = modified; Status = status; }
/// <summary>Converts a relational database representation to a domain model object.</summary> public SupplierGroup ToSupplierGroup() { var supplierGroup = new SupplierGroup(Id, Name); Suppliers.ToList().ForEach(s => supplierGroup.AddSupplier(s.ToSupplier())); return(supplierGroup); }
public static SupplierGroupViewModel FromSupplierGroup(SupplierGroup supplierGroup) { return(new SupplierGroupViewModel { Id = supplierGroup.Id, Name = supplierGroup.Name }); }
public SupplierGroup Add(SupplierGroup SPG, string userid) { var sqlQuery = @"INSERT INTO SUPPLIERGROUP (IDSUPPLIERGROUP, SUPPLIERGROUPNAME, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + SPG.IDSUPPLIERGROUP + @"', '" + SPG.SUPPLIERGROUPNAME + "', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, SPG).Single(); SPG.SID = SID; return(SPG); }
public void FromSupplierGroup_ValidInput_ShouldReturnSqlSupplierGroupWithCopiedValues() { var group = new SupplierGroup(supplierGroupId, supplierGroupName); var result = SqlSupplierGroup.FromSupplierGroup(group); Assert.NotNull(result); Assert.AreEqual(supplierGroupId, result.Id); Assert.AreEqual(supplierGroupName, result.Name); }
public void AddSupplier_SupplierBelongsToDifferentGroup_ShouldAddAndUpdateSupplier() { var tempGroup = new SupplierGroup(id, "temp group"); var supplier = SupplierTests.CreateSupplier("*****@*****.**", tempGroup); //at this moment, supplier belongs to tempgroup - assigned in constructor group.AddSupplier(supplier); Assert.AreEqual(1, group.Suppliers.Count); Assert.AreEqual(group.Name, supplier.Group.Name); }
public async Task <ApiResult <AccountDto> > GetAccountAsync(Guid userId) { var checkAccount = await _userManager.FindByIdAsync(userId.ToString(("D"))); if (checkAccount == null) { return(new ApiResult <AccountDto>(HttpStatusCode.NotFound, $"Không tìm thấy tài khoản có mã: {userId}")); } var roles = await _userManager.GetRolesAsync(checkAccount); var accountRoles = new List <AccountRolesDto>(); foreach (var r in roles) { var role = await _roleManager.FindByNameAsync(r); if (role != null) { accountRoles.Add(ObjectMapper.Mapper.Map <AppRole, AccountRolesDto>(role)); } } var accountDetail = await(from au in _context.AppUsers join emp in _context.Employees on au.Id equals emp.AppuserId into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join cus in _context.Customers on au.Id equals cus.AppUserId into CustomerGroup from c in CustomerGroup.DefaultIfEmpty() join sup in _context.Suppliers on au.Id equals sup.AppUserId into SupplierGroup from s in SupplierGroup.DefaultIfEmpty() where au.Id == userId select new AccountDto() { Id = au.Id, Address = e.Address != null ? e.Address : (c.Address != null ? c.Address : (s.Address != null ? s.Address : "")), Email = au.Email, Name = e.Name != null ? e.Name : (c.Name != null ? c.Name : (s.Name != null ? s.Name : "")), PhoneNumber = au.PhoneNumber != null ? au.PhoneNumber : (e.PhoneNumber != null ? e.PhoneNumber : (c.PhoneNumber != null ? c.PhoneNumber : ( s.PhoneNumber != null ? s.PhoneNumber : ""))), UserName = au.UserName, InRoles = accountRoles }).SingleOrDefaultAsync(); return(new ApiResult <AccountDto>(HttpStatusCode.OK, accountDetail)); }
public void Update_ValidGroup_ShouldUpdateGroupViaContext() { var group = supplierGroupDal.GetOne(supplierGroupId); var newName = group.Name + " - updated"; var updatedGroup = new SupplierGroup(group.Id, newName); supplierGroupDal.Update(updatedGroup); context.Verify(c => c.SetModified(It.IsAny <object>())); context.Verify(c => c.SaveChanges(), Times.Once); }
public async Task <IActionResult> Create([Bind("SupplierGroupId,Code,Name,CreateBy,CreateDate,UpdateBy,UpdateDate,IsActive,IsDelete")] SupplierGroup supplierGroup) { if (ModelState.IsValid) { _context.Add(supplierGroup); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(supplierGroup)); }
public int Delete(int _sgID) { SupplierGroup _sgObj = _context.SupplierGroups.Where(s => s.ID == _sgID && s.active == true).FirstOrDefault(); if (_sgObj != null) { _sgObj.active = false; _context.SaveChanges(); return(1); } return(-99); }
public SupplierGroup Update(SupplierGroup SPG, string userid) { var sqlQuery = "UPDATE SUPPLIERGROUP " + "SET IDSUPPLIERGROUP = '" + SPG.IDSUPPLIERGROUP + "', " + " SUPPLIERGROUPNAME = '" + SPG.SUPPLIERGROUPNAME + "', " + " UPDATEBY = '" + Convert.ToInt32(userid) + "', " + " UPDATEDATE = '" + DateTime.Now + "' " + "WHERE SID = " + SPG.SID + ""; this._db.Execute(sqlQuery, SPG); return(SPG); }
/// <summary>Converts a domain model object to a form that is suitable for storing in a relational database.</summary> public static SqlSupplierGroup FromSupplierGroup(SupplierGroup group) { if (group == null) { throw new ArgumentNullException("Supplier group can't be null."); } return(new SqlSupplierGroup { Id = group.Id, Name = group.Name, Suppliers = group.Suppliers.Select(s => SqlSupplier.FromSupplier(s)).ToList() }); }
public JsonResult Edit(SupplierGroup suppliergroup, string userid) { try { if (ModelState.IsValid) { SPG.Update(suppliergroup, Session["userid"].ToString()); } } catch { return(Json("error")); } return(Json("success")); }
public void FromSupplier_ValidInput_ShouldReturnSqlSupplierWithCopiedValues() { var group = new SupplierGroup(101, "Initial supplier group"); var supplier = SupplierTests.CreateSupplier("*****@*****.**", group); var result = SqlSupplier.FromSupplier(supplier); Assert.NotNull(result); Assert.AreEqual(0, result.Id); Assert.AreEqual("John Doe", result.Name); Assert.AreEqual("Vaclavske Namesti 125", result.Address); Assert.AreEqual("*****@*****.**", result.EmailAddress); Assert.AreEqual("723123456", result.PhoneNumber); Assert.AreEqual(101, result.GroupId); }
public int Save(SupplierGroup model) { SupplierGroup _supplierGroup = _context.SupplierGroups.Where(s => s.ID == model.ID).FirstOrDefault(); if (_supplierGroup == null) { model.MailList = model.MailList ?? ""; model.SupplierIDs = model.SupplierIDs ?? ""; model.active = true; _context.SupplierGroups.Add(model); } else { _supplierGroup.GroupName = model.GroupName; _supplierGroup.MailList = model.MailList ?? ""; _supplierGroup.active = model.active; _supplierGroup.SupplierIDs = model.SupplierIDs ?? ""; } _context.SaveChanges(); return(model.ID); }
// Save Group public JsonResult SaveGroup(SupplierGroup model) { string Msg = null; SupplierGroup aGroup = new SupplierGroup(); if (model.GroupName != null) { var groupNames = db.SupplierGroup.Where(c => c.GroupName == model.GroupName).FirstOrDefault(); if (ModelState.IsValid) { if (groupNames == null) { if (model.GroupID > 0) { aGroup = db.SupplierGroup.SingleOrDefault(x => x.GroupID == model.GroupID); aGroup.GroupName = model.GroupName; db.SaveChanges(); Msg = "Update Successfully"; } else { db.SupplierGroup.Add(model); db.SaveChanges(); Msg = "Group Name Save Successfully"; } } else { Msg = "Group Name already Exists"; } } } else { Msg = "Null field Not Except"; } return(Json(Msg, JsonRequestBehavior.AllowGet)); }
public async Task <ApiResult <PagedResult <ReceiptVouchersDto> > > GetReceiptVoucherPagingAsync(int pageIndex, int pageSize, string accountId) { var checkEmployee = await _context.Employees.Where(x => x.AppuserId.ToString() == accountId) .SingleOrDefaultAsync(); if (checkEmployee == null) { return(new ApiResult <PagedResult <ReceiptVouchersDto> >(HttpStatusCode.NotFound, $"Lỗi tài khoản đăng nhập")); } var receiptVouchers = await(from rv in _context.ReceiptVouchers join employee in _context.Employees on rv.EmployeeId equals employee.Id into EmployeeGroup from e in EmployeeGroup.DefaultIfEmpty() join customer in _context.Customers on rv.CustomerId equals customer.Id into CustomerGroup from c in CustomerGroup.DefaultIfEmpty() join supplier in _context.Suppliers on rv.SupplierId equals supplier.Id into SupplierGroup from s in SupplierGroup.DefaultIfEmpty() join b in _context.Branches on rv.BranchId equals b.Id join pm in _context.PaymentMethods on rv.PaymentMethodId equals pm.Id where rv.BranchId == checkEmployee.BranchId select new ReceiptVouchersDto() { Id = rv.Id, Received = rv.Received, BranchName = b.Name, PaymentMethodName = pm.Name, ReceivedDate = rv.ReceivedDate, PersonName = string.IsNullOrEmpty(rv.CustomerId) ? $"Nhà cung cấp {s.Name}" : $"Khách hàng {c.Name}", EmployeeName = e.Name } ).GetPagedAsync(pageIndex, pageSize); return(new ApiResult <PagedResult <ReceiptVouchersDto> >(HttpStatusCode.OK, receiptVouchers)); }
public void AddToSupplierGroups(SupplierGroup supplierGroup) { base.AddObject("SupplierGroups", supplierGroup); }
public static SupplierGroup CreateSupplierGroup(int ID, string supplierGroupName, bool discontinued, byte[] rowVersion) { SupplierGroup supplierGroup = new SupplierGroup(); supplierGroup.Id = ID; supplierGroup.SupplierGroupName = supplierGroupName; supplierGroup.Discontinued = discontinued; supplierGroup.RowVersion = rowVersion; return supplierGroup; }
public void SetUp() { group = new SupplierGroup(id, name); }
public static Supplier CreateSupplier(string email, SupplierGroup group) { return(new Supplier(id, name, address, email, phoneNumber, group)); }
public void UpdateSupplier(int id, string name, string address, string emailAddress, string phoneNumber, SupplierGroup group) { var supplier = new Supplier(id, name, address, emailAddress, phoneNumber, group); supplierDal.Update(supplier); }
public void UpdateSupplierGroup(int id, string name) { var supplierGroup = new SupplierGroup(id, name); supplierGroupDal.Update(supplierGroup); }