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);
}