public HttpResponseMessage PrintReceipt(PrintReceiptModel model)
{
ResponseStatus response = new ResponseStatus();
try
{
if (ModelState.IsValid)
{
var data = _repository.PrintReceipt(model);
if (data.OrderId > 0)
{
response.serverResponseTime = System.DateTime.Now;
response.isSuccess = true;
return(Request.CreateResponse(HttpStatusCode.OK, new { data, response }));
}
else
{
response.serverResponseTime = System.DateTime.Now;
response.isSuccess = false;
return(Request.CreateResponse(HttpStatusCode.BadRequest, new { response }));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something Worng !"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something Worng !", ex));
}
}
public DataSet PrintReceipt(PrintReceiptModel model)
{
if (model.IsReprinted)
{
printLogRepository.Create(model);
}
var serverDataSet = new DataSet();
serverDataSet.EnforceConstraints = false;
serverDataSet.Tables.Add(new DataTable(nameof(dbContext.SaleTransactions)));
serverDataSet.Tables.Add(new DataTable(nameof(dbContext.PurchaseTransactions)));
using (var sqlConn = new SqlConnection(dbContext.Database.GetDbConnection().ConnectionString))
{
var query = string.Empty;
var sa = new SqlDataAdapter();
query = dbContext.SaleTransactions
.Where(a => a.SaleId == model.TransactionId).ToQueryString();
sa = new SqlDataAdapter(query.ToString(), sqlConn);
sa.Fill(serverDataSet, nameof(dbContext.SaleTransactions));
sa.Dispose();
query = $"SELECT {model.TransactionId} AS PurchaseId";
sa = new SqlDataAdapter(query.ToString(), sqlConn);
sa.Fill(serverDataSet, nameof(dbContext.PurchaseTransactions));
sa.Dispose();
query = null;
}
return(serverDataSet);
}
public PrintLog Create(PrintReceiptModel model)
{
var transaction = dbContext.Database.BeginTransaction();
try
{
var table = model.TransactionTypeCode == "I" ? "PurchaseTransactions" : "SaleTransactions";
var colName = model.TransactionTypeCode == "I" ? "PurchaseId" : "SaleId";
var qry = $"UPDATE {table} SET {nameof(PurchaseTransaction.PrintCount)} = " +
$"{nameof(PurchaseTransaction.PrintCount)}+1 WHERE {colName} ={model.TransactionId}";
dbContext.Database.ExecuteSqlRaw(qry);
var printLog = new PrintLog()
{
DTPrinted = DateTime.Now,
TransactionId = model.TransactionId,
TransactionTypeCode = model.TransactionTypeCode,
PrintReasons = model.ReprintRemarks,
ReceiptNum = model.ReceiptNum,
UserAccountId = model.UserAccoountId,
UserAccountName = model.UserFullName
};
dbContext.PrintLogs.Add(printLog);
dbContext.SaveChanges();
transaction.Commit();
return(printLog);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
public IActionResult PrintReceipt([FromRoute] long id, [FromBody] PrintReceiptModel model)
{
try
{
var result = repository.PrintReceipt(model);
return(Ok(result));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
DataSet ITransDbRepository <Inyard> .PrintReceipt(PrintReceiptModel model) => throw new NotImplementedException();
public void PrintReceipt(PrintReceiptModel model)
{
throw new NotImplementedException();
}