public async Task<String> AddTransaction3(Transaction foo)
{
var httpRequest = HttpContext.Current.Request;
try
{
var _db = new ApplicationDbContext();
// string currentUserId = User.Identity.GetUserId();
Transaction aaa = new Transaction();
aaa.amount = foo.amount;
aaa.Bank_Code = foo.Bank_Code;
aaa.Institution_Code = foo.Institution_Code;
aaa.Payment_Status = "Pending";
//if (foo.Transaction_Status == "Approved")
//{
// aaa.Payment_Status = "Paid";
//}
//else
//{
// aaa.Payment_Status = "error";
//}
aaa.Subscription_Code = foo.Subscription_Code;
// aaa.Transaction_Code = Generate15UniqueDigits();
aaa.Transaction_Code = foo.Transaction_Code;
aaa.payment_type = foo.payment_type;
aaa.Account_Number = foo.Account_Number;
aaa.user_id = foo.user_id;
aaa.Status = "Unused";
aaa.Order_Id = foo.Order_Id;
aaa.Transaction_Date = DateTime.Now;
aaa.Transaction_Status = foo.Transaction_Status;
aaa.Service = foo.Service;
_db.Transaction.Add(aaa);
var kk = _db.SaveChanges();
//Subscription_Detail2 hh = new Subscription_Detail2();
//hh.Payment_Date = DateTime.Now;
//hh.Subscription_Code = foo.Subscription_Code;
//hh.user_id = foo.user_id;
//hh.Transaction_Code = foo.Transaction_Code;
//if (foo.Transaction_Status == "Approved")
//{
// AddSubscription_Detail3(hh);
//}
// _db.SaveChanges();
var xk = (from c in _db.User_Detail where c.User_Id == foo.user_id && c.Services == foo.Subscription_Code select c).Count();
if (xk > 0)
{
}
else
{
User_Detail gs = new User_Detail();
gs.Fee_amount = 0.0;
gs.Services = foo.Service;
gs.User_Id = foo.user_id;
gs.Fee = false;
_db.User_Detail.Add(gs);
_db.SaveChanges();
}
return aaa.Transaction_Code;
}
catch (Exception ee)
{
return ee.Message; ;
}
}
public async Task<String> AddTransaction2(Transaction foo2)
{
var httpRequest = HttpContext.Current.Request;
try
{
var _db = new ApplicationDbContext();
var foo = (from c in _db.Transaction where c.Order_Id == foo2.Order_Id select c).FirstOrDefault();
var foo3 = (from c in _db.Users where c.UserName == foo.user_id select c).FirstOrDefault();
// string currentUserId = User.Identity.GetUserId();
//Transaction aaa = new Transaction();
//foo.amount = foo2.amount;
//foo.Bank_Code = foo2.Bank_Code;
//aaa.Institution_Code = foo.Institution_Code;
if (foo2.Transaction_Status == "Approved")
{
foo.Payment_Status = "Approved";
}
else
{
foo.Payment_Status = "Declined";
}
//aaa.Subscription_Code = foo.Subscription_Code;
//aaa.Transaction_Code =foo.Transaction_Code;
//aaa.payment_type = foo.payment_type;
//aaa.Account_Number = foo.Account_Number;
//aaa.user_id = foo.user_id;
foo.Status = "Unused";
//aaa.Order_Id = foo.Order_Id;
foo.Transaction_Date = DateTime.Now;
foo.Transaction_Status = foo2.Transaction_Status;
foo.Transaction_Code = foo2.Transaction_Code;
// _db.Transaction.Add(aaa);
var kk = _db.SaveChanges();
Subscription_Detail2 hh = new Subscription_Detail2();
hh.Payment_Date = DateTime.Now;
hh.Subscription_Code = foo2.Subscription_Code;
hh.user_id = foo2.user_id;
hh.Transaction_Code = foo2.Transaction_Code;
hh.Service = foo2.Service;
if (foo.Transaction_Status == "Approved") {
if (foo3.Institution_Code != null)
{
var foo4 = (from c in _db.User_Detail where c.User_Id == foo.user_id select c).ToList();
foreach (var kd in foo4)
{
hh.Service = kd.Services;
AddSubscription_Detail3(hh);
}
}
else
{
AddSubscription_Detail3(hh);
}
}
// _db.SaveChanges();
return foo2.Transaction_Code;
}
catch (Exception ee)
{
return ee.Message; ;
}
}