bool DoUpdateSupplier(string sql, OleDbConnection con)
{
progressPanel1.Visible = true;
try
{
var ds = new DataSet();
var ta = new OleDbDataAdapter(sql, con);
ta.Fill(ds);
var dsMaster = new DsMaster();
dsMaster.Merge(new DataManager().GetSupplierList());
int cnt = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
cnt++;
var row = dsMaster.SUPPLIER.FindBySUPPLIERNO(dr["ACCNO"].ToString());
if (row == null)
{
Application.DoEvents();
var newrow = dsMaster.SUPPLIER.NewRow();
newrow["SUPPLIERNO"] = dr["ACCNO"].ToString();
newrow["SUPPLIERNAME"] = dr["ACCNAME"].ToString();
// newrow["ALTERNATENAME"] = dr["ALTERNATENAME"].ToString();
newrow["CONTACT"] = dr["CONTACT"].ToString();
newrow["ADDRESS"] = dr["ADDRESS"].ToString();
newrow["PHONE"] = dr["TEL1"].ToString();
// newrow["FAX"] = dr["FAX"].ToString();
newrow["CREDITLIMIT"] = dr["CRLMT"] ?? 0;
newrow["DUEDAYS"] = dr["DDAY"] ?? 0;
dsMaster.SUPPLIER.Rows.Add(newrow);
}
}
label1.Text = cnt.ToString();
return new DataManager().UpdateSupplier(dsMaster.SUPPLIER);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return false;
}
bool DoCreateItemMast(string sql,OleDbConnection con)
{
progressPanel1.Visible = true;
try
{
var ds = new DataSet();
var ta = new OleDbDataAdapter(sql, con);
ta.Fill(ds);
var dsMaster = new DsMaster();
dsMaster.Merge(new ItemMaster().GetItemMastList());
int cnt = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
cnt++;
var nrow = dsMaster.ITEMMAST.FindByITEMNO(dr["DCODE"].ToString());
if (nrow == null)
{
Application.DoEvents();
var row = dsMaster.ITEMMAST.NewRow();
row["Itemno"] = dr["DCODE"];
row["ITEMTYPE"]=1;
row["SUPPLIERNO"] = dr["ACCNO"];
row["BARCODE"] = dr["BARCD"];
row["ITEMNAME"] = dr["DNAME"];
row["GROUPID"] = int.Parse(dr["ITYPE"].ToString());
row["DISCOUNT"] = dr["STAX"] ?? 0;
row["EXPDATEREQ"] = dr["EXPIRY"];
row["sPRICE"] = dr["SPRICE"];
row["CPRICE"] = dr["CPRICE"];
row["MINQTY"] = dr["MINQTY"];
row["REORDER"] = dr["MINQTY"];
row["SEL"] = 0;
row["DISCONSALE"] = 0;
dsMaster.ITEMMAST.Rows.Add(row);
}
else
{
nrow["SUPPLIERNO"] = dr["ACCNO"];
nrow["ITEMTYPE"] = 1;
nrow["DISCOUNT"] = dr["STAX"] ?? 0;
}
}
label1.Text = cnt.ToString();
return new ItemMaster().UpdateItems(dsMaster.ITEMMAST);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return false;
}
