/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-4-2015
/// Comments :: Select all records for ListContacts grid.
/// </summary>
#region Select_All_Records_ListContactsgrid
public List <ListContacts> ListContactsgrid()
{
objEmailCampDataContext = new EmailCampDataContext();
lstListContacts = new List <ListContacts>();
var Select = (from cde in objEmailCampDataContext.spListContacts_AllActions(null, null, null, null, null, null, null, null, "c")
select cde).ToList();
if (Select.Count > 0)
{
lstListContacts = new List <ListContacts>();
foreach (var item in Select)
{
objListContacts = new ListContacts();
objListContacts.ListName = item.ListName;
//objListContacts.TotalCount = item.;
objListContacts.CreatedOn = item.CreatedOn;
objListContacts.CreatedBy = item.CreatedBy;
objListContacts.UpdatedBy = item.UpdatedBy;
objListContacts.UpdatedOn = item.UpdatedOn;
objListContacts.PK_ContListID = item.PK_ContListID;
lstListContacts.Add(objListContacts);
}
}
objEmailCampDataContext = null;
objListContacts = null;
return(lstListContacts);
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 28-4-2015
/// Comments :: Select all records for ListContacts details.
/// </summary>
#region Select_All_Records_CreateListContacts
public List <ListContacts> ListContactsSelect(int PK_ContListID)
{
objEmailCampDataContext = new EmailCampDataContext();
lstListContacts = new List <ListContacts>();
var Select = (from cde in objEmailCampDataContext.spListContacts_AllActions(PK_ContListID, null, null, null, null, null, null, null, "a")
select cde).ToList();
if (Select.Count > 0)
{
lstListContacts = new List <ListContacts>();
foreach (var item in Select)
{
objListContacts = new ListContacts();
objListContacts.ListName = item.ListName;
objListContacts.Comments = item.comments;
objListContacts.CreatedOn = item.CreatedOn;
objListContacts.CreatedBy = item.CreatedBy;
objListContacts.UpdatedBy = item.UpdatedBy;
objListContacts.UpdatedOn = item.UpdatedOn;
objListContacts.FK_CompanyID = item.FK_CompanyID;
lstListContacts.Add(objListContacts);
}
}
objEmailCampDataContext = null;
objListContacts = null;
return(lstListContacts);
}
public ListContacts ListContacts()
{
ListContacts action = new ListContacts();
action.Client(client);
action.Proxy(proxy);
return(action);
}
async Task UpdateDataCommand()
{
var lista = await GetContacts();
ListContacts.Clear();
foreach (Contacts contato in lista)
{
ListContacts.Add(contato);
}
}
public MainViewModel(IDependencyService serviceLocator)
{
this.serviceLocator = serviceLocator;
GetContact();
Contact unContact = new Contact();
Contacts = new ObservableCollection <ContactViewModel>(ListContacts
.Select(c => new ContactViewModel(c)));
SelectedContact = Contacts.FirstOrDefault();
AddContact = new AsyncDelegateCommand(OnAddContact);
DeleteContact = new AsyncDelegateCommand <ContactViewModel>(OnDeleteContact);
EditContact = new AsyncDelegateCommand <ContactViewModel>(OnEditContact);
ShowContactDetail = new AsyncDelegateCommand <ContactViewModel>(OnShowContactDetails);
}
public void SearchBar_TextChanged(object sender, TextChangedEventArgs e)
{
string toLower = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(e.NewTextValue);
var ContainerSearch = BindingContext as ContactsPageViewModel;
ListContacts.BeginRefresh();
if (string.IsNullOrWhiteSpace(toLower))
{
ListContacts.ItemsSource = ContainerSearch.Contacts;
}
else
{
ListContacts.ItemsSource = ContainerSearch.Contacts.Where(s => s.Name.Contains(toLower));
}
ListContacts.EndRefresh();
SearchBar searchBar = (SearchBar)sender;
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 28-4-2015
/// Comments :: Updation function of ListContacts details.
/// </summary>
#region Delete_ListContactsCreation
public void ListContactsDelete(int ListContactsid)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Delete = (from cde in objEmailCampDataContext.spListContacts_AllActions(ListContactsid, null, null, null, null, null, null, null, "d")
select cde).ToList();
Delete = null;
objListContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 28-4-2015
/// Comments :: Updation function of ListContacts details.
/// </summary>
#region Update_ListContactsCreation
public void ListContactsUpdate(ListContacts objListContacts)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Update = (from cde in objEmailCampDataContext.spListContacts_AllActions(objListContacts.PK_ContListID, objListContacts.ListName, objListContacts.Comments, objListContacts.CreatedBy, objListContacts.CreatedOn, objListContacts.UpdatedBy, objListContacts.UpdatedOn, objListContacts.FK_CompanyID, "u")
select cde).ToList();
Update = null;
objListContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
private async void DeleteCommandMethod(object obj)
{
//var x = (obj as Syncfusion.ListView.XForms.ItemTappedEventArgs).ItemData;
if (await UserDialogs.Instance.ConfirmAsync(new ConfirmConfig
{
CancelText = "Cancel",
OkText = "Ok",
Message = App.Idioma.TwoLetterISOLanguageName == MyIdioma.Español ? "¿Estás seguro de borrar el contacto?" : "Are you sure you want to delete the contact ?",
}))
{
var x = (UserModel)obj;
if (ItemIndex >= 0)
{
ListContacts.RemoveAt(ItemIndex);
}
//Agregar el metodo de borrado de usuario
if (await Services.UserService.DeleteUserAsync(x.UserID))
{
await Application.Current.MainPage.DisplayAlert("JobMe!",
App.Idioma.TwoLetterISOLanguageName == MyIdioma.Español? "Contacto eliminado" : "Contact successfully deleted",
"OK");
//MessagingCenter.Send<EditJobViewModel, int>(this, "UpdateList", 1);
}
else
{
await Application.Current.MainPage.DisplayAlert("JobMe!",
App.Idioma.TwoLetterISOLanguageName == MyIdioma.Español? "Error eliminando el contacto" : "Error deleting contact",
"OK");
}
//sfListView.ResetSwipe();
}
ListView.ResetSwipe();
}
public void AccessUpdateContacts(ListContacts objListContacts1)
{
objDL_ListContacts.ListContactsUpdate(objListContacts1);
}
//public void AccessExcelDataStore()
//{
// objDL_ListContacts.ListContactsExcelInsert();
//}
public void AccessInsertContacts(ListContacts objListContacts1)
{
objDL_ListContacts.ListContactsInsert(objListContacts1);
}
