public string findContactEmail(string incString, string tagToBeReplaced, string contactTypeToMatch, CookDBDataContext db, string filter)
{
try
{
if (db.ProjectContacts.Count(d => d.project_id.Equals(Convert.ToInt32(filter)) && d.type.Equals(contactTypeToMatch)) > 0)
{
if (db.ProjectContacts.Count(d => d.project_id.Equals(Convert.ToInt32(filter)) && d.type.Equals(contactTypeToMatch)) > 1)
{
var multipleContacts = db.ProjectContacts.Where(e => e.project_id.Equals(Convert.ToInt32(filter)) && e.type.Equals(contactTypeToMatch));
var multipleContactsList = multipleContacts.ToList();
string allNames = "";
foreach (ProjectContact currentContact in multipleContactsList)
{
allNames += db.Contacts.Single(e => e.contact_id.Equals(currentContact.contact_id)).email1 + "; ";
}
allNames = allNames.Substring(0, allNames.Length - 2);
incString = incString.Replace(tagToBeReplaced, allNames);
}
else
{
ProjectContact currentContacts = db.ProjectContacts.First(d => d.project_id.Equals(Convert.ToInt32(filter)) && d.type.Equals(contactTypeToMatch));
incString = incString.Replace(tagToBeReplaced, db.Contacts.Single(e => e.contact_id.Equals(currentContacts.contact_id)).email1);
}
}
else
{
incString = incString.Replace(tagToBeReplaced, "{" + contactTypeToMatch + " Not Found}");
}
}
catch (Exception)
{
incString = incString.Replace(tagToBeReplaced, "{" + contactTypeToMatch + " Caused an Error when trying to reference. Contact Cookbook Admin.}");
}
return(incString);
}
public string findContact(string incString, string tagToBeReplaced, string contactTypeToMatch, CookDBDataContext db, string filter)
{
if (db.ProjectContacts.Count(d => d.project_id.Equals(Convert.ToInt32(filter)) && d.type.Equals(contactTypeToMatch)) > 0)
{
ProjectContact currentContacts = db.ProjectContacts.First(d => d.project_id.Equals(Convert.ToInt32(filter)) && d.type.Equals(contactTypeToMatch));
incString = incString.Replace(tagToBeReplaced, db.Contacts.Single(e => e.contact_id.Equals(currentContacts.contact_id)).name);
}
else
{
incString = incString.Replace(tagToBeReplaced, "{" + contactTypeToMatch + " Not Found}");
}
return(incString);
}
private void detach_ProjectContacts(ProjectContact entity)
{
this.SendPropertyChanging();
entity.ProjectInformation = null;
}
private void attach_ProjectContacts(ProjectContact entity)
{
this.SendPropertyChanging();
entity.Contact = this;
}
partial void DeleteProjectContact(ProjectContact instance);
partial void UpdateProjectContact(ProjectContact instance);
partial void InsertProjectContact(ProjectContact instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
System.IO.StreamReader reader = new System.IO.StreamReader(context.Request.InputStream, context.Request.ContentEncoding);
var jsonSerializer = new JsonSerializer();
List <String> failedProjects = new List <string>();
List <String> succeededProjects = new List <string>();
List <String> lockedProjects = new List <string>();
string username = context.Request.Params.Get("user_name");
switch (context.Request.RequestType)
{
case "PUT":
{
return(new PagedData("fake sync complete! records should no longer be dirty you cheating bastard", true));
}
case "POST":
{
String type = "";
JArray blob = (JArray)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd())));
foreach (JObject currentRecord in blob)
{
var currentProject = db.ProjectInformations.Single(a => a.project_id.Equals((Int32)currentRecord["project_id"]));
if ((currentProject.locked != true) || (currentProject.locked == true && (DateTime.Now - DateTime.Parse(currentProject.last_time)).TotalSeconds > 75))
{
//expedite
type = "Expedite";
if (currentRecord["exp"] != null)
{
try
{
if ((String)currentRecord["exp"] == "True")
{
if (!(currentProject.expedite == true))
{
currentProject.expedite = true;
}
}
else if ((String)currentRecord["exp"] == "False")
{
if (!(currentProject.expedite == false))
{
currentProject.expedite = false;
}
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//project name
type = "Project Name";
if (currentRecord["project_name"] != null)
{
try
{
string temp = (String)currentRecord["project_name"];
if (temp.ToLower().Trim() != currentProject.project_name.ToLower().Trim())
{
currentProject.project_name = (String)currentRecord["project_name"];
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//status
type = "Project Status";
if (currentRecord["project_status"] != null)
{
try
{
string temp = (String)currentRecord["project_status"];
if (db.StatusTypes.Count(a => a.type.Equals((String)currentRecord["project_status"])) > 0)
{
ProjectStatus status = new ProjectStatus();
status.project_id = currentProject.project_id;
status.date = DateTime.Now.ToString("s");
status.status_type_id = db.StatusTypes.Single(a => a.type.Equals((String)currentRecord["project_status"])).status_type_id;
db.ProjectStatus.InsertOnSubmit(status);
db.SubmitChanges();
//update project histories
ProjectHistory history = new ProjectHistory();
history.project_id = currentProject.project_id;
history.user_name = username;
history.date = DateTime.Now.ToString("s");
history.description = "Project status changed to \"" + db.StatusTypes.Single(a => a.type.Equals((String)currentRecord["project_status"])).type + "\"";
history.status_id = status.project_status_id;
db.ProjectHistories.InsertOnSubmit(history);
db.SubmitChanges();
//update new current_project_status on pi table
db.ProjectInformations.Single(a => a.project_id.Equals(currentProject.project_id)).current_project_status = (String)currentRecord["project_status"];
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
else
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//business unit
type = "Business Unit";
if (currentRecord["business_unit"] != null)
{
try
{
string temp = (String)currentRecord["business_unit"];
if (db.BusinessUnits.Count(a => a.name.Equals(temp)) > 0)
{
currentProject.primary_business_unit = temp;
}
else
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//TC
type = "TC";
if (currentRecord["tc"] != null)
{
try
{
string[] names = ((String)currentRecord["tc"]).Split(',');
IQueryable <ProjectContact> q = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC"));
foreach (String currName in names)
{
if (db.Contacts.Count(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())) > 0)
{
int contact_id = db.Contacts.First(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())).contact_id;
ProjectContact contact = new ProjectContact();
contact.Contact = db.Contacts.Single(a => a.contact_id.Equals(contact_id));
contact.project_id = currentProject.project_id;
contact.type = "USAN TC";
db.ProjectContacts.InsertOnSubmit(contact);
}
}
if (db.ProjectContacts.Count(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC")) > 0)
{
var oldRecsToDelete = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC"));
db.ProjectContacts.DeleteAllOnSubmit(oldRecsToDelete);
}
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception e)
{
failedProjects.Add(currentProject.project_number + "'s " + type + e.ToString());
continue;
}
}
//PM
type = "PM";
if (currentRecord["pm"] != null)
{
try
{
string[] names = ((String)currentRecord["pm"]).Split(',');
IQueryable <ProjectContact> q = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM"));
foreach (String currName in names)
{
if (db.Contacts.Count(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())) > 0)
{
int contact_id = db.Contacts.First(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())).contact_id;
ProjectContact contact = new ProjectContact();
contact.Contact = db.Contacts.Single(a => a.contact_id.Equals(contact_id));
contact.project_id = currentProject.project_id;
contact.type = "USAN Dev PM";
db.ProjectContacts.InsertOnSubmit(contact);
}
}
if (db.ProjectContacts.Count(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM")) > 0)
{
var oldRecsToDelete = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM"));
db.ProjectContacts.DeleteAllOnSubmit(oldRecsToDelete);
}
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception e)
{
failedProjects.Add(currentProject.project_number + "'s " + type + e.ToString());
continue;
}
}
//flow
type = "Flow";
if (currentRecord["flow"] != null)
{
try
{
if ((String)currentRecord["flow"] == "N/A")
{
currentProject.doc_visio = "0";
currentProject.doc_vui = "0";
}
else if ((String)currentRecord["flow"] == "Visio")
{
if (currentProject.doc_visio != "1" && currentProject.doc_visio != "2" && currentProject.doc_visio != "3")
{
currentProject.doc_visio = "1";
}
if (!(currentProject.doc_vui == "0"))
{
currentProject.doc_vui = "0";
}
}
else if ((String)currentRecord["flow"] == "VUI")
{
if (!(currentProject.doc_visio == "0"))
{
currentProject.doc_visio = "0";
}
if (currentProject.doc_vui != "1" && currentProject.doc_vui != "2" && currentProject.doc_vui != "3")
{
currentProject.doc_vui = "1";
}
}
else if ((String)currentRecord["flow"] == "VUI/Visio")
{
if (currentProject.doc_visio == "0" || currentProject.doc_visio == null)
{
currentProject.doc_visio = "1";
}
if (currentProject.doc_vui == "0" || currentProject.doc_vui == null)
{
currentProject.doc_vui = "1";
}
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//rfq recd
type = "RFQ Rec\'d";
if (currentRecord["rfq_recd"] != null)
{
try
{
string temp = (String)currentRecord["rfq_recd"];
if (temp.ToLower().Trim() != currentProject.rfq_loe_recv_date.ToLower().Trim())
{
currentProject.rfq_loe_recv_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//quote due
type = "Quote Due";
if (currentRecord["quote_due"] != null)
{
try
{
string temp = (String)currentRecord["quote_due"];
if (temp.ToLower().Trim() != currentProject.quote_loe_due_date.ToLower().Trim())
{
currentProject.quote_loe_due_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//req uat
type = "Req UAT";
if (currentRecord["req_uat"] != null)
{
try
{
string temp = (String)currentRecord["req_uat"];
if (temp.ToLower().Trim() != currentProject.requested_uat_date.ToLower().Trim())
{
currentProject.requested_uat_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//req uat
type = "Req PROD";
if (currentRecord["req_prod"] != null)
{
try
{
string temp = (String)currentRecord["req_prod"];
if (temp.ToLower().Trim() != currentProject.requested_prod_date.ToLower().Trim())
{
currentProject.requested_prod_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
}
else
{
if (!lockedProjects.Contains(currentProject.project_number))
{
lockedProjects.Add(currentProject.project_number);
}
continue;
}
db.SubmitChanges();
}
break;
}
default:
return(new PagedData("Error: Unsupported Http Request: " + context.Request.RequestType + " not recognized", false));
}//endswitch
ProjectReportViewReturn returnString = new ProjectReportViewReturn();
for (int i = 0; i < succeededProjects.Count; i++)
{
if (i + 1 < succeededProjects.Count)
{
returnString.succeededProjects += succeededProjects[i] + "; ";
}
else
{
returnString.succeededProjects += succeededProjects[i];
}
}
for (int i = 0; i < failedProjects.Count; i++)
{
if (i + 1 < failedProjects.Count)
{
returnString.failedProjects += failedProjects[i] + "; ";
}
else
{
returnString.failedProjects += failedProjects[i];
}
}
for (int i = 0; i < lockedProjects.Count; i++)
{
if (i + 1 < lockedProjects.Count)
{
returnString.lockedProjects += lockedProjects[i] + "; ";
}
else
{
returnString.lockedProjects += lockedProjects[i];
}
}
return(new PagedData(returnString, true));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
System.IO.StreamReader reader = new System.IO.StreamReader(context.Request.InputStream, context.Request.ContentEncoding);
var jsonSerializer = new JsonSerializer();
List<String> failedProjects = new List<string>();
List<String> succeededProjects = new List<string>();
List<String> lockedProjects = new List<string>();
string username = context.Request.Params.Get("user_name");
switch (context.Request.RequestType)
{
case "PUT":
{
return new PagedData("fake sync complete! records should no longer be dirty you cheating bastard", true);
}
case "POST":
{
String type = "";
JArray blob = (JArray)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd())));
foreach (JObject currentRecord in blob)
{
var currentProject = db.ProjectInformations.Single(a => a.project_id.Equals((Int32)currentRecord["project_id"]));
if ((currentProject.locked != true) || (currentProject.locked == true && (DateTime.Now - DateTime.Parse(currentProject.last_time)).TotalSeconds > 75))
{
//expedite
type = "Expedite";
if (currentRecord["exp"] != null)
{
try
{
if ((String)currentRecord["exp"] == "True")
{
if (!(currentProject.expedite == true))
{
currentProject.expedite = true;
}
}
else if ((String)currentRecord["exp"] == "False")
{
if (!(currentProject.expedite == false))
{
currentProject.expedite = false;
}
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//project name
type = "Project Name";
if (currentRecord["project_name"] != null)
{
try
{
string temp = (String)currentRecord["project_name"];
if (temp.ToLower().Trim() != currentProject.project_name.ToLower().Trim())
{
currentProject.project_name = (String)currentRecord["project_name"];
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//status
type = "Project Status";
if (currentRecord["project_status"] != null)
{
try
{
string temp = (String)currentRecord["project_status"];
if (db.StatusTypes.Count(a => a.type.Equals((String)currentRecord["project_status"])) > 0)
{
ProjectStatus status = new ProjectStatus();
status.project_id = currentProject.project_id;
status.date = DateTime.Now.ToString("s");
status.status_type_id = db.StatusTypes.Single(a => a.type.Equals((String)currentRecord["project_status"])).status_type_id;
db.ProjectStatus.InsertOnSubmit(status);
db.SubmitChanges();
//update project histories
ProjectHistory history = new ProjectHistory();
history.project_id = currentProject.project_id;
history.user_name = username;
history.date = DateTime.Now.ToString("s");
history.description = "Project status changed to \"" + db.StatusTypes.Single(a => a.type.Equals((String)currentRecord["project_status"])).type + "\"";
history.status_id = status.project_status_id;
db.ProjectHistories.InsertOnSubmit(history);
db.SubmitChanges();
//update new current_project_status on pi table
db.ProjectInformations.Single(a => a.project_id.Equals(currentProject.project_id)).current_project_status = (String)currentRecord["project_status"];
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
else
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//business unit
type = "Business Unit";
if (currentRecord["business_unit"] != null)
{
try
{
string temp = (String)currentRecord["business_unit"];
if (db.BusinessUnits.Count(a => a.name.Equals(temp)) > 0)
{
currentProject.primary_business_unit = temp;
}
else
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//TC
type = "TC";
if (currentRecord["tc"] != null)
{
try
{
string[] names = ((String)currentRecord["tc"]).Split(',');
IQueryable<ProjectContact> q = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC"));
foreach (String currName in names)
{
if (db.Contacts.Count(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())) > 0)
{
int contact_id = db.Contacts.First(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())).contact_id;
ProjectContact contact = new ProjectContact();
contact.Contact = db.Contacts.Single(a => a.contact_id.Equals(contact_id));
contact.project_id = currentProject.project_id;
contact.type = "USAN TC";
db.ProjectContacts.InsertOnSubmit(contact);
}
}
if (db.ProjectContacts.Count(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC")) > 0)
{
var oldRecsToDelete = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN TC"));
db.ProjectContacts.DeleteAllOnSubmit(oldRecsToDelete);
}
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception e)
{
failedProjects.Add(currentProject.project_number + "'s " + type + e.ToString());
continue;
}
}
//PM
type = "PM";
if (currentRecord["pm"] != null)
{
try
{
string[] names = ((String)currentRecord["pm"]).Split(',');
IQueryable<ProjectContact> q = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM"));
foreach (String currName in names)
{
if (db.Contacts.Count(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())) > 0)
{
int contact_id = db.Contacts.First(a => a.name.ToLower().Trim().Equals(currName.ToLower().Trim())).contact_id;
ProjectContact contact = new ProjectContact();
contact.Contact = db.Contacts.Single(a => a.contact_id.Equals(contact_id));
contact.project_id = currentProject.project_id;
contact.type = "USAN Dev PM";
db.ProjectContacts.InsertOnSubmit(contact);
}
}
if (db.ProjectContacts.Count(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM")) > 0)
{
var oldRecsToDelete = db.ProjectContacts.Where(a => a.project_id.Equals(currentProject.project_id) && a.type.Equals("USAN Dev PM"));
db.ProjectContacts.DeleteAllOnSubmit(oldRecsToDelete);
}
db.SubmitChanges();
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception e)
{
failedProjects.Add(currentProject.project_number + "'s " + type + e.ToString());
continue;
}
}
//flow
type = "Flow";
if (currentRecord["flow"] != null)
{
try
{
if ((String)currentRecord["flow"] == "N/A")
{
currentProject.doc_visio = "0";
currentProject.doc_vui = "0";
}
else if ((String)currentRecord["flow"] == "Visio")
{
if (currentProject.doc_visio != "1" && currentProject.doc_visio != "2" && currentProject.doc_visio != "3")
{
currentProject.doc_visio = "1";
}
if (!(currentProject.doc_vui == "0"))
{
currentProject.doc_vui = "0";
}
}
else if ((String)currentRecord["flow"] == "VUI")
{
if (!(currentProject.doc_visio == "0"))
{
currentProject.doc_visio = "0";
}
if (currentProject.doc_vui != "1" && currentProject.doc_vui != "2" && currentProject.doc_vui != "3")
{
currentProject.doc_vui = "1";
}
}
else if ((String)currentRecord["flow"] == "VUI/Visio")
{
if (currentProject.doc_visio == "0" || currentProject.doc_visio == null)
{
currentProject.doc_visio = "1";
}
if (currentProject.doc_vui == "0" || currentProject.doc_vui == null)
{
currentProject.doc_vui = "1";
}
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//rfq recd
type = "RFQ Rec\'d";
if (currentRecord["rfq_recd"] != null)
{
try
{
string temp = (String)currentRecord["rfq_recd"];
if (temp.ToLower().Trim() != currentProject.rfq_loe_recv_date.ToLower().Trim())
{
currentProject.rfq_loe_recv_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//quote due
type = "Quote Due";
if (currentRecord["quote_due"] != null)
{
try
{
string temp = (String)currentRecord["quote_due"];
if (temp.ToLower().Trim() != currentProject.quote_loe_due_date.ToLower().Trim())
{
currentProject.quote_loe_due_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//req uat
type = "Req UAT";
if (currentRecord["req_uat"] != null)
{
try
{
string temp = (String)currentRecord["req_uat"];
if (temp.ToLower().Trim() != currentProject.requested_uat_date.ToLower().Trim())
{
currentProject.requested_uat_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
//req uat
type = "Req PROD";
if (currentRecord["req_prod"] != null)
{
try
{
string temp = (String)currentRecord["req_prod"];
if (temp.ToLower().Trim() != currentProject.requested_prod_date.ToLower().Trim())
{
currentProject.requested_prod_date = temp;
}
succeededProjects.Add(currentProject.project_number + "'s " + type);
}
catch (Exception)
{
failedProjects.Add(currentProject.project_number + "'s " + type);
continue;
}
}
}
else
{
if (!lockedProjects.Contains(currentProject.project_number))
{
lockedProjects.Add(currentProject.project_number);
}
continue;
}
db.SubmitChanges();
}
break;
}
default:
return new PagedData("Error: Unsupported Http Request: " + context.Request.RequestType + " not recognized", false);
}//endswitch
ProjectReportViewReturn returnString = new ProjectReportViewReturn();
for (int i = 0; i < succeededProjects.Count; i++)
{
if (i + 1 < succeededProjects.Count)
{
returnString.succeededProjects += succeededProjects[i] + "; ";
}
else
{
returnString.succeededProjects += succeededProjects[i];
}
}
for (int i = 0; i < failedProjects.Count; i++)
{
if (i + 1 < failedProjects.Count)
{
returnString.failedProjects += failedProjects[i] + "; ";
}
else
{
returnString.failedProjects += failedProjects[i];
}
}
for (int i = 0; i < lockedProjects.Count; i++)
{
if (i + 1 < lockedProjects.Count)
{
returnString.lockedProjects += lockedProjects[i] + "; ";
}
else
{
returnString.lockedProjects += lockedProjects[i];
}
}
return new PagedData(returnString, true);
}
public void processProjectContact(string[] names, string projectContactType, CookDBDataContext db, int project_id)
{
try
{
//check if there are existing contacts for this type; and if so, wipe them out
IQueryable<ProjectContact> q = db.ProjectContacts;
q.Where(a => a.project_id.Equals(project_id) && a.type.Equals(projectContactType));
List<ProjectContact> oldRecs = new List<ProjectContact>();
List<ProjectContact> newRecs = new List<ProjectContact>();
Boolean shouldWeDelete = false;
int count = db.ProjectContacts.Count(a => a.project_id.Equals(project_id) && a.type.Equals(projectContactType));
if (count > 0)
{
shouldWeDelete = true;
var result = db.ProjectContacts.Where(a => a.project_id.Equals(project_id) && a.type.Equals(projectContactType));
oldRecs = db.ProjectContacts.Where(a => a.project_id.Equals(project_id) && a.type.Equals(projectContactType)).ToList();
//db.ProjectContacts.DeleteAllOnSubmit(result);
//db.SubmitChanges();
}
foreach (string name in names)
{
string realName = name.Trim();
int contact_id = (db.Contacts.Single(a => a.name.Equals(realName))).contact_id;
//if (db.ProjectContacts.Count(a => a.contact_id.Equals(contact_id) && a.type.Equals(projectContactType) && a.project_id.Equals(project_id)) == 0)
//{
//add the contact to the project
ProjectContact contact = new ProjectContact();
contact.Contact = db.Contacts.Single(a => a.contact_id.Equals(contact_id));
contact.ProjectInformation = db.ProjectInformations.Single(a => a.project_id.Equals(project_id));
contact.type = projectContactType;
newRecs.Add(contact);
db.ProjectContacts.InsertOnSubmit(contact);
//}
}
bool matched = true;
if (oldRecs.Count().Equals(newRecs.Count()) && oldRecs.Count() > 0)
{
try
{
oldRecs = oldRecs.OrderBy(a => a.contact_id).ToList();
newRecs = newRecs.OrderBy(a => a.contact_id).ToList();
}
catch (Exception e)
{
comment += "sorting exception " + e.Message;
}
for (int i = 0; i < oldRecs.Count(); i++)
{
if ((oldRecs[i].contact_id != newRecs[i].contact_id) || (oldRecs[i].type != newRecs[i].type))
{
matched = false;
}
/*try
{
comment += "[Testing: " + oldRecs[i].Contact.name + "|"+oldRecs[i].contact_id + "|" + i + "/" + oldRecs.Count()+"]";
}
catch (Exception e)
{
comment += "[Yep " + e.Message + "]";
}*/
}
}
else
{
matched = false;
}
if (matched != true)
{
comment += "[Testing: " + oldRecs.Count() + "|" + newRecs.Count() + "]";
string a = "", b = "";
foreach (ProjectContact c in oldRecs)
{
a += c.Contact.name + ", ";
}
if (a.LastIndexOf(", ") == a.Length - 2)
{
a = a.Substring(0, a.Length - 2);
}
foreach (ProjectContact d in newRecs)
{
b += d.Contact.name + ", ";
}
if (b.LastIndexOf(", ") == b.Length - 2)
{
b = b.Substring(0, b.Length - 2);
}
logBuilder += projectContactType + " has changed from: \"" + a + "\" -> \"" + b + "\"; ";
}
if (shouldWeDelete != false)
{
var result = db.ProjectContacts.Where(a => a.project_id.Equals(project_id) && a.type.Equals(projectContactType));
db.ProjectContacts.DeleteAllOnSubmit(result);
db.SubmitChanges();
}
}
catch (Exception e)
{
comment += "[something went wrong in processContacts|"+e.Message +"]";
}
}
