private void btnSocialAccountDelete_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (lstSocialNetwork.SelectedItems.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی");
return;
}
#region Member Casting
int memberId = FrmMember.MemberProfile.ID;
if (!Member.Validation(memberId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Member member = Member.Get(memberId, myConnection);
#endregion
#region SocialNetworkType Casting
int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID;
if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection);
#endregion
#region SocialNetworkAccount Casting
SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag;
if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection);
#endregion
DialogResult messageResult =
DataValidationMesaage.ConfirmDeleteData(lstSocialNetwork.SelectedItems[0].SubItems[1].Text);
if (messageResult == DialogResult.Yes)
{
if (socialNetworkAccount.Status)
{
#region NextSocialNetworkAccount Casting
int nextSocialNetworkAccountIndex = (int.Parse(lstSocialNetwork.SelectedItems[0].Text)) %
lstSocialNetwork.Items.Count;
SocialNetworkAccount nextSocialNetworkAccount =
(SocialNetworkAccount)lstSocialNetwork.Items[nextSocialNetworkAccountIndex].Tag;
if (!SocialNetworkAccount.Validation(nextSocialNetworkAccount.ID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
nextSocialNetworkAccount = SocialNetworkAccount.Get(nextSocialNetworkAccount.ID, myConnection);
var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member);
foreach (var item in query)
{
item.Status = false;
myConnection.SubmitChanges();
}
#endregion
nextSocialNetworkAccount.Status = true;
myConnection.SubmitChanges();
}
SocialNetworkAccount.Delete(socialNetworkAccount, myConnection);
SocialNetworkAccount.ShowListByMember(lstSocialNetwork, FrmMember.MemberProfile, myConnection);
if (lstSocialNetwork.Items.Count == 1)
{
btnPhoneDelete.Enabled = false;
}
}
txtSocialAccount.Clear();
myConnection.Dispose();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (gridMember.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridMember.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Member Casting
int memeberId = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString());
if (!Member.Validation(memeberId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Member member = Member.Get(memeberId, myConnection);
#endregion
#region PhoneNumber Casting
string gridPhoneNumber = gridMember.SelectedRows[0].Cells[9].Value.ToString();
PhoneNumber phoneNumber =
myConnection.PhoneNumbers.FirstOrDefault(a => a.Number == gridPhoneNumber && a.Member == member);
if (!PhoneNumber.Validation(phoneNumber.ID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
#endregion
#region SocialNetworkAccount Casting
string gridSocialAccount = gridMember.SelectedRows[0].Cells[8].Value.ToString();
SocialNetworkAccount socialNetworkAccount =
myConnection.SocialNetworkAccounts.FirstOrDefault(
a => a.Account == gridSocialAccount && a.Member == member);
if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
#endregion
DialogResult message = DataValidationMesaage.ConfirmDeleteData(member.Code);
if (message == DialogResult.Yes)
{
PhoneNumber.Delete(phoneNumber, myConnection);
SocialNetworkAccount.Delete(socialNetworkAccount, myConnection);
Member.Delete(member, myConnection);
DataValidationMesaage.DeleteMessage();
GetCode();
Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection);
}
}