static void Simulate_Capture(ref Inventory_System_API x, int Cicles)
{
int LastCounter = x.GetLastCounter();
Random r = new Random();
int counter = 0;
TicketTag z = new TicketTag();
string[] Contadores = { "AC", "AB", "AC", "JL", "GV", "GH" };
Console.WriteLine("Start Simulate Capture");
while (counter < Cicles)
{
int rTag = r.Next(LastCounter);
z = x.LoadTag(rTag);
try
{
if (!z.Verified)
{
int max = Convert.ToInt32(z.InventoryQuantity);
z.CountQTY = r.Next(max + r.Next(5));
z.ReCountQTY = r.Next(max + r.Next(5));
z.Verified = true;
z.CounterInitials = Contadores[r.Next(Contadores.Count())];
z.CountedDate = DateTime.Now;
x.UpdateTag(z);
counter++;
Console.WriteLine("Ticket Tag Captured: " + rTag.ToString());
}
}
catch
{ }
}
Console.WriteLine("Finish Simulate Capture # of Captured Tags: " + Cicles.ToString());
}
public void Load_Tags_From_SQL(ref Inventory_System_API x, string Location)
{
//SQL DBMNG = new SQL("FSSERV", "FSDBMR", "AmalAdmin", "Amalgamma16");
CAPA_INVContext context = new CAPA_INVContext();
SQL DBMNG = context.DB_MNG_FS;
string JZ = " WHERE (Stockroom NOT IN ('3','5','FG','NO')) ";
string EP = " WHERE (Stockroom IN ('3','5','FG','NO')) ";
string Criteria = "";
DataTable TicketTags = new DataTable();
List <TicketTag> L = new List <TicketTag>();
switch (Location)
{
case "JZ":
{
Criteria = JZ;
break;
}
case "EP":
{
Criteria = EP;
break;
}
default:
{
Criteria = "";
break;
}
}
string _query = @"SELECT * FROM [FSDBMR].[dbo].[_CAP_INV_SYS_TicketCount_Tag] " +
Criteria +
" ORDER BY Stockroom, Bin, ItemNumber";
TicketTags = DBMNG.Execute_Query(_query);
int counter = x.GetLastCounter();
foreach (DataRow R in TicketTags.Rows)
{
L.Add(TicketTagLogic.DataRow2Tag(R));
//x.CreateCountTiket(TicketTagLogic.DataRow2Tag(R));
}
for (int j = 0; j < L.Count; j++)
{
L[j].Counter = counter + j + 1;
x.CreateCountTiket(L[j]);
}
context.Dispose();
}
private void NextTag()
{
Loading_data = true;
_tagNo++;
if (_tagNo <= x.GetLastCounter())
{
tb_TagNo.Text = _tagNo.ToString();
LoadTagInfo(x.LoadTag(_tagNo));
}
else
{
tb_TagNo.Text = x.GetLastCounter().ToString();
_tagNo = x.GetLastCounter();
LoadTagInfo(x.LoadTag(x.GetLastCounter()));
}
Loading_data = false;
}
static void Load_Tags_From_Random(ref Inventory_System_API x, int No_Tags)
{
DataTable TicketTags = new DataTable();
List <TicketTag> L = new List <TicketTag>();
Random r = new Random();
TicketTags.Columns.Add("Counter", typeof(int));
TicketTags.Columns.Add("ItemNumber", typeof(string));
TicketTags.Columns.Add("ItemDescription", typeof(string));
TicketTags.Columns.Add("ItemReference1", typeof(string));
TicketTags.Columns.Add("ItemUM", typeof(string));
TicketTags.Columns.Add("Stockroom", typeof(string));
TicketTags.Columns.Add("Bin", typeof(string));
TicketTags.Columns.Add("InventoryCategory", typeof(string));
TicketTags.Columns.Add("InventoryQuantity", typeof(int));
TicketTags.Columns.Add("LotNumber", typeof(string));
string[] SKT = { "FG", "JZ", "3", "J", "NO" };
string[] BIN = { "01", "02", "03", "04", "05", "NORTH", "BIN", "B", "QC", "J01", "NORTH" };
string[] IC = { "O", "H", "I" };
int last_tag = x.GetLastCounter();
for (int i = 1; i < No_Tags; i++)
{
TicketTags.Rows.Add(i + last_tag, "201100", "Test Part", "87", "EA"
, SKT[r.Next(0, SKT.Count())]
, BIN[r.Next(0, BIN.Count())]
, IC[r.Next(0, IC.Count())]
, r.Next(1, 512)
, "TestLot-" + r.Next(1, 365).ToString());
}
foreach (DataRow R in TicketTags.Rows)
{
L.Add(TicketTagLogic.DataRow2Tag(R));
}
for (int j = 0; j < L.Count; j++)
{
x.CreateCountTiket(L[j]);
}
}
