public void InsertContactsIntoListByAccount(IEnumerable <ContactDTO> contactsDTO, AccountDTO accountDTO)
{
Contact account = Database.Contacts.Get(accountDTO.AccountId);
if (account == null)
{
throw new ValidationException("Аккаунт не найден", "");
}
List list = Database.Lists.Get(Database.Lists.Find(l => ((l.Title == "CONTACTS") && (l.CreatorId == account.ContactId))).FirstOrDefault().ListId);
if (list == null)
{
throw new ValidationException("Список контактов не найден", "");
}
foreach (var contactDTO in contactsDTO)
{
ListContact listContact = new ListContact
{
ListId = list.ListId,
ContactId = contactDTO.ContactId
};
Database.ListContacts.Create(listContact);
}
Database.Save();
}
private void Delete_Clicked(object sender, EventArgs e)
{
var menuItem = sender as MenuItem;
var contact = menuItem.CommandParameter as Contact;
ListContact.Remove(contact);
GetSearchedContacts(SearchString);
}
//Appel les methodes en Asynk
public async Task RunAsync(ReqAPI Client)
{
try
{
Contacts = await Client.GetContact(Co); // Sending a request
}
catch (Exception ex)
{ Err.DisplayException(ex); }
}
private void contact_dblClick(object sender, EventArgs e)
{
ListContact c = sender as ListContact;
if (c != null)
{
this.OpenConversationThread(c.contact.jid, true, true);
}
}
public void Delete(int id)
{
ListContact listContact = db.ListContacts.Find(id);
if (listContact != null)
{
db.ListContacts.Remove(listContact);
}
}
private void redraw()
{
this.flowLayoutPanel1.Controls.Clear();
foreach (Contact contact in this._matchingContacts)
{
ListContact lc = new ListContact(contact.jid, this.Style);
lc.DoubleClick += this.listContact_DoubleClick;
this.flowLayoutPanel1.Controls.Add(lc);
}
}
private void listContact_DoubleClick(object sender, EventArgs e)
{
ListContact lc = sender as ListContact;
if (lc != null)
{
this.SelectedJID = lc.contact.jid;
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public void GetSearchedContacts(string str)
{
if (!string.IsNullOrEmpty(str) && !string.IsNullOrWhiteSpace(str))
{
var tempList = ListContact.Where(x => x.Name.ToLower().Contains(str.ToLower()));
listContact.ItemsSource = tempList;
}
else
{
listContact.ItemsSource = ListContact;
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
ListContact = await _context.ListContact.FirstOrDefaultAsync(m => m.ContactId == id);
if (ListContact == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
ListContact = await _context.ListContact.FindAsync(id);
if (ListContact != null)
{
_context.ListContact.Remove(ListContact);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
protected void _loadConversations()
{
if (this.InvokeRequired)
{
remoteDelegate r = new remoteDelegate(_loadConversations);
this.Invoke(r);
}
else
{
this.flowLayoutPanel1.Controls.Clear();
DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");
using (DbConnection cnn = fact.CreateConnection())
{
cnn.ConnectionString = MessageStore.ConnectionString;
cnn.Open();
DbCommand cmd = cnn.CreateCommand();
cmd = cnn.CreateCommand();
cmd.CommandText = "SELECT jid FROM Messages GROUP BY jid";
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string jid = reader["jid"].ToString();
Contact contact = ContactStore.GetContactByJid(jid);
if (contact != null)
{
this.contacts.Add(contact);
//add to richtextbox
ListContact c = new ListContact(contact.jid);
c.DoubleClick += this.contact_dblClick;
this.flowLayoutPanel1.Controls.Add(c);
}
}
}
//done
this.label1.Hide();
}
}
public void Update(ListContact listContact)
{
db.Entry(listContact).State = System.Data.Entity.EntityState.Modified;
//try
//{
// SqlParameter listContactId = new SqlParameter("@listContactId", listContact.ListContactId);
// SqlParameter listId = new SqlParameter("@listId", listContact.ListId);
// SqlParameter contactId = new SqlParameter("@contactId", listContact.ContactId);
// SqlParameter notRelevant = new SqlParameter("@notRelevant", listContact.NotRelevant);
// db.Database.SqlQuery<int>("ListContact_UpdateListContact @listContactId, @listId, @contactId, @notRelevant",
// listContactId, listId, contactId, notRelevant).FirstOrDefault();
//}
//catch (SqlException e)
//{
// Console.Write("SqlException " + e.Message);
//}
//catch (Exception e)
//{
// Console.Write(" " + e.Message);
//}
}
private void OnLogIn(object param)
{
string password = (param as PasswordBox).Password;
if ((_login != "") & (password != ""))
{
foreach (UserElement item in list.UserItems)
{
if ((_login == item.Login) & (item.Password == password))
{
Settings.Default.Password = item.Password;
Settings.Default.Login = item.Login;
Settings.Default.Roles = (Roles)Convert.ToByte(item.Roles);
Logger.Log.InfoFormat("User {0} logged in", Settings.Default.Login);
switch (Language)
{
case Language.English:
System.Threading.Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.GetCultureInfo("en-Us");
break;
case Language.Russian:
System.Threading.Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.GetCultureInfo("ru-RU");
break;
case Language.Italiano:
System.Threading.Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.GetCultureInfo("it-IT");
break;
}
Logger.Log.DebugFormat("User {0} chose culture {1}", Settings.Default.Login, System.Threading.Thread.CurrentThread.CurrentUICulture.DisplayName);
Window window = new ListContact();
window.Show();
View.Close();
return;
}
}
MessageError = "Invalid username or password.";
}
else
MessageError = "Incorrect input information.";
OnPropertyChanged("MessageError");
}
public void Create(ListContact listContact)
{
db.ListContacts.Add(listContact);
//try
//{
// SqlParameter listId = new SqlParameter("@listId", listContact.ListId);
// SqlParameter contactId = new SqlParameter("@contactId", listContact.ContactId);
// SqlParameter creationDate = new SqlParameter("@creationDate", listContact.CreationDate);
// SqlParameter modificationDate = new SqlParameter("@modificationDate", listContact.ModificationDate);
// SqlParameter notRelevant = new SqlParameter("@notRelevant", listContact.NotRelevant);
// db.Database.SqlQuery<int>("ListContact_InsertListContact @listId, @contactId, @creationDate, @modificationDate, @notRelevant",
// listId, contactId, creationDate, modificationDate, notRelevant).FirstOrDefault();
//}
//catch (SqlException e)
//{
// Console.Write("SqlException " + e.Message);
//}
//catch (Exception e)
//{
// Console.Write(" " + e.Message);
//}
}
// If already identified ; No need for a form.
// If not identified; we will ask him for some information
public ActionResult RegisterToEvent()
{
SitecoreEvent sitecoreEvent = EventFromUrl();
var listItem = sitecoreEvent.ListName.TargetItem;
if (listItem == null)
{
return View("NoListAttached");
}
ListContact listContact = new ListContact()
{
ListName = listItem[Templates.Event.Fields.ContactListName],
SitecoreItemId = listItem.ID.ToString()
};
if (Tracker.Current != null)
{
var listTag = _contactListRepository.GetTags(Tracker.Current.Contact, Context.Database, listItem.ID.ToString());
if (listTag.Any())
{
// if empty we do not propose him to register - he is already register.
return this.View("EventAlreadyRegistered", listContact);
}
else
{
var emailFacet = GetEmailFacetFromContact();
// We propose him to register
if (emailFacet.Entries.Contains("Primary"))
{
listContact.Email = emailFacet.Entries["Primary"].SmtpAddress;
}
return this.View("EventRegistration", listContact);
}
}
else
{
//Tracker is null or you don't track the site; or you are on the Experience Editor
return Sitecore.Context.PageMode.IsExperienceEditor ?
View("NoTracker",DictionaryRepository.Get("/Events/Event Registration/Experience Editor", "You are in the page Editor, No Tracker")) :
this.View("NoTracker",string.Empty);
}
}
