static void FillLogin(LoginData s, Context.Tbl_Logins d)
{
if (s.IsAdded("email"))
{
d.Email = s.email;
}
if (s.IsAdded("first_name"))
{
d.FirstName = s.first_name;
}
if (s.IsAdded("last_name"))
{
d.LastName = s.last_name;
}
if (s.IsAdded("title"))
{
d.Title = s.title;
}
if (s.IsAdded("phone"))
{
d.Phone = s.phone;
}
if (s.IsAdded("mobile_phone"))
{
d.MobilePhone = s.mobile_phone;
}
}
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();
}
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();
}
