internal void savelistviewiptodb(string tablename)
{
if (this.InvokeRequired)
{
deg_savelistviewiptodb addlist = new deg_savelistviewiptodb(savelistviewiptodb);
this.Invoke(addlist,new object[]{tablename});
}
else
{
//READ FROM LISTVIEW
Hashtable[] hash = new Hashtable[listView1.Items.Count];
int y = 0;
string _itemtext = "";
bool _boolconv = false;
try
{
this.Invoke((MethodInvoker)delegate
{
foreach (ListViewItem _itemcc in listView1.Items)
{
var i = y;
ListViewItem _item = _itemcc;
hash[i] = new Hashtable();
hash[i].Add("Valid", _item.ImageIndex);
for (int x2 = 0; x2 < listView1.Columns.Count; x2++)
{
_itemtext = _item.SubItems[x2].Text;
ColumnHeader col = listView1.Columns[x2];
if (!_itemtext.Trim().Equals(String.Empty))
{
if (_itemtext.ToLower().Equals("true") || _itemtext.ToLower().Equals("false"))
{
_boolconv = bool.Parse(_itemtext);
if (_boolconv)
{
hash[i].Add(col.Text, 1);
}
else
{
hash[i].Add(col.Text, 0);
}
}
else
{
if (col.Text.Equals("Speed") || col.Text.Equals("Typeprox")) //col.Text.Equals("Speed") || col.Text.Equals("Typeprox"))
{
try
{
int res = int.Parse(_itemtext);
hash[i].Add(col.Text, res);//col.Text, int.Parse(_itemtext));
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
else
{
hash[i].Add(col.Text, _itemtext);//col.Text, _item.SubItems[x1].Text);
}
}
}
}
y++;
}
});
insertbulk(hash, tablename);
}
catch (System.NullReferenceException ex)
{
Debug.WriteLine(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
internal void savelistviewiptodb(string tablename)
{
if (this.InvokeRequired)
{
deg_savelistviewiptodb addlist = new deg_savelistviewiptodb(savelistviewiptodb);
this.Invoke(addlist, new object[] { tablename });
}
else
{
//READ FROM LISTVIEW
Hashtable[] hash = new Hashtable[listView1.Items.Count];
int y = 0;
string _itemtext = "";
bool _boolconv = false;
try
{
this.Invoke((MethodInvoker) delegate
{
foreach (ListViewItem _itemcc in listView1.Items)
{
var i = y;
ListViewItem _item = _itemcc;
hash[i] = new Hashtable();
hash[i].Add("Valid", _item.ImageIndex);
for (int x2 = 0; x2 < listView1.Columns.Count; x2++)
{
_itemtext = _item.SubItems[x2].Text;
ColumnHeader col = listView1.Columns[x2];
if (!_itemtext.Trim().Equals(String.Empty))
{
if (_itemtext.ToLower().Equals("true") || _itemtext.ToLower().Equals("false"))
{
_boolconv = bool.Parse(_itemtext);
if (_boolconv)
{
hash[i].Add(col.Text, 1);
}
else
{
hash[i].Add(col.Text, 0);
}
}
else
{
if (col.Text.Equals("Speed") || col.Text.Equals("Typeprox")) //col.Text.Equals("Speed") || col.Text.Equals("Typeprox"))
{
try
{
int res = int.Parse(_itemtext);
hash[i].Add(col.Text, res);//col.Text, int.Parse(_itemtext));
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
else
{
hash[i].Add(col.Text, _itemtext);//col.Text, _item.SubItems[x1].Text);
}
}
}
}
y++;
}
});
insertbulk(hash, tablename);
}
catch (System.NullReferenceException ex)
{
Debug.WriteLine(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
