/// <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(); }