public HttpResponseMessage DailyFundIn(HttpRequestMessage reqObject)
{
string walletaccNo = string.Empty;
FundIn _FundIn = new FundIn();
//_businessData = _IDataManipulation.GetBusinessData(reqObject);
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_FundIn = JsonConvert.DeserializeObject <FundIn>(_requestedDataObject.BusinessData);
walletaccNo = _FundIn.WalletAccountNo;
}
var result = _IFundInService.DailyFundIn(_FundIn);
if (result != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Data Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public async Task <HttpResponseMessage> AddFundIn(HttpRequestMessage reqObject)
{
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
string result = string.Empty;
_FundIn = new FundIn();
_FundIn = await Task.Factory.StartNew(() => JsonConvert.DeserializeObject <FundIn>(_requestedDataObject.BusinessData));
result = await _IFundInService.AddFundIn(_FundIn);
// more code here...
//return result;
if (result != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(1, "Fund In successfully. Your transaction id " + result);
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(0, "Data Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public IEnumerable <IndPerformanceMonitoringView> DailyFundIn(FundIn _FundIn)
{
try
{
var color = "#2E2EFE";
var walletAccNo = _FundIn.WalletAccountNo;
var date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (walletAccNo == null || walletAccNo == "")
{
if (_FundIn.FormDate != null && _FundIn.ToDate != null)
{
var FormDate = _FundIn.FormDate.Value.Date;
var Todate = _FundIn.ToDate.Value.Date;
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.TransDT >= FormDate &&
x.TransDT <= Todate).
Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
if (_FundIn.Today == true)
{
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.TransDT == date)
.Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
else
{
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.AuthStatusId == "A")
.Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
}
else
{
var result = _IUoW.Repository <AccMaster>().Get(a => a.WalletAccountNo == walletAccNo).Select(s => s.SystemAccountNo).ToList();
var sysAccNo = result[0];
if (_FundIn.FormDate != null && _FundIn.ToDate != null)
{
var FormDate = _FundIn.FormDate.Value.Date;
var Todate = _FundIn.ToDate.Value.Date;
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.TransDT >= FormDate &&
x.TransDT <= Todate &&
x.FromSystemAccountNo == sysAccNo).
Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
if (_FundIn.Today == true)
{
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.TransDT == date &&
x.FromSystemAccountNo == sysAccNo).
Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
else
{
var _DailyFundIn = _IUoW.Repository <FundIn>().Get(x => x.AuthStatusId == "A" &&
x.FromSystemAccountNo == sysAccNo)
.Select(s => new IndPerformanceMonitoringView
{
amount = s.Amount,
time = s.TransDT,
color = color
}).ToList();
return(_DailyFundIn);
}
}
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "DailyFundIn()", string.Empty);
return(null);
}
}
//#region Index
//public List<FundIn> GetAllFundIn()
//{
// try
// {
// List<FundIn> OBJ_LIST_FundIn = new List<FundIn>();
// foreach (var item in _IUoW.Repository<FundIn>().GetAll())
// {
// FundIn OBJ_FundIn = new FundIn();
// BranchInfoService OBJ_BranchInfoService = new BranchInfoService();
// OBJ_FundIn.FundInId = item.FundInId;
// OBJ_FundIn.ToAccountNo = item.ToAccountNo;
// OBJ_FundIn.ToBranchId = item.ToBranchId;
// foreach (var item1 in OBJ_BranchInfoService.GetBranchInfoForDD())
// {
// if (item1.Value == OBJ_FundIn.ToBranchId)
// {
// OBJ_FundIn.ToBranchNm = item1.Text;
// }
// }
// OBJ_FundIn.FromAccountBalance = item.FromAccountBalance;
// OBJ_FundIn.Amount = item.Amount;
// OBJ_FundIn.Narration = item.Narration;
// OBJ_FundIn.FromAccountNo = item.FromAccountNo;
// OBJ_FundIn.FromBranchId = item.FromBranchId;
// foreach (var item1 in OBJ_BranchInfoService.GetBranchInfoForDD())
// {
// if (item1.Value == OBJ_FundIn.FromBranchId)
// {
// OBJ_FundIn.FromBranchNm = item1.Text;
// }
// }
// OBJ_FundIn.AuthStatusId = item.AuthStatusId;
// OBJ_FundIn.LastAction = item.LastAction;
// OBJ_FundIn.LastUpdateDT = item.LastUpdateDT;
// OBJ_FundIn.MakeBy = item.MakeBy;
// OBJ_FundIn.MakeDT = System.DateTime.Now;
// OBJ_FundIn.TransDT = item.TransDT;
// OBJ_LIST_FundIn.Add(OBJ_FundIn);
// }
// return OBJ_LIST_FundIn;
// //var fundin = _IUoW.Repository<FundIn>().GetBy(x => x.AuthStatusId == "A" &&
// // x.LastAction != "DEL", n => new { n.FundInId, n.ToAccountNo, n.ToBranchId, n.FromAccountBalance, n.Amount, n.Narration, n.FromAccountNo, n.FromBranchId });
// //var branch = _IUoW.Repository<BranchInfo>().GetBy(x => x.AuthStatusId == "A" &&
// // x.LastAction != "DEL", n => new { n.BranchId, n.BranchNm });
// //List<FundIn> OBJ_LIST_FundIn = fundin
// // .Join(branch, f => f.ToBranchId, b => b.BranchId, (f, b) => new {f, b})
// // .Join(branch, f1 => f1.f.FromBranchId, b1 => b1.BranchId, (f1, b1) => new {f1, b1})
// //.Select(m => new FundIn
// //{
// // FundInId = m.f1.f.FundInId,
// // ToAccountNo = m.f1.f.ToAccountNo,
// // ToBranchId = m.f1.f.ToBranchId,
// // ToBranchNm = m.f1.b.BranchNm,
// // FromAccountBalance = m.f1.f.FromAccountBalance,
// // Amount = m.f1.f.Amount,
// // Narration = m.f1.f.Narration,
// // FromAccountNo = m.f1.f.FromAccountNo,
// // FromBranchId = m.f1.f.FromBranchId,
// // FromBranchNm = m.b1.BranchNm
// //}).ToList();
// //return OBJ_LIST_FundIn;
// //List<FundIn> OBJ_LIST_FundIn = branch.GroupJoin(fundin, b => b.BranchId, f => f.FromBranchId, (bb, ff) => new { b = bb, f = ff.SingleOrDefault() }).Select(m => new FundIn
// //{
// // FundInId = m.f.FundInId,
// // ToAccountNo = m.f.ToAccountNo,
// // ToBranchId = m.f.ToBranchId,
// // ToBranchNm = m.b.BranchNm,
// // FromAccountBalance = m.f.FromAccountBalance,
// // Amount = m.f.Amount,
// // Narration = m.f.Narration,
// // FromAccountNo = m.f.FromAccountNo,
// // FromBranchId = m.f.FromBranchId,
// // FromBranchNm = m.b.BranchNm
// //}).ToList();
// //return OBJ_LIST_FundIn;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public FundIn GetFundInById(string _FundInId)
//{
// try
// {
// return _IUoW.Repository<FundIn>().GetById(_FundInId);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public FundIn GetFundInBy(FundIn _FundIn)
//{
// try
// {
// if (_FundIn == null)
// {
// return _FundIn;
// }
// return _IUoW.Repository<FundIn>().GetBy(x => x.FundInId == _FundIn.FundInId &&
// x.AuthStatusId == "A" &&
// x.LastAction != "DEL");
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//#endregion
#region Add
/*
* public string AddFundIn(FundIn _FundIn)
* {
* int result = 0;
* _FundIn.TransDT = Convert.ToDateTime(System.DateTime.Now.ToString("dd/MM/yyyy"));
* string split_result = string.Empty;
* string MainAuthFlag = string.Empty;
* AccMasterService _AccInfoService = new AccMasterService();
* AccMaster _AccInfo_Post = new AccMaster();
* AccMaster _AccInfo_Get = new AccMaster();
*
* StatusWiseServiceService _StatusWiseServiceService = new StatusWiseServiceService();
* StatusWiseService _StatusWiseService = new StatusWiseService();
* int CheckStatusWiseService = 0;
*
* TransactionRulesService _TransactionRulesService = new TransactionRulesService();
* TransactionRules _TransactionRules = new TransactionRules();
* int CheckTransactionRules = 0;
*
* AccLimitSetupService _AccLimitSetupService = new AccLimitSetupService();
* AccLimitSetup _AccLimitSetup = new AccLimitSetup();
* string CheckAccLimit = string.Empty;
* try
* {
#region Get SystemAccountNo by WalletAccountNo
* _AccInfo_Post.FromSystemAccountNo = _FundIn.FromSystemAccountNo;
* _AccInfo_Post.ToSystemAccountNo = _FundIn.ToSystemAccountNo;
* _AccInfo_Post.FunctionId = _FundIn.FunctionId;
* _AccInfo_Get = _AccInfoService.GetAccInfo(_AccInfo_Post);
* if (_AccInfo_Get == null || _AccInfo_Get.FromSystemAccountNo == null || _AccInfo_Get.ToSystemAccountNo == null)
* {
* split_result = result + ":" + "Account No. not valid..";
* return split_result;
* }
#endregion
*
#region Check StatusWiseService
* _StatusWiseService.ToSystemAccountNo = _AccInfo_Get.ToSystemAccountNo;
* _StatusWiseService.DefineServiceId = _FundIn.DefineServiceId;
* CheckStatusWiseService = _StatusWiseServiceService.CheckStatusWiseService(_StatusWiseService);
* if (CheckStatusWiseService == 0)
* {
* split_result = result + ":" + "Account No. is not active for this transaction..";
* return split_result;
* }
#endregion
*
#region Check TransactionRules
* _TransactionRules.FromSystemAccountNo = _AccInfo_Get.FromSystemAccountNo;
* _TransactionRules.ToSystemAccountNo = _AccInfo_Get.ToSystemAccountNo;
* _TransactionRules.DefineServiceId = _FundIn.DefineServiceId;
* CheckTransactionRules = _TransactionRulesService.CheckTransactionRules(_TransactionRules);
* if (CheckTransactionRules == 0)
* {
* split_result = result + ":" + "Transaction is not allowed..";
* return split_result;
* }
#endregion
*
#region Check Limit
* _AccLimitSetup.FromSystemAccountNo = _AccInfo_Get.FromSystemAccountNo;
* _AccLimitSetup.FromAccType = _AccInfo_Get.FromAccType;
* _AccLimitSetup.ToSystemAccountNo = _AccInfo_Get.ToSystemAccountNo;
* _AccLimitSetup.ToAccType = _AccInfo_Get.ToAccType;
* _AccLimitSetup.DefineServiceId = _FundIn.DefineServiceId;
* _AccLimitSetup.Amount = _FundIn.Amount;
* _AccLimitSetup.TransDT = _FundIn.TransDT;
* CheckAccLimit = _AccLimitSetupService.CheckAccLimit(_AccLimitSetup);
* if (CheckAccLimit != "true")
* {
* split_result = result + ":" + CheckAccLimit;
* return split_result;
* }
#endregion
*
* if (_AccInfo_Get.FromSystemAccountNo != null && _AccInfo_Get.ToSystemAccountNo != null && CheckStatusWiseService != 0 && CheckTransactionRules != 0 && CheckAccLimit == "true")
* {
* var _max = _IUoW.Repository<FundIn>().GetMaxValue(x => x.FundInId) + 1;
* _FundIn.FundInId = _max.ToString().PadLeft(3, '0');
* _FundIn.AuthStatusId = "U";
* _FundIn.LastAction = "ADD";
* //_FundIn.MakeDT = Convert.ToDateTime(System.DateTime.Now.ToString("dd/MM/yyyy"));
* _FundIn.MakeDT = System.DateTime.Now;
* _FundIn.MakeBy = "prova";
* _FundIn.FromSystemAccountNo = _AccInfo_Get.FromSystemAccountNo;
* _FundIn.ToSystemAccountNo = _AccInfo_Get.ToSystemAccountNo;
* result = _IUoW.Repository<FundIn>().Add(_FundIn);
#region Auth Log
* if (result == 1)
* {
* string url = ConfigurationManager.AppSettings["LgurdaService_server"] + "/GetAuthPermissionByFunctionId/" + _FundIn.FunctionId + "/" + _FundIn.FunctionName + "?format=json";
* using (WebClient wc = new WebClient())
* {
* TransactionRules OBJ_TransactionRules = new TransactionRules();
* var json = wc.DownloadString(url);
* OBJ_TransactionRules = JsonConvert.DeserializeObject<TransactionRules>(json);
* MainAuthFlag = OBJ_TransactionRules.GetAuthPermissionByFunctionIdResult;
* }
* if (MainAuthFlag == "1")
* {
* _IAuthLogService = new AuthLogService();
* long _outMaxSlAuthLogDtl = 0;
* result = _IAuthLogService.AddAuthLog(_IUoW, null, _FundIn, "ADD", "0001", "090107001", 1, "FundIn", "MTK_TRN_FUND_IN", "FundInId", _FundIn.FundInId, "prova", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
* }
* if (MainAuthFlag == "0")
* {
* _IAuthLogService = new AuthLogService();
* FTAuthLog _ObjAuthLog = new FTAuthLog();
* _ObjAuthLog.TableNm = "MTK_TRN_FUND_IN";
* _ObjAuthLog.AuthStatusId = "A";
* _ObjAuthLog.LastAction = "ADD";
* _ObjAuthLog.FunctionId = _FundIn.FunctionId;
* _ObjAuthLog.TablePkColVal = _FundIn.FundInId;
* //_FundIn.FromSystemAccountNo = _AccInfo_Get.FromSystemAccountNo;
* //_FundIn.ToSystemAccountNo = _AccInfo_Get.ToSystemAccountNo;
* result = _IAuthLogService.SetTableObject_FT<FundIn>(_IUoW, _ObjAuthLog, _FundIn);
* }
* }
#endregion
*
* if (result == 1)
* {
* _IUoW.Commit();
* split_result = result + ":" + "Saved Successfully";
* }
* else
* {
* split_result = result + ":" + "information hasn't been added";
* }
* }
* }
* catch (Exception ex)
* {
* _ObjErrorLogService = new ErrorLogService();
* _ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddFundIn(obj)", string.Empty);
* split_result = result + ":" + "";
* }
* return split_result;
* }
*/
public async Task <string> AddFundIn(FundIn _FundIn)
{
string txn_id = string.Empty;
await Task.Run(() =>
{
using (mTakaDbContext _dbContext = new mTakaDbContext())
{
using (var dbContextTransaction = _dbContext.Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
var param = new OracleParameter("PWALLET_ACC_NO_F", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.FromSystemAccountNo
};
var param1 = new OracleParameter("PWALLET_ACC_NO_T", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.ToSystemAccountNo
};
var param2 = new OracleParameter("PDEFINE_SERVICE_ID", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.DefineServiceId
};
var param3 = new OracleParameter("PAMOUNT", OracleDbType.Decimal, ParameterDirection.Input)
{
Value = _FundIn.Amount
};
var param4 = new OracleParameter("PFUNCTIONID", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.FunctionId
};
var param5 = new OracleParameter("PNARRATION", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.Narration
};
var param6 = new OracleParameter("PMAKE_BY", OracleDbType.NVarchar2, ParameterDirection.Input)
{
Value = _FundIn.MakeBy
};
var param7 = new OracleParameter("PTXN_ID", OracleDbType.NVarchar2, ParameterDirection.Output)
{
Size = 100
};
string commandText = "BEGIN MTK_TXN.CREATE_TRANS(:PWALLET_ACC_NO_F,:PWALLET_ACC_NO_T,:PDEFINE_SERVICE_ID,:PAMOUNT,:PFUNCTIONID,:PNARRATION,:PMAKE_BY,:PTXN_ID); end;";
_dbContext.Database.SqlQuery <string>(commandText, param, param1, param2, param3, param4, param5, param6, param7).FirstAsync();
dbContextTransaction.Commit();
txn_id = param7.Value.ToString();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
}
//Log.Info("Thread Id is-->" + Thread.CurrentThread.ManagedThreadId);
}
});
return(txn_id);
}
