/// <summary>
/// Fügt einen neuen Kontakt in die ObservableCollection ContactCollection hinzu
/// </summary>
private void AddNewContactToCollection()
{
ContactCollection.Add(new ViewModels.ContactViewModel()
{
Contact = new Models.Contact()
});
this.CurrentContact = ContactCollection[ContactCollection.Count - 1];
}
/******** 私有方法 ********/
/// <summary>
/// 执行刷新操作。
/// </summary>
private async Task List()
{
ContactCollection.Clear();
var contacts = await _contactService.ListAsync();
foreach (var contact in contacts)
{
ContactCollection.Add(contact);
}
}
static void Main(string[] args)
{
var list = new MyList();
var contacts = new ContactCollection();
var partnerships = new PartnershipCollection();
contacts.Add(new Contact());
partnerships.Add(new Partnership());
list.Add(contacts);
list.Add(partnerships);
list.ClearCollections();
}
private void Button_Save_Click(object sender, EventArgs e)
{
if (ListBox_Contacts.SelectedItem == null)
{
// new contact
Contacts.Add(new Contact(TextBox_ContactPhoneNumber.Text, ComboBox_CountryCode.Text, TextBox_ContactsName.Text));
MessageBox.Show(Contacts.Count.ToString());
ListBox_Contacts.DataSource = Contacts;
ListBox_Contacts.DisplayMember = "this\\Name";
}
else
{
Contact SelectedItem = (Contact)ListBox_Contacts.SelectedItem;
SelectedItem.Name = TextBox_ContactsName.Text;
SelectedItem.PhoneNumber = TextBox_ContactPhoneNumber.Text;
SelectedItem.CountryCode = ComboBox_CountryCode.Text;
ListBox_Contacts.DataSource = Contacts;
ListBox_Contacts.DisplayMember = "this\\Name";
}
}
public FlickrNet.ContactCollection GetAllFriends(string id)
{
try {
var result = (from t1 in db.friends
join t2 in db.linkfriends on t1.IdFriend equals t2.IdFriend
where t2.IdUser == id
select t1).ToList();
Contact returnVal = null;
ContactCollection coll = new ContactCollection();
foreach (var item in result)
{
returnVal = new Contact();
returnVal.UserId = item.IdFriend;
returnVal.UserName = item.UserName;
returnVal.PathAlias = item.PhotoUrl;
returnVal.IconFarm = (item.FullName == "")?item.UserName:item.FullName;
coll.Add(returnVal);
}
return(coll);
}
catch (Exception) {
return(null);
}
}
public ContactCollection getContacts()
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
ContactCollection contacts = new ContactCollection();
String qry = String.Empty;
qry = @"SELECT * FROM contacts order by Name";
SqlCommand cmd = new SqlCommand(qry, con);
SqlDataReader dr = cmd.ExecuteReader();
DataTable contactTable = new DataTable();
contactTable.Load(dr);
dr.Close();
qry = String.Empty;
qry = @"SELECT * FROM lines";
cmd = new SqlCommand(qry, con);
dr = cmd.ExecuteReader();
DataTable lineTable = new DataTable();
lineTable.Load(dr);
dr.Close();
cmd.Dispose();
for (int i = 0; i < contactTable.Rows.Count; i++)
{
bool isprocurement = false;
if (contactTable.Rows[i]["isProcurement"] == DBNull.Value) ;
else if ((int)contactTable.Rows[i]["isProcurement"] == 1)
isprocurement = true;
Contact c = new Contact((string)contactTable.Rows[i]["ID"],
(string)contactTable.Rows[i]["password"],
(string)contactTable.Rows[i]["name"],
(string)contactTable.Rows[i]["number"],
isprocurement);
createAssociation(c,
contactTable.Rows[i]["lineAssociation"] == DBNull.Value ? String.Empty : (String)contactTable.Rows[i]["lineAssociation"],
contactTable.Rows[i]["shiftAssociation"] == DBNull.Value ? String.Empty : (String)contactTable.Rows[i]["shiftAssociation"],
contactTable.Rows[i]["departmentAssociation"] == DBNull.Value ? String.Empty : (String)contactTable.Rows[i]["departmentAssociation"],
contactTable.Rows[i]["escalationAssociation"] == DBNull.Value ? String.Empty : (String)contactTable.Rows[i]["escalationAssociation"]);
contacts.Add(c);
}
con.Close();
con.Dispose();
return contacts;
}
public FlickrNet.ContactCollection GetFriends(string userId)
{
linkfriend ob = null;
try
{
try
{
ob = (from t in db.linkfriends
where t.IdUser == userId
select t).FirstOrDefault();
}
catch (Exception) { ob = null; }
if (ob == null)//inseamna ca nu am prietenii inca adaugati in DB
{
if (Models.User.FlickerObj.UserFl.ContainsKey(userId))
{
Flickr f = Models.User.FlickerObj.UserFl[userId];
FlickrNet.ContactCollection friends = f.ContactsGetPublicList(userId);//preiau din FLICKR
string realName = ""; string description = "";
foreach (var item in friends)
{
var person = f.PeopleGetInfo(item.UserId);
if (person.RealName != null)
{
realName = person.RealName;
}
else
{
realName = "";
}
if (person.Description.Length > 50)
{
description = Models.StringTool.Truncate(person.Description, 50) + "...";
}
else
{
description = person.Description;
}
item.PathAlias = item.BuddyIconUrl;
friend fr = new friend //adaug in DB
{
FullName = realName,
IdFriend = item.UserId,
UserName = item.UserName,
PhotoUrl = item.BuddyIconUrl,
Description = description
};
linkfriend link = new linkfriend
{
IdUser = userId,
IdFriend = item.UserId
};
try
{
db.friends.Add(fr);
db.linkfriends.Add(link);
}
catch (Exception)
{
}
}
db.SaveChanges();
Models.ListOfFriends.coll = friends;
return(friends);
}
else //inseamna ca exista prieteni
{
ContactCollection coll = new ContactCollection();
Contact con = new Contact();
var friends = db.linkfriends.Where(idx => idx.IdUser == userId).ToList();//preiau din DB
foreach (var item in friends)
{
var people = db.friends.Where(idx => idx.IdFriend == item.IdFriend).FirstOrDefault();
con.UserId = people.IdFriend;
con.RealName = people.FullName;
con.UserName = people.UserName;
con.PathAlias = people.PhotoUrl;
con.IconServer = people.Description;//we use some variable already existent so we not create another model
coll.Add(con);
}
return(coll);
}
}
else
{
ContactCollection coll = new ContactCollection();
var friends = db.linkfriends.Where(idx => idx.IdUser == userId).ToList();
foreach (var item in friends)
{
Contact con = new Contact();
var people = db.friends.Where(idx => idx.IdFriend == item.IdFriend).FirstOrDefault();
con.UserId = people.IdFriend;
con.RealName = people.FullName;
con.UserName = people.UserName;
con.PathAlias = people.PhotoUrl;
con.IconServer = people.Description;
coll.Add(con);
}
return(coll);
}
}
catch (Exception)
{
db.Dispose();
return(null);
}
}
public ContactCollection getContacts()
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
ContactCollection contacts = new ContactCollection();
String qry = String.Empty;
qry = @"SELECT * FROM contacts order by name";
SqlCommand cmd = new SqlCommand(qry, con);
SqlDataReader dr = cmd.ExecuteReader();
DataTable contactTable = new DataTable();
contactTable.Load(dr);
dr.Close();
qry = String.Empty;
qry = @"SELECT * FROM lines";
cmd = new SqlCommand(qry, con);
dr = cmd.ExecuteReader();
DataTable lineTable = new DataTable();
lineTable.Load(dr);
dr.Close();
cmd.Dispose();
for (int i = 0; i < contactTable.Rows.Count; i++)
{
Contact c = new Contact((int)contactTable.Rows[i]["slNo"], (string)contactTable.Rows[i]["name"],
(string)contactTable.Rows[i]["number"]);
createAssociation(c,
contactTable.Rows[i]["lineAssociation"] == DBNull.Value ? String.Empty :(String) contactTable.Rows[i]["lineAssociation"],
contactTable.Rows[i]["shiftAssociation"] == DBNull.Value ? String.Empty :(String) contactTable.Rows[i]["shiftAssociation"],
contactTable.Rows[i]["departmentAssociation"] == DBNull.Value ? String.Empty :(String) contactTable.Rows[i]["departmentAssociation"],
contactTable.Rows[i]["escalationAssociation"] == DBNull.Value ? String.Empty :(String) contactTable.Rows[i]["escalationAssociation"]);
if ((bool)contactTable.Rows[i]["hourlySummary"] == true)
c.LineSummary = true;
else
c.LineSummary = false;
if ((bool)contactTable.Rows[i]["shiftSummary"] == true)
c.ShiftSummary = true;
else
c.ShiftSummary = false;
contacts.Add(c);
}
con.Close();
con.Dispose();
return contacts;
}
