/// <summary>
/// Creates a new PermitTableFieldReference record using async
/// </summary>
public static async Task CreateAsync(PermitTableFieldReferenceDO DO)
{
SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
SqlParameter _Label = new SqlParameter("Label", SqlDbType.VarChar);
SqlParameter _FieldType = new SqlParameter("FieldType", SqlDbType.VarChar);
SqlParameter _FieldNAme = new SqlParameter("FieldNAme", SqlDbType.VarChar);
_TOCID.Value = DO.TOCID;
_Label.Value = DO.Label;
_FieldType.Value = DO.FieldType;
_FieldNAme.Value = DO.FieldNAme;
SqlParameter[] _params = new SqlParameter[] {
_TOCID,
_Label,
_FieldType,
_FieldNAme
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
await DataCommon.ExecuteNonQueryAsync("[dbo].[PermitTableFieldReference_Insert]", _params, pid);
}
/// <summary>
/// Updates a PermitTableFieldReference record and returns the number of records affected
/// </summary>
public static int Update(PermitTableFieldReferenceDO DO)
{
SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
SqlParameter _Label = new SqlParameter("Label", SqlDbType.VarChar);
SqlParameter _FieldType = new SqlParameter("FieldType", SqlDbType.VarChar);
SqlParameter _FieldNAme = new SqlParameter("FieldNAme", SqlDbType.VarChar);
_TOCID.Value = DO.TOCID;
_Label.Value = DO.Label;
_FieldType.Value = DO.FieldType;
_FieldNAme.Value = DO.FieldNAme;
SqlParameter[] _params = new SqlParameter[] {
_TOCID,
_Label,
_FieldType,
_FieldNAme
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return DataCommon.ExecuteScalar("[dbo].[PermitTableFieldReference_Update]", _params, pid);
}
/// <summary>
/// Gets all PermitTableFieldReference records
/// </summary>
public static async Task<PermitTableFieldReferenceDO[]> GetAllAsync()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[PermitTableFieldReference_GetAll]", new SqlParameter[] { }, pid);
List<PermitTableFieldReferenceDO> objs = new List<PermitTableFieldReferenceDO>();
while(sr.Read()){
PermitTableFieldReferenceDO obj = new PermitTableFieldReferenceDO();
obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID"));
obj.Label = sr.GetString(sr.GetOrdinal("Label"));
obj.FieldType = sr.GetString(sr.GetOrdinal("FieldType"));
obj.FieldNAme = sr.GetString(sr.GetOrdinal("FieldNAme"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Selects PermitTableFieldReference records by PK
/// </summary>
public static async Task<PermitTableFieldReferenceDO[]> GetByPKAsync(Int32 TOCID,
String Label)
{
SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
SqlParameter _Label = new SqlParameter("Label", SqlDbType.VarChar);
_TOCID.Value = TOCID;
_Label.Value = Label;
SqlParameter[] _params = new SqlParameter[] {
_TOCID,
_Label
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[PermitTableFieldReference_GetByPK]", _params, pid);
List<PermitTableFieldReferenceDO> objs = new List<PermitTableFieldReferenceDO>();
while(sr.Read())
{
PermitTableFieldReferenceDO obj = new PermitTableFieldReferenceDO();
obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID"));
obj.Label = sr.GetString(sr.GetOrdinal("Label"));
obj.FieldType = sr.GetString(sr.GetOrdinal("FieldType"));
obj.FieldNAme = sr.GetString(sr.GetOrdinal("FieldNAme"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a PermitTableFieldReference record
/// </summary>
public static async Task<int> DeleteAsync(PermitTableFieldReferenceDO DO)
{
SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
SqlParameter _Label = new SqlParameter("Label", SqlDbType.VarChar);
_TOCID.Value = DO.TOCID;
_Label.Value = DO.Label;
SqlParameter[] _params = new SqlParameter[] {
_TOCID,
_Label
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[PermitTableFieldReference_Delete]", _params, pid);
}