public ActionResult DeleteCheckAccount(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
creditcard creditcard = db.creditcard.Find(id);
if (creditcard == null)
{
return(HttpNotFound());
}
account creditCardAccount = creditcard.account;
if (creditCardAccount.creditcard.Count == 1)
{
if (creditCardAccount.balance > 0)
{
return(Json("LAST_CARD_NON_ZERO_BALANCE"));
}
return(Json("LAST_CARD"));
}
return(Json("DELETE"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
creditcard creditcard = db.creditcard.Find(id);
if (creditcard == null)
{
return(HttpNotFound());
}
account creditCardAccount = creditcard.account;
db.creditcard.Remove(creditcard);
if (creditCardAccount.creditcard.Count == 0)
{
db.account.Remove(creditCardAccount);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
creditcard creditcard = db.card_table.Find(id);
db.card_table.Remove(creditcard);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,email_address,creditcard_number,cvc,Card_Holder")] creditcard creditcard)
{
if (ModelState.IsValid)
{
db.Entry(creditcard).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(creditcard));
}
public ActionResult Create([Bind(Include = "cardnumber")] creditcard creditcard)
{
if (ModelState.IsValid)
{
db.creditcards.Add(creditcard);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(creditcard));
}
public ActionResult addcredit(string first_name, string surname, string card_number,
int month, int year, string ccv, string address, string country, string state, string city,
string postal_code, string phone)
{
try
{
long userId = (long)Session["USER_ID"];
creditcard creditcardItem = entities.creditcards.Where(m => m.user_id == userId).FirstOrDefault();
if (creditcardItem == null)
{
creditcardItem = new creditcard();
creditcardItem.first_name = first_name;
creditcardItem.surname = surname;
creditcardItem.card_number = card_number;
creditcardItem.ccv = ccv;
creditcardItem.address = address;
creditcardItem.country = country;
creditcardItem.state = state;
creditcardItem.city = city;
creditcardItem.postal_code = postal_code;
creditcardItem.phone = phone;
creditcardItem.user_id = userId;
creditcardItem.expiration_date = new DateTime(year, month, 1);
creditcardItem.created_at = DateTime.Now;
creditcardItem.updated_at = DateTime.Now;
entities.creditcards.Add(creditcardItem);
}
else
{
creditcardItem.first_name = first_name;
creditcardItem.surname = surname;
creditcardItem.card_number = card_number;
creditcardItem.ccv = ccv;
creditcardItem.address = address;
creditcardItem.country = country;
creditcardItem.state = state;
creditcardItem.city = city;
creditcardItem.postal_code = postal_code;
creditcardItem.phone = phone;
creditcardItem.expiration_date = new DateTime(year, month, 1);
creditcardItem.updated_at = DateTime.Now;
}
entities.SaveChanges();
return(Redirect(Url.Action("balance", "cuotas")));
}
catch (Exception ex)
{
return(Redirect(Url.Action("balance", "cuotas")));
}
}
// GET: creditcards/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
creditcard creditcard = db.card_table.Find(id);
if (creditcard == null)
{
return(HttpNotFound());
}
return(View(creditcard));
}
// GET: creditcards/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
creditcard creditcard = db.creditcards.Find(id);
if (creditcard == null)
{
return(HttpNotFound());
}
return(View(creditcard));
}
public ActionResult Edit([Bind(Include = "cardID,cardNumber,expirationDate,securityCode,customerFirstName,customerLastName,accountID")] creditcard creditcard)
{
if (db.creditcard.Where(x => x.cardNumber == creditcard.cardNumber && x.cardID != creditcard.cardID).Count() > 0)
{
ModelState.AddModelError("cardNumber", "Credit card number all ready exists.");
}
if (ModelState.IsValid)
{
db.Entry(creditcard).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(creditcard));
}
public ActionResult Create([Bind(Include = "id,email_address,creditcard_number,cvc,Card_Holder")] creditcard creditcard)
{
if (ModelState.IsValid)
{
if (creditcard.Card_Holder == null || creditcard.creditcard_number == null || creditcard.cvc == null)
{
ViewBag.data = "All fields must be completed";
return(View());
}
db.card_table.Add(creditcard);
db.SaveChanges();
ViewBag.confirmation = "you have successfully booked! Have a nice trip ";
return(RedirectToAction("Index", "Customers"));
}
return(View(creditcard));
}
public async Task <ActionResult> MakePayment(decimal cost, decimal taxCharge, decimal penalty)
{
try
{
long communityAct = Convert.ToInt64(Session["CURRENT_COMU"]);
string paymentType = "CC"; // CreditCard
bool makePayment = false;
long userId = (long)Session["USER_ID"];
user curUser = entities.users.Find(userId);
long adminId = (long)curUser.create_userid;
fee feeItem = entities.fees.Where(m => m.user_id == adminId && m.community_id == communityAct).FirstOrDefault();
bank adminBankItem = entities.banks.Find(feeItem.bank_id);
string bank_account = adminBankItem.account_number;
string routing_number = adminBankItem.route_number;
string account_name = adminBankItem.account_name;
user adminUser = entities.users.Find(adminId);
decimal totalAmount = cost + taxCharge + penalty;
creditcard creditcardItem = entities.creditcards.Where(m => m.user_id == userId).FirstOrDefault();
StripeConfiguration.SetApiKey(ep.GetStripeSecretKey());
if (creditcardItem != null)
{
DateTime expire_date = (DateTime)creditcardItem.expiration_date;
var options = new TokenCreateOptions
{
Card = new CreditCardOptions
{
Number = creditcardItem.card_number, //"4000 0000 0000 0077", //creditcardItem.card_number,//"4242424242424242"
ExpYear = expire_date.Year, //2020
ExpMonth = expire_date.Month,
Cvc = creditcardItem.ccv
}
};
var service = new TokenService();
Token stripeToken = service.Create(options);
int pc = await PaymentCredit(stripeToken.Id, Convert.ToInt32(cost * 100),
bank_account, routing_number, account_name);
if (pc == 1)
{
paymentType = "CC";
makePayment = true;
}
}
else
{
bank userBank = entities.banks.Where(m => m.user_id == userId).FirstOrDefault();
if (userBank != null)
{
var options = new TokenCreateOptions
{
BankAccount = new BankAccountOptions
{
Country = "US",
Currency = "usd",
AccountHolderName = userBank.account_name, //"Jenny Rosen"
AccountHolderType = "individual",
RoutingNumber = userBank.route_number, //"110000000"
AccountNumber = userBank.account_number //"000123456789"
}
};
var service = new TokenService();
Token stripeToken = service.Create(options);
int ach = await PaymentAch(stripeToken.Id, Convert.ToInt32(totalAmount * 100),
bank_account, routing_number);
if (ach == 1)
{
paymentType = "ACH";
makePayment = true;
}
}
}
if (makePayment == true)
{
transaction transItem = new transaction();
if (transItem.balance != null)
{
decimal originBalance = (decimal)transItem.balance;
transItem.balance = originBalance + totalAmount;
}
else
{
transItem.balance = totalAmount;
}
transItem.credit = 0;
transItem.debit = totalAmount;
transItem.date_info = DateTime.Now;
transItem.kind = "Factura";
transItem.state = "Factura";
transItem.trans_id = "";
entities.transactions.Add(transItem);
payment paymentItem = new payment();
paymentItem.method = paymentType;
paymentItem.date_issue = DateTime.Now;
paymentItem.date_payment = null;
paymentItem.email = adminUser.email;
paymentItem.first_name = adminUser.first_name1;
paymentItem.surname = adminUser.last_name1;
paymentItem.to_user_id = adminId;
paymentItem.quantity = totalAmount;
paymentItem.user_id = userId;
paymentItem.state = true;
entities.payments.Add(paymentItem);
entities.SaveChanges();
}
return(Redirect(Url.Action("estado", "cuotas")));
}
catch (Exception ex)
{
return(Redirect(Url.Action("balance", "cuotas")));
}
}
public ActionResult ProcessTransaction(int id)
{
transaction currentTransaction = null;
String currentCardNumber = null;
creditcard currentCard = null;
account currentAccount = null;
int currentCardCount = 0;
currentTransaction = db.transaction.Where(x => x.transactionID == id).FirstOrDefault();
currentTransaction.isProcessed = true;
currentTransaction.isEncrypted = false;
currentCardNumber = currentTransaction.cardNumber;
currentCardCount = db.creditcard.Where(x => x.cardNumber == currentCardNumber).Count();
currentTransaction.timeOfResponse = DateTime.Now;
if (currentCardCount < 1)
{
currentTransaction.status = false;
db.SaveChanges();
return(PartialView("_DetailTransactionRowPartial", currentTransaction));
}
else
{
currentCard = db.creditcard.Where(x => x.cardNumber == currentCardNumber).FirstOrDefault();
currentAccount = currentCard.account;
}
if (!currentTransaction.expirationDate.Equals(currentCard.expirationDate) ||
!((currentTransaction.securityCode) == (currentCard.securityCode)))
{
currentTransaction.status = false;
db.SaveChanges();
return(PartialView("_DetailTransactionRowPartial", currentTransaction));
}
var totalSpendingCredit = currentAccount.spendingLimit - currentAccount.balance;
currentTransaction.cardID = currentCard.cardID;
if (currentTransaction.expirationDate < DateTime.Now)
{
currentTransaction.status = false;
db.SaveChanges();
return(PartialView("_DetailTransactionRowPartial", currentTransaction));
}
if (currentTransaction.isCredit && currentTransaction.amount < totalSpendingCredit)
{
//transaction approved
currentTransaction.status = true;
currentAccount.balance = currentAccount.balance + currentTransaction.amount;
db.SaveChanges();
}
else if (!currentTransaction.isCredit)
{
//transaction approved
currentTransaction.status = true;
currentAccount.balance = currentAccount.balance - currentTransaction.amount;
db.SaveChanges();
}
else
{
//transaction declined
currentTransaction.status = false;
db.SaveChanges();
}
return(PartialView("_DetailTransactionRowPartial", currentTransaction));
}
