public async Task<List<GetTransaction>> GetTransaction4()
{
var _db = new ApplicationDbContext();
IdentityUser user = await UserManager.FindByIdAsync(User.Identity.GetUserId());
var kd = (from c in _db.Users where c.UserName==User.Identity.Name select c ).FirstOrDefault();
var vv = (from c in _db.Transaction
join o in _db.Subscription on new { a = c.Subscription_Code } equals new { a = o.Subscription_Code }
join p in _db.Banks on new { a = c.Bank_Code } equals new { a = p.Bank_Code } into sr
from x in sr.DefaultIfEmpty()
join k in _db.Institutions on new { a = c.Institution_Code } equals new { a = k.Institution_Code }
where ((c.Payment_Status == "Paid" && k.Institution_Code==kd.Institution_Code ))
// where ((c.DateCreated.Date == start_date) && (c.DateCreated.Date <= end_date))
// where (c.DateCreated.Date >= start_date.Date && c.DateCreated.Date <= end_date.Date)
select new { c.Account_Number, c.amount, c.Transaction_Code, o.Subscription_Name, x.Bank_Name, k.Institution_Name, c.user_id, c.Payment_Status, o.Subscription_Code }).ToList();
List<GetTransaction> xk2 = new List<GetTransaction>();
foreach (var vv2 in vv)
{
GetTransaction xk = new GetTransaction();
xk.Account_Number = vv2.Account_Number;
xk.amount = vv2.amount;
xk.Bank_Name = vv2.Bank_Name;
xk.Institution_Name = vv2.Institution_Name;
xk.Subscription_Name = vv2.Subscription_Name;
xk.Transaction_Code = vv2.Transaction_Code;
xk.User_Name = vv2.user_id;
xk.Payment_Status = vv2.Payment_Status;
xk.Subscription_Code = vv2.Subscription_Code;
xk2.Add(xk);
}
return xk2;
}
public async Task<List<GetTransaction>> GetTransaction12()
{
try
{
var _db = new ApplicationDbContext();
var vv = (from c in _db.Subscription_Details
// join d in _db.Subscription_Details on new { a = o.Subscription_Code } equals new { a = d.Subscription_Code }
join o in _db.Subscription on new { a = c.Subscription_Code } equals new { a = o.Subscription_Code }
// join k in _db.Institutions on new { a = c.Institution_Code } equals new { a = k.Institution_Code }
//where ((c.user_id == d.user_id && c.Transaction_Code== d.Transaction_id))\
// where ((c.user_id == d.user_id))
select new { o.Amount, o.Subscription_Name, c.user_id, o.Subscription_Code, Payment_Date =EntityFunctions.TruncateTime( c.Payment_Date), c.Used, Expiry_Date =EntityFunctions.TruncateTime( c.Expiry_Date.Value) }).Distinct().ToList();
List<GetTransaction> xk2 = new List<GetTransaction>();
foreach (var vv2 in vv)
{
GetTransaction xk = new GetTransaction();
// xk.Account_Number = vv2.Account_Number;
xk.amount = vv2.Amount;
// xk.Institution_Name = vv2.Institution_Name;
xk.Subscription_Name = vv2.Subscription_Name;
// xk.Transaction_Code = vv2.Transaction_Code;
xk.User_Name = vv2.user_id;
// xk.Payment_Status = vv2.Payment_Status3;
xk.Subscription_Code = vv2.Subscription_Code;
xk.TranDateTime2 = Convert.ToString(vv2.Payment_Date);
DateTime tt = DateTime.Now;
if (vv2.Subscription_Code == "NG002" && vv2.Payment_Date != null)
{
if (vv2.Expiry_Date > tt.Date)
{
xk2.Add(xk);
// return ddp.ID;
}
}
else if (vv2.Subscription_Code == "NG003" && vv2.Payment_Date != null)
{
if (vv2.Expiry_Date > tt.Date)
{
xk2.Add(xk);
// return ddp.ID;
}
}
else if (vv2.Subscription_Code == "NG001")
{
if (!(vv2.Used))
{
xk2.Add(xk);
}
}
//xk2.Add(xk);
}
return xk2;
}
catch (Exception ee)
{
return null;
}
}
public async Task<List<GetTransaction>> GetTransaction3()
{
var _db = new ApplicationDbContext();
var vv = (from c in _db.Transaction
join o in _db.Subscription on new { a = c.Subscription_Code } equals new { a = o.Subscription_Code }
join p in _db.Banks on new { a = c.Bank_Code } equals new { a = p.Bank_Code } into sr
from x in sr.DefaultIfEmpty()
join k in _db.Institutions on new { a = c.Institution_Code } equals new { a = k.Institution_Code }
// where ((c.Payment_Status == "Paid"))
// where ((c.DateCreated.Date == start_date) && (c.DateCreated.Date <= end_date))
// where (c.DateCreated.Date >= start_date.Date && c.DateCreated.Date <= end_date.Date)
select new { c.Account_Number, c.amount, c.Transaction_Code, o.Subscription_Name, x.Bank_Name, k.Institution_Name, c.user_id, c.Payment_Status, o.Subscription_Code ,c.Order_Id,c.Transaction_Status}).ToList();
List<GetTransaction> xk2 = new List<GetTransaction>();
foreach (var vv2 in vv)
{
GetTransaction xk = new GetTransaction();
xk.Account_Number = vv2.Account_Number;
xk.amount = vv2.amount;
xk.Bank_Name = vv2.Bank_Name;
xk.Institution_Name = vv2.Institution_Name;
xk.Subscription_Name = vv2.Subscription_Name;
xk.Transaction_Code = vv2.Transaction_Code;
xk.User_Name = vv2.user_id;
xk.Payment_Status = vv2.Payment_Status;
xk.Subscription_Code = vv2.Subscription_Code;
xk.Order_Id = vv2.Order_Id;
xk.Transaction_Status = vv2.Transaction_Status;
xk2.Add(xk);
}
return xk2;
}
public async Task<GetTransaction> GetTransaction([FromUri] String property1)
{
var _db = new ApplicationDbContext();
var vv = (from c in _db.Transaction
join o in _db.Subscription on new { a = c.Subscription_Code } equals new { a = o.Subscription_Code }
join p in _db.Banks on new { a = c.Bank_Code } equals new { a = p.Bank_Code }
into sr
from x in sr.DefaultIfEmpty()
join k in _db.Institutions on new { a = c.Institution_Code } equals new { a = k.Institution_Code }
where ((c.Transaction_Code == property1))
// where ((c.DateCreated.Date == start_date) && (c.DateCreated.Date <= end_date))
// where (c.DateCreated.Date >= start_date.Date && c.DateCreated.Date <= end_date.Date)
select new { c.Account_Number, c.amount,c.Transaction_Code, o.Subscription_Name, x.Bank_Name,k.Institution_Name ,c.user_id,c.Transaction_Date,c.Payment_Status}).FirstOrDefault();
GetTransaction xk = new GetTransaction();
xk.Account_Number = vv.Account_Number;
xk.amount = vv.amount;
xk.Bank_Name = vv.Bank_Name;
xk.Institution_Name = vv.Institution_Name;
xk.Subscription_Name = vv.Subscription_Name;
xk.Transaction_Code = vv.Transaction_Code;
xk.User_Name = vv.user_id;
xk.ResponseDescription2 = vv.Payment_Status;
xk.TranDateTime2 =Convert.ToString( vv.Transaction_Date);
return xk;
}