using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace Payroll
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
private SqlCommand command = new SqlCommand();
private void Form1_Load(object sender, EventArgs e)
{
this.salariesTableAdapter.FillBy(this.salariesDataSet.Salaries);
}
private decimal BasicSalary, Overtime, ExtraOvertime, LeaveOutstanding, GrossSalary, SSNIT13, SSNIT5, TaxableIncome, IncomeTax, Absent, TotalDeductions, NetSalary;
private int DaysWorked, DaysAbsent;
private DateTime EmpDate, CurrentDate;
private void saveButton_Click(object sender, EventArgs e)
{
this.Validate();
this.salariesBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.salariesDataSet);
}
private void salariesBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
try
{
this.Validate();
this.salariesBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.salariesDataSet);
SalariesDataSet.SalariesDataTable deletedSalaries = (SalariesDataSet.SalariesDataTable)
SalariesDataSet.SalariesRow.GetChanges(DataRowState.Deleted);
SalariesDataSet.SalariesDataTable newSalaries = (SalariesDataSet.SalariesDataTable)
SalariesDataSet.SalariesRow.GetChanges(DataRowState.Added);
SalariesDataSet.SalariesDataTable modifiedSalaries = (SalariesDataSet.SalariesDataTable)
SalariesDataSet.SalariesRow.GetChanges(DataRowState.Modified);
{
if (deletedSalaries != null)
{
salariesTableAdapter.Update(deletedSalaries);
}
if (newSalaries != null)
{
salariesTableAdapter.Update(newSalaries);
}
if (modifiedSalaries != null)
{
salariesTableAdapter.Update(newSalaries);
}
salariesDataSet.AcceptChanges();
}
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
}