bool CheckForMultiStock(string itemno,string itemname)
{
var bl = new BLSales();
var drstock = new BLSales().GetStockItem(itemno, "S");
var dprice = bl.GetDisctinctSprices(drstock);
int cnt = dprice.Count();
var stk = new DsInventory.STOCKMASTERDataTable();
// var topRows = drstock.AsEnumerable().OrderBy(o => o.Field<int>("STOCKID")).Take(1).ToList().CopyToDataTable();
DataTable topRows = drstock.Rows.Cast<DataRow>().Take(1).CopyToDataTable();
// object[] topRows = drstock.Select( * ", "EXPDATE ASC ");
DataRow dr = stk.NewRow();
foreach (DataRow drs in topRows.Rows)
{
drs["DQNTY"] = 1;
dr.ItemArray = drs.ItemArray;
}
stk.Rows.Add(dr);
AddMultipleItems(stk, itemname);
if (cnt > 1)
{
onePing();
lblmutilpleprice.Visible = true;
gridControl2.DataSource = drstock;
}
return cnt > 0;
}
void DoReturn(DataRow d,bool frmstock=false)
{
_isreturn = true;
// var sprice = 0m;
_validateoff = true;
var dt = new DsInventory.STOCKMASTERDataTable();
var dr = (DsInventory.STOCKMASTERRow) dt.NewRow();
dr.SPRICE = decimal.Parse(d["SPRICE"].ToString());
dr.ITEMNO = d["ITEMNO"].ToString();
dr.BARCODE = d["BARCODE"].ToString();
dr.DISC = 0;
if (frmstock)
{
dr.QTY = int.Parse(d["QTY"].ToString());
dr.DQNTY = int.Parse(d["QTY"].ToString());
if (!string.IsNullOrEmpty(d["DISC"].ToString()))
{
if (decimal.Parse(d["DISC"].ToString()) > 0)
{
dr.DISC = decimal.Parse(d["DISC"].ToString());
}
}
}
else
{
dr.DQNTY = 1;
dr.QTY = 1;
}
// dr.INVRATE = sprice; // dr.SPRICE = sprice;
dr.STOCKID = frmstock ? int.Parse(d["STOCKID"].ToString()) : 0;
dr.CPRICE = !string.IsNullOrEmpty(d["CPRICE"].ToString()) ? decimal.Parse(d["CPRICE"].ToString()) : 0;
dr.COMPANY = VIRETAILDAL.COMMON.Utils.Company;
dt.Rows.Add(dr);
AddMultipleItems(dt,d["ITEMNAME"].ToString());
_isreturn = false;
}
private void FetchServerData()
{
tranids = string.Empty;
progressPanel1.Visible = true;
Application.DoEvents();
_dsdownload.Clear();
string cnstr = new SqlAsyncConnectionString(6, true);
// string _syncConstr = new SqlAsyncConnectionString(6, true);
if (Utils.Company == "01" || Utils.Company == "00")
{
cnstr = Utils.ConnectionstringSync;//_constr = VIRETAILDAL.COMMON.Utils.Connectionstring;
}
var bl = new ItemDownLoadDataManager();
try
{
string maxtran = new Blitemmove().GetMaxTranid();
_negativestockmaster = bl.GetNegativeStock();
bl.GetServerData(ref _ds, cnstr, maxtran);
if (DoStartPusingData(true))
{
////////new RemoteSync().UpDateRemoteTransferMain(_ds.ITEMTRANSFERMAIN);
XtraMessageBox.Show("Down load finish", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString());
}
}
