public static MPSUser NewUser()
{
string name = DateTime.Now.Ticks.ToString();
string email = name + "@domain.com";
AddObject(_Tabl, new string[] { _login, _pname, _pass, _isAdm, _ret, _birth, _lvl, _email }, new object[] { name, name, "", 0, 0, DateTime.Now, 3, email }, "");
DefectUser.NewUser(name, "", email);
ReferenceVersion.Updatekey();
foreach (int i in EnumRecords(_Tabl, _pid, new string[] { _login }, new object[] { name }))
{
return(new MPSUser(i));
}
return(null);
}
public static MPSUser FindUser(string name, string pass)
{
bool domain = name.Contains("@");
if (domain)
{
bool valid = false;
string dispUserName = name;
using (PrincipalContext context = new PrincipalContext(ContextType.Domain, Settings.CurrentSettings.COMPANYDOMAIN))
{
valid = context.ValidateCredentials(name, pass);
if (valid)
{
var usr = UserPrincipal.FindByIdentity(context, name);
if (usr != null)
{
dispUserName = usr.GivenName + " " + usr.Surname;
}
}
}
if (!valid)
{
return(null);
}
foreach (int i in EnumRecords(_Tabl, _pid, new string[] { _login }, new object[] { name }))
{
return(new MPSUser(i));
}
AddObject(_Tabl, new string[] { _login, _pname, _pass, _isAdm, _ret, _birth, _lvl, _email }, new object[] { name, dispUserName, "", 0, 0, DateTime.Now, 3, name }, "");
DefectUser.NewUser(name, "", name);
ReferenceVersion.Updatekey();
foreach (int i in EnumRecords(_Tabl, _pid, new string[] { _login }, new object[] { name }))
{
return(new MPSUser(i));
}
return(null);
}
foreach (int i in EnumRecords(_Tabl, _pid, new string[] { _login, _pass }, new object[] { name, pass }))
{
return(new MPSUser(i));
}
return(null);
}
public static int New(string tabl, string desc)
{
string sql = $@"
INSERT INTO {tabl}
(
{_ID},
{_idPrj},
{_idOrd},
{_Desc}
)
values
(
(SELECT MAX(T1.{_ID}) + 1 FROM {tabl} T1)
, 1
, (SELECT MAX(T2.{_idOrd}) + 1 FROM {tabl} T2)
, ?
)" ;
SQLExecute(sql, new object[] { desc });
ReferenceVersion.Updatekey();
return(Convert.ToInt32(GetValue($"SELECT MAX({_ID}) FROM {tabl}")));
}
protected override void PostStore()
{
ReferenceVersion.Updatekey();
}