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)); } }