private void button162_Click(object sender, EventArgs e) { string today = DateTime.Today.ToString("yyyy/MM/dd"); ProjectRequest InsightProjectRequest = new ProjectRequest(); Address ProjectRequestAd = new Address(); InsightProjectRequest.ProjectRequestDescription = PRconfirmtxt.Text; InsightProjectRequest.ProjectRequestTypeID = Convert.ToInt32(PRcbx.SelectedValue); InsightProjectRequest.ProjectRequestDate = Convert.ToDateTime(today); ProjectRequestAd.CityID = Convert.ToInt32(citycbx.SelectedValue); string projectRequestAddress = addressline1lbl.Text + ", " + addressline2lbl.Text + ", " + addressline3lbl.Text; ProjectRequestAd.AddressDescription = projectRequestAddress; using (InsightEntities db = new InsightEntities()) { db.Addresses.Add(ProjectRequestAd); db.SaveChanges(); } int addressID = ProjectRequestAd.AddressID; using (InsightEntities db = new InsightEntities()) { InsightProjectRequest.AddressID = addressID; InsightProjectRequest.ProjectRequestStatusID = 1; InsightProjectRequest.ClientID = 2; //temporary: needs to be replaced with logged in clientID db.ProjectRequests.Add(InsightProjectRequest); db.SaveChanges(); } }
private void ConfirmBtn_Click(object sender, EventArgs e) { Supplier InsightSupplier = new Supplier(); ContactPerson InsightCP = new ContactPerson(); Address InsightAddress = new Address(); InsightSupplier.SupplierName = SupName; InsightAddress.AddressDescription = AddL1 + " " + AddL2 + " " + AddL3; //InsightAddress.City = City; //InsightAddress.County = Country; InsightCP.ContactPersonName = CPName; InsightCP.ContactPersonPhoneNumber = Convert.ToInt32(CPNumber); InsightCP.ContactPersonJobDescription = JobD; InsightCP.ContactPersonEmailAddress = CPEmail; InsightCP.SupplierID = InsightSupplier.SupplierID; InsightSupplier.AddressID = InsightAddress.AddressID; using (InsightEntities db = new InsightEntities()) { db.Suppliers.Add(InsightSupplier); db.ContactPersons.Add(InsightCP); db.Addresses.Add(InsightAddress); db.SaveChanges(); } }
private void AProdConfirmBtn_Click(object sender, EventArgs e) { Product InsightProduct = new Product(); ProductPrice InsightProdPrice = new ProductPrice(); InsightProduct.ProductDescription = Descr; InsightProduct.ProductQuantity = Quantity; InsightProdPrice.ProductPriceDate = DateTime.Now; InsightProdPrice.ProductPriceAmount = Price; //Determine Decimal points for values without decimals on entry using (InsightEntities db = new InsightEntities()) { var Ty = db.ProductTypes.SingleOrDefault(x => x.ProductTypeDescription == Type); InsightProduct.ProductTypeID = Ty.ProductTypeID; InsightProdPrice.ProductID = InsightProduct.ProductID; db.ProductPrices.Add(InsightProdPrice); db.Products.Add(InsightProduct); db.SaveChanges(); //Selecting the ID to save into the Price Table //var ID = db.Products.Select(x => x.ProductDescription == InsightProduct.ProductDescription); } AddProductTab.SelectedIndex = 2; }
private void RemoveBtn_Click(object sender, EventArgs e) { Vehicle InsightVehicle = new Vehicle(); using (InsightEntities db = new InsightEntities()) { var V = db.Vehicles.SingleOrDefault(x => x.VehicleID == VID); db.Vehicles.Remove(V); db.SaveChanges(); } }
private void AJTConfirmBtn_Click(object sender, EventArgs e) { JobType InsightJobType = new JobType(); InsightJobType.JobTypeDescription = JT; using (InsightEntities db = new InsightEntities()) { db.JobTypes.Add(InsightJobType); db.SaveChanges(); } }
private void ASConfirmBtn_Click(object sender, EventArgs e) { Skill InsightSkill = new Skill(); InsightSkill.SkillDescription = Skill; using (InsightEntities db = new InsightEntities()) { db.Skills.Add(InsightSkill); db.SaveChanges(); } AddSkillTab.SelectedIndex = 2; }
private void AVTConfirmBtn_Click(object sender, EventArgs e) { VehicleType InsightVehicleType = new VehicleType(); InsightVehicleType.VehicleTypeDescription = VehicleType; using (InsightEntities db = new InsightEntities()) { db.VehicleTypes.Add(InsightVehicleType); db.SaveChanges(); AddVehicleTypeTab.SelectedIndex = 2; } }
private void DVTConfirmBtn_Click(object sender, EventArgs e) { using (InsightEntities db = new InsightEntities()) { var VType = db.VehicleTypes.SingleOrDefault(x => x.VehicleTypeID == 2); if (VType != null) { db.VehicleTypes.Remove(VType); db.SaveChanges(); } } }
private void AProdTConfirmBtn_Click(object sender, EventArgs e) { ProductType InsightProdType = new ProductType(); InsightProdType.ProductTypeDescription = ProdType; using (InsightEntities db = new InsightEntities()) { db.ProductTypes.Add(InsightProdType); db.SaveChanges(); } AddProductTypeTab.SelectedIndex = 2; }
private void DEqBtn_Click(object sender, EventArgs e) { //Are we going to delete a certain quantity of of equipment or all of them? using (InsightEntities db = new InsightEntities()) { var Eq = db.Equipments.SingleOrDefault(x => x.EquipmentID == 2); if (Eq != null) { db.Equipments.Remove(Eq); db.SaveChanges(); } } }
private void DProdTDeleteBtn_Click(object sender, EventArgs e) { using (InsightEntities db = new InsightEntities()) { var ProdType = db.ProductTypes.SingleOrDefault(x => x.ProductTypeID == 2); if (ProdType != null) { db.ProductTypes.Remove(ProdType); db.SaveChanges(); } } }
private void AOTConfirmBtn_Click(object sender, EventArgs e) { OrganisationType InsightOrgType = new OrganisationType(); InsightOrgType.OrganisationTypeDescription = OrgType; using (InsightEntities db = new InsightEntities()) { db.OrganisationTypes.Add(InsightOrgType); db.SaveChanges(); AddOrganisationTypeTab.SelectedIndex = 2; } }
private void AETConfirmBtn_Click(object sender, EventArgs e) { EmployeeType InsightEmployeeType = new EmployeeType(); InsightEmployeeType.EmployeeTypeDescription = EType; using (InsightEntities db = new InsightEntities()) { db.EmployeeTypes.Add(InsightEmployeeType); db.SaveChanges(); AddEmployeeTypeTab.SelectedIndex = 2; } }
private void DETDeleteBtn_Click(object sender, EventArgs e) { using (InsightEntities db = new InsightEntities()) { var EmpType = db.EmployeeTypes.SingleOrDefault(x => x.EmployeeTypeID == 5); if (EmpType != null) { db.EmployeeTypes.Remove(EmpType); db.SaveChanges(); } } }
private void UVSConfirmBtn_Click(object sender, EventArgs e) { Vehicle InsightVehicle = new Vehicle(); InsightVehicle.VehicleStatusID = VStatusCmb.SelectedIndex + 1; using (InsightEntities db = new InsightEntities()) { var curVehicle = db.Vehicles.SingleOrDefault(x => x.VehicleID == 3); curVehicle.VehicleStatusID = InsightVehicle.VehicleStatusID; db.SaveChanges(); } UpdateVehicleStatusTab.SelectedIndex = 2; }
private void AEqTConfirmBtn_Click(object sender, EventArgs e) { EquipmentType InsightEquipType = new EquipmentType(); InsightEquipType.EquipmentTypeDescription = EquipType; using (InsightEntities db = new InsightEntities()) { db.EquipmentTypes.Add(InsightEquipType); db.SaveChanges(); } AddEquipmentTypeTab.SelectedIndex = 2; }
private void DEmpDeleteBtn_Click(object sender, EventArgs e) { //Add deletion of Login and Address as well as getting ID Value from view form //Bind all labels to the ID using (InsightEntities db = new InsightEntities()) { var Emp = db.Employees.SingleOrDefault(x => x.EmployeeID == 2); if (Emp != null) { db.Employees.Remove(Emp); db.SaveChanges(); } } }
private void AEqConfirmBtn_Click(object sender, EventArgs e) { Equipment InsightEquipment = new Equipment(); InsightEquipment.EquipmentDescription = EqDescr; InsightEquipment.EquipmentQuantity = EqQuantity; using (InsightEntities db = new InsightEntities()) { var Ty = db.EquipmentTypes.SingleOrDefault(x => x.EquipmentTypeDescription == EqType); InsightEquipment.EquipmentTypeID = Ty.EquipmentTypeID; db.Equipments.Add(InsightEquipment); db.SaveChanges(); } AddEquipmentTab.SelectedIndex = 2; }
private void DOTDeleteBtn_Click(object sender, EventArgs e) { MessageBox.Show("Are you sure you want to delete this Organisation Type?"); //OrganisationType InsightOrgType = new OrganisationType(); using (InsightEntities db = new InsightEntities()) { var OType = db.OrganisationTypes.SingleOrDefault(x => x.OrganisationTypeID == 2); //replace number with ID from the View OType Screen. if (OType != null) { db.OrganisationTypes.Remove(OType); db.SaveChanges(); } } }
private void button8_Click(object sender, EventArgs e) { ProjectPhase InsightProPhase = new ProjectPhase(); InsightProPhase.ProjectPhaseDescription = PhaseDescr; InsightProPhase.ProjectPhaseEndDate = PhaseEDate; InsightProPhase.ProjectPhaseStartDate = PhaseSDate; InsightProPhase.ProjectID = ProjID; using (InsightEntities db = new InsightEntities()) { var Ty = db.ProjectPhaseTypes.SingleOrDefault(x => x.ProjectPhaseTypeDescription == PhaseTy); var Stat = db.ProjectPhaseStatus.SingleOrDefault(x => x.ProjectPhaseStatusDescription == PhaseStat); InsightProPhase.ProjectPhaseTypeID = Ty.ProjectPhaseTypeID; InsightProPhase.ProjectPhaseStatusID = Stat.ProjectPhaseStatusID; db.ProjectPhases.Add(InsightProPhase); db.SaveChanges(); } this.Close(); }
private void AVConfirmBtn_Click(object sender, EventArgs e) { //VehicleType vehicleType = new VehicleType(); Vehicle InsightVehicle = new Vehicle(); InsightVehicle.VehicleRegistration = Reg; InsightVehicle.VehicleMake = Make; InsightVehicle.VehicleModel = Model; //InsightVehicle.VehicleYear = Convert.ToDateTime(Year); InsightVehicle.VehicleStatusID = 1; InsightVehicle.VehicleYear = DateTime.Now; InsightVehicle.PurchaseDate = Convert.ToDateTime(PDate); using (InsightEntities db = new InsightEntities()) { InsightVehicle.VehicleType = db.VehicleTypes.SingleOrDefault(x => x.VehicleTypeDescription == Type); db.Vehicles.Add(InsightVehicle); db.SaveChanges(); AddVehicleTab.SelectedIndex = 2; } }
private void button19_Click(object sender, EventArgs e) { Globals myglobalclass = new Globals(); SqlConnection conn = new SqlConnection(myglobalclass.myConn); SqlDataReader myReader; #region Check if user exists bool duplicate = false; int num = 2; SqlCommand checkUser; String username = Char.ToUpper(EmployeeNamelbl.Text[0]) + "." + EmployeeSurnamelbl.Text; while (duplicate) { try { checkUser = new SqlCommand("SELECT EmployeeUsername FROM EmployeeLogin WHERE EmployeeUsername ="******"'" + username + "'", conn); conn.Open(); myReader = checkUser.ExecuteReader(); if (myReader.HasRows) { duplicate = true; //If duplicate, add identifier to name username = Char.ToUpper(EmployeeNamelbl.Text[0]) + "." + EmployeeSurnamelbl.Text + num.ToString(); num++; } else { duplicate = false; } myReader.Close(); conn.Close(); } catch (Exception myEx) { MessageBox.Show("Error: " + myEx.Message); } } #endregion #region Adding employee details into database string employeeAddress = EmployeeAd1lbl.Text + "," + EmployeeAd2lbl.Text + "," + EmployeeAd3lbl.Text; Employee InsightEmployee = new Employee(); Address InsightAddress = new Address(); EmployeeLogin InsightEmployeeLogin = new EmployeeLogin(); //dataGridView1.DataSource= InsightEmployee.Skills.ToList(); //Using Employee Table InsightEmployee.EmployeeName = EmployeeNamelbl.Text; InsightEmployee.EmployeeSurname = EmployeeSurnamelbl.Text; InsightEmployee.EmployeeDateOfBirth = EmployeeDOB.Value.Date; InsightEmployee.EmployeeEmailAddress = EmployeeEmaillbl.Text; //InsightEmployee.EmployeeNumber = Convert.ToInt32(EmployeeNumberlbl.Text); InsightEmployee.EmployeeGender = EmployeeGenderCbx.Text; InsightEmployee.EmployeeTypeID = Convert.ToInt32(EmployeeTypeCbx.SelectedValue); //Using Address Table InsightAddress.AddressDescription = employeeAddress; InsightAddress.CityID = Convert.ToInt32(EmployeeCity.SelectedValue); InsightEmployeeLogin.EmployeeUsername = username; #endregion #region Hashing and storing the password string pass = username + "#123"; //Generate hash HashAlgorithm hashFunc = SHA256.Create(); byte[] hold = hashFunc.ComputeHash(Encoding.UTF8.GetBytes(pass)); //Get hash string StringBuilder hashString = new StringBuilder(); foreach (byte b in hold) { hashString.Append(b.ToString("X2")); } //Store hash string in database InsightEmployeeLogin.EmployeePassword = hashString.ToString(); InsightEmployeeLogin.AccessLevelID = 3; #endregion using (InsightEntities db = new InsightEntities()) { db.Addresses.Add(InsightAddress); db.SaveChanges(); } using (InsightEntities db = new InsightEntities()) { db.EmployeeLogins.Add(InsightEmployeeLogin); db.SaveChanges(); } //new primary keys int addressID = InsightAddress.AddressID; int employeeLoginID = InsightEmployeeLogin.EmployeeLoginID; int employeeID = InsightEmployee.EmployeeID; //Table carrying all foreign keys at the bottom using (InsightEntities db = new InsightEntities()) { InsightEmployee.AddressID = addressID; InsightEmployee.EmployeeLoginID = employeeLoginID; db.Employees.Add(InsightEmployee); db.SaveChanges(); } //Entity Framework not putting assossiatives as classes var addedskill = AddedSkillList.Items.Cast <String>().ToList(); SqlCommand insertEmployeeSkill; SqlCommand getSkillID; int skillID = 0; //default //Insert skills into db foreach (string skillDesc in addedskill) { // DataSet ds = new DataSet(); #region Retrieve skill id for specific skill description try { insertEmployeeSkill = new SqlCommand("Insert into EmployeeSkill(EmployeeID, SkillID) Values(@EmployeeID, @SkillID)", conn); insertEmployeeSkill.Parameters.AddWithValue("@EmployeeID", employeeID); getSkillID = new SqlCommand("SELECT SkillID FROM Skill WHERE SkillDescription =" + "'" + skillDesc + "'", conn); conn.Open(); myReader = getSkillID.ExecuteReader(); //Getting skillId from database while (myReader.Read()) { skillID = Convert.ToInt32(myReader["SkillID"]); } myReader.Close(); #region Insert skill id with employeeId into EmployeeSkill insertEmployeeSkill.Parameters.AddWithValue("@SkillID", skillID); insertEmployeeSkill.ExecuteNonQuery(); #endregion conn.Close(); } catch (Exception myEx) { MessageBox.Show("Error: " + myEx.Message); } #endregion } }
private void button13_Click(object sender, EventArgs e) { string clientAddress = addressline1.Text + ", " + addressline2.Text + ", " + addressline3.Text; Client InsightClient = new Client(); Individual InsightIndividual = new Individual(); Address InsightClientAddress = new Address(); ClientLogin InsightClientLogin = new ClientLogin(); //Client Table InsightClient.ClientName = clientNametxt.Text; InsightClient.ClientNumber = Convert.ToInt32(clientNumbertxt.Text); //Address Table InsightClientAddress.AddressDescription = clientAddress; InsightClientAddress.CityID = Convert.ToInt32(citycbx.SelectedValue); #region store client and address info using (InsightEntities db = new InsightEntities()) { db.Addresses.Add(InsightClientAddress); db.SaveChanges(); } int clientTypeID = Convert.ToInt32(clientcbx.SelectedValue); int addressID = InsightClientAddress.AddressID; using (InsightEntities db = new InsightEntities()) { db.Clients.Add(InsightClient); InsightClient.ClientTypeID = clientTypeID; InsightClient.AddressID = addressID; db.SaveChanges(); } #endregion int clientID = InsightClient.ClientID; #region Individual if (clientcbx.Text == "Individual") { SqlConnection Myconn = new SqlConnection(globalClass.myConn); Myconn.Open(); SqlCommand insertIndividual = new SqlCommand("Insert Into Individual(ClientID, IndividualEmailAddress, IndividualDateOfBirth) Values (@ClientID, @IndividualEmailAddress, @IndividualDateOfBirth)", Myconn); insertIndividual.Parameters.AddWithValue("@ClientID", clientID); insertIndividual.Parameters.AddWithValue("@IndividualEmailAddress", contactEmail.Text); insertIndividual.Parameters.AddWithValue("@IndividualDateOfBirth", clientDOB.Value.Date); insertIndividual.ExecuteNonQuery(); Myconn.Close(); } #endregion #region Organisation if (clientcbx.Text == "Organisation") { ContactPerson organisationContact = new ContactPerson(); SqlConnection Myconn = new SqlConnection(globalClass.myConn); Myconn.Open(); SqlCommand insertOrganisation = new SqlCommand("Insert into Organisation(ClientID, OrganisationTypeID) Values (@ClientID, @OrganisationTypeID)", Myconn); insertOrganisation.Parameters.AddWithValue("@ClientID", clientID); insertOrganisation.Parameters.AddWithValue("@OrganisationTypeID", organisationTypecbx.SelectedValue); insertOrganisation.ExecuteNonQuery(); Myconn.Close(); organisationContact.ContactPersonEmailAddress = contactEmail.Text; organisationContact.ContactPersonJobDescription = contactJobtxt.Text; organisationContact.ContactPersonName = contactNametxt.Text; organisationContact.ContactPersonPhoneNumber = Convert.ToInt32(contactNumbertxt.Text); organisationContact.ClientID = clientID; using (InsightEntities db = new InsightEntities()) { db.ContactPersons.Add(organisationContact); db.SaveChanges(); } } #endregion string username = Char.ToUpper(clientcbx.Text[0]) + "." + clientNamelbl.Text; #region generate username and password SqlConnection conn = new SqlConnection(globalClass.myConn); SqlDataReader myReader; int usernumber = 1; int tmp = 0; try { while (tmp == 0) { SqlCommand checkUser = new SqlCommand("Select ClientUsername From ClientLogin Where ClientUsername ="******"'" + username + "'", conn); conn.Open(); myReader = checkUser.ExecuteReader(); if (myReader.HasRows) { username = username + Convert.ToString(usernumber); usernumber++; } else { myReader.Close(); conn.Close(); tmp = 1; } } } catch (Exception error) { MessageBox.Show("Error: " + error.Message); } string pass = username + "#123"; //Generate hash HashAlgorithm hashFunc = SHA256.Create(); byte[] hold = hashFunc.ComputeHash(Encoding.UTF8.GetBytes(pass)); StringBuilder hashString = new StringBuilder(); foreach (byte b in hold) { hashString.Append(b.ToString("X2")); } //Store hash string in database InsightClientLogin.ClientPassword = hashString.ToString(); InsightClientLogin.AccessLevelID = 2; #endregion using (InsightEntities db = new InsightEntities()) { db.ClientLogins.Add(InsightClientLogin); db.SaveChanges(); } //email feature MessageBox.Show("Successful, Username: "******" Password: " + pass); }