private void Items_ItemRemoved(cItem sender)
{
string sName = Encrypt(sender.Name);
System.Data.DataRow oROW = this.Dataset.Tables[DatasetConnStr].Rows.Find(sName);
if (oROW != null)
{
oROW.Delete();
}
}
public void OnDeleteCommandExecute(object obj)
{
try
{
System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row;
dataRow.Delete();
}
catch
{
}
}
public void OnDeletePosKeyCommandExecute(object obj)
{
try
{
//PosKeyView view1 = _container.Resolve<PosKeyView>();
System.Data.DataRow dataRow = ((System.Data.DataRowView)_colViewPosKeys.CurrentItem).Row;
//view1.SetDataContext(dataRow);
// int response = view1.ShowInputDialog();
// if (response > 0)
// {
dataRow.Delete();
// }
}
catch
{
}
}
public void OnDeleteCommandExecute(object obj)
{
System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row;
dataRow.Delete();
View.DrawTableModel();
}
/// <summary>
///
/// </summary>
/// <param name="list"></param>
/// <param name="uidllist"></param>
/// <returns></returns>
public bool buildMessageTable(System.Int32[] list, System.String[] uidlist)
{
bool error = false;
// We need to initialize the inbox list
if (this.Count == 0)
{
for (int i = 0; i < uidlist.Length; i++)
{
this.newMessage(i + 1, list[i], uidlist[i]);
}
}
else
{
System.Collections.Specialized.StringCollection uidl = new System.Collections.Specialized.StringCollection();
uidl.AddRange(uidlist);
// As we already have an index, we try to put it in sync
// with the mail server
for (int i = 0; i < uidlist.Length; i++)
{
if (uidlist[i] == null)
{
continue;
}
this.inbox_view.RowFilter = System.String.Concat("uidl = '", EscapeExpression(uidlist[i]), "'");
// Message not found, so we add it
if (this.inbox_view.Count == 0)
{
this.newMessage(i + 1, list[i], uidlist[i]);
}
else
{
// Message found, but at the wrong position
if (!this.inbox_view[0][1].Equals(i + 1))
{
this.inbox_view[0][1] = i + 1;
}
// Message found, but in the wrong folder.
if (!this.inbox_view[0][18].Equals(this.current_folder))
{
this.inbox_view[0][18] = this.current_folder;
}
}
}
// now we try to find deleted messages
this.inbox_view.RowFilter = System.String.Concat("folder='", EscapeExpression(this.current_folder), "'");
for (int i = 0; i < this.inbox.Rows.Count; i++)
{
System.Data.DataRow item = this.inbox.Rows[i];
if (!uidl.Contains(item[3].ToString()))
{
if (item[15].Equals(false))
{
this.mcount--;
}
this.msize -= (int)item[2];
item.Delete();
i--;
}
}
}
return(!error);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (action == ActionState.New)
{
try
{
System.Data.DataRow newRow = phoneNumbersDataSet.PhoneNumbers.NewRow();
newRow.BeginEdit();
newRow["Phonenum"] = txtPhoneNumber.Text.Trim();
newRow["Subscriber"] = txtSubscriber.Text.Trim();
newRow["Contract_Value"] = Int32.Parse(txtContractValue.Text.Trim());
newRow["Contract_Date"] = DateTime.Parse(txtContractDate.Text.Trim());
newRow.EndEdit();
phoneNumbersDataSet.PhoneNumbers.Rows.Add(newRow);
tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers);
phoneNumbersDataSet.AcceptChanges();
}
catch (System.Data.DataException ex)
{
phoneNumbersDataSet.RejectChanges();
MessageBox.Show(ex.Message);
}
btnNew.IsEnabled = true;
btnEdit.IsEnabled = true;
btnSave.IsEnabled = false;
btnCancel.IsEnabled = false;
lstPhones.IsEnabled = true;
btnPrevious.IsEnabled = true;
btnNext.IsEnabled = true;
txtPhoneNumber.IsEnabled = false;
txtSubscriber.IsEnabled = false;
txtContractValue.IsEnabled = false;
txtContractDate.IsEnabled = false;
}
else if (action == ActionState.Edit)
{
try
{
System.Data.DataRow editRow = phoneNumbersDataSet.PhoneNumbers.Rows[lstPhones.SelectedIndex];
editRow.BeginEdit();
editRow["Phonenum"] = txtPhoneNumber.Text.Trim();
editRow["Subscriber"] = txtSubscriber.Text.Trim();
editRow["Contract_Value"] = Int32.Parse(txtContractValue.Text.Trim());
editRow["Contract_Date"] = DateTime.Parse(txtContractDate.Text.Trim());
editRow.EndEdit();
tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers);
phoneNumbersDataSet.AcceptChanges();
}
catch (System.Data.DataException ex)
{
phoneNumbersDataSet.RejectChanges();
MessageBox.Show(ex.Message);
}
btnNew.IsEnabled = true;
btnEdit.IsEnabled = true;
btnDelete.IsEnabled = true;
btnSave.IsEnabled = false;
btnCancel.IsEnabled = false;
lstPhones.IsEnabled = true;
btnPrevious.IsEnabled = true;
btnNext.IsEnabled = true;
txtPhoneNumber.IsEnabled = false;
txtSubscriber.IsEnabled = false;
txtContractValue.IsEnabled = false;
txtContractDate.IsEnabled = false;
txtPhoneNumber.SetBinding(TextBox.TextProperty, txtPhoneNumberBinding);
txtSubscriber.SetBinding(TextBox.TextProperty, txtSubscriberBinding);
}
else if (action == ActionState.Delete)
{
try
{
System.Data.DataRow deleterow = phoneNumbersDataSet.PhoneNumbers.Rows[lstPhones.SelectedIndex];
deleterow.Delete();
tblPhoneNumbersAdapter.Update(phoneNumbersDataSet.PhoneNumbers);
phoneNumbersDataSet.AcceptChanges();
}
catch (System.Data.DataException ex)
{
phoneNumbersDataSet.RejectChanges(); MessageBox.Show(ex.Message);
MessageBox.Show(ex.Message);
}
btnNew.IsEnabled = true;
btnEdit.IsEnabled = true;
btnDelete.IsEnabled = true;
btnSave.IsEnabled = false;
btnCancel.IsEnabled = false;
lstPhones.IsEnabled = true;
btnPrevious.IsEnabled = true;
btnNext.IsEnabled = true;
txtPhoneNumber.IsEnabled = false;
txtSubscriber.IsEnabled = false;
txtPhoneNumber.SetBinding(TextBox.TextProperty, txtPhoneNumberBinding);
txtSubscriber.SetBinding(TextBox.TextProperty, txtSubscriberBinding);
txtContractValue.SetBinding(TextBox.TextProperty, txtContractValueBinding);
txtContractDate.SetBinding(TextBox.TextProperty, txtContractDateBinding);
}
}