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