public async Task <IActionResult> PutSalesRegion([FromRoute] int id, [FromBody] SalesRegion salesRegion) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != salesRegion.Id) { return(BadRequest()); } salesRegion.UpdatedAt = DateTimeOffset.Now; _context.Entry(salesRegion).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SalesRegionExists(id)) { return(NotFound()); } else { throw; } } return(Ok(_context.SalesRegions.Find(id))); }
public async Task <IActionResult> PostSalesRegion([FromBody] SalesRegion salesRegion) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } salesRegion.Status = Status.Active; var now = DateTimeOffset.Now; salesRegion.CreatedAt = now; salesRegion.UpdatedAt = now; _context.SalesRegions.Add(salesRegion); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSalesRegion", new { id = salesRegion.Id }, salesRegion)); }
public bool AddSalesmenRegion(int salesmenId, int regionId) { try { if (CheckExistedSalesRegion(salesmenId, regionId) == false) { SalesRegion r = new SalesRegion(); r.SalesmenId = salesmenId; r.RegionId = regionId; db.SalesRegions.InsertOnSubmit(r); db.SubmitChanges(); return true; } else return false; } catch { return false; } }
public bool Add(string upiCode, string fullName, string phone, int roleId, int smsQuota, DateTime expiredDate, int groupId, int regionId, int areaId, int localId) { try { if (CheckExistedSalemen(-1, phone)) return false; var o = new Salesmen { UpiCode = upiCode, FullName = fullName, Phone = phone, RoleId = roleId, SmsQuota = smsQuota, ExpiredDate = expiredDate }; db.Salesmens.InsertOnSubmit(o); db.SubmitChanges(); int salesMenId = o.Id; if (groupId != 0) { // insert Group to SaleGroup SalesGroup salesGroup = new SalesGroup(); salesGroup.GroupId = groupId; salesGroup.SalesmenId = salesMenId; db.SalesGroups.InsertOnSubmit(salesGroup); db.SubmitChanges(); } if (regionId != 0) { // insert region SalesRegion salesRegion = new SalesRegion(); salesRegion.SalesmenId = salesMenId; salesRegion.RegionId = regionId; db.SalesRegions.InsertOnSubmit(salesRegion); db.SubmitChanges(); } if (areaId != 0) { // insert area SalesArea salesArea = new SalesArea(); salesArea.SalesmenId = salesMenId; salesArea.AreaId = areaId; db.SalesAreas.InsertOnSubmit(salesArea); db.SubmitChanges(); } if (localId != 0) { // insert area SalesLocal salesLocal = new SalesLocal(); salesLocal.SalesmenId = salesMenId; salesLocal.LocalId = localId; db.SalesLocals.InsertOnSubmit(salesLocal); db.SubmitChanges(); } return true; } catch { return false; } }
public bool UpdateSaleRegion(int salesmenId, int regionId) { var o = (from e in db.SalesRegions where e.SalesmenId == salesmenId && e.RegionId == regionId select e).SingleOrDefault(); if (o != null) { try { db.SalesRegions.DeleteOnSubmit(o); db.SubmitChanges(); return true; } catch { return false; } } else { try { SalesRegion sr = new SalesRegion(); sr.RegionId = regionId; sr.SalesmenId = salesmenId; db.SalesRegions.InsertOnSubmit(sr); db.SubmitChanges(); return true; } catch { return false; } } }
public bool Edit(int id, string upiCode, string fullName, string phone, int roleId, int smsQuota, DateTime expiredDate, int groupId, int regionId, int areaId, int localId) { try { if (CheckExistedSalemen(id, phone)) return false; var o = (from e in db.Salesmens where e.Id == id select e).SingleOrDefault(); if (o != null) { o.UpiCode = upiCode; o.FullName = fullName; o.Phone = phone; o.RoleId = roleId; o.SmsQuota = smsQuota; o.ExpiredDate = expiredDate; db.SubmitChanges(); int salesMenId = id; if (groupId != 0) { //// delete all existing setting for this //db.SalesGroups.DeleteAllOnSubmit(from sg in db.SalesGroups where sg.SalesmenId == salesMenId select sg); // insert Group to SaleGroup SalesGroup salesGroup = new SalesGroup(); salesGroup.GroupId = groupId; salesGroup.SalesmenId = salesMenId; db.SalesGroups.InsertOnSubmit(salesGroup); db.SubmitChanges(); } if (regionId != 0) { // insert region SalesRegion salesRegion = new SalesRegion(); salesRegion.SalesmenId = salesMenId; salesRegion.RegionId = regionId; db.SalesRegions.InsertOnSubmit(salesRegion); db.SubmitChanges(); } if (areaId != 0) { // insert area SalesArea salesArea = new SalesArea(); salesArea.SalesmenId = salesMenId; salesArea.AreaId = areaId; db.SalesAreas.InsertOnSubmit(salesArea); db.SubmitChanges(); } if (localId != 0) { // insert area SalesLocal salesLocal = new SalesLocal(); salesLocal.SalesmenId = salesMenId; salesLocal.LocalId = localId; db.SalesLocals.InsertOnSubmit(salesLocal); db.SubmitChanges(); } return true; } return false; } catch { return false; } }
partial void DeleteSalesRegion(SalesRegion instance);
partial void UpdateSalesRegion(SalesRegion instance);
partial void InsertSalesRegion(SalesRegion instance);
private void detach_SalesRegions(SalesRegion entity) { this.SendPropertyChanging(); entity.Salesmen = null; }
private void attach_SalesRegions(SalesRegion entity) { this.SendPropertyChanging(); entity.Region = this; }