void SaveCSVLocation(string filename, IGLNLocation iGLNLocation)
{
var reader = new StreamReader(filename);
var content = reader.ReadToEnd();
reader.Close();
char[] splitParams = new char[] { '\r', '\n' };
string[] rows = content.Split(splitParams, StringSplitOptions.RemoveEmptyEntries);
var newRow = string.Empty;
var oldRow = string.Empty;
foreach (string row in rows)
{
if (row.Contains(iGLNLocation.GLN))
{
oldRow = row;
newRow = Regex.Replace(row, "False", "True", RegexOptions.IgnoreCase);
break;
}
}
if (newRow != string.Empty && oldRow != string.Empty)
{
content = Regex.Replace(content, oldRow, newRow);
}
var writer = new StreamWriter(filename);
writer.Write(content);
writer.Close();
}
public void SaveLocation(string filename, IGLNLocation iGLNLocation)
{
if (filename.Contains(".csv"))
{
SaveCSVLocation(filename, iGLNLocation);
}
else if (filename.Contains(".xlsx"))
{
SaveXLSLocation(filename, iGLNLocation);
}
}
void SaveXLSLocation(string filename, IGLNLocation iGLNLocation)
{
var stream = File.Open(filename, FileMode.Open, FileAccess.ReadWrite);
IExcelDataReader excelReader;
if (filename.Contains(".xlsx"))
{
excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
}
stream.Close();
excelReader.IsFirstRowAsColumnNames = true;
var dataset = excelReader.AsDataSet();
var rowCollection = dataset.Tables[0].Rows;
foreach (DataRow row in rowCollection)
{
if (row[11].ToString().Contains(iGLNLocation.GLN))
{
var printed = (string)row[13];
printed = Regex.Replace(printed, "False", "True", RegexOptions.IgnoreCase);
row[13] = printed;
break;
}
}
try
{
if (File.Exists(filename))
{
File.Delete(filename);
}
stream = File.Open(filename, FileMode.Create, FileAccess.ReadWrite);
using (SpreadsheetDocument document = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook))
ExcelFunctions.WriteExcelFile(dataset, document);
stream.Close();
}
catch (Exception ex)
{
// call LogFile method and pass argument as Exception message, event name, control name, error line number, current form name
// LogFile(ex.Message + " :6", ex.ToString(), MethodBase.GetCurrentMethod().Name, ExceptionHelper.LineNumber(ex), GetType().Name);
}
}
public async void SaveFile(string filename, IGLNLocation location)
{
try
{
AndHUD.Shared.Show(this, "Updating...", -1, MaskType.Black);
await Task.Factory.StartNew(() =>
fileUtility.SaveLocation(filename, location));
AndHUD.Shared.Dismiss(this);
}
catch (Exception ex)
{
// call LogFile method and pass argument as Exception message, event name, control name, error line number, current form name
fileUtility.LogFile(ex.Message, ex.ToString(), MethodBase.GetCurrentMethod().Name, ExceptionHelper.LineNumber(ex), GetType().Name);
}
}
string GetZplGLNLabel(IGLNLocation location, int position)
{
var zpl =
@"^XA" + "\r\n" +
@"^MMT" + "\r\n" +
@"^PW601" + "\r\n" +
@"^LL0406" + "\r\n" +
@"^LS0" + "\r\n";
if (location == null)
{
zpl +=
@"^BY3,3,230^FT508,109^BCI,,N,N^FD>;>8414" + "1234567890123" + "^FS" + "\r\n" +
@"^FT441,71^A0I,34,33^FB276,1,0,C^FH\^FD(414)" + "1234567890123" + "\r\n";
}
else
{
if (locationList[position].Region == "ROYAL CORNWALL HOSPITALS NHS TRUST")
{
// Royal Cornwall want the room code above the barcode
zpl +=
@"^FT591,340^A0I,54,52^FD" + "Room Number:" + locationList[position].Code + "^FS" + "\r\n" +
@"^BY3,3,230^FT508,89^BCI,,N,N^FD>;>8414" + locationList[position].GLN + "^FS" + "\r\n" +
@"^FT441,41^A0I,34,33^FB276,1,0,C^FH\^FD(414)" + locationList[position].GLN + "\r\n";
// @"^FT591,360^A0I,40,39^FD" + "Room Number:" + locationList[currentSelected].Code + "^FS" + "\r\n" +
// @"^BY3,3,230^FT508,109^BCI,,N,N^FD>;>8414" + locationList[currentSelected].GLN + "^FS" + "\r\n" +
// @"^FT441,71^A0I,34,33^FB276,1,0,C^FH\^FD(414)" + locationList[currentSelected].GLN + "\r\n";
}
else
{
zpl +=
@"^BY3,3,230^FT508,109^BCI,,N,N^FD>;>8414" + locationList[position].GLN + "^FS" + "\r\n" +
@"^FT441,71^A0I,34,33^FB276,1,0,C^FH\^FD(414)" + locationList[position].GLN + "\r\n";
}
}
zpl += @"^PQ" + printQuantity + ",0,1,Y^XZ" + "\r\n";
return(zpl);
}
void SaveLocations(string filename, IGLNLocation location)
{
fileUtility.SaveLocation(filename, location);
}