public void getDB() { EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in cntx.EmpInformations select a; EmpInformation p = str.Where(obj => obj.Id1 == ae.id1 && obj.Id2 == ae.id2 && obj.Password == ae.Pass).First(); if (ae.id1 == 'A') { Form1 f = new Form1(); Form2 f2 = new Form2(f); ae.NName = p.Name; ae.PNumber = p.PhoneNumber; ae.Pass = p.Password; //ae.DOB = p.DateofBirth; //p.Picture = ae1.Pict; ae.SalGrade = p.SalaryGrade; ae.HAddress = p.HomeAddress; ae.id1 = p.Id1; ae.id2 = p.Id2; ae.RRank = p.Rank; ae.EAddress = p.EmailAddress; f2.S = 1; f.change(); } else { Form1 f = new Form1(); Form2 f2 = new Form2(f); /*EmpInfoLinqDataContext cntx1 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); * var str1 = from a in cntx1.EmpInformations * select a; * EmpInformation p1 = str1.Where(obj1 => obj1.Id2 == ae.id2).First();*/ ae.NName = p.Name; ae.PNumber = p.PhoneNumber; ae.Pass = p.Password; //p.Picture = ae1.Pict; ae.SalGrade = p.SalaryGrade; ae.HAddress = p.HomeAddress; ae.id1 = p.Id1; ae.id2 = p.Id2; ae.RRank = p.Rank; ae.EAddress = p.EmailAddress; ae.Under = p.Under; //ae.Pict = p1.Division; f2.S = 2; f.change(); } cntx.SubmitChanges(); }
public void changeP(string pa) { SignInEmp ae = new SignInEmp(); EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in cntx.EmpInformations where a.Id2 == ae.id2 select a; EmpInformation p = str.First(); p.Password = pa; //ae.Pass = pa; cntx.SubmitChanges(); }
public void editp() { SignInEmp ae = new SignInEmp(); EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in cntx.EmpInformations where a.Password == ae.Pass select a; EmpInformation p = str.First(); p.PhoneNumber = ae.PNumber; p.EmailAddress = ae.EAddress; p.HomeAddress = ae.HAddress; cntx.SubmitChanges(); }
public int addToDB() { try { AddEmp1 ae1 = new AddEmp1(); EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); Loans_Leave lo = new Loans_Leave(); lo.Id2 = ae1.id2; lo.LeaveDays = 100; lo.SavingsAccount = 10000; lo.LoanAmount = 0; lo.PayAmount = 0; lo.Year = Convert.ToInt32(DateTime.Now.ToString("yyyy")); taxAndSal trs = new taxAndSal(); trs.Id2 = ae1.id2; trs.PendingTax = 0; /*CheckIn ci = new CheckIn(); * ci.Id2 = ae1.id2; ; * ci.CheckinMark = 0; * ci.PCheckInMark = 0; * ci.CheckInCounter = "0"; * ci.Password = ae1.Pass;*/ EmpInformation emp = new EmpInformation(); emp.Id1 = ae1.id1; emp.Id2 = ae1.id2; emp.Name = ae1.NName; emp.Password = ae1.Pass; emp.PhoneNumber = ae1.PNumber; emp.Rank = ae1.RRank; emp.SalaryGrade = ae1.SalGrade; emp.HomeAddress = ae1.HAddress; emp.EmailAddress = ae1.EAddress; emp.Under = ae.id1 + ae.id2; cntx.EmpInformations.InsertOnSubmit(emp); cntx.Loans_Leaves.InsertOnSubmit(lo); cntx.taxAndSals.InsertOnSubmit(trs); //cntx.CheckIns.InsertOnSubmit(ci); cntx.SubmitChanges(); return(0); } catch { return(1); } }
private void metroTile2_Click(object sender, EventArgs e) { SignInEmp si = new SignInEmp(); EmpInfoLinqDataContext cntx3 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str3 = from a in cntx3.CheckIns select a; CheckIn p3 = str3.Where(obj => obj.Id2 == metroTextBox4.Text).First(); //EmpInformation em = str.First(); cntx3.CheckIns.DeleteOnSubmit(p3); cntx3.SubmitChanges(); EmpInfoLinqDataContext cntx1 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str1 = from a in cntx1.taxAndSals select a; taxAndSal p1 = str1.Where(obj => obj.Id2 == metroTextBox4.Text).First(); //EmpInformation em = str.First(); cntx1.taxAndSals.DeleteOnSubmit(p1); cntx1.SubmitChanges(); EmpInfoLinqDataContext cntx2 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str2 = from a in cntx2.Loans_Leaves select a; Loans_Leave p2 = str2.Where(obj => obj.Id2 == metroTextBox4.Text).First(); //EmpInformation em = str.First(); cntx2.Loans_Leaves.DeleteOnSubmit(p2); cntx2.SubmitChanges(); EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in cntx.EmpInformations select a; EmpInformation p = str.Where(obj => obj.Id2 == metroTextBox4.Text).First(); //EmpInformation em = str.First(); cntx.EmpInformations.DeleteOnSubmit(p); cntx.SubmitChanges(); MetroFramework.MetroMessageBox.Show(this, " Deleted", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); EmpInfoLinqDataContext cntx5 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str5 = from a in cntx5.EmpInformations where a.Id1 == si.id1 + 1 select new { Id1 = a.Id1, Id2 = a.Id2, Name = a.Name }; metroGrid1.DataSource = str5; }
private void metroButton2_Click(object sender, EventArgs e) { try { EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in cntx.EmpInformations where a.Id2 == metroTextBox4.Text select a; EmpInformation em = str.First(); metroTextBox7.Text = em.Name; metroTextBox1.Text = em.PhoneNumber; metroTextBox2.Text = em.EmailAddress; metroTextBox3.Text = em.HomeAddress; metroLabel6.Text = em.Rank; metroLabel9.Text = em.SalaryGrade; } catch { MetroFramework.MetroMessageBox.Show(this, "Error", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
partial void DeleteEmpInformation(EmpInformation instance);
partial void UpdateEmpInformation(EmpInformation instance);
partial void InsertEmpInformation(EmpInformation instance);