public bool Insert(pmmaDateBLL u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = @"INSERT INTO tbl_pmma_date (" + dateMonth + "," + dateYear + "," + dateStart + "," + dateEnd + "," + dateUpdatedDate + "," + dateUpdatedBy + ") VALUES (@month,@year," + "@date_start," + "@date_end," + "@updated_date," + "@updated_by)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@month", u.month); cmd.Parameters.AddWithValue("@year", u.year); cmd.Parameters.AddWithValue("@date_start", u.date_start); cmd.Parameters.AddWithValue("@date_end", u.date_end); cmd.Parameters.AddWithValue("@updated_date", u.updated_date); cmd.Parameters.AddWithValue("@updated_by", u.updated_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the rows' value = 0 if (rows > 0) { //query successful isSuccess = true; } else { //Query falled isSuccess = false; } } catch (Exception ex) { Module.Tool tool = new Module.Tool(); tool.saveToTextAndMessageToUser(ex); } finally { conn.Close(); } return(isSuccess); }
public bool Update(pmmaDateBLL u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = @"UPDATE tbl_pmma_date SET " + dateStart + "=@date_start," + dateEnd + "=@date_end," + dateUpdatedDate + "=@updated_date," + dateUpdatedBy + "=@updated_by" + " WHERE month=@month AND year=@year"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@month", u.month); cmd.Parameters.AddWithValue("@year", u.year); cmd.Parameters.AddWithValue("@date_start", u.date_start); cmd.Parameters.AddWithValue("@date_end", u.date_end); cmd.Parameters.AddWithValue("@updated_date", u.updated_date); cmd.Parameters.AddWithValue("@updated_by", u.updated_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the rows' value = 0 if (rows > 0) { //query successful isSuccess = true; } else { //Query falled isSuccess = false; } } catch (Exception ex) { Module.Tool tool = new Module.Tool(); tool.saveToText(ex); } finally { conn.Close(); } return(isSuccess); }