/// <summary>
/// Creates a new Deficiency record
/// </summary>
public static int Create(DeficiencyDO DO)
{
SqlParameter _Section = new SqlParameter("Section", SqlDbType.VarChar);
SqlParameter _SubSection = new SqlParameter("SubSection", SqlDbType.VarChar);
SqlParameter _DeficiencyStatusID = new SqlParameter("DeficiencyStatusID", SqlDbType.VarChar);
SqlParameter _DeficiencyTypeID = new SqlParameter("DeficiencyTypeID", SqlDbType.VarChar);
SqlParameter _DeficiencyStateID = new SqlParameter("DeficiencyStateID", SqlDbType.VarChar);
SqlParameter _DeficiencyDate = new SqlParameter("DeficiencyDate", SqlDbType.DateTime);
SqlParameter _User = new SqlParameter("User", SqlDbType.VarChar);
SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar);
_Section.Value = DO.Section;
_SubSection.Value = DO.SubSection;
_DeficiencyStatusID.Value = DO.DeficiencyStatusID;
_DeficiencyTypeID.Value = DO.DeficiencyTypeID;
_DeficiencyStateID.Value = DO.DeficiencyStateID;
_DeficiencyDate.Value = DO.DeficiencyDate;
_User.Value = DO.User;
_Description.Value = DO.Description;
SqlParameter[] _params = new SqlParameter[] {
_Section,
_SubSection,
_DeficiencyStatusID,
_DeficiencyTypeID,
_DeficiencyStateID,
_DeficiencyDate,
_User,
_Description
};
return DataCommon.ExecuteScalar("[dbo].[Deficiency_Insert]", _params, "dbo");
}
/// <summary>
/// Deletes a Deficiency record
/// </summary>
public static int Delete(DeficiencyDO DO)
{
SqlParameter _DeficiencyID = new SqlParameter("DeficiencyID", SqlDbType.Int);
_DeficiencyID.Value = DO.DeficiencyID;
SqlParameter[] _params = new SqlParameter[] {
_DeficiencyID
};
return DataCommon.ExecuteScalar("[dbo].[Deficiency_Delete]", _params, "dbo");
}
/// <summary>
/// Gets all Deficiency records
/// </summary>
public static DeficiencyDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Deficiency_GetAll]", new SqlParameter[] { }, "dbo");
List<DeficiencyDO> objs = new List<DeficiencyDO>();
while(sr.Read()){
DeficiencyDO obj = new DeficiencyDO();
obj.DeficiencyID = sr.GetInt32(sr.GetOrdinal("DeficiencyID"));
obj.Section = sr.GetString(sr.GetOrdinal("Section"));
obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection"));
obj.DeficiencyStatusID = sr.GetString(sr.GetOrdinal("DeficiencyStatusID"));
obj.DeficiencyTypeID = sr.GetString(sr.GetOrdinal("DeficiencyTypeID"));
obj.DeficiencyStateID = sr.GetString(sr.GetOrdinal("DeficiencyStateID"));
obj.DeficiencyDate = sr.GetDateTime(sr.GetOrdinal("DeficiencyDate"));
obj.User = sr.GetString(sr.GetOrdinal("User"));
obj.Description = sr.GetString(sr.GetOrdinal("Description"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Selects Deficiency records by PK
/// </summary>
public static DeficiencyDO[] GetByPK(Int32 DeficiencyID)
{
SqlParameter _DeficiencyID = new SqlParameter("DeficiencyID", SqlDbType.Int);
_DeficiencyID.Value = DeficiencyID;
SqlParameter[] _params = new SqlParameter[] {
_DeficiencyID
};
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Deficiency_GetByPK]", _params, "dbo");
List<DeficiencyDO> objs = new List<DeficiencyDO>();
while(sr.Read())
{
DeficiencyDO obj = new DeficiencyDO();
obj.DeficiencyID = sr.GetInt32(sr.GetOrdinal("DeficiencyID"));
obj.Section = sr.GetString(sr.GetOrdinal("Section"));
obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection"));
obj.DeficiencyStatusID = sr.GetString(sr.GetOrdinal("DeficiencyStatusID"));
obj.DeficiencyTypeID = sr.GetString(sr.GetOrdinal("DeficiencyTypeID"));
obj.DeficiencyStateID = sr.GetString(sr.GetOrdinal("DeficiencyStateID"));
obj.DeficiencyDate = sr.GetDateTime(sr.GetOrdinal("DeficiencyDate"));
obj.User = sr.GetString(sr.GetOrdinal("User"));
obj.Description = sr.GetString(sr.GetOrdinal("Description"));
objs.Add(obj);
}
return objs.ToArray();
}
