private void SaveDataOcr(OcrDataDto dto)
{
//string sql = string.Format("SET SQL_SAFE_UPDATES = 0;insert INTO ocr_data(Id, InvoiceNumber, InvoiceDate, DeliveryAddress, TotalAmount, Company, ListData, CreatedTime) VALUES(uuid(), @InvoiceNumber, @InvoiceDate, @DeliveryAddress, @TotalAmount, @Company, @ListData, NOW());SET SQL_SAFE_UPDATES = 1;", dto.InvoiceNumber, dto.InvoiceDate, dto.DeliveryAddress, dto.TotalAmount, dto.Company, dto.ListData);
if (dto.Id == Guid.Empty)
{
string sql = string.Format("SET SQL_SAFE_UPDATES = 0;insert INTO ocr_data(Id, InvoiceNumber, InvoiceDate, DeliveryAddress, TotalAmount, Company, ListData, CreatedTime) VALUES(uuid(),'{0}','{1}','{2}','{3}','{4}','{5}', NOW());SET SQL_SAFE_UPDATES = 1;", dto.InvoiceNumber, dto.InvoiceDate, dto.DeliveryAddress, dto.TotalAmount, dto.Company, dto.ListData);
MySqlConnection myCon = new MySqlConnection(ConfigurationManager.ConnectionStrings[Configs.Instance.ConnectionString].ToString());
myCon.Open();
MySqlCommand mysqlcom = new MySqlCommand(sql, myCon);
mysqlcom.ExecuteNonQuery();
mysqlcom.Dispose();
myCon.Close();
myCon.Dispose();
}
else
{
string sql = string.Format("SET SQL_SAFE_UPDATES = 0;update ocr_data set InvoiceNumber='{0}', InvoiceDate='{1}', DeliveryAddress='{2}', TotalAmount='{3}', Company='{4}', ListData='{5}' where Id='{6}';SET SQL_SAFE_UPDATES = 1;", dto.InvoiceNumber, dto.InvoiceDate, dto.DeliveryAddress, dto.TotalAmount, dto.Company, dto.ListData, dto.Id);
MySqlConnection myCon = new MySqlConnection(ConfigurationManager.ConnectionStrings[Configs.Instance.ConnectionString].ToString());
myCon.Open();
MySqlCommand mysqlcom = new MySqlCommand(sql, myCon);
mysqlcom.ExecuteNonQuery();
mysqlcom.Dispose();
myCon.Close();
myCon.Dispose();
}
}
public ActionResult SaveOcr(OcrDataModel model)
{
OcrDataService ocrDataService = new OcrDataService();
OcrDataDto dto = new OcrDataDto();
dto.Company = model.Company;
dto.DeliveryAddress = model.DeliveryAddress;
dto.InvoiceDate = model.InvoiceDate;
dto.InvoiceNumber = model.InvoiceNumber;
dto.TotalAmount = model.TotalAmount;
dto.ListData = model.ListData;
if (!string.IsNullOrEmpty(model.Id))
{
dto.Id = Guid.Parse(model.Id);
}
try
{
SaveDataOcr(dto);
}
catch (Exception ex)
{
}
return(Success());
}
public ActionResult Add(Guid?Id)
{
ViewBag.ListGo = Id != null;
if (Id == null)
{
OcrDataDto dto = new OcrDataDto();
return(View(dto));
}
else
{
OcrDataService ocrDataService = new OcrDataService();
var model = ocrDataService.GetOcrDataById(Id.Value);
return(View(model));
}
}
