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);
