public void LoadAttachments(int requestID)
{
ProjectRequestEntities projectRequest = new ProjectRequestEntities();
List <Control> dynamicControls = new List <Control>();
List <string> allAttachments = new List <string>();
List <string> To = new List <string>();
List <string> Bcc = new List <string>();
List <string> Cc = new List <string>();
FieldInfo fieldInfo = new FieldInfo();
List <string> attatchments = new List <string>();
int listNum;
if (ViewState["Attatchment"] != null)
{
string fileName;
CreateDirectory(requestID);
List <string> Attachment = new List <string>();
Attachment = (List <string>)ViewState["Attatchment"];
foreach (var file in Attachment)
{
fileName = file;
Attachment attachment = new Attachment();
attachment.filePath = requestID.ToString() + "/" + fileName;
attachment.requestID = requestID;
projectRequest.AddToAttachments(attachment);
projectRequest.SaveChanges();
System.IO.File.Copy(filePath + fileName, filePath + requestID.ToString() + @"\" + fileName);
allAttachments.Add(filePath + requestID.ToString() + @"\" + fileName);
deleteAttachments.Add(filePath + fileName);
}
}
ViewState["allAttachments"] = allAttachments;
projectRequest.Dispose();
}
public void InsertData(Panel panel, int subRequestID)
{
if (panel.ID != "pnlStoryPic")
{
//the page is warpped in a pnael, cycle through it to get all the labels on the page
foreach (Control control in panel.Controls)
{
ProjectRequestEntities projectRequest = new ProjectRequestEntities();
Answer answer = new Answer();
answer.subrequestID = subRequestID;
//if the current selected control is a panel you need to cycle through this panel to get all the controls in side of it
if (control is Panel)
{
InsertData((Panel)control, subRequestID);
}
else if (control is TextBox || control is DropDownList || control is RadioButtonList || control is CheckBox)
{
//check to see what type of control is selected so you can get the appropiate text value
if (control is TextBox)
{
answer.AnswerText = ((TextBox)control).Text;
answer.QuestionID = control.ID;
}
else if (control is DropDownList)
{
if (((DropDownList)control).SelectedIndex > 0)
{
answer.AnswerText = ((DropDownList)control).SelectedItem.Text;
answer.AnswerValue = ((DropDownList)control).SelectedValue;
}
else
{
answer.AnswerText = "No Answer";
}
answer.QuestionID = control.ID;
}
else if (control is RadioButtonList)
{
if (((RadioButtonList)control).SelectedIndex > -1)
{
answer.AnswerText = ((RadioButtonList)control).SelectedItem.Text;
answer.AnswerValue = ((RadioButtonList)control).SelectedValue;
}
else
{
answer.AnswerText = "No Answer";
}
answer.QuestionID = control.ID;
}
else if (control is CheckBox)
{
if (((CheckBox)control).Checked)
{
answer.AnswerText = "Yes";
}
else
{
answer.AnswerText = "No";
}
answer.QuestionID = control.ID;
}
else
{
answer.AnswerText = "No Answer";
answer.QuestionID = control.ID;
}
projectRequest.AddToAnswers(answer);
projectRequest.SaveChanges();
projectRequest.Dispose();
}
}
}
}
public int DataInsert()
{
int requestID;
string emailBody;
List <string> To = new List <string>();
List <string> Bcc = new List <string>();
List <string> Cc = new List <string>();
FieldInfo fieldInfo = new FieldInfo();
List <string> attatchments = new List <string>();
using (ProjectRequestEntities projectRequest = new ProjectRequestEntities())
{
ProjectRequestEntities newCase = new ProjectRequestEntities();
Models.Request request = new Models.Request();
var DOAs = newCase.DOAs.Select(d => d.doaID).ToList();
var staffList = newCase.Staffs.Select(s => s.staffID).ToList();
var approverList = newCase.Approvers.Select(a => a.sullivanID).ToList();
request.name = tbFName.Text + " " + tbLName.Text;
request.location = ddlLocation.SelectedItem.Text;
request.contactInfo = tbContact.Text;
request.dateRequested = DateTime.Now;
request.completed = false;
request.subProjects = 1;
request.projectName = tbProjectName.Text;
request.categoryID = "multi";
request.department = ddlDepartment.SelectedItem.Text;
request.email = tbEmail.Text;
request.additionalInfo = tbAdditionalInfo.Text;
if (DOAs.Contains((string)ViewState["name"]) || staffList.Contains((string)ViewState["name"]) || approverList.Contains((string)ViewState["name"]))
{
request.status = "Approved";
}
else
{
request.status = "Pending";
var approvers = newCase.Approvers.Where(d => d.department == ddlDepartment.SelectedItem.Text);
string approverName = "";
foreach (var name in approvers)
{
approverName += name.name + ", ";
}
approverName = approverName.Trim();
approverName = approverName.TrimEnd(',');
request.doaName = approverName;
}
projectRequest.AddToRequests(request);
projectRequest.SaveChanges();
requestID = request.reuqestID;
ViewState["RequestID"] = requestID.ToString();
projectRequest.Dispose();
LoadAttachments(requestID);
//}
//catch (Exception ex)
//{
// To.Clear();
// Cc.Clear();
// To.Add("*****@*****.**");
// fieldInfo.SendEmail("PR Database Error for " + category, ex.ToString(), To, Bcc, Cc, "*****@*****.**", attatchments);
//}
}
return(requestID);
}