public List <BookingsViewModel> GetListofBookings()
{
var _entities = new PegasusEntities();
// _entities.Configuration.ProxyCreationEnabled = false;
List <Booking> bookings = new List <Booking>();
List <BookingsViewModel> bookingdetails = new List <BookingsViewModel>();
var context = new ApplicationUser.ApplicationDbContext();
try
{
bookings = (from c in _entities.Bookings select c).ToList();
bookingdetails = (from b in bookings
let firstOrDefault = context.Users.FirstOrDefault(x => x.Id == b.b_createdbyUser)
where firstOrDefault != null
join s in _entities.ServiceTypes on b.typeofservice equals s.serviceId
select new BookingsViewModel
{
trn_Id = b.trn_Id,
c_Id = b.c_Id,
noofperson = b.noofperson,
occasion = b.occasion,
packagename = b.Package.p_descripton,
packageType = b.Package.p_type.Trim(),
amoutperPax = Convert.ToDecimal(b.Package.p_amountPax),
venue = b.venue,
typeofservice = b.typeofservice,
startdate = b.startdate,
enddate = b.enddate,
transdate = b.transdate,
serve_status = b.serve_stat,
serviceType = s.servicetypedetails,
eventcolor = b.eventcolor,
pId = Convert.ToInt32(b.p_id),
fullname = Utilities.getfullname(b.Customer.lastname, b.Customer.firstname, b.Customer.middle),
b_createdbyUser = b.b_createdbyUser,
b_createdbyUserName = firstOrDefault.UserName,
refernce = b.reference,
apply_extendedAmount = (bool)b.apply_extendedAmount,
b_updatedDate = Convert.ToDateTime(b.b_updatedDate),
iscancelled = Convert.ToBoolean(b.is_cancelled),
booktypecode = !string.Equals(b.booktype, null, StringComparison.Ordinal) ?b.booktype:"",
no_of_lackingMenus = BookMenusViewModel.GetTotalLackingMenus(Convert.ToInt32(b.p_id), b.trn_Id)
}).ToList();
//}).Where(x=>x.serve_status==false).OrderBy(d => d.startdate).ToList();
}
catch (EntityCommandExecutionException eceex)
{
if (eceex.InnerException != null)
{
throw eceex.InnerException;
}
throw;
}
return(bookingdetails.ToList());
}
public ActionResult GetProfileInformation(string userId)
{
var context = new ApplicationUser.ApplicationDbContext();
var userprofile = context.Users.FirstOrDefault(u => u.Id == userId);
UserProfileViewModel userProfile = new UserProfileViewModel();
//ViewBag.userRoles = string.Join(",", UserManager.GetRoles(userId));
if (userprofile != null)
{
userProfile = new UserProfileViewModel()
{
uId = userprofile.Id,
username = userprofile.UserName,
emailAdd = userprofile.Email,
fullname = Utilities.getfullname_nonreverse(userprofile.Lastname, userprofile.Firstname, userprofile.Middle),
roles = string.Join(",", UserManager.GetRoles(userId))
};
}
return(View(userProfile));
}
public IEnumerable <UserinRoleViewModel> GetUsersinRole()
{
var context = new ApplicationUser.ApplicationDbContext();
var listofuser = (from user in context.Users
select new
{
userId = user.Id,
username = user.UserName,
email = user.Email,
Rolenames = (from userRole in user.Roles
join role in context.Roles on userRole.RoleId
equals role.Id
select role).ToList()
}).ToList().Select(p => new UserinRoleViewModel()
{
userId = p.userId,
username = p.username,
email = p.email,
userRole = p.Rolenames
}).ToList();
return(listofuser.ToList());
}
public IEnumerable <UsersViewModel> listofUsers()
{
//List<UsersViewModel> listofuser=new List<UsersViewModel>();
var context = new ApplicationUser.ApplicationDbContext();
var listofuser = (from user in context.Users select new
{
userId = user.Id,
username = user.UserName,
email = user.Email,
Rolenames = (from userRole in user.Roles
join role in context.Roles on userRole.RoleId
equals role.Id
select role.Name).ToList()
}).ToList().Select(p => new UsersViewModel()
{
userId = p.userId,
username = p.username,
email = p.email,
roles = string.Join(",", p.Rolenames),
has_superadminRights = p.Rolenames.Contains("superadmin")
}).ToList();
return(listofuser);
}
public IEnumerable <CollectionReportViewModel> GetAllCollection()
{
List <CollectionReportViewModel> list = new List <CollectionReportViewModel>();
var appuser = new ApplicationUser.ApplicationDbContext();
try
{
var bookinglist = (from b in dbEntities.Bookings select b).ToList();
list = (from item in bookinglist
join p in dbEntities.Payments on item.trn_Id equals p.trn_Id
join pp in dbEntities.Packages on item.p_id equals pp.p_id
join c in dbEntities.Customers on item.c_Id equals c.c_Id
select new CollectionReportViewModel()
{
transId = p.payNo,
payDate = Convert.ToDateTime(p.dateofPayment),
customer = Utilities.getfullname_nonreverse(c.lastname, c.firstname, c.middle),
occassion = item.occasion,
venue = item.venue,
eventDate = Convert.ToDateTime(item.startdate),
reference = p.particular,
paymeans = p.pay_means,
checkdetails = p.checkNo,
notes = p.notes,
noofPax = Convert.ToInt32(item.noofperson),
AmountperPax = Convert.ToDecimal(pp.p_amountPax),
PayAmt = Convert.ToDecimal(p.amtPay),
recievedBy = p.p_createdbyUser != null?(from user in appuser.Users where user.Id == p.p_createdbyUser select user).Select(t => t.UserName).FirstOrDefault().ToString():null
}).OrderBy(t => t.transId).ToList();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(list);
}
public FilmlerController()
{
_context = new ApplicationUser.ApplicationDbContext();
}
public KiralarController()
{
_context = new ApplicationUser.ApplicationDbContext();
}
public MusterilerController()
{
_context = new ApplicationUser.ApplicationDbContext();
}
private ApplicationUser.ApplicationDbContext _context; // We need a DbContext to access the database. Initialize it in the constructor.
public MusterilerController()
{
_context = new ApplicationUser.ApplicationDbContext(); // dbContext is a disposable (tek kullanımlık) object.
}
public CustomersController()
{
_context = new ApplicationUser.ApplicationDbContext();
}
public MoviesController()
{
_context = new ApplicationUser.ApplicationDbContext();
}
