private void SaveToCSV(CycleLineItem item)
{
string fileName = AppDomain.CurrentDomain.BaseDirectory + @"\data\CycleCount_" + DateTime.Now.ToString("ddMMyyyy") + ".csv";
if (!File.Exists(fileName))
{
String header = "PartNumber,PartDescription,Location,Qty,QtyCommitted,UOM,Date,Note,Customer,Tracking-Lot Number,Tracking-Revision Level,Tracking-Expiration Date" + Environment.NewLine;
File.WriteAllText(fileName, header);
}
String sw = item.PartNumber + "," + item.PartDescription + "," + item.Location + "," + item.Qty + "," + item.QtyCommitted + "," + item.UOM + "," + item.Date + "," + item.Note + "," + item.Customer + "," + item.TrackingLotNumber + "," + item.TrackingRevisionLevel + "," + item.TrackingExpirationDate + Environment.NewLine;
File.AppendAllText(fileName, sw);
}
private void CycleCount(out bool cancel)
{
CycleLineItem item = new CycleLineItem();
cancel = false;
bool finish = false;
Location location = null;
String partNo = null;
int qty = 0;
String trackingNo = null;
Dictionary <String, int> PartList = new Dictionary <string, int>();
while (!cancel && !finish)
{
bool isReady = location != null && !String.IsNullOrEmpty(partNo) && qty > 0 && !String.IsNullOrEmpty(trackingNo);
C.CL();
C.WL("Cycle Count");
C.WL("Location: " + (location?.Name ?? "NONE"));
C.WL("Part: " + (partNo ?? "NONE"));
C.WL("Qty: " + ((qty > 0) ? qty : 0));
C.WL("Tracking: " + (trackingNo ?? "NONE"));
C.WL("F1=Exit" + (isReady ? "F2=Count" : ""));
if (location == null)
{/*
* C.WL("Location:");
* location = LocationUtils.captureDisplayLocation(api, C.getString(out cancel));
* continue;
*/
C.WL("Location:");
String scan = C.getString(out cancel);
if (cancel)
{
var yn = C.YN("Are you sure? Exiting.");
cancel = yn;
continue;
}
if (!String.IsNullOrWhiteSpace(scan))
{
string query = "select tag.num from tag join location on location.id = tag.locationid and tag.typeid = 10 where location.name like @lcn";
int locValue = db.Query <Int32>(query, new { lcn = scan }).First();
location = LocationUtils.captureDisplayLocation(api, Convert.ToString(locValue));
continue;
}
}
if (String.IsNullOrEmpty(partNo))
{
ConsoleKey?fnKey;
C.WL("Part #:");
String scan = C.getStringFinishableFunctions(out cancel, out finish, out fnKey);
if (cancel)
{
var yn = C.YN("Are you sure? Exiting.");
cancel = yn;
continue;
}
else if (finish)
{
var yn = C.YN("Are you sure? Finishing.");
finish = yn;
continue;
}
else if (fnKey.HasValue)
{
}
else if (!String.IsNullOrWhiteSpace(scan))
{
var part = ic.Find(scan);
if (part != null)
{
partNo = part.PARTNUMBER;
}
else
{
C.A("Part# Not Found");
continue;
}
}
else
{
C.A("Scan Error");
continue;
}
}
if (qty == 0)
{
ConsoleKey?fnKey;
C.WL("Qty :");
String scan = C.getStringFinishableFunctions(out cancel, out finish, out fnKey);
if (cancel)
{
var yn = C.YN("Are you sure? Exiting.");
cancel = yn;
continue;
}
else if (finish)
{
var yn = C.YN("Are you sure? Exiting.");
finish = yn;
continue;
}
else if (fnKey.HasValue)
{
}
else if (!String.IsNullOrWhiteSpace(scan))
{
var QTY = scan;
if (QTY != null)
{
qty = Int32.Parse(QTY);
}
else
{
C.A("Invalid Qty");
}
}
else
{
C.A("Entry Error");
}
}
if (String.IsNullOrEmpty(trackingNo))
{
ConsoleKey?fnKey;
C.WL("Tracking :");
String scan = C.getStringFinishableFunctions(out cancel, out finish, out fnKey);
if (cancel)
{
var yn = C.YN("Are you sure? Exiting.");
cancel = yn;
continue;
}
else if (finish)
{
var yn = C.YN("Are you sure? Exiting.");
finish = yn;
continue;
}
else if (fnKey.HasValue)
{
}
else if (!String.IsNullOrWhiteSpace(scan))
{
var track = scan;
if (track != null)
{
trackingNo = track;
}
else
{
C.A("Invalid Tracking No.");
}
}
else
{
C.A("Entry Error");
}
}
if (isReady)
{
PartGetRsType rq = api.getPart(partNo);
if (rq.statusCode == "1000")
{
item.PartNumber = partNo;
item.Location = location.Name;
item.Qty = Convert.ToString(qty);
item.PartDescription = rq.Part.Description;
item.UOM = rq.Part.UOM.Name;
item.TrackingLotNumber = trackingNo;
SaveToCSV(item);
location = null;
partNo = null;
trackingNo = null;
qty = 0;
}
return;
}
}
}