public string GetCustomerByIdCustomerAndNumber(int idCustomer, string number)
{
var Context = new KoloAndroidEntities();
SimpleContact simpleContact = new SimpleContact()
{
FirstName = "name...",
LastName = "Full",
Telephone = "Phone number..."
};
Customer outCustomer;
var customerQuery = Context.Customers.Include("MobileDevice").Include("Person").Include("Registration");
if (idCustomer > 0)
{
outCustomer = customerQuery.Where(e => e.IdCustomer == idCustomer).FirstOrDefault();
}
else
{
outCustomer = customerQuery.Where(e => e.Registration.PhoneNumber == number).FirstOrDefault();
}
if (outCustomer != null)
{
simpleContact = new SimpleContact(outCustomer);
}
KoloWsObject <SimpleContact> koloWs = new KoloWsObject <SimpleContact>("", simpleContact);
var result = SerializationHelper.SerializeToJson(koloWs);
Context.Dispose();
return(result);
}
public static HashSet <SimpleContact> FindCustomerContacts(int idCustomer, HashSet <string> contacts, KoloAndroidEntities context, out string error)
{
error = "";
HashSet <SimpleContact> registredContats = new HashSet <SimpleContact>();
try
{
foreach (string number in contacts)
{
Customer tmpCustomer = null;
SimpleContact tmpSimpleContact = null;
tmpCustomer = context.Customers.Where(c => c.Registration.PhoneNumber == number).FirstOrDefault();
if (tmpCustomer != null)
{
tmpSimpleContact.Email = tmpCustomer.Registration.Email;
tmpSimpleContact.FirstName = tmpCustomer.Person.Firstname;
tmpSimpleContact.IdCustomer = tmpCustomer.IdCustomer;
//tmpSimpleContact.ImageUrl = "";
tmpSimpleContact.LastName = tmpCustomer.Person.Lastname;
tmpSimpleContact.Telephone = tmpCustomer.Registration.PhoneNumber;
registredContats.Add(tmpSimpleContact);
}
}
}
catch (Exception e)
{
error = KoloWin.Utilities.ExceptionHelper.GetMessageFromException(e);
}
return(registredContats);
}
private Contact CreateContact(SimpleContact contact)
{
return(new Contact
{
Email = contact.Email != null ? contact.Email : "",
Name = contact.Name != null ? contact.Name : "",
Organization = contact.Organization != null ? contact.Organization : ""
});
}
public Contact(SimpleContact incoming, string defaultRole)
{
if (incoming != null)
{
Name = incoming.Name;
Organization = incoming.Organization;
Email = incoming.Email;
Role = incoming.Role;
}
else
{
Role = defaultRole;
}
}
public frmRxCollectionView()
{
InitializeComponent();
myDemoData = SimpleContact.GetDemoData();
myFilter1 = new RxCollectionView <SimpleContact, TinyContact>(myDemoData);
myFilter1.Query = from item in myFilter1.Source
where item.City.Equals("Lippstadt")
select new TinyContact
{
FirstName = item.FirstName,
LastName = item.LastName
};
myResultingFilter1Collection = myFilter1.ResultingCollection;
myResultingFilter1Collection.CollectionChanged += MyResultingFilter1Collection_CollectionChanged;
}
private void EditContactInfoInWordDocument(SimpleContact contact, string tempfile)
{
using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(tempfile, true))
{
string docText = null;
using (StreamReader sr = new StreamReader(wordDoc.MainDocumentPart.GetStream()))
{
docText = sr.ReadToEnd();
}
if (!String.IsNullOrEmpty(contact.GivenName))
{
Regex regexText = new Regex("\\[Recipient\\]");
docText = regexText.Replace(docText, contact.GivenName);
}
using (StreamWriter sw = new StreamWriter(wordDoc.MainDocumentPart.GetStream(FileMode.Create)))
{
sw.Write(docText);
}
using (StreamReader sr = new StreamReader(wordDoc.MainDocumentPart.HeaderParts.FirstOrDefault().GetStream()))
{
docText = sr.ReadToEnd();
}
if (!String.IsNullOrEmpty(contact.Street) ||
!String.IsNullOrEmpty(contact.City) ||
!String.IsNullOrEmpty(contact.State) ||
!String.IsNullOrEmpty(contact.PostalCode))
{
Regex regexText = new Regex("\\[Street .*>\\]");
docText = regexText.Replace(docText, contact.DisplayName + "<w:br/>"
+ contact.Street + ", "
+ contact.City + ", "
+ contact.State + ", "
+ contact.PostalCode);
}
using (StreamWriter sw = new StreamWriter(wordDoc.MainDocumentPart.HeaderParts.FirstOrDefault().GetStream(FileMode.Create)))
{
sw.Write(docText);
}
}
}
public AddContactWindow(SimpleContact item)
{
InitializeComponent();
this.contactType = new List <ContactType>();
using (SmallBusinessDBEntities context = new SmallBusinessDBEntities()) {
try {
contactType.AddRange(context.ContactType.ToList());
ContactTypeComboBox.ItemsSource = contactType.Select(s => s.contactType1).ToList();
ContactTypeComboBox.SelectedItem = item.contactType;
ContactTypeComboBox.IsEnabled = false;
Contacts contact = context.Contacts.FirstOrDefault(c => c.ContactID == item.ContactID);
if (contact == null)
{
this.DialogResult = false;
}
EmployeerTextBox.Text = contact.employeeID == null ? "" : contact.employeeID.ToString();
EmployeerTextBox.IsEnabled = false;
SupplierTextBox.Text = contact.supplierID == null ? "" : contact.supplierID.ToString();
SupplierTextBox.IsEnabled = false;
DescriptionTextBox.Text = item.description;
ContactTextBox.Text = item.contact;
OKButton.Content = "Сохранить";
}//try
catch (Exception ex) {
MessageBox.Show(ex.Message);
} //catch
} // using
}
