/// <summary> /// Creates a new TOCTemplates record using async /// </summary> public static async Task<int> CreateAsync(TOCTemplatesDO DO) { SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); SqlParameter _Template = new SqlParameter("Template", SqlDbType.VarChar); _TOCID.Value = DO.TOCID; _Template.Value = DO.Template; SqlParameter[] _params = new SqlParameter[] { _TOCID, _Template }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[TOCTemplates_Insert]", _params, pid); }
/// <summary> /// Updates a TOCTemplates record and returns the number of records affected /// </summary> public static int Update(TOCTemplatesDO DO) { SqlParameter _TOCTemplatesID = new SqlParameter("TOCTemplatesID", SqlDbType.Int); SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); SqlParameter _Template = new SqlParameter("Template", SqlDbType.VarChar); _TOCTemplatesID.Value = DO.TOCTemplatesID; _TOCID.Value = DO.TOCID; _Template.Value = DO.Template; SqlParameter[] _params = new SqlParameter[] { _TOCTemplatesID, _TOCID, _Template }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[TOCTemplates_Update]", _params, pid); }
/// <summary> /// Selects TOCTemplates records by PK /// </summary> public static async Task<TOCTemplatesDO[]> GetByPKAsync(Int32 TOCTemplatesID) { SqlParameter _TOCTemplatesID = new SqlParameter("TOCTemplatesID", SqlDbType.Int); _TOCTemplatesID.Value = TOCTemplatesID; SqlParameter[] _params = new SqlParameter[] { _TOCTemplatesID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[TOCTemplates_GetByPK]", _params, pid); List<TOCTemplatesDO> objs = new List<TOCTemplatesDO>(); while(sr.Read()) { TOCTemplatesDO obj = new TOCTemplatesDO(); obj.TOCTemplatesID = sr.GetInt32(sr.GetOrdinal("TOCTemplatesID")); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); obj.Template = sr.GetString(sr.GetOrdinal("Template")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all TOCTemplates records /// </summary> public static async Task<TOCTemplatesDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[TOCTemplates_GetAll]", new SqlParameter[] { }, pid); List<TOCTemplatesDO> objs = new List<TOCTemplatesDO>(); while(sr.Read()){ TOCTemplatesDO obj = new TOCTemplatesDO(); obj.TOCTemplatesID = sr.GetInt32(sr.GetOrdinal("TOCTemplatesID")); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); obj.Template = sr.GetString(sr.GetOrdinal("Template")); objs.Add(obj); } return objs.ToArray(); }