public static List <Sitelet> GetSiteletsByToken(string token)
{
SqlConnection conn = null;
SqlCommand command = null;
SqlDataReader reader = null;
List <string> clients = new List <string>();
string result = string.Empty;
List <Sitelet> Sitelets = new List <Sitelet>();
try
{
// create and open a connection object
using (conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MLBStyleGuideConnectionString1"].ConnectionString))
{
conn.Open();
using (command = new SqlCommand("[mlbstyleguide].[uspGetSiteletsByToken]", conn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@token", SqlDbType.UniqueIdentifier).Value = new Guid(token);
reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
var sitelet = new Sitelet();
sitelet.id = Convert.ToInt32(reader[0].ToString());
sitelet.description = reader[1].ToString();
Sitelets.Add(sitelet);
}
}
}
}
catch (Exception ex)
{
ErrorEmailer.SendEmail(ex);
}
finally
{
if (reader != null)
{
reader.Close();
reader.Dispose();
}
if (command != null)
{
command.Dispose();
}
if (conn != null)
{
conn.Close();
}
}
//return clients;
return(Sitelets);
}
public static void SaveDownload(string token, int siteletID, string year, string file, string dateDownloaded)
{
SqlConnection conn = null;
SqlCommand command = null;
try
{
// create and open a connection object
using (conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MLBStyleGuideConnectionString1"].ConnectionString))
{
conn.Open();
using (command = new SqlCommand("[mlbstyleguide].[uspSaveDownload]", conn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Token", SqlDbType.UniqueIdentifier).Value = new Guid(token);
command.Parameters.AddWithValue("@Section", GetSectionNameBySiteletID(siteletID));
command.Parameters.AddWithValue("@Year", year);
command.Parameters.AddWithValue("@File", file);
command.Parameters.AddWithValue("@DateDownloaded", Convert.ToDateTime(dateDownloaded));
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
ErrorEmailer.SendEmail(ex);
throw ex;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (conn != null)
{
conn.Close();
}
}
//return clients;
}