/// <summary>
/// Deletes a PremineLandUseList record
/// </summary>
public static int Delete(PremineLandUseListDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PremineLandUse = new SqlParameter("PremineLandUse", SqlDbType.VarChar);
_PermitKey.Value = DO.PermitKey;
_PremineLandUse.Value = DO.PremineLandUse;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PremineLandUse
};
return DataCommon.ExecuteScalar("[dbo].[PremineLandUseList_Delete]", _params, "dbo");
}
/// <summary>
/// Creates a new PremineLandUseList record
/// </summary>
public static void Create(PremineLandUseListDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PremineLandUse = new SqlParameter("PremineLandUse", SqlDbType.VarChar);
SqlParameter _Acres = new SqlParameter("Acres", SqlDbType.Int);
_PermitKey.Value = DO.PermitKey;
_PremineLandUse.Value = DO.PremineLandUse;
_Acres.Value = DO.Acres;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PremineLandUse,
_Acres
};
DataCommon.ExecuteNonQuery("[dbo].[PremineLandUseList_Insert]", _params, "dbo");
}
/// <summary>
/// Gets all PremineLandUseList records
/// </summary>
public static PremineLandUseListDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PremineLandUseList_GetAll]", new SqlParameter[] { }, "dbo");
List<PremineLandUseListDO> objs = new List<PremineLandUseListDO>();
while(sr.Read()){
PremineLandUseListDO obj = new PremineLandUseListDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.PremineLandUse = sr.GetString(sr.GetOrdinal("PremineLandUse"));
obj.Acres = sr.GetInt32(sr.GetOrdinal("Acres"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Selects PremineLandUseList records by PK
/// </summary>
public static PremineLandUseListDO[] GetByPK(Int32 PermitKey,
String PremineLandUse)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PremineLandUse = new SqlParameter("PremineLandUse", SqlDbType.VarChar);
_PermitKey.Value = PermitKey;
_PremineLandUse.Value = PremineLandUse;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PremineLandUse
};
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PremineLandUseList_GetByPK]", _params, "dbo");
List<PremineLandUseListDO> objs = new List<PremineLandUseListDO>();
while(sr.Read())
{
PremineLandUseListDO obj = new PremineLandUseListDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.PremineLandUse = sr.GetString(sr.GetOrdinal("PremineLandUse"));
obj.Acres = sr.GetInt32(sr.GetOrdinal("Acres"));
objs.Add(obj);
}
return objs.ToArray();
}