private void giveSalary_button_Click(object sender, EventArgs e)
{
try
{
if (serachMembertextBox.Text != "" && signUpFirstNamemetroTextBox.Text != "")
{
if (year_comboBox.Text != "" && month_comboBox.Text != "")
{
if (MessageBox.Show("Are you sure?", "Give Member Salary", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
SalaryHistory salaryHistory = new SalaryHistory();
salaryHistory.UserName = serachMembertextBox.Text;
salaryHistory.year = year_comboBox.Text;
salaryHistory.month = month_comboBox.Text;
salaryHistory.recieveAdvance = recievedadvance_textBox.Text;
salaryHistory.basicSalary = basicSalary_textBox.Text;
salaryHistory.totalAttendence = totalAttendence_textBox.Text;
//salaryHistory.servicingAmount = totalservicingAmount_textBox.Text;
salaryHistory.prouctSellProfitAmount = productSell_textBox.Text;
salaryHistory.festivalBonus = festivalBonus_comboBox.Text;
//salaryHistory.servicingBonus = servicingBonus_comboBox.Text;
salaryHistory.sellBonus = sell_comboBox.Text;
salaryHistory.totalsalary = totalTobePaid_textBox.Text;
try
{
totalDays = DateTime.DaysInMonth(Convert.ToInt32(year_comboBox.Text), Convert.ToInt32(month_comboBox));
}
catch
{
}
salaryHistory.date = year_comboBox.Text +"/"+ month+"/"+ totalDays.ToString();
// MessageBox.Show(salaryHistory.year+" "+salaryHistory.month+" "+salaryHistory.UserName+" "+salaryHistory.totalAttendence+ " "+salaryHistory.basicSalary+" "+salaryHistory.recieveAdvance+" "+salaryHistory.servicingAmount+" "+salaryHistory.prouctSellProfitAmount+" "+salaryHistory.servicingBonus+" "+salaryHistory.festivalBonus+" "+salaryHistory.sellBonus+" "+salaryHistory.totalsalary+" "+salaryHistory.date);
if(account_Bo.setSalaryHistory(salaryHistory))
{
//string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\DB\Database.mdf;Integrated Security=True";
//SqlConnection conn = new SqlConnection(connString);
//SqlCommand cmd = new SqlCommand("Insert into SalaryHistory values('"+year_comboBox.Text+"','"+month_comboBox.Text+"','"+serachMembertextBox.Text+"','"+totalAttendence_textBox.Text+"','"+basicSalary_textBox.Text+"','"+recievedadvance_textBox.Text+"','"+ totalservicingAmount_textBox.Text+"','"+productSell_textBox.Text+"','"+servicingBonus_comboBox.Text+"','"+festivalBonus_comboBox.Text+"','"+sell_comboBox.Text+"','"+totalTobePaid_textBox.Text+"','"+date+"')", conn);
//conn.Open();
//cmd.ExecuteNonQuery();
//conn.Close();
MessageBox.Show("Salary paid successfully done");
Expenditure expenditure = new Expenditure();
expenditure.date = dateTimePicker3.Text;
expenditure.amount = totalTobePaid_textBox.Text;
expenditure.description = "MemberSalary";
account_Bo.setExpenditure(expenditure);
month_comboBox.ResetText();
year_comboBox.ResetText();
basicSalary_textBox.Clear();
totalAttendence_textBox.Clear();
recievedadvance_textBox.Clear();
totalTobePaid_textBox.Clear();
//servicingBonus_comboBox.ResetText();
festivalBonus_comboBox.ResetText();
// totalservicingAmount_textBox.Clear();
sell_comboBox.ResetText();
productSell_textBox.Clear();
}
else
{
MessageBox.Show("Already paid");
month_comboBox.ResetText();
year_comboBox.ResetText();
basicSalary_textBox.Clear();
totalAttendence_textBox.Clear();
recievedadvance_textBox.Clear();
totalTobePaid_textBox.Clear();
//servicingBonus_comboBox.ResetText();
festivalBonus_comboBox.ResetText();
//totalservicingAmount_textBox.Clear();
sell_comboBox.ResetText();
productSell_textBox.Clear();
}
}
}
else
{
MessageBox.Show("Please enter the information fully");
}
}
else
{
MessageBox.Show("Please select a member first");
}
}
catch
{
MessageBox.Show("Already paid");
month_comboBox.ResetText();
year_comboBox.ResetText();
basicSalary_textBox.Clear();
totalAttendence_textBox.Clear();
recievedadvance_textBox.Clear();
totalTobePaid_textBox.Clear();
//servicingBonus_comboBox.ResetText();
festivalBonus_comboBox.ResetText();
//totalservicingAmount_textBox.Clear();
sell_comboBox.ResetText();
productSell_textBox.Clear();
}
}
private void save_btn_Click(object sender, EventArgs e)
{
try
{
if (expenditureAmount_Txtbox.Text != "" && expenditureDescription_Txtbox.Text != "")
{
Expenditure expenditure = new Expenditure();
expenditure.date = expendituredateTimePicker.Text;
expenditure.amount = expenditureAmount_Txtbox.Text;
expenditure.description = expenditureDescription_Txtbox.Text;
if (MessageBox.Show("Are you sure?", "Add Income", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
if (account_Bo.setHardwareIncome(expenditure))
{
MessageBox.Show("Servicing income entry succefully done");
expendituredateTimePicker.ResetText();
expenditureAmount_Txtbox.Clear();
expenditureDescription_Txtbox.Clear();
}
}
}
else
{
MessageBox.Show("Enter the information fully");
}
}
catch
{
}
}
public bool setHardwareIncome(Expenditure expenditure)
{
return account_DAL.setHardwareIncome(expenditure);
}
//Expenditure
public bool setExpenditure(Expenditure expenditure)
{
return account_DAL.setExpenditure(expenditure);
}
//expenditure
public bool setExpenditure(Expenditure expenditure)
{
try
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SetExpenditure", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Date", SqlDbType.NVarChar, 10).Value = expenditure.date;
cmd.Parameters.Add("@Amount", SqlDbType.NVarChar, 30).Value = expenditure.amount;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = expenditure.description;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch
{
return false;
}
}