public static async Task InsertDocTypesAsync()
{
await DocTypeTable.InsertDocType(CommandInsertModel.InsertDocType());
DocTypeContextList.Add(CommandModel.GetDocTypeContext());
return;
}
public static async Task InsertSectionAsync()
{
await SectionTable.InsertSection(CommandInsertModel.InsertSection());
SectionContextList.Add(CommandModel.GetSectionContext());
return;
}
/// <summary>
/// Takes in IList of Unit Diaries and pushes it into the Database.
/// </summary>
/// <param name="InsertStatement"></param>
/// <returns>Task Completed</returns>
public static async Task <string> InsertBulkDiaryInfoAsync(IList <UnitDiary> InsertStatement)
{
SQLiteConnection connection = await Database.Connect();
try
{
SQLiteCommand cmd = connection.CreateCommand();
SQLiteTransaction transaction = connection.BeginTransaction();
cmd.CommandText = CommandInsertModel.InsertBulkDiary();
cmd.Parameters.AddWithValue("@UDYear", "");
cmd.Parameters.AddWithValue("@UDNumber", "");
cmd.Parameters.AddWithValue("@UDDate", "");
cmd.Parameters.AddWithValue("@CertifierID", "");
cmd.Parameters.AddWithValue("@CertifierEdipi", "");
cmd.Parameters.AddWithValue("@LastName", "");
cmd.Parameters.AddWithValue("@CycleNumber", "");
cmd.Parameters.AddWithValue("@CycleDate", "");
cmd.Parameters.AddWithValue("@Accepted", "");
cmd.Parameters.AddWithValue("@Rejected", "");
cmd.Parameters.AddWithValue("@Total", "");
cmd.Parameters.AddWithValue("@Section", "");
cmd.Parameters.AddWithValue("@Uploaded", "");
cmd.Parameters.AddWithValue("@UploadedBy", "");
cmd.Parameters.AddWithValue("@UploadedOn", "");
cmd.Parameters.AddWithValue("@UploadLocation", "");
foreach (var diary in InsertStatement)
{
cmd.Parameters["@UDYear"].Value = diary.UDYear;
cmd.Parameters["@UDNumber"].Value = diary.UDNumber;
cmd.Parameters["@UDDate"].Value = diary.UDDate.ToShortDateString();
cmd.Parameters["@CertifierID"].Value = diary.CertifierID;
cmd.Parameters["@CertifierEdipi"].Value = diary.CertifierEdipi;
cmd.Parameters["@LastName"].Value = diary.LastName;
cmd.Parameters["@CycleNumber"].Value = diary.CycleNumber;
cmd.Parameters["@CycleDate"].Value = diary.CycleDate.ToShortDateString();
cmd.Parameters["@Accepted"].Value = diary.Accepted;
cmd.Parameters["@Rejected"].Value = diary.Rejected;
cmd.Parameters["@Total"].Value = diary.Total;
cmd.Parameters["@Section"].Value = " ";
cmd.Parameters["@Uploaded"].Value = "False";
cmd.Parameters["@UploadedBy"].Value = " ";
cmd.Parameters["@UploadedOn"].Value = "11/10/1775";
cmd.Parameters["@UploadLocation"].Value = " ";
cmd.ExecuteNonQuery();
}
transaction.Commit();
cmd.Dispose();
connection.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("An error occured during the Insert Statement: " + ex.Message.ToString(), "Insert Statement Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return("Failed");
}
return("Completed");
}
public static async Task InsertUserAsync()
{
await UserTable.UpdateUser(CommandInsertModel.InsertUser());
return;
}
public static async Task InsertDocumentAsync(string DateOfDoc, string MembersEdipi, string FilePath)
{
string fileName = CommandModel.GetDocTypeContext() + "." + MembersEdipi + "." + CommandModel.GetSectionContext() + "." + DateOfDoc + ".pdf";
Task <string> SaveFile = Task.Run(() => FileOperation.CopyFile(fileName, "Member Documents" + @"\" + MembersEdipi, FilePath));
string FileSaveLocation = await SaveFile;
Task InsertDocument = Task.Run(() => DocumentTable.InsertDocument(CommandInsertModel.InsertDocument(MembersEdipi, DateOfDoc, FileSaveLocation)));
await InsertDocument;
}
public static async Task InsertMarineInfoAsync(string MembersEdipi, string MembersLastName, string MembersFirstName, string MembersMI)
{
Task InsertMarineInfo = Task.Run(() => MarineTable.InsertMarine(CommandInsertModel.InsertMarine(MembersEdipi, MembersLastName, MembersFirstName, MembersMI)));
await InsertMarineInfo;
}
/// <summary>
/// Updates the Associated Diary and adds a Record to the Certified Package Table
/// </summary>
/// <param name="DiaryID"></param>
/// <param name="UDNumber"></param>
/// <param name="FilePath"></param>
/// <param name="MembersEdipi"></param>
/// <param name="MembersFirstName"></param>
/// <param name="MembersLastName"></param>
/// <param name="MembersMI"></param>
/// <returns></returns>
public static async Task UpdateCertifiedPackageAsync(int DiaryID, string UDNumber, string FilePath, int MembersEdipi, string MembersFirstName, string MembersLastName, string MembersMI)
{
string fileName = UDNumber + '.' + MembersEdipi + ".pdf";
Task <string> SaveFile = Task.Run(() => FileOperation.CopyFile(fileName, "Certified Package", FilePath));
string FileSaveLocation = await SaveFile;
Task UpdateDiaryTable = Task.Run(() => DiaryTable.UpdateUnitDiary(CommandUpdateModel.DiaryUpdate(FileSaveLocation, DiaryID)));
Task InsertCertifiedPackage = Task.Run(() => CertifiedPackageTable.Insert(CommandInsertModel.InsertCertifiedPackage(DiaryID, UDNumber, MembersEdipi, MembersLastName, MembersFirstName, MembersMI)));
await UpdateDiaryTable;
await InsertCertifiedPackage;
CertifiedPackageList.UpdateList(DiaryID, UserName, InsertDate, FileSaveLocation, MembersEdipi, MembersLastName, MembersFirstName, MembersMI);
return;
}
