private void btnSave_Click(object sender, EventArgs e)
{
//save to db
if (string.IsNullOrEmpty(txtToFind.Text))
{
return;
}
var allOcr = string.Empty;
foreach (var ocr in Global.OcrLines)
{
allOcr += ocr.Content + "^`^";
}
var receipt = (Receipt)receiptBindingSource.Current;
receipt.OcrLines = allOcr;
using (MyReceiptOnlyContext db = new MyReceiptOnlyContext())
{
db.TableReceipts.Add(receipt);
db.SaveChanges();
}
//if (chkDelImage.Checked)
//{
// FileInfo current = (FileInfo)bindingSource1.Current;
// var fname = current.FullName;// context.GetValue(FilePath);
// File.Delete(fname);
// Global.LogWarn("File Deleted..." + fname);
//}
}
private void btnLoad_Click(object sender, EventArgs e)
{
using (MyReceiptOnlyContext db = new MyReceiptOnlyContext())
{
var q = db.TableReceipts.Where(r => r.UserFolder == txtCurrentUser.Text);
var list = q.OrderBy(r => r.Created).ToList();
this.bindingSourceCSV.DataSource = list;
dgCSV.DataSource = bindingSourceCSV;
this.bindingNavigatorCSV.BindingSource = bindingSourceCSV;
}
}
private void btnUserSet_Click(object sender, EventArgs e)
{
WaitForReady();
SetStatus(ProcessStatus.Election);
List <Receipt> table = new List <Receipt>();
//string user = Path.GetFileName(Global.CurrentUserFolder);
var current = Global.CurrentReciept;
var tinId = current.Tax_Identification;
tinId = RocsTextService.RefineToPureNumber(tinId);
using (MyReceiptOnlyContext db = new MyReceiptOnlyContext())
{
var q = db.TableReceiptFixes.Where(r => r.UserFolder == Global.CurrentUser &&
r.Modified.HasValue);
List <ReceiptFix> listR = new List <ReceiptFix>();
foreach (var r in q)
{
// && RocsTextService.RefineToPureNumber(r.Tax_Identification) == tinId
if (RocsTextService.RefineToPureNumber(r.Tax_Identification) == tinId)
{
listR.Add(r);
}
}
if (listR.Count > 0)
{
var setting = listR.OrderByDescending(r => r.Modified).ToList().FirstOrDefault();
if (setting.Id > 0)
{
current.Address = setting.Address;
current.Comapany_Name = setting.Comapany_Name;
current.Description = setting.Description;
}
Global.CurrentReciept = current;
}
}
table.Add(Global.CurrentReciept);
receiptBindingSource.DataSource = table;
dgReceipts.DataSource = receiptBindingSource;
this.bindingNavigatorReceipts.BindingSource = receiptBindingSource;
SetStatus(ProcessStatus.Ready);
}
private void btnClearDb_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to clear all records in the database?", "Confirm Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (MyReceiptOnlyContext db = new MyReceiptOnlyContext())
{
db.Database.ExecuteSqlCommand("DELETE FROM [Receipts]");
var q = db.TableReceipts.Where(r => r.UserFolder == Global.CurrentUser);
var list = q.OrderByDescending(r => r.Date).ToList();
this.bindingSourceCSV.DataSource = list;
dgCSV.DataSource = bindingSourceCSV;
this.bindingNavigatorCSV.BindingSource = bindingSourceCSV;
}
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
string csvName = "receipt";
using (MyReceiptOnlyContext db = new MyReceiptOnlyContext())
{
var q = db.TableReceipts.Where(r => r.UserFolder == Global.CurrentUser);
var list = q.OrderBy(r => r.Created).ToList();
if (list.Count > 0)
{
var cnt = list.Count;
csvName += cnt.ToString();
}
this.bindingSourceCSV.DataSource = list;
dgCSV.DataSource = bindingSourceCSV;
this.bindingNavigatorCSV.BindingSource = bindingSourceCSV;
}
//export to csv
var folder = Global.Config.GetValue("FrontFolder") + "\\" + Global.CurrentUser; //Global.CurrentUserFolder;
var file = csvName + ".csv";
var path = Path.Combine(folder, file);
SaveDataGridViewToCSV(path);
var stat = BaiRocService.GetEngineStat();
if (stat.Value >= stat.MaxValue)
{
stat.Status = "Idle";
stat.LastBatchCount = stat.MaxValue;
stat.TotalConvert += stat.MaxValue;
stat.MaxValue = 0;
stat.Value = 0;
BaiRocService.UpdateEngine(stat);
}
}
