private void UpdateApplicationRoles(contactPerson contactPerson, DALPortalDataContext dc) { if (!contactPerson.isWebContact) { // Delete all roles var userRoles = dc.userRoles.Where(c => c.userId.Equals(contactPerson.userId)); dc.userRoles.DeleteAllOnSubmit(userRoles); dc.SubmitChanges(); return; } // Add CERT_USER role if (contactPerson.TMP_PortalAccess == "01" || contactPerson.TMP_PortalAccess == "04") { if (!dc.userRoles.Any(c => c.userId.Equals(contactPerson.userId) && c.roleCode.Equals("CERT_USER"))) { dc.userRoles.InsertOnSubmit(new userRole() { userId = contactPerson.userId.Value, roleCode = "CERT_USER" }); } } // Add DOP_USER role if (contactPerson.TMP_PortalAccess == "03" || contactPerson.TMP_PortalAccess == "04") { if (!dc.userRoles.Any(c => c.userId.Equals(contactPerson.userId) && c.roleCode.Equals("DOP_USER"))) { dc.userRoles.InsertOnSubmit(new userRole() { userId = contactPerson.userId.Value, roleCode = "DOP_USER" }); } } if (contactPerson.TMP_PortalAccess == "01") { // Delete DOP_USER role var userRoles = dc.userRoles.Where(c => c.userId.Equals(contactPerson.userId) && c.roleCode.Equals("DOP_USER")); dc.userRoles.DeleteAllOnSubmit(userRoles); } if (contactPerson.TMP_PortalAccess == "03") { // Delete CERT_USER role var userRoles = dc.userRoles.Where(c => c.userId.Equals(contactPerson.userId) && c.roleCode.Equals("CERT_USER")); dc.userRoles.DeleteAllOnSubmit(userRoles); } if (contactPerson.TMP_PortalAccess == null) { // Delete all roles var userRoles = dc.userRoles.Where(c => c.userId.Equals(contactPerson.userId)); dc.userRoles.DeleteAllOnSubmit(userRoles); } dc.SubmitChanges(); }
private void DeleteContactPerson_Click(object sender, RoutedEventArgs e) { var selectRow = (System.Data.DataRowView)contactPersonDataGrid.SelectedItem; int icontactPersonID = (int)selectRow["contacnPersonID"]; //to identify slected row data in contact datagrid, and find it's person id. contactPerson deleteContactPerson = db.contactPerson.First(c => c.contacnPersonID == icontactPersonID); //delete contact person linq db.contactPerson.Remove(deleteContactPerson); db.SaveChanges(); reload_EditDataGrid(); //reload datagrid. }
private void contactPersonInCustomer_Filter(object sender, FilterEventArgs e) { contactPerson t = e.Item as contactPerson; if (t != null) // If filter is turned on, filter completed items. { if (t.companyCode != selectedCustomerCode) { e.Accepted = false; } else { e.Accepted = true; } } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { contactPerson addContactPerson = new contactPerson() { companyCode = getCompanyCode, department = DepartmentTextBox.Text, gender = GenderTextBox.Text, name = NameTextBox.Text, contacnPersonID = int.Parse(ContactPersonIDTextBox.Text) }; //add a new contact person to db. db.contactPerson.Add(addContactPerson); db.SaveChanges(); closeDialogEvent(); //after save in db,use this func to call reload_datagrid func to refresh the data. this.Close(); }
public static Boolean ProcessCustomer(string fileContent, out businessPartner businessPartner, out String outCompanyCode) { businessPartner = new businessPartner(); DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; String companyCode = String.Empty; outCompanyCode = String.Empty; try { XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("DEBMAS03"); XElement iDocElement = docTypeElement.Element("IDOC"); var customerHeaderElement = iDocElement.Element("E1KNA1M"); //Int32 CardCode; // Remove unused elements iDocElement.Element("EDI_DC40").Remove(); // BpCode, remove leading zero's from Cardcode String bpCode = Convert.ToInt32(customerHeaderElement.Element("KUNNR").Value).ToString(); String sectionCode = customerHeaderElement.Element("E1KNVVM").Element("VKORG").Value; companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); outCompanyCode = companyCode; // Check if bp Already exists businessPartner = BusinessPartnerClass.GetBusinessPartner(bpCode, companyCode, dc); if (businessPartner == null) { businessPartner = new businessPartner(); update = false; } else { update = true; } if (!update) { String companyGroupCode = dc.companyGroupForBps.Where(c => c.companyCode.Equals(companyCode)).Select(c => c.companyGroupCode).FirstOrDefault(); if (String.IsNullOrEmpty(companyGroupCode)) { businessPartner.companyCode = companyCode; } else { businessPartner.companyGroupCode = companyGroupCode; } } // Mapp customer header data businessPartner.bpCode = bpCode; businessPartner.bpType = 'C'; businessPartner.bpName = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("NAME1")).FirstOrDefault().Value; businessPartner.address = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("STRAS")).FirstOrDefault().Value; if (customerHeaderElement.Elements().Any(c => c.Name.ToString().Equals("TELF1"))) { businessPartner.telephone = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("TELF1")).FirstOrDefault().Value; } if (customerHeaderElement.Elements().Any(c => c.Name.ToString().Equals("TELFX"))) { businessPartner.fax = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("TELFX")).FirstOrDefault().Value; } businessPartner.countryCode = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("LAND1")).FirstOrDefault().Value; businessPartner.languageCode = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("SPRAS_ISO")).FirstOrDefault().Value; // Mapp contactperson data foreach (var contactpersonElement in customerHeaderElement.Elements("E1KNVKM").ToList()) { contactPerson contact; // Contact Id String contactPersonCode = Convert.ToInt32(contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("PARNR")).FirstOrDefault().Value).ToString(); Boolean newContact = false; if (update && businessPartner.contactPersons.Any(c => c.contactPersonCode.Equals(contactPersonCode))) { contact = businessPartner.contactPersons.Where(c => c.contactPersonCode.Equals(contactPersonCode)).FirstOrDefault(); } else { contact = new contactPerson(); contact.contactPersonCode = contactPersonCode; newContact = true; } // Email var emailAddress = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("PARAU")).FirstOrDefault(); if (emailAddress != null) { contact.eMail = emailAddress.Value.ToLower(); } // Title var title = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("ANRED")).FirstOrDefault(); if (title != null) { contact.title = title.Value; } // FirstName var firstName = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("NAMEV")).FirstOrDefault(); if (firstName != null) { contact.firstName = firstName.Value; } // LastName var lastName = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("NAME1")).FirstOrDefault(); if (lastName != null) { contact.lastName = lastName.Value; } // WebUser var webUserType = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("AKVER")).FirstOrDefault(); if (webUserType != null) { contact.isWebContact = (webUserType.Value == "02") ? false : true; contact.TMP_PortalAccess = webUserType.Value; } // Add CardCode to contactperson if (newContact) { businessPartner.contactPersons.Add(contact); } } } catch (Exception ex) { Trace.WriteLine(String.Format("Error converting customer {0} for company {1} from SAP ECC6 XML format. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return(false); } if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Customer {0} for company {1} Successfull.", businessPartner.bpCode, companyCode), "MapCustomerFromECC6"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Customer {0} for company {1}. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return(false); } } else { try { dc.businessPartners.InsertOnSubmit(businessPartner); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Customer {0} for company {1} Successfull.", businessPartner.bpCode, companyCode), "MapCustomerFromECC6"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Customer {0} for company {1}. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return(false); } } return(true); }
/// <summary> /// læser dataset indhold og tilføjer dem /// til en class til data /// </summary> private fileInput GetFilesValues(DataSet readxml, string filename) { fileInput fileData = new fileInput(); fileData.filename = filename; if (readxml.Tables.Contains("kontaktPerson")) { for (int i = 0; i < readxml.Tables["kontaktPerson"].Rows.Count; i++) { contactPerson contactPer = new contactPerson(); contactPer.name = readxml.Tables["kontaktPerson"].Rows[i]["navn"].ToString(); contactPer.mobile = readxml.Tables["kontaktPerson"].Rows[i]["mobil"].ToString(); contactPer.mail = readxml.Tables["kontaktPerson"].Rows[i]["email"].ToString(); contactPer.post = readxml.Tables["kontaktPerson"].Rows[i]["stilling"].ToString(); contactPer.print = bool.Parse(readxml.Tables["kontaktPerson"].Rows[i]["print"].ToString()); fileData.contactPerson.Add(contactPer); } } if (readxml.Tables.Contains("kandidater")) { for (int i = 0; i < readxml.Tables["kandidater"].Rows.Count; i++) { fileData.candidates.Add(readxml.Tables["kandidater"].Rows[i]["navn"].ToString()); } } if (readxml.Tables.Contains("uddannelsesaftale1")) { for (int i = 0; i < readxml.Tables["uddannelsesaftale1"].Rows.Count; i++) { fileData.uddannelsesCheckBoxs.Add(readxml.Tables["uddannelsesaftale1"].Rows[i]["checkbox"].ToString()); } } if (readxml.Tables.Contains("uddannelsesaftale2")) { for (int i = 0; i < readxml.Tables["uddannelsesaftale2"].Rows.Count; i++) { fileData.agreementType.Add(readxml.Tables["uddannelsesaftale2"].Rows[i]["checkbox"].ToString()); } } if (readxml.Tables.Contains("files")) { for (int i = 0; i < readxml.Tables["files"].Rows.Count; i++) { files newFile = new files(); newFile.name = readxml.Tables["files"].Rows[i]["name"].ToString(); newFile.path = readxml.Tables["files"].Rows[i]["path"].ToString(); newFile.link = bool.Parse(readxml.Tables["files"].Rows[i]["link"].ToString()); fileData.files.Add(newFile); } } if (readxml.Tables.Contains("sproglige")) { for (int i = 0; i < readxml.Tables["sproglige"].Rows.Count; i++) { string value = readxml.Tables["sproglige"].Rows[i]["value"].ToString(); fileData.language.Add(value); } } if (readxml.Tables.Contains("record")) { for (int i = 0; i < readxml.Tables["record"].Rows.Count; i++) { string value = readxml.Tables["record"].Rows[i]["value"].ToString(); fileData.record.Add(value); } } if (readxml.Tables.Contains("FirmaØnsker")) { for (int i = 0; i < readxml.Tables["FirmaØnsker"].Rows.Count; i++) { string value = readxml.Tables["FirmaØnsker"].Rows[i]["checkbox"].ToString(); fileData.firmReceive.Checkbox.Add(value); } } if (readxml.Tables.Contains("andet")) { fileData.name = readxml.Tables["andet"].Rows[0]["virsomhed"].ToString(); fileData.cvr = readxml.Tables["andet"].Rows[0]["CVR"].ToString(); fileData.adresse = readxml.Tables["andet"].Rows[0]["adresse"].ToString(); fileData.tjenestested = readxml.Tables["andet"].Rows[0]["andetTjenestested"].ToString(); fileData.profil = readxml.Tables["andet"].Rows[0]["virsomhedProfil"].ToString(); fileData.uddannelses_lager = readxml.Tables["andet"].Rows[0]["uddannelses_lager"].ToString(); fileData.uddannelses_chauffor = readxml.Tables["andet"].Rows[0]["uddannelses_chauffor"].ToString(); fileData.uddannelses_lufthavn = readxml.Tables["andet"].Rows[0]["uddannelses_lufthavn"].ToString(); fileData.firmReceive.andet = readxml.Tables["andet"].Rows[0]["other"].ToString(); fileData.firmReceive.antalAftaler = readxml.Tables["andet"].Rows[0]["antalAftaler"].ToString(); fileData.firmReceive.lastDay = readxml.Tables["andet"].Rows[0]["datoFrist"].ToString(); fileData.firmReceive.antalPersoner = readxml.Tables["andet"].Rows[0]["antalKandidater"].ToString(); fileData.firmReceive.StartDate = readxml.Tables["andet"].Rows[0]["startDato"].ToString(); fileData.jobDescription = readxml.Tables["andet"].Rows[0]["jobBeskrivelse"].ToString(); fileData.age = readxml.Tables["andet"].Rows[0]["alder"].ToString(); fileData.driverLicense = readxml.Tables["andet"].Rows[0]["koerekort"].ToString(); fileData.physical = readxml.Tables["andet"].Rows[0]["fysiske"].ToString(); fileData.math = readxml.Tables["andet"].Rows[0]["matematiske"].ToString(); fileData.other = readxml.Tables["andet"].Rows[0]["bemaerkninger"].ToString(); fileData.VUF = readxml.Tables["andet"].Rows[0]["VUF"].ToString(); fileData.signedBy = readxml.Tables["andet"].Rows[0]["aftaleHvem"].ToString(); } return(fileData); }