public void CreatePermit(Models.ViewModel.VVehiclePermit VehiclePermit)
{
using (oversiiEntities db = new oversiiEntities())
{
db.ApplyPermit(VehiclePermit.Vehicle.VehicleMake.VehicleMakeID, VehiclePermit.Vehicle.VehicleColor.VehicleColorID, 1, VehiclePermit.Vehicle.MakeYear, VehiclePermit.Vehicle.LicPlateNum, VehiclePermit.Vehicle.State.StateID);
}
}
public List<Models.DB.VehicleColor> VehicleColorList()
{
using (oversiiEntities db = new oversiiEntities())
{
List<Models.DB.VehicleColor> RS = new List<VehicleColor>();
RS = db.VehicleColors.ToList();
return RS;
}
}
public List<Models.DB.State> StateList()
{
using (oversiiEntities db = new oversiiEntities())
{
List<Models.DB.State> RS = new List<State>();
RS = db.States.ToList();
return RS;
}
}
public AuthenticateUser_Result AuthenticateUser(string email,string password)
{
using (oversiiEntities db = new oversiiEntities())
{
List<AuthenticateUser_Result> RS = new List<AuthenticateUser_Result>();
RS = db.AuthenticateUser(email, password).ToList();
return RS.FirstOrDefault();
}
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
using (oversiiEntities db = new oversiiEntities())
{
UserRepository UM = new UserRepository();
foreach (var roles in userAssignedRoles)
{
authorize = UM.IsUserInRole(httpContext.User.Identity.Name, roles);
if (authorize)
return authorize;
}
}
return authorize;
}
//public void AddUserAccount(UserAccount resident)
//{
// using (oversiiEntities db = new oversiiEntities())
// {
// user US = new user();
// US.Email = resident.Email;
// US.Password = resident.Password;
// US.FirstName = resident.FirstName;
// US.LastName = resident.LastName;
// US.Phone1 = resident.Phone1;
// US.Phone2 = resident.Phone2;
// US.CreateDate = DateTime.Now;
// db.users.Add(US);
// db.SaveChanges();
// }
//}
//public bool ISEmailExist(string email)
//{
// using (oversiiEntities db = new oversiiEntities())
// {
// return db.users.Where(o => o.Email.Equals(email)).Any();
// }
//}
//public string GetUserPassword(string emailid)
//{
// using (oversiiEntities db = new oversiiEntities())
// {
// var user = db.users.Where(o => o.Email.ToLower().Equals(emailid));
// if (user.Any())
// return user.FirstOrDefault().Password;
// else
// return string.Empty;
// }
//}
//public string GetParkingGL(int? propID)
//{
// using (oversiiEntities db = new oversiiEntities())
// {
// var parkingGL = (from pr in db.properties
// where pr.propID == propID
// select pr.parkingGL).FirstOrDefault();
// if (parkingGL != null)
// return parkingGL.ToString();
// else
// return null;
// }
//}
//public List<Oversii.Models.DB.property> PropertyList(string zipcode)
//{
// using (oversiiEntities db = new oversiiEntities())
// {
// var propmgmtid = (from pm in db.property_management
// where pm.Zipcode.Equals(zipcode)
// select pm.propertyMgmtID).ToList();
// var propertyList = (from pr in db.properties where propmgmtid.Contains(pr.propertyMgmtID)
// select pr).ToList();
// return propertyList;
// }
//}
public List<Models.DB.VehicleMake> VehilceMakeList()
{
using (oversiiEntities db = new oversiiEntities())
{
List<Models.DB.VehicleMake> RS = new List<VehicleMake>();
RS = db.VehicleMakes.ToList();
return RS;
}
}