private void btnBegin_Click(object sender, EventArgs e) { SplashForm.ShowSplashScreen(); LDAPUserImporter li = new LDAPUserImporter(); li.ImportLDAPUser(); SplashForm.CloseForm(); MessageBox.Show("Users Synced Successfully!"); }
private void btnBrowse_Click(object sender, EventArgs e) { { OpenFileDialog openDlg = new OpenFileDialog(); //openDlg.InitialDirectory = "c:\\"; openDlg.Filter = "image files |*.csv; "; openDlg.FilterIndex = 1; //openFileDialog1.RestoreDirectory = true; var res = openDlg.ShowDialog(); if (res == DialogResult.OK) { var filename = openDlg.FileName; txtFilename.Text = filename; SplashForm.ShowSplashScreen(); using (TextFieldParser parser = new TextFieldParser(filename)) { parser.TextFieldType = FieldType.Delimited; parser.SetDelimiters(","); while (!parser.EndOfData) { //Processing row string[] fields = parser.ReadFields(); //EMPLOYEE PCNAME DEPARTMENT OFFICE CPU OS HDD HDD RAM UPS PRINTER LOG-IN OS OFFICE IP SUBNET GATEWAY AV //Create CPU var email = fields[16]; var userId = 0; if (email.IndexOf("@") != -1) { var addr = new MailAddress(email); email = addr.User; var user = Singleton.Instance.UserModel.GetUsersByUsername(email); if (user != null) { userId = user.Id; } } fields[5] = (fields[5] == "") ? "Unknown" : fields[5]; fields[3] = (fields[3] == "") ? "MS OFFICE" : fields[3].Replace(" ", ""); fields[4] = (fields[4] == "") ? "Unknown" : fields[4].Replace(" ", ""); fields[8] = (fields[8] == "") ? "Unknown" : fields[8].Replace(" ", ""); fields[6] = (fields[6] == "") ? "Unknown" : fields[6].Replace(" ", ""); fields[7] = (fields[7] == "") ? "Unknown" : fields[7].Replace(" ", ""); fields[10] = (fields[10] == "") ? "Unknown" : fields[10].Replace(" ", ""); fields[12] = (fields[12] == "") ? "Unknown" : fields[12].Replace(" ", ""); fields[11] = (fields[11] == "") ? "Unknown" : fields[11].Replace(" ", ""); var iCPU = new ItemViewModel(); iCPU.Name = fields[1]; iCPU.OS = Singleton.Instance.ItemModel.GetOSname(fields[5]).Id; iCPU.Processor = (ItemProcessors)Enum.Parse(typeof(ItemProcessors), fields[4], true); iCPU.Memory = (ItemMemory)Enum.Parse(typeof(ItemMemory), fields[8], true); iCPU.HDD1 = (ItemHDDCapacity)Enum.Parse(typeof(ItemHDDCapacity), fields[6], true); iCPU.HDD2 = (ItemHDDCapacity)Enum.Parse(typeof(ItemHDDCapacity), fields[7], true); iCPU.PrinterType = (fields[10] == "network") ? (PrinterType)Enum.Parse(typeof(PrinterType), fields[10], true) : PrinterType.Local; iCPU.LoginType = (ItemLoginType)Enum.Parse(typeof(ItemLoginType), fields[11], true); iCPU.TypeId = 1; iCPU.SubTypeId = 1; iCPU.PurchasePrice = Singleton.Instance.ItemSubTypeModel.GetDefaultPrice(iCPU.SubTypeId); iCPU.Description = string.Format("{0}({1})", fields[0], fields[2]); iCPU.NetworkIP = fields[12]; iCPU.NetworkSubnet = fields[13]; iCPU.NetworkGateway = fields[14]; iCPU.Status = ItemStatus.Available; if (userId > 0) { iCPU.CurrentOwner = userId; iCPU.Status = ItemStatus.Assigned; } var result = Singleton.Instance.ItemModel.CreateNewItem(iCPU, Singleton.Instance.UserModel.CurrentUser.Id); iCPU.Id = Convert.ToInt32(result.Param1); //Create OS - 37 var iOS = new ItemViewModel(); iOS.Name = string.Format("{0} ({1})", fields[5], fields[1]); iOS.Serial = fields[17]; iOS.TypeId = 5; iOS.SubTypeId = 37; iOS.PurchasePrice = Singleton.Instance.ItemSubTypeModel.GetDefaultPrice(iOS.SubTypeId); iOS.ParentId = iCPU.Id; iOS.Description = fields[0]; iOS.Status = ItemStatus.Available; if (userId > 0) { iOS.CurrentOwner = userId; iOS.Status = ItemStatus.Assigned; } result = Singleton.Instance.ItemModel.CreateNewItem(iOS, Singleton.Instance.UserModel.CurrentUser.Id); //Create Office - 38 var iOffice = new ItemViewModel(); iOffice.Name = string.Format("{0} ({1})", fields[3], fields[1]); iOffice.Serial = fields[18]; iOffice.SubTypeId = 38; iOffice.TypeId = 5; iOffice.PurchasePrice = Singleton.Instance.ItemSubTypeModel.GetDefaultPrice(iOffice.SubTypeId); iOffice.Description = fields[0]; iOffice.Status = ItemStatus.Available; if (userId > 0) { iOffice.CurrentOwner = userId; iOffice.Status = ItemStatus.Assigned; } result = Singleton.Instance.ItemModel.CreateNewItem(iOffice, Singleton.Instance.UserModel.CurrentUser.Id); //Symantec - 36 var iAV = new ItemViewModel(); iAV.Name = "Symantec"; iAV.Serial = fields[15]; iAV.SubTypeId = 36; iAV.TypeId = 5; iAV.Description = fields[0]; iAV.PurchasePrice = Singleton.Instance.ItemSubTypeModel.GetDefaultPrice(iAV.SubTypeId); iAV.CurrentOwner = userId; iAV.Status = ItemStatus.Available; if (userId > 0) { iAV.CurrentOwner = userId; iAV.Status = ItemStatus.Assigned; } result = Singleton.Instance.ItemModel.CreateNewItem(iAV, Singleton.Instance.UserModel.CurrentUser.Id); //Create Printer - 39 if (fields[11] != "" && fields[10] != "network") { var iPrinter = new ItemViewModel(); iPrinter.Name = string.Format("{0} ({1})", "Printer", fields[1]); iPrinter.Model = fields[10]; iPrinter.SubTypeId = 39; iPrinter.TypeId = 1; iPrinter.PurchasePrice = Singleton.Instance.ItemSubTypeModel.GetDefaultPrice(iPrinter.SubTypeId); iPrinter.Description = ""; iPrinter.Status = ItemStatus.Available; if (userId > 0) { iPrinter.CurrentOwner = userId; iPrinter.Status = ItemStatus.Assigned; } result = Singleton.Instance.ItemModel.CreateNewItem(iPrinter, Singleton.Instance.UserModel.CurrentUser.Id); } } } SplashForm.CloseForm(); MessageBox.Show("Item upload successful!"); } } }