public HttpResponseMessage TransferAmount(Models.TransferData transferData)
{
try
{
var currentUser = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d;
if (currentUser.Any())
{
var source = from d in db.MstCards
where d.CardNumber == currentUser.FirstOrDefault().MotherCardNumber
select d;
var destination = from d in db.MstCards
where d.CardNumber == transferData.DestinationCardNumber
select d;
if (source.Any() && destination.Any())
{
if (source.FirstOrDefault().Status.Equals("Disable"))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Cannot transfer if the current source card or mother card is disabled."));
}
else if (destination.FirstOrDefault().Status.Equals("Disable"))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Cannot transfer if the current destination card is disabled."));
}
else
{
Decimal sourceBalance = source.FirstOrDefault().Balance;
if (sourceBalance >= transferData.Amount &&
source.FirstOrDefault().UserId == destination.FirstOrDefault().UserId)
{
Data.TrnLedger newLedgerSource = new Data.TrnLedger()
{
CardId = source.FirstOrDefault().Id,
CardNumber = source.FirstOrDefault().CardNumber,
LedgerDateTime = DateTime.Now,
DebitAmount = 0,
CreditAmount = transferData.Amount,
Particulars = transferData.Particulars
};
Data.TrnLedger newLedgerDestination = new Data.TrnLedger()
{
CardId = destination.FirstOrDefault().Id,
CardNumber = destination.FirstOrDefault().CardNumber,
LedgerDateTime = DateTime.Now,
DebitAmount = transferData.Amount,
CreditAmount = 0,
Particulars = transferData.Particulars
};
db.TrnLedgers.InsertOnSubmit(newLedgerSource);
db.TrnLedgers.InsertOnSubmit(newLedgerDestination);
db.SubmitChanges();
var updateSource = source.FirstOrDefault();
var updateDistination = destination.FirstOrDefault();
updateSource.Balance = source.FirstOrDefault().TrnLedgers.Any() ? source.FirstOrDefault().TrnLedgers.Sum(s => s.DebitAmount - s.CreditAmount) : 0;
updateDistination.Balance = destination.FirstOrDefault().TrnLedgers.Any() ? destination.FirstOrDefault().TrnLedgers.Sum(d => d.DebitAmount - d.CreditAmount) : 0;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The source card balance should be greater than or equal to your destination card balance."));
}
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Some cards are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. No current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server. " + e.Message));
}
}
public HttpResponseMessage Post(Models.TransferData transferData)
{
Int32 creditId = 0;
var source = from d in db.MstCards
where d.CardNumber == transferData.SourceCardNumber
select d;
var destination = from d in db.MstCards
where d.CardNumber == transferData.DestinationCardNumber
select d;
// Both cards must be enabled.
if (source.Any() && destination.Any())
{
if (source.FirstOrDefault().Status.Equals("Disable"))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Cannot transfer if the current source card or mother card is disabled."));
}
else if (destination.FirstOrDefault().Status.Equals("Disable"))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Cannot transfer if the current destination card is disabled."));
}
else
{
decimal sourceBalance = 0;
// Source Balance should be greater than the transferred amount.
// The source card owner should be the same with the destination card owner.
sourceBalance = source.FirstOrDefault().Balance;
if (sourceBalance >= transferData.Amount &&
source.FirstOrDefault().UserId == destination.FirstOrDefault().UserId)
{
try
{
var s = source.FirstOrDefault();
var d = destination.FirstOrDefault();
DateTime timeStamp = DateTime.Now;
Data.TrnLedger newLedger1 = new Data.TrnLedger()
{
CardId = s.Id,
CardNumber = s.CardNumber,
LedgerDateTime = timeStamp,
DebitAmount = 0,
CreditAmount = transferData.Amount,
Particulars = transferData.Particulars
};
Data.TrnLedger newLedger2 = new Data.TrnLedger()
{
CardId = d.Id,
CardNumber = d.CardNumber,
LedgerDateTime = timeStamp,
DebitAmount = transferData.Amount,
CreditAmount = 0,
Particulars = transferData.Particulars
};
db.TrnLedgers.InsertOnSubmit(newLedger1);
db.TrnLedgers.InsertOnSubmit(newLedger2);
db.SubmitChanges();
s.Balance = s.TrnLedgers.Sum(t => t.DebitAmount - t.CreditAmount);
d.Balance = d.TrnLedgers.Sum(t => t.DebitAmount - t.CreditAmount);
db.SubmitChanges();
creditId = newLedger1.Id;
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent(e.ToString())
});
}
}
else
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("Invalid Card")
});
}
}
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent(creditId.ToString())
});
}
else
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("Invalid Card")
});
}
}
