/// <summary>
/// Updates a OtherPermitType record and returns the number of records affected
/// </summary>
public static int Update(OtherPermitTypeDO DO)
{
SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar);
_OtherPermitTypeID.Value = DO.OtherPermitTypeID;
SqlParameter[] _params = new SqlParameter[] {
_OtherPermitTypeID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return DataCommon.ExecuteScalar("[dbo].[OtherPermitType_Update]", _params, pid);
}
/// <summary>
/// Creates a new OtherPermitType record using async
/// </summary>
public static async Task CreateAsync(OtherPermitTypeDO DO)
{
SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar);
_OtherPermitTypeID.Value = DO.OtherPermitTypeID;
SqlParameter[] _params = new SqlParameter[] {
_OtherPermitTypeID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
await DataCommon.ExecuteNonQueryAsync("[dbo].[OtherPermitType_Insert]", _params, pid);
}
/// <summary>
/// Selects OtherPermitType records by PK
/// </summary>
public static async Task<OtherPermitTypeDO[]> GetByPKAsync(String OtherPermitTypeID)
{
SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar);
_OtherPermitTypeID.Value = OtherPermitTypeID;
SqlParameter[] _params = new SqlParameter[] {
_OtherPermitTypeID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[OtherPermitType_GetByPK]", _params, pid);
List<OtherPermitTypeDO> objs = new List<OtherPermitTypeDO>();
while(sr.Read())
{
OtherPermitTypeDO obj = new OtherPermitTypeDO();
obj.OtherPermitTypeID = sr.GetString(sr.GetOrdinal("OtherPermitTypeID"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Gets all OtherPermitType records
/// </summary>
public static async Task<OtherPermitTypeDO[]> GetAllAsync()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[OtherPermitType_GetAll]", new SqlParameter[] { }, pid);
List<OtherPermitTypeDO> objs = new List<OtherPermitTypeDO>();
while(sr.Read()){
OtherPermitTypeDO obj = new OtherPermitTypeDO();
obj.OtherPermitTypeID = sr.GetString(sr.GetOrdinal("OtherPermitTypeID"));
objs.Add(obj);
}
return objs.ToArray();
}