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);
}
private string GetPackageVersion(ReferenceVersion version)
{
if
(
version.Version != null &&
version.MaxVersion == version.Version &&
version.MinVersion == version.Version
)
{
return(version.Version.ToString());
}
var str = new StringBuilder();
if (version.IsIncludeMinVersion)
{
str.Append("[");
}
else
{
str.Append("(");
}
if (version.MinVersion != null)
{
str.Append(version.MinVersion.ToString());
}
str.Append(",");
if (version.MaxVersion != null)
{
str.Append(version.MaxVersion.ToString());
}
str.Append
(
version.IsIncludeMaxVersion ? "]" : ")"
);
return(str.ToString());
}
private IEnumerable <Package> GetProjectReference(XElement element, string version)
{
return(Enumerable.Empty <Package>());
var packageList = new List <Package>();
var regex = new Regex(@"([\w|\.]+)\.csproj");
var referenceVersion = ReferenceVersion.Parser(version);
foreach (var temp in element.DescendantsAndSelf(XName.Get("ProjectReference")))
{
var package = temp.Attribute(XName.Get("Include"))?.Value;
if (!string.IsNullOrEmpty(package))
{
package = regex.Match(package).Groups[1].Value;
}
packageList.Add(new Package(package, referenceVersion));
}
return(packageList);
}
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}")));
}
private static List <Package> GetPackageReference(XElement element)
{
var packageList = new List <Package>();
var packageReferenceList = new List <string>();
foreach (var temp in element.DescendantsAndSelf(XName.Get("PackageReference")))
{
var package = temp.Attribute(XName.Get("Include"));
var version = temp.Attribute(XName.Get("Version"));
if (package == null || version == null)
{
continue;
}
packageList.Add(new Package(package.Value, ReferenceVersion.Parser(version.Value)));
packageReferenceList.Add(temp.ToString());
}
return(packageList);
}
/// <inheritdoc />
public Package(string packageName, ReferenceVersion referenceVersion)
{
PackageName = packageName;
ReferenceVersion = referenceVersion;
}
public void EditInfo(string name, ReferenceVersion version, byte[] rowVersion)
{
this.Name = name;
this.ReferenceVersion = version;
this.RowVersion = rowVersion;
}
protected override void PostStore()
{
ReferenceVersion.Updatekey();
}
