public static void InsertLogin(Guid OrganizationId, int DepartmentId, LoginData ld) { if (string.IsNullOrEmpty(ld.email)) return; ld.email=ld.email.ToLower(); lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrganizationId, DepartmentId); var l = (from ll in dc.Tbl_Logins where ll.Email.ToLower() == ld.email select ll).FirstOrNull(); if (l == null) { l = new Context.Tbl_Logins(); FillLogin(ld, l); dc.Tbl_Logins.InsertOnSubmit(l); dc.SubmitChanges(); } else { FillLogin(ld, l); } var j = (from jj in dc.Tbl_LoginCompanyJunc where jj.Company_id==DepartmentId && jj.Login_id==l.Id select jj).FirstOrNull(); if (j == null) { j = new Context.Tbl_LoginCompanyJunc(); j.Company_id = DepartmentId; j.Login_id = l.Id; FillJunk(ld, j); dc.Tbl_LoginCompanyJunc.InsertOnSubmit(j); } else { FillJunk(ld, j); } dc.SubmitChanges(); }
static void FillJunk(LoginData s, Context.Tbl_LoginCompanyJunc d) { if (s.IsAdded("organization")) { d.VchOrganization = s.organization; } if (s.IsAdded("user_type_id") && s.user_type_id != null) { d.UserType_Id = GetId(s.user_type_id); } if (s.IsAdded("global_level_setting")) { d.TintLevel = (s.global_level_setting == null) ? null : (byte?)((byte)((int)s.global_level_setting)); } }
public static void InsertLogin(Guid OrganizationId, int DepartmentId, LoginData ld) { if (string.IsNullOrEmpty(ld.email)) { return; } ld.email = ld.email.ToLower(); lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrganizationId, DepartmentId); var l = (from ll in dc.Tbl_Logins where ll.Email.ToLower() == ld.email select ll).FirstOrNull(); if (l == null) { l = new Context.Tbl_Logins(); FillLogin(ld, l); dc.Tbl_Logins.InsertOnSubmit(l); dc.SubmitChanges(); } else { FillLogin(ld, l); } var j = (from jj in dc.Tbl_LoginCompanyJunc where jj.Company_id == DepartmentId && jj.Login_id == l.Id select jj).FirstOrNull(); if (j == null) { j = new Context.Tbl_LoginCompanyJunc(); j.Company_id = DepartmentId; j.Login_id = l.Id; FillJunk(ld, j); dc.Tbl_LoginCompanyJunc.InsertOnSubmit(j); } else { FillJunk(ld, j); } dc.SubmitChanges(); }