public bool UpdateSaleLocal(int salesmenId, int localId)
{
var o = (from e in db.SalesLocals where e.SalesmenId == salesmenId && e.LocalId == localId select e).SingleOrDefault();
if (o != null)
{
try
{
db.SalesLocals.DeleteOnSubmit(o);
db.SubmitChanges();
return true;
}
catch
{
return false;
}
}
else
{
try
{
SalesLocal sr = new SalesLocal();
sr.LocalId = localId;
sr.SalesmenId = salesmenId;
db.SalesLocals.InsertOnSubmit(sr);
db.SubmitChanges();
return true;
}
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 AddSalesmenLocal(int salesmenId, int LocalId)
{
try
{
if (CheckExistSalesLocal(salesmenId, LocalId) == false)
{
SalesLocal r = new SalesLocal();
r.SalesmenId = salesmenId;
r.LocalId = LocalId;
db.SalesLocals.InsertOnSubmit(r);
db.SubmitChanges();
return true;
}
else
return false;
}
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 DeleteSalesLocal(SalesLocal instance);
partial void UpdateSalesLocal(SalesLocal instance);
partial void InsertSalesLocal(SalesLocal instance);
private void detach_SalesLocals(SalesLocal entity)
{
this.SendPropertyChanging();
entity.Salesmen = null;
}
private void attach_SalesLocals(SalesLocal entity)
{
this.SendPropertyChanging();
entity.Salesmen = this;
}
