public bool Delete(Model.RegionModel obj) { bool flag = false; using (SqlConnection SqlConn = new SqlConnection(_ConnectString)) { SqlConn.Open(); SqlCommand Cmd = new SqlCommand(); Cmd.Connection = SqlConn; Cmd.CommandText = "delete from Region where RegionID=@RegionID"; Cmd.Parameters.Add("@RegionID", obj.RegionID); Cmd.ExecuteNonQuery(); } return(true); }
public bool Insert(Model.RegionModel obj) { bool flag = false; using (SqlConnection SqlConn = new SqlConnection(_ConnectString)) { SqlConn.Open(); SqlCommand Cmd = new SqlCommand(); Cmd.Connection = SqlConn; Cmd.CommandText = "insert into Region(RegionID,RegionDescription) values(@RegionID,@RegionDescription)"; Cmd.Parameters.Add("@RegionID", obj.RegionID); Cmd.Parameters.Add("@RegionDescription", obj.RegionDescription); Cmd.ExecuteNonQuery(); } return(true); }