public VarlikResult ApproveFromBankAdmin(long idMainOrder, string idTransactionState)
{
var result = new VarlikResult();
using (var ctx = new VarlikContext())
{
var data = ctx.MainOrderLog
.FirstOrDefault(l => l.Id == idMainOrder &&
l.IdTransactionState != TransactionStateEnum.Completed &&
l.IdTransactionType == TransactionTypeEnum.FromBank);
if (idTransactionState == TransactionStateEnum.Completed)
{
if (data != null)
{
data.IdTransactionState = TransactionStateEnum.Completed;
data.TransactionDate = DateTime.Now;
var order = ctx.UserCoinTransactionOrder
.FirstOrDefault(l => l.IdMainOrderLog == idMainOrder &&
l.IdTransactionState != TransactionStateEnum.Completed &&
l.IdTransactionType == TransactionTypeEnum.FromBank);
if (order != null)
{
ctx.UserCoinTransactionOrder.Remove(order);
}
//write tx log
var tx = new UserTransactionLog()
{
MoneyAmount = data.MoneyAmount,
IdTransactionState = TransactionStateEnum.Completed,
IdTransactionType = TransactionTypeEnum.FromBank,
TransactionDate = data.TransactionDate.Value,
IsSucces = true,
IdUser = data.IdUser,
IdMainOrderLog = idMainOrder
};
ctx.UserCoinTransactionLog.Add(tx);
try
{
ctx.SaveChanges();
result.Success();
}
catch (Exception e)
{
Log.Error("ApproveFromBankAdmin", e);
}
}
}
}
return(result);
}
public IList <UserTransactionLog> Select(UserTransactionLog data)
{
IList <UserTransactionLog> datos = new List <UserTransactionLog>();
datos = GetHsql(data).List <UserTransactionLog>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public void OnAuthorization(AuthorizationFilterContext context)
{
try
{
var userAgent = Accessor.HttpContext.Request.Headers["User-Agent"];
string uaString = Convert.ToString(userAgent[0]);
var uaParser = Parser.GetDefault();
ClientInfo c = uaParser.Parse(uaString);
var devicetype = c.Device.Family;
string userId = context.HttpContext.Session.GetString("userid");
string userIpAddress = Accessor.HttpContext.Connection.RemoteIpAddress.ToString();
var userTranLog = new UserTransactionLog();
userTranLog.userid = Accessor.HttpContext.Session.GetString("userid");
//userLoging.userid = Accessor.HttpContext.Session.GetString("userid");
var controllerActionDescriptor = context.ActionDescriptor as ControllerActionDescriptor;
string controller = controllerActionDescriptor?.ControllerName;
//string CommandType = controllerActionDescriptor?.;
//var action = filterContext.ActionDescriptor;
var action = controllerActionDescriptor?.ActionName;
userTranLog.WebLink = Accessor.HttpContext.Request.Headers["Url"];// .AbsolutePath;
//userTranLog.TransactionStatement = TransactionStatement;
//userTranLog.CommandType = commandType;
userTranLog.FromDateTime = DateTime.Now;
userTranLog.ToDateTime = DateTime.Now;
userTranLog.IPAddress = userIpAddress;//request.UserHostName;// request.UserHostAddress;
userTranLog.comid = Accessor.HttpContext.Session.GetString("comid");
userTranLog.ControllerName = controller;
userTranLog.ActionName = action;
//userTranLog.FlagValue = TransactionalId;
userTranLog.PcName = Environment.MachineName;
db.Entry(userTranLog).State = Microsoft.EntityFrameworkCore.EntityState.Added;
//db.UserTransactionLogs.Add(userTranLog);
db.SaveChanges();
}
catch (Exception ex)
{
//errorlog(ex);
Console.WriteLine(ex.Message);
}
throw new NotImplementedException();
}
public void TransactionLog(string Controller, string Action, string TransactionStatement, string TransactionalId, string commandType, string DocumentReferance)
{
try
{
var userAgent = Accessor.HttpContext.Request.Headers["User-Agent"];
string uaString = Convert.ToString(userAgent[0]);
var uaParser = Parser.GetDefault();
ClientInfo c = uaParser.Parse(uaString);
var devicetype = c.Device.Family;
string userIpAddress = Accessor.HttpContext.Connection.RemoteIpAddress.ToString();
var userTranLog = new UserTransactionLog();
userTranLog.userid = Accessor.HttpContext.Session.GetString("userid");
//userLoging.userid = Accessor.HttpContext.Session.GetString("userid");
//Microsoft.Extensions.Primitives.StringValues d="";
// Accessor.HttpContext.Request.Headers.TryGetValue("Origin",out d);
userTranLog.WebLink = Accessor.HttpContext.Request.Headers["Referer"]; // .AbsolutePath;
userTranLog.TransactionStatement = TransactionStatement;
userTranLog.CommandType = commandType;
userTranLog.FromDateTime = DateTime.Now;
userTranLog.ToDateTime = DateTime.Now;
userTranLog.IPAddress = userIpAddress;//request.UserHostName;// request.UserHostAddress;
userTranLog.comid = Accessor.HttpContext.Session.GetString("comid");
userTranLog.ControllerName = Controller;
userTranLog.ActionName = Action;
userTranLog.FlagValue = TransactionalId;
userTranLog.DocumentReferance = DocumentReferance;
userTranLog.PcName = Environment.MachineName;
db.Entry(userTranLog).State = Microsoft.EntityFrameworkCore.EntityState.Added;
//db.UserTransactionLogs.Add(userTranLog);
db.SaveChanges();
}
catch (Exception ex)
{
errorlog(ex);
Console.WriteLine(ex.Message);
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from UserTransactionLog a where ");
UserTransactionLog usertransactionlog = (UserTransactionLog)data;
if (usertransactionlog != null)
{
Parms = new List <Object[]>();
if (usertransactionlog.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", usertransactionlog.RowID });
}
if (usertransactionlog.Company != null && usertransactionlog.Company.CompanyID != 0)
{
sql.Append(" a.Company.CompanyID = :id1 and ");
Parms.Add(new Object[] { "id1", usertransactionlog.Company.CompanyID });
}
if (usertransactionlog.Location != null && usertransactionlog.Location.LocationID != 0)
{
sql.Append(" a.Location.LocationID = :id2 and ");
Parms.Add(new Object[] { "id2", usertransactionlog.Location.LocationID });
}
if (usertransactionlog.Terminal != null && usertransactionlog.Terminal.TerminalID != 0)
{
sql.Append(" a.Terminal.TerminalID = :id3 and ");
Parms.Add(new Object[] { "id3", usertransactionlog.Terminal.TerminalID });
}
if (usertransactionlog.DocType != null && usertransactionlog.DocType.DocTypeID != 0)
{
sql.Append(" a.DocType.DocTypeID = :id4 and ");
Parms.Add(new Object[] { "id4", usertransactionlog.DocType.DocTypeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public VarlikResult ApproveAdmin(long idMainOrder,
string idTransactionState,
bool commissionable,
decimal confirmableMoneyAmount = -1)
{
var result = new VarlikResult();
using (var ctx = new VarlikContext())
{
var mainOrder = ctx.MainOrderLog
.FirstOrDefault(l => l.Id == idMainOrder &&
l.IdTransactionState != TransactionStateEnum.Completed);
var order = ctx.UserCoinTransactionOrder
.FirstOrDefault(l => l.IdMainOrderLog == idMainOrder &&
l.IdTransactionState != TransactionStateEnum.Completed &&
l.IdTransactionType == mainOrder.IdTransactionType);
if (mainOrder == null || order == null)
{
return(result);
}
if (idTransactionState == TransactionStateEnum.Completed)
{
mainOrder.IdTransactionState = TransactionStateEnum.Completed;
mainOrder.TransactionDate = DateTime.Now;
ctx.UserCoinTransactionOrder.Remove(order);
//write tx log
var commissinMoney = 0M;
if (mainOrder.IdTransactionType == TransactionTypeEnum.ToBank)
{
commissinMoney = 2.5M;
}
var commissionCoinCount = 0M;
if (mainOrder.IdTransactionType == TransactionTypeEnum.ToWallet)
{
var commissionMAnager = new CommisionOperation();
var commissionR = commissionMAnager.GetTransferCommissionByIdCoinType(mainOrder.IdCoinType);
if (commissionR.IsSuccess)
{
commissionCoinCount = commissionR.Data;
}
}
var moneyAmount = order.MoneyAmount;
if (confirmableMoneyAmount > 0M)
{
moneyAmount = confirmableMoneyAmount;
}
var coinAmount = mainOrder.CoinAmount - commissionCoinCount;
if (!commissionable)
{
coinAmount = mainOrder.CoinAmount;
commissionCoinCount = 0;
}
var tx = new UserTransactionLog()
{
MoneyAmount = moneyAmount,
IdTransactionState = TransactionStateEnum.Completed,
IdTransactionType = mainOrder.IdTransactionType,
TransactionDate = mainOrder.TransactionDate.Value,
IsSucces = true,
IdUser = mainOrder.IdUser,
IdMainOrderLog = idMainOrder,
CoinAmount = coinAmount,
CoinUnitPrice = mainOrder.CoinUnitPrice,
IdCoinType = mainOrder.IdCoinType,
CommissionMoney = commissinMoney,
CommissionCoinCount = commissionCoinCount
};
ctx.UserCoinTransactionLog.Add(tx);
try
{
ctx.SaveChanges();
result.Success();
}
catch (Exception e)
{
Log.Error("ApproveFromBankAdmin", e);
}
}
else if (idTransactionState == TransactionStateEnum.CancelledByAdmin)
{
ctx.UserCoinTransactionOrder.Remove(order);
mainOrder.IdTransactionState = TransactionStateEnum.CancelledByAdmin;
mainOrder.TransactionDate = DateTime.Now;
try
{
ctx.SaveChanges();
result.Success();
}
catch (Exception e)
{
Log.Error("ApproveFromBankAdmin", e);
}
}
}
return(result);
}
public UserTransactionLog SelectById(UserTransactionLog data)
{
return((UserTransactionLog)base.SelectById(data));
}
public Boolean Delete(UserTransactionLog data)
{
return(base.Delete(data));
}
public Boolean Update(UserTransactionLog data)
{
return(base.Update(data));
}
public UserTransactionLog Save(UserTransactionLog data)
{
return((UserTransactionLog)base.Save(data));
}
