public Model.CompanyType GetCompanyType(string id)
{
SqlConnection conn = new SqlConnection(DBConnectionString);
Model.CompanyType _CompanyType = new Model.CompanyType();
try {
conn.Open();
SqlCommand cmd = new SqlCommand("GetCompanyType", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter();
cmd.Parameters.Add(new SqlParameter("@ID", id));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
_CompanyType = new Model.CompanyType(int.Parse(reader["ID"].ToString()), reader["Name"].ToString());
}
reader.Close();
}
catch (SqlException e) {
System.Windows.MessageBox.Show(e.Message);
}
finally {
conn.Close();
conn.Dispose();
}
return(_CompanyType);
}
public void Remove(Model.CompanyType entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
Remove(entity.CompanyTypeId);
}
public void Update(Model.CompanyType entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
string update = string.Format(@"update CompanyType set CompanyTypeName= @CompanyTypeName,Description= @Description where CompanyTypeId = @CompanyTypeId");
Connection.Execute(update, entity, transaction: Transaction);
}
public void Add(Model.CompanyType entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
string insert = string.Format(@"insert into CompanyType(CompanyTypeName,Description) values (@CompanyTypeName,@Description)");
Connection.Execute(insert, entity, Transaction);
}