protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
return;
// Upload Attachment File
try
{
int iAuthorID = -1;
// Upload Author Information
DAL.ConferenceDataSet.AuthorsDataTable dataTableAuthors = new DAL.ConferenceDataSet.AuthorsDataTable();
DAL.ConferenceDataSet.AuthorsRow rowAuthors = dataTableAuthors.NewAuthorsRow();
if (!User.Identity.IsAuthenticated)
{
rowAuthors.FirstName = txtFirstName.Text;
rowAuthors.LastName = txtLastName.Text;
rowAuthors.Email = txtEmail.Text;
}
else
{
rowAuthors.FirstName = AccountProfile.CurrentUser.FirstName;
rowAuthors.LastName = AccountProfile.CurrentUser.LastName;
rowAuthors.Email = Membership.GetUser().Email;
}
dataTableAuthors.AddAuthorsRow(rowAuthors);
DAL.ConferenceDataSetTableAdapters.AuthorsTableAdapter tableAdapterAuthors = new DAL.ConferenceDataSetTableAdapters.AuthorsTableAdapter();
tableAdapterAuthors.Update(dataTableAuthors);
iAuthorID = rowAuthors.AuthorID;
DAL.ConferenceDataSet.DocumentsDataTable dataTableDocuments = new DAL.ConferenceDataSet.DocumentsDataTable();
DAL.ConferenceDataSet.DocumentsRow drDocument = dataTableDocuments.NewDocumentsRow();
drDocument.Title = txtTitle.Text;
drDocument.DocumentSummary = txtDocumentSummary.Text;
drDocument.SetStatusIDRefNull();
int iIndex = ddlLanguage.SelectedIndex;
if (iIndex > -1)
drDocument.LanguageLCID = System.Convert.ToInt32(ddlLanguage.Items[iIndex].Value);
else
drDocument.LanguageLCID = 1033; // en-us
if (User.Identity.IsAuthenticated)
drDocument.UserName = Membership.GetUser().UserName;
else
drDocument.UserName = null;
drDocument.ModifiedDate = DateTime.Now;
dataTableDocuments.AddDocumentsRow(drDocument);
DAL.ConferenceDataSetTableAdapters.DocumentsTableAdapter adptConference = new DAL.ConferenceDataSetTableAdapters.DocumentsTableAdapter();
adptConference.Update(dataTableDocuments);
int iDocumentID = drDocument.DocumentID;
int iFileID = DAL.DataAccessLayerManagement.UploadFile(fuAttachmentFile.PostedFile, iDocumentID);
// Upload Paper
DAL.ConferenceDataSet.PapersDataTable dataTablePapers = new DAL.ConferenceDataSet.PapersDataTable();
DAL.ConferenceDataSet.PapersRow rowPaper = dataTablePapers.NewPapersRow();
rowPaper.AuthorIDRef = iAuthorID;
rowPaper.DocumentIDRef = iDocumentID;
dataTablePapers.AddPapersRow(rowPaper);
DAL.ConferenceDataSetTableAdapters.PapersTableAdapter adapterPapers = new DAL.ConferenceDataSetTableAdapters.PapersTableAdapter();
adapterPapers.Update(dataTablePapers);
}
catch (ArgumentException exception)
{
ltrMessage.Visible = true;
ltrMessage.Text = exception.Message;
}
catch (System.Data.NoNullAllowedException exception)
{
ltrMessage.Visible = true;
ltrMessage.Text = exception.Message;
}
catch (System.Data.SqlClient.SqlException exception)
{
ltrMessage.Visible = true;
ltrMessage.Text = exception.Message;
}
}
protected void UpdateDocumentStatus(DAL.StatusEnum Status)
{
DAL.ConferenceDataSet.DocumentsDataTable dataTableDocuments = new DAL.ConferenceDataSet.DocumentsDataTable();
DAL.ConferenceDataSetTableAdapters.DocumentsTableAdapter adapterDocuments = new DAL.ConferenceDataSetTableAdapters.DocumentsTableAdapter();
dataTableDocuments = adapterDocuments.GetDataByDocumentID(iDocumentID);
for (int i = 0; i < dataTableDocuments.Rows.Count; i++)
{
DAL.ConferenceDataSet.DocumentsRow rowDocuments = (DAL.ConferenceDataSet.DocumentsRow)dataTableDocuments.Rows[i];
rowDocuments.StatusIDRef = (int)Status;
}
adapterDocuments.Update(dataTableDocuments);
Response.Redirect("~/PaperList.aspx");
}