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