Example #1
0
 public bool setSalaryHistory(SalaryHistory salaryHistory)
 {
     return account_DAL.setSalaryHistory(salaryHistory);
 }
Example #2
0
        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();
            }
        }
Example #3
0
        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;
            }
        }