public int salgE()
{
try
{
SalGr sg = new SalGr();
if (sg.SAL == 0 || sg.Heal == 0 || sg.HAL == 0 || sg.Dl == 0)
{
return(1);
}
else
{
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.SalaryGs
select a;
SalaryG p = str.Where(obj => obj.SalaryGrade == sg.SLG).First();
p.Salary = sg.SAL;
p.HealthAl = sg.Heal;
p.HomeAl = sg.HAL;
p.HealthAlp = sg.Heal2;
p.HomeAlp = sg.HAL2;
p.DayAl = sg.Dl;
p.Bonus = sg.BON;
cntx.SubmitChanges();
return(0);
}
}
catch { return(1); }
}
private void metroButton3_Click(object sender, EventArgs e)
{
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.taxAndSals
where a.Id2 == ae.id2
select a;
taxAndSal p = str.First();
p.Count = 1;
p.PendingTax = (Convert.ToInt32(metroLabel2.Text) * 2) / 100;
cntx.SubmitChanges();
SaveS ss = new SaveS();
ss.CO = Convert.ToInt32(p.Count);
AddEmp2 ae2 = new AddEmp2();
ae2.FSA();
if (metroTextBox2.Text == "")
{
metroTextBox2.Text = "0";
}
SaveS sa = new SaveS();
int k = Convert.ToInt32(metroLabel7.Text);
if (k == 0)
{
metroTextBox1.Text = "0";
metroTextBox1.Enabled = false;
MetroFramework.MetroMessageBox.Show(this, "Checking Successful", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (metroTextBox1.Text == "")
{
if (Convert.ToInt32(metroLabel7.Text) <= sa.PA)
{
metroTextBox1.Text = metroLabel7.Text;
sa.TL = 0;
sa.PA = 0;
sa.LA = 0;
MetroFramework.MetroMessageBox.Show(this, "Checking Successful", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
metroTextBox1.Text = Convert.ToString(sa.PA);
sa.LA = sa.LA - sa.PA;
MetroFramework.MetroMessageBox.Show(this, "Checking Successful", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (Convert.ToInt32(metroTextBox1.Text) > (sa.PA + 100))
{
MetroFramework.MetroMessageBox.Show(this, "Cant Pay That Much Together", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
metroButton3.Enabled = false;
metroButton1.Enabled = true;
metroLabel18.Text = Convert.ToString(Convert.ToInt32(metroLabel2.Text) + Convert.ToInt32(metroLabel4.Text) + Convert.ToInt32(metroLabel5.Text) - Convert.ToInt32(metroLabel12.Text) - Convert.ToInt32(metroTextBox1.Text) - Convert.ToInt32(metroTextBox2.Text));
}
private void metroButton1_Click(object sender, EventArgs e)
{
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
join b in cntx.CheckIns
on a.Id2 equals b.Id2
select new { Id1 = a.Id1, Id2 = a.Id2, Name = a.Name, Rank = a.Rank, SalaryGrade = a.SalaryGrade, EmailAddress = a.EmailAddress, PreviousMonthCheckInMark = b.PCheckInMark, RunningMonthCheckInMark = b.CheckinMark };
metroGrid1.DataSource = str;
}
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);
}
}
/*public void tcs()
* {
* 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.Travels
* select a;
* Travel p = str.Where(obj => obj.Id2 == ae.id2).First();
* TravelC tc = new TravelC();
* p.Cause = tc.Cau;
* p.Division = tc.Div;
* p.From = tc.Frm;
* p.To = tc.Too;
* p.TicketPrice = tc.TP;
* p.TravelledBy = tc.TrvB;
* cntx.SubmitChanges();
*
* }*/
public void TPayment()
{
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.SalaryGs
select a;
SalaryG p = str.Where(obj => obj.SalaryGrade == ae.SalGrade).First();
FPayment fp = new FPayment();
fp.Bas = Convert.ToInt32(p.Salary);
fp.Hoal = Convert.ToInt32(p.HomeAlp);
fp.Heal = Convert.ToInt32(p.HealthAlp);
fp.BON = Convert.ToInt32(p.Bonus);
//taxC(fp.Bas);
}
public void FLeave()
{
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.Loans_Leaves
select a;
Loans_Leave p = str.Where(obj => obj.Id2 == ae.id2).First();
//Loans_Leave p = str.First();
LoanLeaveC llc = new LoanLeaveC();
llc.YYear = Convert.ToInt32(p.Year);
llc.LeSell = Convert.ToInt32(p.SellLeaveAmount);
llc.LeaveD = Convert.ToInt32(p.LeaveDays);
cntx.SubmitChanges();
}
public void AddLe()
{
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.Loans_Leaves
where a.Id2 == ae.id2
select a;
Loans_Leave p = str.First();
LoanLeaveC llc = new LoanLeaveC();
p.LeaveDays = llc.LeaveD;
p.Year = llc.YYear;
p.SellLeaveAmount = llc.LeSell;
cntx.SubmitChanges();
}
private void button2_Click(object sender, EventArgs e)
{
metroLabel16.Text = Convert.ToString(Convert.ToInt32(metroTextBox1.Text) * 2);
SignInEmp si = new SignInEmp();
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.SalaryGs
select a;
SalaryG p1 = str1.Where(obj => obj.SalaryGrade == si.SalGrade).First();
DateTime ds1 = metroDateTime1.Value.Date;
DateTime ds2 = metroDateTime2.Value.Date;
TimeSpan ts = ds2 - ds1;
int i = ts.Days;
metroLabel13.Text = Convert.ToString(p1.DayAl * i);
}
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;
}
public void FSA()
{
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.Loans_Leaves
where a.Id2 == ae.id2
select a;
Loans_Leave p = str.Where(obj => obj.Id2 == ae.id2).First();
SaveS sa = new SaveS();
// sa.SA = Convert.ToInt32(p.SavingsAccount);
sa.TL = Convert.ToInt32(p.TotalLoan);
sa.PA = Convert.ToInt32(p.PayAmount);
sa.LA = Convert.ToInt32(p.LoanAmount);
sa.LP = Convert.ToInt32(p.LPay);
}
private void metroTile1_Click(object sender, EventArgs e)
{
if (metroTextBox1.Text != "" && metroTextBox2.Text != "" && metroTextBox3.Text != "" && metroTextBox4.Text != "" && metroTextBox5.Text != "" && metroTextBox6.Text != "" && metroTextBox7.Text != "" && metroTextBox5.Text == metroTextBox6.Text)
{
SignInEmp si = new SignInEmp();
AddEmp1 ae1 = new AddEmp1();
ae1.id1 = Convert.ToChar(metroLabel5.Text);
ae1.id2 = metroTextBox4.Text;
ae1.NName = metroTextBox7.Text;
ae1.RRank = metroLabel6.Text;
ae1.SalGrade = metroLabel9.Text;
ae1.PNumber = metroTextBox1.Text;
ae1.HAddress = metroTextBox3.Text;
ae1.EAddress = metroTextBox2.Text;
ae1.Pass = metroTextBox5.Text;
//ae1.DOB = this.metroDateTime1.Text;
//ae1.Pict = filename;
AddEmp2 ae2 = new AddEmp2();
int c = ae2.addToDB();
if (c == 1)
{
MetroFramework.MetroMessageBox.Show(this, " Error", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroFramework.MetroMessageBox.Show(this, " Successful", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
metroTextBox1.Text = "";
metroTextBox2.Text = "";
metroTextBox3.Text = "";
metroTextBox4.Text = "";
metroTextBox5.Text = "";
metroTextBox6.Text = "";
metroTextBox7.Text = "";
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.Under == si.id1 + si.id2
select new { Id1 = a.Id1, Id2 = a.Id2, Name = a.Name };
metroGrid1.DataSource = str;
}
}
else
{
MessageBox.Show("Error Ditected", "Please Fillup all the Boxes");
}
}
public int salgF()
{
SalGr sg = new SalGr();
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.SalaryGs
select a;
SalaryG p = str.Where(obj => obj.SalaryGrade == sg.SLG).First();
sg.SAL = Convert.ToInt32(p.Salary);
sg.Heal = Convert.ToInt32(p.HealthAl);
sg.HAL = Convert.ToInt32(p.HomeAl);
sg.Dl = Convert.ToInt32(p.DayAl);
return(0);
}
catch { return(1); }
}
private void GeneralEmployeePanel_Load(object sender, EventArgs e)
{
if (ae1.id1 == 'F')
{
metroTile2.Enabled = false;
}
metroLabel10.Text = ae1.NName;
metroLabel9.Text = ae1.id1 + ae1.id2;
metroLabel8.Text = ae1.RRank;
//metroLabel16.Text = ae1.DOB;
metroLabel13.Text = ae1.Under;
metroLabel7.Text = ae1.PNumber;
metroLabel6.Text = ae1.EAddress;
metroLabel11.Text = ae1.HAddress;
// pictureBox1.Image = Image.FromFile(ae1.Pict);
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.Loans_Leaves
select a;
Loans_Leave p = str.Where(obj => obj.Id2 == ae.id2).First();
if (Convert.ToInt32(DateTime.Now.ToString("yyyy")) > p.Year)
{
p.LeaveDays = p.LeaveDays + 100;
p.Year = Convert.ToInt32(DateTime.Now.ToString("yyyy"));
cntx.SubmitChanges();
}
//SignInEmp ae = new SignInEmp();
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 == ae.id2).First();
if (p1.Count == 1 && Convert.ToInt32(DateTime.Now.ToString("dd")) > 1)
{
metroTile5.Enabled = false;
}
if (p1.Count == 1 && Convert.ToInt32(DateTime.Now.ToString("dd")) == 1)
{
metroTile5.Enabled = true;
p1.Count = 0;
cntx.SubmitChanges();
}
}
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);
}
}
private void metroButton14_Click(object sender, EventArgs e)
{
SignInEmp si = new SignInEmp();
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
where a.Id2 == si.id2
select a;
taxAndSal tt = str1.First();
tt.PendingTax = tt.PendingTax - Convert.ToInt32(metroTextBox1.Text);
cntx1.SubmitChanges();
Form2 f = new Form2();
Graphics g = f.CreateGraphics();
bmp = new Bitmap(f.Size.Width, f.Size.Height, g);
Graphics mg = Graphics.FromImage(bmp);
mg.CopyFromScreen(f.Location.X, f.Location.Y, 0, 0, f.Size);
printPreviewDialog1.ShowDialog();
}
private void QueryTax_Load(object sender, EventArgs e)
{
SignInEmp si = new SignInEmp();
TaxIn ti = new TaxIn();
AddEmp2 ae = new AddEmp2();
FPayment fp = new FPayment();
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.Loans_Leaves
where a.Id2 == si.id2
select a;
Loans_Leave tsl = str.First();
metroLabel2.Text = DateTime.Now.ToString("yyyy");
metroLabel32.Text = Convert.ToString(tsl.SavingsAccount);
ae.TPayment();
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
where a.Id2 == si.id2
select a;
taxAndSal tt = str1.First();
metroLabel30.Text = Convert.ToString(tt.PendingTax);
}
private void TakePayment_Load(object sender, EventArgs e)
{
metroButton1.Enabled = false;
metroButton3.Enabled = false;
SignInEmp ae = new SignInEmp();
metroLabel20.Text = DateTime.Now.ToString("dd : MM : yyyy");
AddEmp2 ae1 = new AddEmp2();
FPayment fp = new FPayment();
LoanLeaveC llc = new LoanLeaveC();
ae1.TPayment();
metroLabel2.Text = Convert.ToString(fp.Bas);
metroLabel4.Text = Convert.ToString(fp.Hoal);
metroLabel5.Text = Convert.ToString(fp.Heal);
SignInEmp si = 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.CheckIns
select a;
CheckIn p = str.Where(obj => obj.Id2 == si.id2).First();
{
if (Convert.ToInt32(p.PCheckInMark) > 65)
{
metroLabel13.Text = Convert.ToString(((fp.BON * fp.Bas) / 100) + 5000);
}
else
{
metroLabel13.Text = Convert.ToString((fp.BON * fp.Bas) / 100);
}
}
ae1.FindL();
metroLabel7.Text = Convert.ToString(llc.TPA);
}
private void AddEmployee_Load_1(object sender, EventArgs e)
{
SignInEmp si = new SignInEmp();
metroLabel5.Text = Convert.ToString(Convert.ToChar(si.id1 + 1));
if (si.id1 == 'A')
{
metroLabel6.Text = "Junior Manager";
metroLabel9.Text = "Grade 1";
}
else if (si.id1 == 'B')
{
metroLabel6.Text = "Exicutive Officer";
metroLabel9.Text = "Grade 2";
}
if (si.id1 == 'C')
{
metroLabel6.Text = "Senior Engineer";
metroLabel9.Text = "Grade 3";
}
if (si.id1 == 'D')
{
metroLabel6.Text = "Assitant Senior Engineer";
metroLabel9.Text = "Grade 4";
}
if (si.id1 == 'E')
{
metroLabel6.Text = "Assistant Engineer";
metroLabel9.Text = "Grade 5";
}
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.Under == si.id1 + si.id2
select new { Id1 = a.Id1, Id2 = a.Id2, Name = a.Name };
metroGrid1.DataSource = str;
}