public ActionResult Addsalary(int?id, List_salary k)
{
SqlConnection con = conD.getConnection();
if (con.State == System.Data.ConnectionState.Open)
{
SqlDataAdapter sda1 = new SqlDataAdapter("Select * From Salary Where StaffId='" + id + "'", con);
DataTable TT = new DataTable();
sda1.Fill(TT);
foreach (DataRow dr in TT.Rows) // dt is a DataTable
{
k.list.Add(new Salary {
med_id = Convert.ToInt32(dr["StaffId"]), SalaryAmount = Convert.ToInt32(dr["SalaryAmount"]), bonus = Convert.ToInt32(dr["Bonus"]), Month = Convert.ToDateTime(dr["Month"])
});
}
foreach (DataRow dr in TT.Rows) // dt is a DataTable
{
if (Convert.ToDateTime(dr["Month"]).Year == k.s.Month.Year && Convert.ToDateTime(dr["Month"]).Month == k.s.Month.Month)
{
ViewBag.Error = "->>The salary of this month already exists ";
return(View("Addsalary", k));
}
}
string q = "Insert INTO [Salary] VALUES('" + Convert.ToInt32(id) + "','" + Convert.ToInt32(k.s.SalaryAmount) + "','" + Convert.ToInt32(k.s.bonus) + "','" + Convert.ToDateTime(k.s.Month) + "')";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Addsalary"));
}
return(View());
}
public ActionResult Edit_salary(int?id)
{
List_salary f = new List_salary();
Salary ss = new Salary();
SqlConnection con = conD.getConnection();
if (con.State == System.Data.ConnectionState.Open)
{
SqlDataAdapter sda1 = new SqlDataAdapter("Select * From Salary where Salary.StaffId= '" + id + "' ", con);
DataTable TT = new DataTable();
sda1.Fill(TT);
foreach (DataRow dr in TT.Rows) // dt is a DataTable
{
f.list.Add(new Salary {
med_id = Convert.ToInt32(dr["StaffId"]), SalaryAmount = Convert.ToInt32(dr["SalaryAmount"]), bonus = Convert.ToInt32(dr["Bonus"]), Month = Convert.ToDateTime(dr["Month"])
});
if (id == Convert.ToInt32(dr["StaffId"]))
{
ss.med_id = Convert.ToInt32(dr["StaffId"]);
ss.SalaryAmount = Convert.ToInt32(dr["SalaryAmount"]);
ss.bonus = Convert.ToInt32(dr["Bonus"]);
ss.Month = Convert.ToDateTime(dr["Month"]);
}
}
f.s = ss;
}
return(View("Addsalary", f));
}
public ActionResult Delete_salary(int?id)
{
List_salary f = new List_salary();
SqlConnection con = conD.getConnection();
if (con.State == System.Data.ConnectionState.Open)
{
string q = "Delete From Salary where Salary.StaffId='" + id + "'";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Addstaff", new { id = id }));
}
public ActionResult Edit_salary(int?id, List_salary ss)
{
SqlConnection con = conD.getConnection();
if (con.State == System.Data.ConnectionState.Open)
{
string q = "UPDATE [Salary] SET Salary.SalaryAmount='" + Convert.ToInt32(ss.s.SalaryAmount) + "',Salary.Bonus='" + Convert.ToInt32(ss.s.bonus) + "',Salary.Month='" + Convert.ToDateTime(ss.s.Month) + "' where Salary.StaffId='" + Convert.ToInt32(id) + "'";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Addsalary", new { id = id }));
}
return(RedirectToAction("Addsalary", id));
}
