/// <summary>
/// Updates a State record and returns the number of records affected
/// </summary>
public static int Update(StateDO DO)
{
SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar);
SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar);
_StateID.Value = DO.StateID;
_Description.Value = DO.Description;
_FIPSStateID.Value = DO.FIPSStateID;
SqlParameter[] _params = new SqlParameter[] {
_StateID,
_Description,
_FIPSStateID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return DataCommon.ExecuteScalar("[dbo].[State_Update]", _params, pid);
}
/// <summary>
/// Creates a new State record using async
/// </summary>
public static async Task CreateAsync(StateDO DO)
{
SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar);
SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar);
_StateID.Value = DO.StateID;
_Description.Value = DO.Description;
_FIPSStateID.Value = DO.FIPSStateID;
SqlParameter[] _params = new SqlParameter[] {
_StateID,
_Description,
_FIPSStateID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
await DataCommon.ExecuteNonQueryAsync("[dbo].[State_Insert]", _params, pid);
}
/// <summary>
/// Gets all State records
/// </summary>
public static async Task<StateDO[]> GetAllAsync()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[State_GetAll]", new SqlParameter[] { }, pid);
List<StateDO> objs = new List<StateDO>();
while(sr.Read()){
StateDO obj = new StateDO();
obj.StateID = sr.GetString(sr.GetOrdinal("StateID"));
obj.Description = sr.GetString(sr.GetOrdinal("Description"));
obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Selects State records by PK
/// </summary>
public static async Task<StateDO[]> GetByPKAsync(String StateID)
{
SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
_StateID.Value = StateID;
SqlParameter[] _params = new SqlParameter[] {
_StateID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[State_GetByPK]", _params, pid);
List<StateDO> objs = new List<StateDO>();
while(sr.Read())
{
StateDO obj = new StateDO();
obj.StateID = sr.GetString(sr.GetOrdinal("StateID"));
obj.Description = sr.GetString(sr.GetOrdinal("Description"));
obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a State record
/// </summary>
public static async Task<int> DeleteAsync(StateDO DO)
{
SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
_StateID.Value = DO.StateID;
SqlParameter[] _params = new SqlParameter[] {
_StateID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[State_Delete]", _params, pid);
}
