internal bool GetByMember(Entities.TourMember member)
{
bool res = false;
try
{
this.query.Parameters.Clear();
this.query.Parameters.Add(new SqlParameter("@MemberId", member.Id));
res = this.query.ExecuteReader("ContactsGetByMemberId", MapContactToObject, member);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
internal static void EditMember(Entities.TourMember member)
{
using (FrmTourMemberEditor frm = new FrmTourMemberEditor(member))
{
frm.ShowDialog();
}
}
internal bool Delete(Entities.TourMember person)
{
bool res = false;
try
{
this.query.Parameters.Clear();
this.query.Parameters.Add(new SqlParameter("@PersonId", person.Id));
int affected;
res = this.query.ExecuteUpdateProc("PhonebookDeleteByPersonId", out affected);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
public static void Save(Entities.TourMember person)
{
try
{
if (person.IsInPhonebook)
{
if (!cache.Contains(person))
{
persons.Insert(person);
cache.Add(person);
}
}
else
{
if (cache.Contains(person))
{
persons.Delete(person);
cache.Remove(person);
}
}
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
}
internal bool Insert(Entities.TourGroup group, Entities.TourMember member)
{
bool res = false;
try
{
this.query.Parameters.Clear();
this.query.Parameters.Add(new SqlParameter("@PersonId", member.Id));
this.query.Parameters.Add(new SqlParameter("@GroupId", group.Id));
int id;
res = this.query.ExecuteInsertProc("TourGroupMemberAdd", out id);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
internal bool Update(Entities.TourMember member)
{
bool res = false;
try
{
this.query.Parameters.Clear();
this.query.Parameters.Add(new SqlParameter("@MemberId", member.Id));
this.query.Parameters.Add(new SqlParameter("@TitleId", member.Title.Id));
this.query.Parameters.Add(new SqlParameter("@FirstName", member.FirstName));
this.query.Parameters.Add(new SqlParameter("@LastName", member.LastName));
this.query.Parameters.Add(new SqlParameter("@MembershipType", member.MemberShip == null ? -1 : member.MemberShip.Id));
int affected;
res = this.query.ExecuteUpdateProc("TourMembertUpdateById", out affected);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
internal static void Edit(Entities.TourMember person)
{
using (FrmTourMemberEditor frm = new FrmTourMemberEditor(person))
{
frm.AlwaysInAddressbook = true;
frm.ShowDialog();
}
}
internal static bool Delete(Entities.TourMember person)
{
if (person != null && person.Id >= 0)
{
return(DomainModel.Phonebook.Delete(person));
}
return(false);
}
public static bool Delete(Entities.TourGroup group, Entities.TourMember member)
{
bool res = true;
try
{
using (TransactionScope ts = new TransactionScope())
{
if (DomainModel.Phonebook.Contains(member))
{
// Remove only relation
if (res)
{
res = groupMembers.Delete(group, member);
}
}
else
{
foreach (Entities.Contact contact in member.Contacts)
{
if (!(res = contacts.Delete(contact)))
{
break;
}
}
if (res)
{
res = groupMembers.Delete(group, member);
}
if (res)
{
res = members.Delete(member);
}
}
if (res)
{
ts.Complete();
}
}
}
catch (Exception ex)
{
res = false;
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
void editToolbar_EditButtonClick(object sender, EventArgs e)
{
Entities.TourMember member =
(Entities.TourMember) this.fgvMembers.SelectedItem;
if (member != null)
{
Presentation.Controllers.Phonebook.Edit(member);
}
}
void editToolbar_DeleteButtonClick(object sender, EventArgs e)
{
Entities.TourMember member =
(Entities.TourMember) this.fgvMembers.SelectedItem;
if (Presentation.Controllers.Phonebook.Delete(member))
{
this.fgvMembers.SelectLastItem();
}
}
public void OnContactMenu(Entities.TourMember item)
{
if (item == null)
{
// Add new contact
Presentation.Controllers.Tours.AddMember(this.group);
}
else
{
DomainModel.TourGroupMembers.Save(item, this.group);
}
}
public static bool Delete(Entities.TourMember person)
{
bool res = true;
try
{
using (TransactionScope ts = new TransactionScope())
{
foreach (Entities.Contact contact in person.Contacts)
{
if (!(res = contacts.Delete(contact)))
{
break;
}
}
if (res)
{
res = persons.Delete(person);
}
if (res)
{
res = members.Delete(person);
}
if (res)
{
ts.Complete();
}
}
if (res)
{
cache.Remove(person);
}
}
catch (Exception ex)
{
res = false;
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
protected void MapContactToObject(SqlDataReader reader, object userData)
{
Entities.Contact contact = new Entities.Contact();
contact.Id = Utils.GetSafeInt32(reader, "ContactId");
contact.Media = DomainModel.ContactMediaTypes.GetById(
Utils.GetSafeInt32(reader, "ContactMediaId"));
contact.Value = Utils.GetSafeString(reader, "ContactValue");
contact.IsDirty = false;
Entities.TourMember member = (Entities.TourMember)userData;
member.Contacts.Add(contact);
}
private void UpdateSelectedMemberContacts()
{
Entities.TourMember member =
(Entities.TourMember) this.fgvMembers.SelectedItem;
if (member != null)
{
this.lsvMemberContacts.SetDataSource(
member.Contacts);
}
else
{
this.lsvMemberContacts.SetDataSource(null);
}
}
protected void MapMemberToObject(SqlDataReader reader, object userData)
{
Entities.TourMember member = new Entities.TourMember();
member.Id = Utils.GetSafeInt32(reader, "MemberId");
member.Title = DomainModel.PersonTitleTypes.GetById(
Utils.GetSafeInt32(reader, "TitleId"));
member.FirstName = Utils.GetSafeString(reader, "FirstName");
member.LastName = Utils.GetSafeString(reader, "LastName");
member.MemberShip = DomainModel.TourMembershipTypes.GetById(
Utils.GetSafeInt32(reader, "MembershipType"));
member.IsDirty = false;
Entities.TourGroup group = (Entities.TourGroup)userData;
group.Members.Add(member);
}
void editToolbar_DeleteButtonClick(object sender, EventArgs e)
{
Entities.TourMember member =
(Entities.TourMember) this.fgvMembers.SelectedItem;
if (member != null)
{
if (member.Id >= 0)
{
if (DomainModel.TourGroupMembers.Delete(this.group, member))
{
group.Members.Remove(member);
//this.fgvMembers.SelectLastItem();
this.fgvMembers.Focus();
}
}
}
}
internal bool Update(Entities.TourMember member, Entities.Contact contact)
{
bool res = false;
try
{
if (contact.Id < 0)
{
DomainModel.Application.Status.Update(
StatusTypes.Warning,
"stat_wrn_db_id_not_exists");
return(true);
}
this.query.Parameters.Clear();
this.query.Parameters.Add(new SqlParameter("@ContactMediaId", contact.Media.Id));
this.query.Parameters.Add(new SqlParameter("@ContactValue", contact.Value));
this.query.Parameters.Add(new SqlParameter("@ContactId", contact.Id));
this.query.Parameters.Add(new SqlParameter("@PersonId", member.Id));
int affected;
res = this.query.ExecuteUpdateProc("PersonContactUpdateById", out affected);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
public static void Load(Entities.TourGroup group)
{
try
{
// Load member details
members.GetByGroup(group);
// Load each member contacts
for (int i = 0; i < group.Members.Count; i++)
{
Entities.TourMember member = group.Members[i];
Entities.TourMember inPhonebook =
DomainModel.Phonebook.FindById(member.Id);
if (inPhonebook == null)
{
contacts.GetByMember(member);
}
else
{
group.Members[i] = inPhonebook;
}
}
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
}
// Provide group for inserts
public static bool Save(Entities.TourMember member, Entities.TourGroup group = null)
{
bool res = true;
try
{
using (TransactionScope ts = new TransactionScope())
{
// Save changes to member
if (member.IsDirty)
{
if (member.Id < 0)
{
if (!(res = members.Insert(member)))
{
return(res);
}
}
else
{
if (!(res = members.Update(member)))
{
return(res);
}
}
}
// Save member-tour relation
if (group != null)
{
if (!(res = groupMembers.Insert(group, member)))
{
return(res);
}
}
// Save contacts
foreach (Entities.Contact contact in member.Contacts)
{
if (contact.IsDirty)
{
if (contact.Id < 0)
{
if (!(res = contacts.Insert(member, contact)))
{
return(res);
}
}
else
{
if (!(res = contacts.Update(member, contact)))
{
return(res);
}
}
}
}
// Save deleted contacts
foreach (Entities.Contact contact in member.DeletedContacts)
{
if (!(res = contacts.Delete(contact)))
{
return(res);
}
}
// Update cache
if (group != null && !group.Members.Contains(member))
{
group.Members.Add(member);
}
ts.Complete();
}
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}
internal static bool Contains(Entities.TourMember member)
{
return(cache.Contains(member));
}
