public static System.Data.DataTable ToDataTable <T>(this IEnumerable <T> collection)
{
System.Data.DataTable dt = new System.Data.DataTable();
Type t = typeof(T);
System.Reflection.PropertyInfo[] pia = t.GetProperties();
//Create the columns in the DataTable
foreach (System.Reflection.PropertyInfo pi in pia)
{
if ((pi.PropertyType.IsGenericType))
{
Type typeOfColumn = pi.PropertyType.GetGenericArguments()[0];
dt.Columns.Add(pi.Name, typeOfColumn);
}
else
{
dt.Columns.Add(pi.Name, pi.PropertyType);
}
}
//Populate the table
foreach (T item in collection)
{
System.Data.DataRow dr = dt.NewRow();
dr.BeginEdit();
foreach (System.Reflection.PropertyInfo pi in pia)
{
dr[pi.Name] = pi.GetValue(item, null);
}
dr.EndEdit();
dt.Rows.Add(dr);
}
return(dt);
}
private void cboSelectedIndex(object sender, System.EventArgs e)
{
System.Data.DataRow dr = _contacto.ListaClientes.Rows.Find(grdCliente[grdCliente.CurrentRowIndex, 0]);
if (dr != null)
{
dr.BeginEdit();
dr["TipoContacto"] = ((ComboBox)sender).SelectedValue;
dr["TipoContactoDescripcion"] = ((ComboBox)sender).Text;
dr.EndEdit();
}
}
private void cboSelectedIndex(object sender, System.EventArgs e)
{
System.Data.DataRow dr = _asignacion.ListaCobradores.Rows.Find(grdListaCobradores[grdListaCobradores.CurrentRowIndex, 0]);
if ((dr != null) &&
(Convert.ToInt32(dr["EmpleadoResguardo"]) != Convert.ToInt32(((ComboBox)sender).SelectedValue)))
{
dr.BeginEdit();
dr["EmpleadoResguardo"] = ((ComboBox)sender).SelectedValue;
dr["EmpleadoResguardoNombre"] = ((ComboBox)sender).Text;
dr.EndEdit();
}
}
/// <summary>
/// the operation target is to update constantly the Using: box
// its done by an infinite thread that requires the Ip from the server
/// </summary>
public void UpdateUsingTB()
{
while (true)
{
bool ok = true;
System.Threading.Thread.Sleep(100000);
this.Form_1.button1.Click += new EventHandler(this.slep);
this.Wriite(IPC + ":Get Total Using");
string info = this.Reead();
if (info == "New client arrives")
{
this.NewClient();
ok = false;
}
if (ok)
{
string EqualltyCheck = info.Substring(0, this.IPC.Length);
if (EqualltyCheck.Equals(this.IPC))
{
this.Form_1.Invoke(new MethodInvoker(delegate()
{
this.Form_1.TUsingBox.Text = info.Substring(this.IPC.Length + 1);
}));
}
if (!(EqualltyCheck.Equals(this.IPC)))
{
int Ipin = info.IndexOf(':') + 1;
string Ipn = info.Substring(0, Ipin);
string Datta = info.Substring(Ipin);
int Parami = Datta.IndexOf(':');
string Parmat = Datta.Substring(0, Parami);
this.Form_1.Invoke(new MethodInvoker(delegate()
{
this.IPC = Convert.ToString(this.Form_1.Clients.SelectedItem);
System.Data.DataRow copyingvaluesRow = this.computersBasicDDataSet.Basic_Table.Rows.Find(Ipn);
copyingvaluesRow.BeginEdit();
this.Form_1.TUsingBox.Text = Convert.ToString(copyingvaluesRow[Parmat]);
copyingvaluesRow[Parmat] = Datta;
}));
}
}
this.Form_1.button1.Click += new EventHandler(this.slep);
}
}
public virtual void ImportXls(System.Data.DataTable dt)
{
int rowcnt = 1;
string keyfield = dt.Columns[0].Caption;
Object[,] data = readCell(1, ++rowcnt, dt.Columns.Count);
string tmp = "";
while (data[1, 1] != null)
{
tmp += data[1, 1].ToString() + "{}";
System.Data.DataRow[] dr = dt.Select(keyfield + "='" + data[1, 1].ToString() + "'");
if (dr != null && dr.Length > 0)
{
dr[0].BeginEdit();
for (int i = 0; i < data.GetUpperBound(1); i++)
{
if (data[1, i + 1] != null)
{
dr[0][i] = data[1, i + 1];
}
}
dr[0].EndEdit();
}
else
{
System.Data.DataRow r = dt.NewRow();
r.BeginEdit();
for (int i = 0; i < data.GetUpperBound(1); i++)
{
if (data[1, i + 1] != null)
{
r[i] = data[1, i + 1];
}
}
r.EndEdit();
dt.Rows.Add(r);
}
data = readCell(1, ++rowcnt, dt.Columns.Count);
}
}
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);
}
}
