public HttpResponseMessage financeup(int id)
{
try
{
using (project1Entities db = new project1Entities())
{
var data = db.Finances.Find(id);
CardDetail card = db.CardDetails.Where(x => x.Email == data.Email).FirstOrDefault();
if (data == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Purchase with finance id " + id + " not found"));
}
else
{
data.Months = data.Months - 1;
//data.EmiAmount = finance.EmiAmount;
//data.TotalAmount = finance.TotalAmount;
data.RemainingAmount = data.RemainingAmount - data.EmiAmount;
//data.purchaseDate = finance.purchaseDate;
//data.ProductID = finance.ProductID;
data.LastPaymentDate = DateTime.Now;
card.CurrentLimit = card.CurrentLimit + data.EmiAmount;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage PostFinance(string Email, int ProductID, [FromBody] Finance finance)
{
try
{
using (project1Entities db = new project1Entities())
{
var limit = db.CardDetails.Where(cd => cd.Email == Email).FirstOrDefault();
var price = db.Products.Where(pr => pr.ProductID == ProductID).FirstOrDefault();
if (limit.CurrentLimit > price.Price)
{
limit.CurrentLimit = limit.CurrentLimit - price.Price;
finance.purchaseDate = DateTime.Now;
db.Finances.Add(finance);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, finance));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Finance id cannot be created due to low current limit"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetDashBoard(string email)
{
project1Entities db = new project1Entities();
var data = from cd in db.CardDetails
join fn in db.Finances on cd.Email equals fn.Email
join pr in db.Products on fn.ProductID equals pr.ProductID
where cd.UserTable.Email == email
select new
{
Card_Number = cd.CardNumber,
Email = cd.UserTable.Email,
Name = cd.UserTable.Name,
Valid_Till = cd.ValidTill.ToString("MM/yy"),
Card_Type = cd.CardType,
Total_Credit = fn.TotalAmount,
Credit_used = fn.TotalAmount - fn.RemainingAmount,
Remaining_Credit = fn.RemainingAmount,
Product_Name = pr.ProductName,
Amount = pr.Price,
Paid = fn.TotalAmount - fn.RemainingAmount,
Balance = fn.TotalAmount - fn.RemainingAmount,
Product = pr.ProductName,
Date = fn.LastPaymentDate,
Amount_Paid = fn.TotalAmount - fn.RemainingAmount
};
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
//public HttpResponseMessage Register(string Email, string password, string Name, string PhoneNumber, string username,
// string Address, string CardType, string BankName, string AccountNumber, string IFSCCode)
public HttpResponseMessage Registertest([FromBody] regandlogin ub)
{
project1Entities db = new project1Entities();
UserTable tabledata = new UserTable();
var emailAlreadyExists = db.UserTables.Find(ub.Email);
if (emailAlreadyExists != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Already Exists!"));
}
tabledata.Email = ub.Email;
tabledata.password = ub.password;
tabledata.Name = ub.Name;
tabledata.PhoneNumber = ub.PhoneNumber;
tabledata.username = ub.username;
tabledata.validation = ub.validation;
tabledata.Address = ub.Address;
tabledata.CardType = ub.CardType;
db.UserTables.Add(tabledata);
db.SaveChanges();
BankDetail data = new BankDetail();
data.Email = ub.Email;
data.BankName = ub.BankName;
data.AccountNumber = ub.AccountNumber;
data.IFSCCode = ub.IFSCCode;
db.BankDetails.Add(data);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, ub));
}
public HttpResponseMessage PutFinance(int FinanceID, [FromBody] Finance finance)
{
try
{
using (project1Entities db = new project1Entities())
{
var data = db.Finances.Find(FinanceID);
if (data == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Purchase with finance id " + FinanceID + "not found"));
}
else
{
data.Email = finance.Email;
data.Months = finance.Months;
data.EmiAmount = finance.EmiAmount;
data.TotalAmount = finance.TotalAmount;
data.RemainingAmount = finance.RemainingAmount;
data.purchaseDate = finance.purchaseDate;
data.ProductID = finance.ProductID;
data.LastPaymentDate = finance.LastPaymentDate;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Approved(string Email)
{
try
{
using (project1Entities db = new project1Entities())
{
UserTable user = db.UserTables.Find(Email);
CardType type = db.CardTypes.Find(user.CardType);
Random rnd = new Random();
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "User with Email " + Email + "not found"));
}
DateTime d1 = DateTime.Now;
user.validation = "Approved";
CardDetail card = new CardDetail();
card.Type = user.CardType;
card.Email = user.Email;
card.CurrentLimit = type.Limit;
card.ValidFrom = d1;
card.ValidTill = d1.AddYears(4);
card.CVV = rnd.Next(101, 999);
db.CardDetails.Add(card);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, user));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Login(string email, string password)
{
project1Entities db = new project1Entities();
UserTable tabledata = new UserTable();
var data = db.UserTables.Where(x => x.Email == email && x.password == password).FirstOrDefault();
if (data != null && data.validation.Trim() == "Approved")
{
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
else if (data != null && data.validation.Trim() == "ToValidate")
{
return(Request.CreateResponse(HttpStatusCode.OK, "yet to get approved"));
}
else if (data != null && data.validation.Trim() == "Rejected")
{
return(Request.CreateResponse(HttpStatusCode.OK, "Request Rejected"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invalid Email or password"));
}
}
public HttpResponseMessage ChangePassword(string email, string phonenumber, string pwd)
{
try
{
project1Entities db = new project1Entities();
UserTable ut = new UserTable();
var data = db.UserTables.Find(email);
if (data == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Account with given email is not found"));
}
else
{
if (data.PhoneNumber == phonenumber)
{
data.password = pwd;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Password Changed!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Phone number is wrong"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Please try again!"));
}
}
public HttpResponseMessage GetFinance()
{
using (project1Entities db = new project1Entities())
{
var data = db.Finances.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
public HttpResponseMessage FinanaceDashBoard()
{
project1Entities db = new project1Entities();
var data1 = from fn1 in db.Finances
select new
{
Total_Credit = fn1.TotalAmount,
Credit_used = fn1.TotalAmount - fn1.RemainingAmount,
Remaining_Credit = fn1.RemainingAmount
};
return(Request.CreateResponse(HttpStatusCode.OK, data1));
}
public HttpResponseMessage CardDashBoard()
{
project1Entities db = new project1Entities();
var data = from cd1 in db.CardDetails
select new
{
CardNumber = cd1.CardNumber,
Name = cd1.UserTable.Name,
Valid_Till = cd1.ValidTill.ToString("MM/yy"),
Card_Type = cd1.CardType
};
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage GetFinance(int FinanceID)
{
using (project1Entities db = new project1Entities())
{
var data = db.Finances.Find(FinanceID);
if (data != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Purchase with finance id " + FinanceID + "not found"));
}
}
}
public HttpResponseMessage Adminlogin(string Email, string password)
{
project1Entities db = new project1Entities();
var data = db.Admins.Where(x => x.Email == Email && x.password == password);
if (data != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invalid Credentials"));
}
}
public HttpResponseMessage PostFinance([FromBody] Finance finance)
{
try
{
using (project1Entities db = new project1Entities())
{
db.Finances.Add(finance);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, finance));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Rejected(string Email)
{
try
{
using (project1Entities db = new project1Entities())
{
UserTable user = db.UserTables.Find(Email);
user.validation = "Rejected";
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, user));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage ProductDashBoard()
{
project1Entities db = new project1Entities();
var data2 = from pr1 in db.Products
join fn1 in db.Finances on pr1.ProductID equals fn1.ProductID
select new
{
Product_Name = pr1.ProductName,
Amount = pr1.Price,
Paid = fn1.TotalAmount - fn1.RemainingAmount,
Balance = fn1.TotalAmount - fn1.RemainingAmount,
Product = pr1.ProductName,
Date = fn1.LastPaymentDate,
Amount_Paid = fn1.TotalAmount - fn1.RemainingAmount
};
return(Request.CreateResponse(HttpStatusCode.OK, data2));
}
public HttpResponseMessage GetDashBoard(string email)
{
project1Entities db = new project1Entities();
var data = from c in db.CardDetails
join u in db.UserTables on c.Email equals u.Email
where c.Email == email
select new
{
CardNumber = c.CardNumber,
Name = u.Name,
Type = c.Type,
CurrentLimit = c.CurrentLimit,
ValidFrom = c.ValidFrom,
ValidTill = c.ValidTill,
CVV = c.CVV
};
return(Request.CreateResponse(HttpStatusCode.OK, data.ToList()));
}
public HttpResponseMessage UserDetails()
{
using (project1Entities db = new project1Entities())
{
var u = from user in db.UserTables
where user.validation == "ToValidate"
select new
{
Email = user.Email,
Name = user.Name,
Phone = user.PhoneNumber,
Username = user.username,
Address = user.Address,
Cardtype = user.CardType,
Validation = user.validation
};
var data = u.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
public HttpResponseMessage Details(string Email)
{
using (project1Entities db = new project1Entities())
{
var data = db.UserTables.Include("BankDetail").Where(s => s.Email == Email).FirstOrDefault <UserTable>();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
//from user in db.UserTables
//where user.Email == Email
//select new
//{
// Email = user.Email,
// Name = user.Name,
// Phone = user.PhoneNumber,
// Username = user.username,
// Address = user.Address,
// Cardtype = user.CardType,
// Validation = user.validation
//};
}
public HttpResponseMessage UserFinance(string Email)
{
using (project1Entities db = new project1Entities())
{
var data = (from f in db.Finances
join u in db.UserTables on f.Email equals u.Email
join p in db.Products on f.ProductID equals p.ProductID
where f.Email == Email
select new
{
FinanceID = f.FinanceID,
Email = f.Email,
Months = f.Months,
EmiAmount = f.EmiAmount,
TotalAmount = f.TotalAmount,
RemainingAmount = f.RemainingAmount,
purchaseDate = f.purchaseDate,
ProductName = p.ProductName,
LastPaymentDate = f.LastPaymentDate,
userName = u.username
}).AsEnumerable().Select(x => new {
FinanceID = x.FinanceID,
Email = x.Email,
Months = x.Months,
EmiAmount = x.EmiAmount,
TotalAmount = x.TotalAmount,
RemainingAmount = x.RemainingAmount,
purchaseDate = x.purchaseDate,
ProductName = x.ProductName,
LastPaymentDate = x.LastPaymentDate,
userName = x.userName,
value = getvDate(x.LastPaymentDate, x.Months)
});
var finance = data.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, finance));
}
}
public HttpResponseMessage DeleteFinance(int FinanceId)
{
try
{
using (project1Entities db = new project1Entities())
{
var data = db.Finances.Find(FinanceId);
if (data == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Purchase with finance id" + FinanceId + "not found"));
}
else
{
db.Finances.Remove(data);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
