public void Export(data.dsMain.tItemTypeDataTable typesTable)
{
long type = 0;
var q = typesTable.Where(r => r.FOTypeId == Type);
if (q.Count() > 0)
{
type = q.First().TypeId;
}
data.dsMainTableAdapters.TableAdapterManager ta = new AuctionAdminMK2.data.dsMainTableAdapters.TableAdapterManager();
ta.Init();
ta.Connection.Open();
ta.tItemProtoTableAdapter.Insert(ProtoId, ProtoName, ProtoDescription, Alias, type);
int newId = (int)(ta.tItemProtoTableAdapter.GetLastInsertedId());
ta.tLotsTableAdapter.UpdateLotsNewProto(newId, ProtoId);
ta.tItemProtoTableAdapter.DeleteByPidFiltered(ProtoId, newId);
ta.Connection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Подтвердите экспорт списка в базу данных.", "Экспорт", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
data.dsMain ds = new AuctionAdminMK2.data.dsMain();
data.dsMainTableAdapters.TableAdapterManager ta = new AuctionAdminMK2.data.dsMainTableAdapters.TableAdapterManager();
ta.Init();
ta.tItemTypeTableAdapter.Fill(ds.tItemType);
var q = (this.cm.DataSource as List <Fonline.FOProtoItem>);
fBase f = this.MdiParent as fBase;
int c = 0;
int l = q.Count();
f.ProgressBar.Maximum = q.Count();
f.ProgressBar.Value = 0;
foreach (var i in q)
{
c++;
if (f != null)
{
f.ProgressBar.Value = c;
f.StatusLabel.Text = string.Format("Обработка записи {0} из {1}", c, l);
Application.DoEvents();
}
i.Export(ds.tItemType);
}
if (f != null)
{
f.ProgressBar.Value = 0;
f.StatusLabel.Text = "Выполнено";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
