public bool setSalaryHistory(SalaryHistory salaryHistory) { return account_DAL.setSalaryHistory(salaryHistory); }
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(); } }
public bool setSalaryHistory(SalaryHistory salaryHistory) { try { SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = new SqlCommand("SetSalaryHistory", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Year", SqlDbType.NVarChar, 50).Value = salaryHistory.year; cmd.Parameters.Add("@Month", SqlDbType.NVarChar, 50).Value = salaryHistory.month; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 100).Value = salaryHistory.UserName; cmd.Parameters.Add("@TotalAttendence", SqlDbType.NVarChar, 50).Value = salaryHistory.totalAttendence; cmd.Parameters.Add("@BasicSalary", SqlDbType.NVarChar, 50).Value = salaryHistory.basicSalary; cmd.Parameters.Add("@RecieveAdvance", SqlDbType.NVarChar, 50).Value = salaryHistory.recieveAdvance; //cmd.Parameters.Add("@ServicingAmount", SqlDbType.NVarChar, 50).Value = salaryHistory.servicingAmount; cmd.Parameters.Add("@ProductSellProfitAmount", SqlDbType.NVarChar, 50).Value = salaryHistory.prouctSellProfitAmount; //cmd.Parameters.Add("@ServicingBonus", SqlDbType.NVarChar, 50).Value = salaryHistory.servicingBonus; cmd.Parameters.Add("@FestivalBonus", SqlDbType.NVarChar, 50).Value = salaryHistory.festivalBonus; cmd.Parameters.Add("@SellBonus", SqlDbType.NVarChar, 50).Value = salaryHistory.sellBonus; cmd.Parameters.Add("@TotalSalary", SqlDbType.NVarChar, 50).Value = salaryHistory.totalsalary; cmd.Parameters.Add("@Date", SqlDbType.NVarChar, 50).Value = salaryHistory.date; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return true; } catch { return false; } }