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;
}
