public static int Edit(Moperson T) { try { int r = -1; using (SqlConnection cnn = new SqlConnection(Models.DataBase.Config.GetConnectionString())) { cnn.Open(); string query = "UPDATE Moperson SET address=@address,age=@age,date_of_birth=@date_of_birth,first_name=@first_name,last_name=@last_name WHERE Id=@Id"; SqlCommand cmd = new SqlCommand(query, cnn); cmd.Parameters.AddWithValue("Id", T.Id); cmd.Parameters.AddWithValue("address", T.address); cmd.Parameters.AddWithValue("age", T.age == null ? (object)DBNull.Value : T.age); cmd.Parameters.AddWithValue("date_of_birth", T.date_of_birth == null ? (object)DBNull.Value : T.date_of_birth); cmd.Parameters.AddWithValue("first_name", T.first_name); cmd.Parameters.AddWithValue("last_name", T.last_name); r = cmd.ExecuteNonQuery(); } return(r); } catch (Exception Ex) { throw Ex; } }
public static int Add(Moperson T) { try { int InsertedID = -1; using (SqlConnection cnn = new SqlConnection(Models.DataBase.Config.GetConnectionString())) { cnn.Open(); string query = "INSERT INTO Moperson(address,age,date_of_birth,first_name,last_name) VALUES (@address,@age,@date_of_birth,@first_name,@last_name)"; SqlCommand cmd = new SqlCommand(query, cnn); cmd.Parameters.AddWithValue("address", T.address); cmd.Parameters.AddWithValue("age", T.age == null ? (object)DBNull.Value : T.age); cmd.Parameters.AddWithValue("date_of_birth", T.date_of_birth == null ? (object)DBNull.Value : T.date_of_birth); cmd.Parameters.AddWithValue("first_name", T.first_name); cmd.Parameters.AddWithValue("last_name", T.last_name); InsertedID = cmd.ExecuteNonQuery(); } return(InsertedID); } catch (Exception Ex) { throw Ex; } }