[C#] Mssql Select

[C#] Mssql Select

 

 

public async Task<List<AdvertiserModel>> SelectContents(int id)
{
    var datas = new List<AdvertiserModel>();
    try
    {
        using (SqlConnection con = new SqlConnection(Startup.DBConnectionString))
        {
            //계정정보를 가져온다
            SqlCommand cmd = new SqlCommand("SELECT_AdvertiserInfo", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(DBCommon.MakeParam("@ID", id));
            con.Open();
            SqlDataReader rdr = await cmd.ExecuteReaderAsync();
            while (rdr.Read())
            {
                var data = new AdvertiserModel()
                {
                    ID = DBCommon.GetInt(rdr["ID"]),
                    CorporateRegistrationNumber = DBCommon.GetString(rdr["CorporateRegistrationNumber"]),
                    Name = DBCommon.GetString(rdr["Name"]),
                    ManagerName = DBCommon.GetString(rdr["ManagerName"]),
                    ManagerPhone = DBCommon.GetString(rdr["ManagerPhone"]),
                    RegDate = DBCommon.GetDateTime(rdr["RegDate"]),
                };
                data.RegDateString = data.RegDate == DateTime.MinValue ? string.Empty : data.RegDate.ToString("yyyy-MM-dd HH:mm:ss");
                datas.Add(data);
            }
 
            rdr.Close();
        }
    }
    catch (Exception e)
    {
        Debug.WriteLine(e.Message);
    }
    return datas;
}