private void UpdateEmployeebutton_Click(object sender, EventArgs e)
{
if (employeeNametextBox.Text.Length != 0)
{
try
{
Employee aEmployee = new Employee();
aEmployee.EmployeeId = EmployyId;
aEmployee.EmployeeName = employeeNametextBox.Text.Replace("'", "''");
aEmployee.EmployeeAddress = employeeAddresstextBox.Text.Replace("'", "''");
aEmployee.EmployeePId = "123";
aEmployee.EmployeePhone = employeePhonetextBox.Text.Replace("'", "''");
aEmployee.EmployeePostion = positiontextBox.Text.Replace("'", "''");
// aEmployee.LastPayDate = DateTime.Now.Date;
EmployeeDAO aDao = new EmployeeDAO();
string sr = aDao.UpdateEmployee(aEmployee);
MessageBox.Show(sr);
if (sr == "Update Sucessfully")
{
this.Close();
}
}
catch (Exception)
{
MessageBox.Show("Please Check Your Input");
}
}
else MessageBox.Show("Please Check Your Input");
}
public EmployeeSalaryReport()
{
InitializeComponent();
yearcomboBox.SelectedIndex = 0;
monthcomboBox.SelectedIndex = 0;
EmployeeDAO aEmployeeDao=new EmployeeDAO();
List<Employee> aEmployees=new List<Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
employeecomboBox.DataSource = aEmployees;
employeecomboBox.DisplayMember = "EmployeeName";
employeecomboBox.ValueMember = "EmployeeId";
}
private void employeedataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
try
{
if (e.ColumnIndex == 9) //when paid
{
PaidSalaryForm aForm = new PaidSalaryForm();
aForm.EmployeeId = Convert.ToInt32("0" + employeedataGridView.Rows[e.RowIndex].Cells["EmployeeId"].Value);
aForm.employeeNamelabel.Text = (employeedataGridView.Rows[e.RowIndex].Cells["EmployeeName"].Value).ToString();
aForm.ShowDialog();
LoadDataGridView();
}
if (e.ColumnIndex == 10) //when update
{
UpdateEmployee aForm = new UpdateEmployee();
aForm.EmployyId = Convert.ToInt32("0" + employeedataGridView.Rows[e.RowIndex].Cells["EmployeeId"].Value);
aForm.employeeNametextBox.Text = (employeedataGridView.Rows[e.RowIndex].Cells["EmployeeName"].Value).ToString();
aForm.employeePhonetextBox.Text = (employeedataGridView.Rows[e.RowIndex].Cells["EmployeePhone"].Value).ToString();
aForm.employeeAddresstextBox.Text = (employeedataGridView.Rows[e.RowIndex].Cells["EmployeeAddress"].Value).ToString();
aForm.positiontextBox.Text = (employeedataGridView.Rows[e.RowIndex].Cells["EmployeePostion"].Value).ToString();
aForm.employeePidtextBox.Text = (employeedataGridView.Rows[e.RowIndex].Cells[4].Value).ToString();
aForm.ShowDialog();
LoadDataGridView();
}
if (e.ColumnIndex == 11) //when delete
{
DialogResult dialogResult = MessageBox.Show("Are you sure want to delete it?", "Alert!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
EmployeeDAO aEmployeeDao = new EmployeeDAO();
string sr = aEmployeeDao.EmployeeDeleted(Convert.ToInt32("0" + employeedataGridView.Rows[e.RowIndex].Cells[0].Value));
MessageBox.Show(sr);
LoadDataGridView();
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
}
catch (Exception)
{
}
}
private void paidbutton_Click(object sender, EventArgs e)
{
if(totalPayableSalarytextBox.Text.Length!=0)
{
try
{
Employee aEmployee=new Employee();
aEmployee.EmployeeId = EmployeeId;
aEmployee.LastPaidAmount = Convert.ToDouble(totalPayableSalarytextBox.Text);
EmployeeDAO aDao=new EmployeeDAO();
string sr = aDao.UpdateAmount(aEmployee);
if (sr == "Update Sucessfully")
{
SalaryTransaction aSalaryTransaction=new SalaryTransaction();
aSalaryTransaction.EmployeeId = EmployeeId;
aSalaryTransaction.WorkingDay = Convert.ToInt32("0" + workingdaystextBox.Text);
aSalaryTransaction.AttendingDay = Convert.ToInt32("0" + attendingtextBox.Text);
aSalaryTransaction.Salary = Convert.ToDouble("0" + salarystructuretextBox.Text);
aSalaryTransaction.DeductedSalary = Convert.ToDouble("0" + deductedsalarytextBox.Text);
aSalaryTransaction.PayableSalary = Convert.ToDouble("0" + payablesalarytextBox.Text);
aSalaryTransaction.ServiceCharge = Convert.ToDouble("0" + servicechargetextBox.Text);
aSalaryTransaction.FoodAndRoomAllowance = Convert.ToDouble("0" + foodAndRoomtextBox.Text);
aSalaryTransaction.TotalPayableSalary = Convert.ToDouble("0" +totalPayableSalarytextBox.Text);
aSalaryTransaction.Remarks = remarkstextBox.Text;
aDao.InsertPaidAmountReport(aSalaryTransaction,monthcomboBox.Text, yearcomboBox.Text);
this.Close();
}
}
catch (Exception)
{
MessageBox.Show("Please Check Your Input");
}
}
else MessageBox.Show("Please Check Your Input");
}
private void employeeNametextBox_TextChanged(object sender, EventArgs e)
{
if (employeeNametextBox.Text == "" || string.IsNullOrEmpty(employeeNametextBox.Text))
{
LoadDataGridView();
}
else
{
EmployeeDAO aEmployeeDao = new EmployeeDAO();
List<Employee> aEmployees = new List<Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
List<Employee> aaEmployees = (from myRow in aEmployees.AsEnumerable()
where myRow.EmployeeName.ToUpper().StartsWith(employeeNametextBox.Text.ToUpper())
select myRow).ToList();
// DataView view = results.AsDataView();
employeedataGridView.DataSource = aaEmployees;
}
}
private void LoadDataGridView()
{
EmployeeDAO aEmployeeDao=new EmployeeDAO();
List<Employee> aEmployees=new List<Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
employeedataGridView.DataSource = aEmployees;
}
private void showreportButton_Click(object sender, EventArgs e)
{
DateTime fromDate = fromdateTimePicker.Value;
fromDate = fromDate.Date;
DateTime toDate = todateTimePicker.Value;
toDate = toDate.Date;
toDate = toDate.AddDays(1);
toDate = toDate.AddSeconds(-1);
List<Transaction1> otherTransactions = new List<Transaction1>();
List<Transaction1> aTransactions = new List<Transaction1>();
List<Transaction1> employeeTransactions = new List<Transaction1>();
StoreDAO aStoreDao = new StoreDAO();
EmployeeDAO aEmployeeDao=new EmployeeDAO();
otherTransactions = aStoreDao.GetOtherTransactionBydateForProfit(fromDate, toDate);
aTransactions = aStoreDao.GetTransactionBydateForProfit(fromDate, toDate);
employeeTransactions = aEmployeeDao.EmployeeTransactionReportBydate(fromDate, toDate);
Int64 startDate = new DateTime(fromdateTimePicker.Value.Year, fromdateTimePicker.Value.Month, fromdateTimePicker.Value.Day, 0, 0, 0).Ticks;
DateTime dtTemp = todateTimePicker.Value.AddDays(1);
Int64 endDate = new DateTime(dtTemp.Year, dtTemp.Month, dtTemp.Day, 0, 0, 0).Ticks;
List<Transaction1> saleTransactions = new List<Transaction1>();
saleTransactions = aStoreDao.showAllData(startDate, endDate);
toDate = todateTimePicker.Value;
toDate = toDate.Date;
List<ProfitLoss> aProfitLosses=new List<ProfitLoss>();
while(fromDate<=toDate)
{
ProfitLoss aProfitLoss=new ProfitLoss();
aProfitLoss.Date = fromDate;
aProfitLoss.AccsCost = AmountCalculate(otherTransactions, fromDate);
aProfitLoss.RMCost = AmountCalculate(aTransactions, fromDate);
aProfitLoss.SalaryCost = AmountCalculate(employeeTransactions, fromDate);
aProfitLoss.SaleAmount = AmountCalculate(saleTransactions, fromDate);
double amount1 = (aProfitLoss.AccsCost + aProfitLoss.RMCost + aProfitLoss.SalaryCost);
if (aProfitLoss.SaleAmount - amount1 < 0)
{
aProfitLoss.Loss = aProfitLoss.SaleAmount - amount1;
}
else aProfitLoss.Profit = aProfitLoss.SaleAmount - amount1;
aProfitLosses.Add(aProfitLoss);
fromDate = fromDate.AddDays(1);
}
profitlossdataGridView.DataSource = aProfitLosses;
}