public bool Delete(WorkingDays w)
{
bool x = false;
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ASUS\Documents\TimeTableManagement.mdf;Integrated Security=True;Connect Timeout=30");
try
{
string sql = "DELETE FROM WorkingDays WHERE Emp_ID = @id";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", w.Emp_ID);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
x = true;
}
else
{
x = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(x);
}
public bool Insert(WorkingDays w)
{
bool x = false;
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ASUS\Documents\TimeTableManagement.mdf;Integrated Security=True;Connect Timeout=30");
try
{
string sql = "INSERT INTO WorkingDays (Emp_ID,NoOfWork,WorkDays,WorkingPerDay) VALUES (@empid,@noofwork,@workdays,@workingperday)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@empid", w.Emp_ID);
cmd.Parameters.AddWithValue("@noofwork", w.NoOfWork);
cmd.Parameters.AddWithValue("@workdays", w.WorkDays);
cmd.Parameters.AddWithValue("@workingperday", w.WorkingPerDay);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
x = true;
}
else
{
x = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(x);
}