public C_SubCompany GetCompany(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
C_SubCompany entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_SubCompany_Repository_GetSubCompany, parms)) {
if (rdr.Read())
{
entity = new C_SubCompany();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["linkMan"]);
entity.Phone = SqlTypeConverter.DBNullStringHandler(rdr["Phone"]);
entity.Fax = SqlTypeConverter.DBNullStringHandler(rdr["Fax"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.Level = SqlTypeConverter.DBNullStringHandler(rdr["Level"]);
entity.PostalCode = SqlTypeConverter.DBNullStringHandler(rdr["PostalCode"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public List <C_SubCompany> GetCompanies()
{
var entities = new List <C_SubCompany>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_SubCompany_Repository_GetSubCompanies, null)) {
while (rdr.Read())
{
var entity = new C_SubCompany();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["linkMan"]);
entity.Phone = SqlTypeConverter.DBNullStringHandler(rdr["Phone"]);
entity.Fax = SqlTypeConverter.DBNullStringHandler(rdr["Fax"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.Level = SqlTypeConverter.DBNullStringHandler(rdr["Level"]);
entity.PostalCode = SqlTypeConverter.DBNullStringHandler(rdr["PostalCode"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
