public String Insert(WorkingDay c) { String isSucces = "false"; SqlConnection conn = new SqlConnection(myconnstring); try { conn.Open(); string sql = "INSERT INTO WorkingDay(Days) VALUES(@Days)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Days", c.Days); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSucces = "true"; } else { isSucces = "false"; } } catch (Exception ex) { isSucces = ex.Message; } finally { conn.Close(); } return(isSucces); }
public String Update(WorkingDay c, int id) { String isSuccess = "false"; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "UPDATE WorkingDay SET Days=@Days WHERE EntryID=@ID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Days", c.Days); cmd.Parameters.AddWithValue("@ID", id); conn.Open(); cmd.ExecuteNonQuery(); isSuccess = "true"; } catch (Exception ex) { isSuccess = ex.Message; } finally { conn.Close(); } return(isSuccess); }
public bool Delete(WorkingDay c, int id) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "DELETE FROM WorkingDay WHERE EntryID=@EntryID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@EntryID", id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }