public static string Manage(NameValueCollection querystring)
{
string isInsert = querystring.Get("TransType");
int intParser;
decimal decParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var fundtransfer = new FundTransfer
{
FTID = querystring.Get("FTID"),
intIDMasLocation = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
FTDate = querystring.Get("FTDate"),
COAIDOrg = querystring.Get("COAIDOrg"),
COASubsidiaryIDOrg = querystring.Get("COASubsidiaryIDOrg"),
COAIndSubsidiaryIDOrg = querystring.Get("COAIndSubsidiaryIDOrg"),
FTAmount = decimal.TryParse(querystring.Get("FTAmount"), out decParser) ? decParser : 0,
FTRemarks = querystring.Get("FTRemarks"),
FTBranchDestID = querystring.Get("FTBranchDestID"),
COAIDDest = querystring.Get("COAIDDest"),
COASubsidiaryIDDest = querystring.Get("COASubsidiaryIDDest"),
COAIndSubsidiaryIDDest = querystring.Get("COAIndSubsidiaryIDDest"),
intIDSecUser = userProfile.UserId
};
string param = WebCommon.ToXML(fundtransfer);
return(FundTransferFormDAL.Manage(param, isInsert));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
var loggedInUser = HttpContext.User;
var customerId = loggedInUser.Claims.FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier).Value;
if (id == null)
{
return(NotFound());
}
fundTransfer = await _context.FundTransfer
.OrderBy(f => f.TransactionDate)
.FirstOrDefaultAsync <FundTransfer>(f => f.CustomerID == customerId);
//.Include(f => f.Customer)
//.Where(f => f.Customer.Id == "0976cf3d-e934-494e-8a22-d7882deee2f1")
//.FirstOrDefaultAsync<FundTransfer>();
//var customerid = fundTransfer.Where(f => f.Customer.Id == "0976cf3d-e934-494e-8a22-d7882deee2f1").Single().Id;
if (fundTransfer == null)
{
return(Unauthorized());
}
// if (fundTransfer == null)
// {
// return NotFound();
// }
return(Page());
}
public async Task <int> AddFundTransferAsync(FundTransfer model)
{
if (model == null)
{
return(0);
}
try
{
var entity = new FundTransfer()
{
FundTransferGuid = model.FundTransferGuid,
PayeeId = model.PayeeId,
PayeePaymentType = model.PayeePaymentType,
PayeeBankId = model.PayeeBankId,
PayeeCashId = model.PayeeCashId,
DateOfPayment = model.DateOfPayment,
Amount = model.Amount,
Narration = model.Narration,
ReceiverId = model.ReceiverId,
ReceiverPaymentType = model.ReceiverPaymentType,
ReceiverBankId = model.ReceiverBankId,
ReceiverCashId = model.ReceiverCashId
};
_dataSource.Entry(entity).State = EntityState.Added;
await _dataSource.SaveChangesAsync();
return(entity.FundTransferId);
}
catch (Exception ex)
{
throw ex;
}
}
// To protect from overposting attacks, see https://aka.ms/RazorPagesCRUD
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
var loggedInUser = HttpContext.User;
var customerId = loggedInUser.Claims.FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier).Value;
var emptyFundTransfer = new FundTransfer();
emptyFundTransfer.CustomerID = customerId;
if (await TryUpdateModelAsync <FundTransfer>(
emptyFundTransfer,
"fundtransfer",
f => f.ID, f => f.AccountFrom, f => f.AccountTo, f => f.Amount, f => f.TransactionDate, f => f.Note, f => f.CustomerID))
{
_context.FundTransfer.Add(emptyFundTransfer);
await _context.SaveChangesAsync();
return(RedirectToPage("./Index"));
}
PopulateAccountsDropDownList(_context);
return(Page());
}
public ActionResult FundTransfer(FundTransfer ft)
{
Statement s = new Statement();
int facntbal = db.AccountsSummary.Where(o => o.Account == ft.FromAccount).FirstOrDefault().Balance;
int tacntbal = db.AccountsSummary.Where(o => o.Account == ft.ToAccount).FirstOrDefault().Balance;
if (facntbal >= ft.Amount)
{
s.Account = ft.FromAccount;
s.Credit = 0;
s.Debit = ft.Amount;
s.Balance = facntbal - ft.Amount;
s.Updatedat = DateTime.UtcNow;
s.comment = "Transferred to :" + ft.ToAccount;
db.Statements.Add(s);
Statement a = new Statement();
a.Account = ft.ToAccount;
a.Credit = ft.Amount;
a.Debit = 0;
a.Balance = tacntbal + ft.Amount;
a.Updatedat = DateTime.UtcNow;
a.comment = "Transferred from: " + ft.FromAccount;
db.Statements.Add(a);
db.SaveChanges();
}
return(RedirectToAction("Statement", "BankAccounts", new { acct = ft.FromAccount }));
}
public void Save(FundTransfer transfer)
{
var existTransfer = erpNodeDBContext.FundTransfers.Find(transfer.Id);
if (existTransfer == null)
{
transfer.FiscalYear = organization.FiscalYears.Find(transfer.TransactionDate);
transfer.TransactionType = Models.Accounting.Enums.TransactionTypes.FundTransfer;
transfer.No = NextNumber;
transfer.BankFeeAccountGuid = organization.SystemAccounts.BankFee.Id;
erpNodeDBContext.FundTransfers.Add(transfer);
}
else
{
if (existTransfer.PostStatus == LedgerPostStatus.Posted)
{
return;
}
transfer.FiscalYear = organization.FiscalYears.Find(transfer.TransactionDate);
existTransfer.Reference = transfer.Reference;
existTransfer.TransactionDate = transfer.TransactionDate;
existTransfer.DepositAccountGuid = transfer.DepositAccountGuid;
existTransfer.WithDrawAccountGuid = transfer.WithDrawAccountGuid;
existTransfer.AmountwithDraw = transfer.AmountwithDraw;
existTransfer.AmountFee = transfer.AmountFee;
existTransfer.Reference = transfer.Reference;
}
erpNodeDBContext.SaveChanges();
}
static public async Task <FundTransferModel> CreateFundTransferModelAsync(FundTransfer source, bool includeAllFields)
{
var model = new FundTransferModel()
{
FundTransferId = source.FundTransferId,
FundTransferGuid = source.FundTransferGuid,
PayeeId = source.PayeeId.ToString(),
PayeePaymentType = source.PayeePaymentType,
PayeeBankId = source.PayeeBankId,
PayeeCashId = source.PayeeCashId,
DateOfPayment = source.DateOfPayment,
Amount = source.Amount.ToString(),
Narration = source.Narration,
ReceiverId = source.ReceiverId.ToString(),
ReceiverPaymentType = source.ReceiverPaymentType,
ReceiverBankId = source.ReceiverBankId,
ReceiverCashId = source.ReceiverCashId,
FromAccountName = source.FromAccountName,
FromCompanyName = source.FromCompanyName,
ToAccountName = source.ToAccountName,
ToCompanyName = source.ToCompanyName
};
return(model);
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (!id.HasValue)
{
return(NotFound());
}
if (!User.Identity.IsAuthenticated)
{
return(Challenge());
}
fundTransfer = await _context.FundTransfer
.Where(f => f.ID == id)
.Include(f => f.Customer)
.OrderBy(f => f.TransactionDate)
.FirstOrDefaultAsync <FundTransfer>();
var isAuthorized = await _authorizationService.AuthorizeAsync(
User, fundTransfer,
"Owner");
if (!isAuthorized.Succeeded)
{
return(Forbid());
}
return(Page());
}
public IEnumerable <FundTransfer> GetFundTransfers(string search)
{
List <FundTransfer> fundTransfers = new List <FundTransfer>();
using (SqliteConnection con = new SqliteConnection(connectionString))
{
SqliteCommand cmd = new SqliteCommand("Select * from FundTransfer where Note like '%" + @search + "%'", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@search", search);
con.Open();
SqliteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
FundTransfer fundtransfer = new FundTransfer();
fundtransfer.ID = Convert.ToInt32(rdr["ID"]);
fundtransfer.AccountFrom = Convert.ToInt32(rdr["AccountFrom"]);
fundtransfer.AccountTo = Convert.ToInt32(rdr["AccountTo"]);
fundtransfer.TransactionDate = Convert.ToDateTime(rdr["TransactionDate"]);
fundtransfer.Amount = decimal.Parse(rdr["Amount"].ToString());
fundtransfer.Note = rdr["Note"].ToString();
fundTransfers.Add(fundtransfer);
}
con.Close();
}
return(fundTransfers);
}
public HttpResponseMessage AddFundTransfer(HttpRequestMessage reqObject)
{
string result = string.Empty;
int result_result = 0;
string result_msg = "information hasn't been added";
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_FundTransfer = new FundTransfer();
_FundTransfer = JsonConvert.DeserializeObject <FundTransfer>(_requestedDataObject.BusinessData);
bool IsValid = ModelValidation.TryValidateModel(_FundTransfer, out _modelErrorMsg);
if (IsValid)
{
result = _IFundTransferService.AddFundTransfer(_FundTransfer);
var split = result.ToString().Split(':');
result_result = Convert.ToInt32(split[0]);
result_msg = split[1];
}
}
if (!string.IsNullOrWhiteSpace(_modelErrorMsg))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result_result, _modelErrorMsg);
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result_result, result_msg);
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public async Task <int> UpdateFundTransferAsync(FundTransfer model)
{
_dataSource.Entry(model).State = EntityState.Modified;
int res = await _dataSource.SaveChangesAsync();
return(res);
}
public ActionResult FundTransfer(String userid)
{
ViewBag.fromAccount_List = new SelectList(db.customeraccounts.Where(o => o.UserID == userid).ToList(), "Account", "Account");
ViewBag.toAccount_List = new SelectList(db.Benefeciries.Where(o => o.UserID == userid).ToList(), "Account", "Account");
FundTransfer b = new FundTransfer();
return(View(b));
}
public void UnPostLedger(FundTransfer transfer)
{
Console.WriteLine("> UnPost GL," + transfer.TransactionType + " " + transfer.No);
organization.LedgersDal.RemoveTransaction(transfer.Id);
transfer.PostStatus = LedgerPostStatus.ReadyToPost;
erpNodeDBContext.SaveChanges();
}
public void Delete(FundTransfer transfer)
{
if (transfer.PostStatus == LedgerPostStatus.Posted)
{
this.UnPostLedger(transfer);
erpNodeDBContext.FundTransfers.Remove(transfer);
erpNodeDBContext.SaveChanges();
}
}
public async Task <int> DeleteFundTransferAsync(FundTransferModel model)
{
var fundTransfer = new FundTransfer {
FundTransferId = model.FundTransferId
};
using (var dataService = DataServiceFactory.CreateDataService())
{
return(await dataService.DeleteFundTransferAsync(fundTransfer));
}
}
public object AproveOrRejectDisburseAmountPosting(string evnt, [FromBody] FundTransfer fundTransferModel)
{
string checkedUser = fundTransferModel.CheckUser;
//fundTransferModel = _fundTransferService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "TransNo", new FundTransfer());
//fundTransferModel.CheckUser = checkedUser;
TblDisburseAmtDtlMake objTblDisburseAmtDtlMake = new TblDisburseAmtDtlMake();
objTblDisburseAmtDtlMake = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake());
try
{
if (evnt == "register")
{
//fundTransferModel.Status = "A";
objTblDisburseAmtDtlMake.Status = "C";
objTblDisburseAmtDtlMake.CheckerId = checkedUser;
objTblDisburseAmtDtlMake.CheckTime = System.DateTime.Now;
var successOrErrorMsg = _disbursementService.DataInsertToTransMSTandDTL(objTblDisburseAmtDtlMake);
if (successOrErrorMsg.ToString() == "1")
{
//Insert into audit trial audit and detail
TblDisburseAmtDtlMake prevModel = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake());
prevModel.Status = "M";//insert for only audit trail
_auditTrailService.InsertUpdatedModelToAuditTrail(objTblDisburseAmtDtlMake, prevModel, objTblDisburseAmtDtlMake.CheckerId, 10, 4, "Disburse Amount Posting", objTblDisburseAmtDtlMake.CompanyId.ToString(), "Approved Successfully!");
}
return(successOrErrorMsg);
}
else if (evnt == "reject")
{
objTblDisburseAmtDtlMake.Status = "R";
objTblDisburseAmtDtlMake.CheckerId = checkedUser;
objTblDisburseAmtDtlMake.CheckTime = System.DateTime.Now;
_disburseAmtDtlMakeService.UpdateByStringField(objTblDisburseAmtDtlMake, "Tranno");
//Insert into audit trial audit and detail
TblDisburseAmtDtlMake prevModel = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake());
prevModel.Status = "M";//insert for only audit trail
_auditTrailService.InsertUpdatedModelToAuditTrail(objTblDisburseAmtDtlMake, prevModel, objTblDisburseAmtDtlMake.CheckerId, 10, 4, "Disburse Amount Posting", objTblDisburseAmtDtlMake.CompanyId.ToString(), "Rejected Successfully!");
return(true);
}
else
{
return(true);
}
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public static List <FundTransfer> GetFundTransfer(string criteria, int branchid)
{
var dbUtil = new DatabaseManager();
var fundtransferHeaders = new List <FundTransfer>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spFundTransferGetHeader";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var fundtransferHeader = new FundTransfer
{
FTID = ReferenceEquals(reader["FTID"], DBNull.Value) ? String.Empty : (string)reader["FTID"],
FTDate = ReferenceEquals(reader["FTDate"], DBNull.Value) ? String.Empty : (string)reader["FTDate"],
COAIDOrg = ReferenceEquals(reader["COAIDOrg"], DBNull.Value) ? String.Empty : (string)reader["COAIDOrg"],
COADescOrg = ReferenceEquals(reader["COADescOrg"], DBNull.Value) ? String.Empty : (string)reader["COADescOrg"],
COASubsidiaryIDOrg = ReferenceEquals(reader["COASubsidiaryIDOrg"], DBNull.Value) ? String.Empty : (string)reader["COASubsidiaryIDOrg"],
COASubsidiaryDescOrg = ReferenceEquals(reader["COASubsidiaryDescOrg"], DBNull.Value) ? String.Empty : (string)reader["COASubsidiaryDescOrg"],
FTBranchDestID = ReferenceEquals(reader["FTBranchDestID"], DBNull.Value) ? String.Empty : (string)reader["FTBranchDestID"],
FTBranchDestName = ReferenceEquals(reader["FTBranchDestName"], DBNull.Value) ? String.Empty : (string)reader["FTBranchDestName"],
FTAmount = ReferenceEquals(reader["FTAmount"], DBNull.Value) ? 0 : (decimal)reader["FTAmount"],
FTRemarks = ReferenceEquals(reader["FTRemarks"], DBNull.Value) ? String.Empty : (string)reader["FTRemarks"],
COAIndSubsidiaryIDOrg = ReferenceEquals(reader["COAIndSubsidiaryIDOrg"], DBNull.Value) ? String.Empty : (string)reader["COAIndSubsidiaryIDOrg"],
COAIndSubsidiartDescOrg = ReferenceEquals(reader["COAIndSubsidiartDescOrg"], DBNull.Value) ? string.Empty : (string)reader["COAIndSubsidiartDescOrg"],
COAIDDest = ReferenceEquals(reader["COAIDDest"], DBNull.Value) ? String.Empty : (string)reader["COAIDDest"],
COADescDest = ReferenceEquals(reader["COADescDest"], DBNull.Value) ? String.Empty : (string)reader["COADescDest"],
COASubsidiaryIDDest = ReferenceEquals(reader["COASubsidiaryIDDest"], DBNull.Value) ? String.Empty : (string)reader["COASubsidiaryIDDest"],
COASubsidiaryDescDest = ReferenceEquals(reader["COASubsidiaryDescDest"], DBNull.Value) ? String.Empty : (string)reader["COASubsidiaryDescDest"],
COAIndSubsidiaryIDDest = ReferenceEquals(reader["COAIndSubsidiaryIDDest"], DBNull.Value) ? String.Empty : (string)reader["COAIndSubsidiaryIDDest"],
COAIndSubsidiartDescDest = ReferenceEquals(reader["COAIndSubsidiartDescDest"], DBNull.Value) ? string.Empty : (string)reader["COAIndSubsidiartDescDest"]
};
fundtransferHeaders.Add(fundtransferHeader);
}
return(fundtransferHeaders);
}
}
}
}
private void Manage()
{
string result = FundTransferFormBAL.Manage(Request.QueryString);
var fundtransfer = new FundTransfer
{
//FTID = Convert.ToInt32(result.Split(',')[0]),
FTID = result
};
Response.Write(fundtransfer.ToJSON());
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
FundTransfer = await _context.FundTransfer.FirstOrDefaultAsync(m => m.ID == id);
if (FundTransfer == null)
{
return(NotFound());
}
return(Page());
}
private void UpdateFundTransferFromModel(FundTransfer target, FundTransferModel source)
{
target.FundTransferId = source.FundTransferId;
target.FundTransferGuid = source.FundTransferGuid;
target.PayeeId = Convert.ToInt32(source.PayeeId);
target.PayeePaymentType = source.PayeePaymentType;
target.PayeeBankId = source.PayeeBankId;
target.PayeeCashId = source.PayeeCashId;
target.DateOfPayment = source.DateOfPayment.UtcDateTime;
target.Amount = Convert.ToDecimal(string.IsNullOrEmpty(source.Amount) ? "0" : source.Amount);
target.Narration = source.Narration;
target.ReceiverId = Convert.ToInt32(source.ReceiverId);
target.ReceiverPaymentType = source.ReceiverPaymentType;
target.ReceiverBankId = source.ReceiverBankId;
target.ReceiverCashId = source.ReceiverCashId;
}
public async Task <FundTransferModel> AddFundTransferAsync(FundTransferModel model)
{
using (var dataService = DataServiceFactory.CreateDataService())
{
var fundTransfer = new FundTransfer();
if (fundTransfer != null)
{
UpdateFundTransferFromModel(fundTransfer, model);
fundTransfer.FundTransferGuid = Guid.NewGuid();
var id = await dataService.AddFundTransferAsync(fundTransfer);
model.Merge(await GetFundTransferAsync(dataService, id));
}
return(model);
}
}
public void InstantiateIn(Control container)
{
parent = (GridViewBaseRowTemplateContainer)container;
//CssPostfix = parent.Grid.CssPostfix;
//tbControl = new Table();
tbData = new Table();
//tbControl.SetTableControlStyle(CssPostfix);
//tbData.SetTableStyle(CssPostfix);
//TableRow row = new TableRow();
//TableCell cell = new TableCell();
//cell.Controls.Add(tbData);
//row.Cells.Add(cell);
//tbControl.Rows.Add(row);
//tbData.SetPageContentStyle(parent.Grid.CssPostfix);
int paymentID = (int)DataBinder.Eval(parent.DataItem, "PaymentID");
payment = context.PersistencySession.Get <iSabaya.Payment>(paymentID);
if (payment.Type.Equals(typeof(Cheque)))
{
Cheque c = payment as Cheque;
this.AddDataItem(c);
}
else if (payment.Type.Equals(typeof(Cash)))
{
Cash c = payment as Cash;
this.AddDataItem("Destination Bank Account:", c.DestinationBankAccount);
this.AddDataItem("Recipient Name:", c.RecipientName);
}
else if (payment.Type.Equals(typeof(BankDeposit)))
{
BankDeposit bd = payment as BankDeposit;
this.AddDataItem(bd.Cheque);
this.AddDataItem("Bank Account:", bd.BankAccount);
this.AddDataItem("Recipient Name:", bd.RecipientName);
}
else if (payment.Type.Equals(typeof(FundTransfer)))
{
FundTransfer ft = payment as FundTransfer;
this.AddDataItem("Status:", ft.Status.ToString());
this.AddDataItem("Status Date:", ft.StatusDate);
this.AddDataItem("From Bank Account:", ft.FromBankAccount);
this.AddDataItem("To Bank Account:", ft.ToBankAccount);
this.AddDataItem("Recipient Name:", ft.RecipientName);
}
parent.Controls.Add(tbData);
}
public FundTransfer Copy(FundTransfer originalFundTransfer, DateTime trDate)
{
var cloneFundTransfer = this.erpNodeDBContext.FundTransfers
.AsNoTracking()
.FirstOrDefault(x => x.Id == originalFundTransfer.Id);
cloneFundTransfer.Id = Guid.NewGuid();
cloneFundTransfer.TransactionDate = trDate;
cloneFundTransfer.Reference = "Clone-" + cloneFundTransfer.Reference;
cloneFundTransfer.No = organization.FundTransfers.NextNumber;
cloneFundTransfer.PostStatus = LedgerPostStatus.ReadyToPost;
this.erpNodeDBContext.FundTransfers.Add(cloneFundTransfer);
this.erpNodeDBContext.SaveChanges();
return(cloneFundTransfer);
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
FundTransfer = await _context.FundTransfer.FindAsync(id);
if (FundTransfer != null)
{
_context.FundTransfer.Remove(FundTransfer);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public bool PostLedger(FundTransfer tr, bool SaveImmediately = true)
{
if (tr.PostStatus == LedgerPostStatus.Posted)
{
return(false);
}
var trLedger = new Models.Accounting.LedgerGroup()
{
Id = tr.Id,
TransactionDate = tr.TransactionDate,
TransactionName = tr.Name,
TransactionNo = tr.No,
TransactionType = transactionType
};
trLedger.AddCredit(tr.WithDrawAccount, tr.AmountwithDraw);
if (tr.AmountFee > 0)
{
trLedger.AddDebit(tr.BankFeeAccount, tr.AmountFee);
}
trLedger.AddDebit(tr.DepositAccount, tr.AmountDeposit);
if (trLedger.FinalValidate())
{
erpNodeDBContext.LedgerGroups.Add(trLedger);
tr.PostStatus = LedgerPostStatus.Posted;
}
else
{
return(false);
}
if (SaveImmediately)
{
erpNodeDBContext.SaveChanges();
}
return(true);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
fundTransfer = await _context.FundTransfer
.Where(f => f.ID == id)
.Include(f => f.Customer)
.OrderBy(f => f.TransactionDate)
.FirstOrDefaultAsync <FundTransfer>();
if (fundTransfer == null)
{
return(NotFound());
}
return(Page());
}
public ActionResult FundTransfer(FundTransfer fund)
{
OnlineBankingEntities Context = new OnlineBankingEntities();
var r = Session["UserID"];
var accountDetails = (from e in Context.AccountDetails
where e.UserID == r.ToString()
select e).First();
var customerInfo = (from e in Context.CustomerInfo
where e.UserID == r.ToString()
select e).First();
var currentbalance = accountDetails.BalanceAvailable;
if (fund.TransAmount >= 100)
{
Transaction t1 = new Transaction();
if (accountDetails.BalanceAvailable >= fund.TransAmount)
{
t1.UserID = fund.UserID;
t1.ValueDate = DateTime.Now;
t1.Narration = "Fund Transfer";
t1.InitialBalance = currentbalance;
t1.Withdrawal = fund.TransAmount;
t1.ClosingBalance = currentbalance - fund.TransAmount;
t1.FundTransferToAccount = fund.ToAccount;
accountDetails.BalanceAvailable = t1.ClosingBalance;
customerInfo.BalanceAvailable = t1.ClosingBalance;
Context.Transactions.Add(t1);
Context.SaveChanges();
ViewBag.Message = "Current Balance is " + t1.ClosingBalance + " in your account ";
}
else
{
ViewBag.Message = "Insufficient Balance";
}
}
else
{
ViewBag.Message = "Minimum value is above 100";
}
return(View());
}
// To protect from overposting attacks, see https://aka.ms/RazorPagesCRUD
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
var emptyFundTransfer = new FundTransfer();
if (await TryUpdateModelAsync <FundTransfer>(
emptyFundTransfer,
"fundtransfer",
f => f.ID, f => f.AccountFrom, f => f.AccountTo, f => f.Amount, f => f.TransactionDate, f => f.Note))
{
_context.FundTransfer.Add(emptyFundTransfer);
await _context.SaveChangesAsync();
return(RedirectToPage("./Index"));
}
PopulateAccountsDropDownList(_context);
return(Page());
}
public void Add(FundTransfer entity)
{
erpNodeDBContext.FundTransfers.Add(entity);
}
protected void add_Callback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
List <Payment> payments;
if (e.Parameters == "clear")
{
Session["listPayment"] = null;
}
#region Add Payment
else
{
payments = new List <Payment>();
decimal amount = 0.0M, amountCheque = 0.0M, amountChequeForTransaction = 0.0M;
if (cbxPayMethod.SelectedItem == null)
{
throw new ApplicationException("เลือกวิธีการชำระเงิน");
}
String payMethod = (String)cbxPayMethod.SelectedItem.Value;
String payType = (cbxPayType.SelectedItem == null ? "Cash" : (String)cbxPayType.SelectedItem.Value);
//Party payee = Organization.FindByCode(iSabayaContext, CommonConstants.PayeeOrgCode);
Payment payment = null;
#region BankDeposit
if (payMethod.Equals("BankAccountDeposit"))
{
BankDeposit bankDeposit = new BankDeposit();
bankDeposit.PaymentType = "BankDeposit";
if (payType.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
bankDeposit.Amount = new Money(amount, iSabayaContext.imSabayaConfig.DefaultCurrency);
bankDeposit.BankAccount = ToBankAccount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.AmountForThisTransaction = amount;
}
else if (payType.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New Cheque
{
payment = new Cheque();
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.StatusDate = DateTime.Now;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PaymentDate = paymentDate.Date;
cheque.PrintChequeDate = TimeInterval.MaxDate;
bankDeposit.Amount = cheque.Amount;
bankDeposit.BankAccount = ToBankAccount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.DueDate = cheque.DueDate.Date;
bankDeposit.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Cheque = cheque;
}
else // 0ld Cheque
{
c.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Amount = c.Amount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.DueDate = c.DueDate.Date;
bankDeposit.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Cheque = c;
}
}
payments.Add(bankDeposit);
}
#endregion BankDeposit
#region FundTransfer
else if (payMethod.Equals("FundTransfer"))
{
amount = (decimal)spnAmount.Value;
FundTransfer fundTransfer = new FundTransfer();
fundTransfer.PaymentType = "FundTransfer";
fundTransfer.FromBankAccount = FromBankAccount;
fundTransfer.ToBankAccount = ToBankAccount;
fundTransfer.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
fundTransfer.AmountForThisTransaction = fundTransfer.Amount.Amount;
fundTransfer.PaymentDate = DateTime.Now;
if (fundTransfer.FromBankAccount == null)
{
throw new ApplicationException("ไม่พบบัญชีต้นทาง");
}
if (fundTransfer.ToBankAccount == null)
{
throw new ApplicationException("ไม่พบบัญชีปลายทาง");
}
payments.Add(fundTransfer);
}
#endregion FundTransfer
#region Cash
else if (payMethod.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
Cash cash = (Cash)payment;
cash.PaymentType = "Cash";
cash.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
cash.PaymentDate = DateTime.Now.Date;
cash.AmountForThisTransaction = amount;
payments.Add(cash);
}
#endregion Cash
#region Cheque
else if (payMethod.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New cheque
{
payment = new Cheque();
payment.PaymentType = "Cheque";
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.PaymentDate = DateTime.Now.Date;
cheque.StatusDate = DateTime.Now;
cheque.PrintChequeDate = TimeInterval.MinDate;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PayableTo = "";
cheque.PrintChequeDate = TimeInterval.MaxDate;
payments.Add(cheque);
}
else
{
c.AmountForThisTransaction = amountChequeForTransaction;
payments.Add(c);
}
}
#endregion Cheque
#region BillPayment
else if (payMethod.Equals("BillPayment"))
{
//no class
BillPayment billPayment = new BillPayment();
billPayment.PaymentType = "Bill Payment";
if (payType.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
Cash cash = (Cash)payment;
billPayment.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
billPayment.PaymentDate = paymentDate.Date.Date;
billPayment.AmountForThisTransaction = amount;
}
else if (payType.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New cheque
{
payment = new Cheque();
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.PaymentDate = paymentDate.Date.Date;
cheque.StatusDate = paymentDate.Date.Date;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PayableTo = "";
cheque.PrintChequeDate = TimeInterval.MaxDate;
//special for bank deposit
billPayment.Amount = cheque.Amount;
billPayment.PaymentDate = cheque.PaymentDate;
billPayment.DueDate = cheque.DueDate.Date;
billPayment.AmountForThisTransaction = amountChequeForTransaction;
//special for bank deposit
billPayment.Cheque = cheque;
}
else // Old cheque
{
c.AmountForThisTransaction = amountChequeForTransaction;
billPayment.Cheque = c;
}
}
payments.Add(billPayment);
}
#endregion BillPayment
Session["listPayment"] = payments;
}
#endregion Add Payment
gridPaymetod.DataSource = Session["listPayment"];
gridPaymetod.DataBind();
}
