public static void CreateAdminInfo(AdminInfoDTO adminInfoDTO)
{
// ballpark instance of Player class in Retrosheet_Persist.Retrosheet
var adminInfo = convertToEntity(adminInfoDTO);
// entity data model
var dbCtx = new retrosheetDB();
dbCtx.Admin_Info.Add(adminInfo);
try
{
dbCtx.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
catch (Exception e)
{
string text;
text = e.Message;
}
}
private static void ReadWriteAdminInfoFile()
{
string[] columnValue;
string textLine = null;
using (StreamReader reader = new StreamReader(@"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016SLN\2016SLN_admininfo"))
{
while (!reader.EndOfStream)
{
try
{
textLine = reader.ReadLine();
}
catch (Exception e)
{
// Let the user know what went wrong.
Console.WriteLine("The " + @"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016SLN\2016SLN_admininfo" + " file could not be read:");
Console.WriteLine(e.Message);
Console.ReadLine();
}
columnValue = textLine.Split('|');
AdminInfoDTO adminInfoDTO = new AdminInfoDTO();
adminInfoDTO.RecordID = Guid.NewGuid();
adminInfoDTO.GameID = columnValue[0];
adminInfoDTO.AdminInfoType = columnValue[2];
adminInfoDTO.AdminInfoValue = columnValue[3];
AdminInfoPersist.CreateAdminInfo(adminInfoDTO);
Console.WriteLine(textLine);
}
}
}
private static Admin_Info convertToEntity(AdminInfoDTO adminInfoDTO)
{
var adminInfo = new Admin_Info();
adminInfo.record_id = adminInfoDTO.RecordID;
adminInfo.game_id = adminInfoDTO.GameID;
adminInfo.admin_info_type = adminInfoDTO.AdminInfoType;
adminInfo.admin_inf_value = adminInfoDTO.AdminInfoValue;
return(adminInfo);
}