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