/// <summary>
/// Конструктор по умолчанию
/// </summary>
public MainWindow()
{
InitializeComponent();
Loaded += (s, e) => {
HttpClient httpClient = new HttpClient();
string url = host + $@"getCompanyList";
DataContractJsonSerializer jsonCompanyFormatter = new DataContractJsonSerializer(typeof(CompanyTable[]));
CompanyTable[] ct = (CompanyTable[])jsonCompanyFormatter.ReadObject(new MemoryStream(Encoding.UTF8.GetBytes(httpClient.GetStringAsync(url).Result)));
CompanyTable first = ct.First();
TextBoxCompany.Text = first.Name;
string urlDep = host + $@"getDepartmentsListForCompany/{first.ID}";
DataContractJsonSerializer jsonDepartmentFormatter = new DataContractJsonSerializer(typeof(DepartmentTable[]));
DepartmentTable[] dt = (DepartmentTable[])jsonDepartmentFormatter.ReadObject(new MemoryStream(Encoding.UTF8.GetBytes(httpClient.GetStringAsync(urlDep).Result)));
DeportmentDataGrid.ItemsSource = dt;
};
Closing += (s, e) => {
};
btnShowDepartment.Click += (s, e) => {
if (DeportmentDataGrid.SelectedItem != null)
{
EditDeportmant editWindow = new EditDeportmant(((DepartmentTable)DeportmentDataGrid.SelectedItem).ID);
editWindow.Show();
}
};
}
public DBHelper(string connectionString, LogFunc log = null) : base(connectionString, log)
{
_AppLogTable = new AppLogTable(connectionString, log);
_CompanyTable = new CompanyTable(connectionString, log);
_MaterialTable = new MaterialTable(connectionString, log);
_ReceiptTable = new ReceiptTable(connectionString, log);
_RecordTable = new RecordTable(connectionString, log);
}
static void Main(string[] args)
{
Database db = new Database();
db.Connect();
Vehicle u = new Vehicle();
u.Id = 14;
// u.Manufacturer = "Stadler";
//u.Model = "Tango NF2 kopie";
Console.WriteLine("Seznam vsech statu ve DB");
foreach (Country c in CountryTable.Select())
{
Console.WriteLine(c.Id + " " + c.Name + " " + c.Continent);
}
Console.WriteLine("----");
Console.WriteLine("Seznam vsech mest ve DB");
foreach (City c in CityTable.Select())
{
Console.WriteLine(c.Id + " " + c.Name + " " + c.Region + " STAT: " + c.Country.Name);
}
Console.WriteLine("----");
Console.WriteLine("Seznam vsech vozidel ve DB");
foreach (Vehicle v in VehicleTable.Select())
{
Console.WriteLine(v.Id + " Znacka:" + v.vehicleModel.Manufacturer + " Model:" + v.vehicleModel.Model + " Podtyp:" + v.Podtyp + " City:" + v.city.Name + " Depo:" + v.depot.Name);
}
Console.WriteLine("Seznam vsech company ve DB");
foreach (Company c in CompanyTable.Select())
{
Console.WriteLine(c.Id + " Nazev:" + c.Name);
}
//VehicleTable.Insert(u, db);
/*
* int count1 = VehicleTable.Select(db).Count;
* int dltCount = VehicleTable.Delete(7, db);
* int count2 = VehicleTable.Select(db).Count;
*
* Console.WriteLine("#C: " + count1);
* Console.WriteLine("#D: " + dltCount);
* Console.WriteLine("#C: " + count2);
*/
db.Close();
Console.ReadKey();
}
public HttpResponseMessage Get()
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, "value");
ICompanyService _Companyservice = DependencyResolver.Current.GetService <ICompanyService>();
CompanyTable company = _Companyservice.FirstOrDefault(x => x.AliasCompanyName == "ATK");
BuildTreeLDAP(company, company.DomainTable.LDAPBaseDN, "");
BuildTreeLDAP(company, company.DomainTable.LDAPBaseDN, "", true);
return(response);
}
private void POST_CheckCompany()
{
if (ConfirmType == CONFIRMTYPE_DECLINE_COMPANY)
{
var companyAccount = AccountTable.RetrieveAccountByCompanyID(CompanyID);
AccountTable.DeleteAccount(companyAccount.Id);
CompanyTable.DeleteCompany(CompanyID);
}
else if (ConfirmType == CONFIRMTYPE_CONFIRM_COMPANY)
{
CompanyTable.UpdateCompanyConfirm(CompanyID, true);
}
}
public void OnPost()
{
ValidateEquality(ConfirmEmail, Email, nameof(ConfirmEmail), "The email addresses do not match!");
ValidateEquality(ConfirmPassword, Password, nameof(ConfirmPassword), "The passwords do not match!");
if (ModelState.IsValid)
{
var company = CompanyTable.CreateCompany(CompanyType, CompanyName, CompanyDescription, Latitude, Longitude);
var accountType = (CompanyType == CompanyType.RESTAURANT) ? AccountType.RESTAURANT : AccountType.TAXI;
UserAgent.Register(accountType, Email, Password, new ContactDetails {
FirstName = FirstName, LastName = LastName
}, company.Id);
}
}
public void Save(CompanyView viewTable)
{
if (viewTable.Id == null)
{
var domainTable = new CompanyTable();
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
else
{
var domainTable = Find(viewTable.Id);
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
}
public void SaveDomain(CompanyTable domainTable, string currentUserName = "")
{
string localUserName = getCurrentUserName(currentUserName);
ApplicationUser user = _AccountService.FirstOrDefault(x => x.UserName == localUserName);
if (domainTable.Id == Guid.Empty)
{
domainTable.Id = Guid.NewGuid();
domainTable.CreatedDate = DateTime.UtcNow;
domainTable.ModifiedDate = domainTable.CreatedDate;
domainTable.ApplicationUserCreatedId = user.Id;
domainTable.ApplicationUserModifiedId = user.Id;
repo.Add(domainTable);
}
else
{
domainTable.ModifiedDate = DateTime.UtcNow;
domainTable.ApplicationUserModifiedId = user.Id;
repo.Update(domainTable);
}
_uow.Save();
}
private void BuildTreeLDAP(CompanyTable _item, string _LDAPpath, string _parentDepartmentName = "", bool afterUpdate = false)
{
DirectoryEntry entry = new DirectoryEntry("LDAP://" + _item.DomainTable.LDAPServer + ":" + Convert.ToString(_item.DomainTable.LDAPPort) + "/" + _LDAPpath, _item.DomainTable.LDAPLogin, _item.DomainTable.LDAPPassword, AuthenticationTypes.None);
DirectorySearcher ds = new DirectorySearcher(entry);
ds.SearchScope = SearchScope.OneLevel;
ds.Filter = "(&(objectCategory=organizationalUnit)(!(name=Computers))(!(name=Disable))(!(name=Improvers))(!(name=Service&App))(!(name=Labs))(!(name=Servers))(!(name=Users))(!(name=Groups))(!(name=Disabled)))";
ds.PropertiesToLoad.Add("distinguishedname");
ds.PropertiesToLoad.Add("name");
foreach (SearchResult result in ds.FindAll())
{
if (result.Properties.Contains("distinguishedname") && result.Properties.Contains("name"))
{
Guid depId = Guid.Empty;
if (afterUpdate == false)
{
depId = DepartmentIntegration(result.Properties["name"][0].ToString(), _parentDepartmentName, _item.Id);
}
getUsersDepartment(_item, result.Properties["distinguishedname"][0].ToString(), depId, afterUpdate);
BuildTreeLDAP(_item, result.Properties["distinguishedname"][0].ToString(), result.Properties["name"][0].ToString(), afterUpdate);
}
}
}
private void getUsersDepartment(CompanyTable _item, string _LDAPpath, Guid _department, bool afterUpdate)
{
DirectoryEntry entry = new DirectoryEntry("LDAP://" + _item.DomainTable.LDAPServer + ":"
+ Convert.ToString(_item.DomainTable.LDAPPort) + "/"
+ _LDAPpath, _item.DomainTable.LDAPLogin, _item.DomainTable.LDAPPassword, AuthenticationTypes.None);
DirectorySearcher ds = new DirectorySearcher(entry);
string ldapData;
Guid titleId = Guid.Empty;
ds.SearchScope = SearchScope.OneLevel;
ds.Filter = "(&(objectCategory=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))";
ds.PropertiesToLoad.Add("title");
ds.PropertiesToLoad.Add("mail");
ds.PropertiesToLoad.Add("telephonenumber");
ds.PropertiesToLoad.Add("mobile");
ds.PropertiesToLoad.Add("description");
ds.PropertiesToLoad.Add("cn");
ds.PropertiesToLoad.Add("sn");
ds.PropertiesToLoad.Add("manager");
ds.PropertiesToLoad.Add("sAMAccountName");
foreach (SearchResult result in ds.FindAll())
{
if (result.Properties.Contains("title") && afterUpdate == false)
{
ldapData = result.Properties["title"][0].ToString();
titleId = TitleIntegration(ldapData);
}
if (result.Properties.Contains("description") && result.Properties.Contains("mail"))
{
string telephone = string.Empty;
string mobile = string.Empty;
string mail = string.Empty;
string userid = string.Empty;
string userName = string.Empty;
string manager = string.Empty;
string[] emplName = new string[3];
ldapData = result.Properties["description"][0].ToString();
//mail = result.Properties["mail"][0].ToString();
mail = "*****@*****.**";
emplName = DecodeLDAPNameUsers(ldapData, 0);
if (result.Properties.Contains("telephonenumber"))
{
telephone = result.Properties["telephonenumber"][0].ToString();
}
if (result.Properties.Contains("mobile"))
{
mobile = result.Properties["mobile"][0].ToString();
}
if (result.Properties.Contains("cn"))
{
userName = result.Properties["cn"][0].ToString();
}
if (result.Properties.Contains("sAMAccountName"))
{
userid = result.Properties["sAMAccountName"][0].ToString();
}
if (result.Properties.Contains("manager"))
{
manager = result.Properties["manager"][0].ToString();
}
if (emplName[0] != null && emplName[1] != null)
{
if (afterUpdate == true)
{
try
{
DirectoryEntry entryManager = new DirectoryEntry("LDAP://" + _item.DomainTable.LDAPServer + ":"
+ Convert.ToString(_item.DomainTable.LDAPPort) + "/"
+ manager, _item.DomainTable.LDAPLogin, _item.DomainTable.LDAPPassword, AuthenticationTypes.None);
if (entryManager.Properties.Contains("sAMAccountName"))
{
string ManagerUserId = entryManager.Properties["sAMAccountName"].Value.ToString();
ApplicationDbContext context = new ApplicationDbContext();
var um = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
var userTable = um.FindByName(ManagerUserId);
manager = userTable != null ? userTable.Id : String.Empty;
EmplUpdateIntegration(emplName[1], emplName[0], emplName[2], _item.Id, manager);
}
}
catch
{
return;
}
}
else
{
PrincipalContext ctx = new PrincipalContext(ContextType.Domain);
UserPrincipal user = UserPrincipal.FindByIdentity(ctx, userid);
string domainSID = user.Sid.ToString();
String ApplicationUserId = UserIntegration(userid, mail, domainSID, _item.Id);
EmplIntegration(emplName[1], emplName[0], emplName[2], telephone, mobile, ApplicationUserId, _department, titleId, _item.Id, manager);
}
}
}
}
}
