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);
}
