public async Task <ActionResult> ManageTravelAgency()
{
using (BTCEntities db = new BTCEntities())
{
return(View(await db.TravelAgency.ToListAsync()));
}
}
public async Task <ActionResult> LPOProcessing(int?id)
{
using (BTCEntities db = new BTCEntities())
{
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ProxyCreationEnabled = true;
var RFQList = await db.RFQ.Include(a => a.TravelRequests).Include(a => a.LPO).Include(a => a.TravelAgency).Include(a => a.Users).Include(a => a.Quotation).Include("Quotation.ATQuotation").Include("Quotation.HSQuotation").Include("Quotation.PCQuotation").Where(a => a.Processing == (int)ProcessingStatus.BeingProcessed && a.TravelRequestID == id).Distinct().ToListAsync();
if (RFQList.Count > 0)
{
ViewBag.RFQList = RFQList;
ViewBag.TravelAgency = db.TravelAgency.ToList();
ViewBag.Cities = db.City.ToList();
ViewBag.Currencies = db.Currency.ToList();
ViewBag.ApprovalBy = db.Users.ToList();
using (EmployeeDetailsDBService EmpDBService = new EmployeeDetailsDBService("", RFQList[0].TravelRequests.Users1.HREmployeeID.ToString()))
{
ViewBag.FullEmployeeDetails = EmpDBService.FullEmployeeDetails();
}
return(View(RFQList.ToList()));
}
else
{
return(RedirectToAction("Index", new { id = id }));
}
}
}
public ActionResult ManagerDashboard()
{
using (var dbcontext = new BTCEntities())
{
return(View(ViewApprovalTravelRequests((int)ApprovalLevels.ToBeApproved, empCode)));
}
}
public ActionResult FileUpload(FormCollection formCollection)
{
using (BTCEntities db = new BTCEntities())
{
string attachmentsForVal = "Unknown", retrunToVal = "Index";
string IDVal = "";
int QuoteID = Convert.ToInt32(formCollection["QuotationID"]);
int ID = Convert.ToInt32(formCollection["ID"]);
if (Request.Files != null && Request.Files.Count > 0)
{
string fileName = string.Empty;
string destinationPath = string.Empty;
List <Attachments> uploadFileModel = new List <Attachments>();
SetQuotation(pageNo, ID, out attachmentsForVal, out IDVal, out retrunToVal);
fileName = Path.GetFileName(Request.Files[0].FileName);
destinationPath = Path.Combine(Server.MapPath("~/UploadedFiles/" + attachmentsForVal) + "/", fileName);
Directory.CreateDirectory(Server.MapPath("~/UploadedFiles/" + attachmentsForVal));
Request.Files[0].SaveAs(destinationPath);
var isFileNameRepete = (db.Attachments.AsEnumerable().Where(x => x.FileName == fileName).ToList());
if (isFileNameRepete == null || isFileNameRepete.Count <= 0)
{
Attachments attachments = new Attachments {
FileName = fileName, FileType = Request.Files[0].ContentType, FilePath = destinationPath, UploadedDate = DateTime.Now, UploadedBy = dbuser.ID
};
db.Attachments.Add(attachments);
db.SaveChanges();
AttachmentLink attachmentLink = new AttachmentLink {
AttachmentFor = attachmentsForVal, AttachmentForID = attachments.ID
};
db.AttachmentLink.Add(attachmentLink);
db.SaveChanges();
ViewBag.SuccessMessage = "File Uploaded Successfully";
}
else
{
ViewBag.WarningMessage = "File is already exists";
}
}
ViewBag.fileUploader = db.AttachmentLink.Where(a => a.AttachmentFor.Contains(attachmentsForVal)).Select(x => x.Attachments).Include(a => a.AttachmentLink).Include(a => a.Users)?.ToList();
switch (pageNo)
{
case 1:
return(RedirectToAction(retrunToVal, new { QuoteID, atquoteID = ID }));
case 2:
return(RedirectToAction(retrunToVal, new { QuoteID, hsquoteID = ID }));
case 3:
return(RedirectToAction(retrunToVal, new { QuoteID, pcquoteID = ID }));
default:
return(RedirectToAction(retrunToVal, new { QuoteID }));
}
}
}
public ActionResult RemoveRFQ(int?id)
{
using (BTCEntities db = new BTCEntities())
{
RFQ rfqlist = db.RFQ.Where(a => a.ID == id).FirstOrDefault();
if (ModelState.IsValid)
{
rfqlist.IsDeleted = true;
db.RFQ.Attach(rfqlist);
var entry = db.Entry(rfqlist);
entry.Property(a => a.IsDeleted).IsModified = true;
db.SaveChanges();
}
else
{
var errlist = ModelState.Values.Where(e => e.Errors.Count > 0).Select(a => a.Errors);
List <string> sberr = new List <string>();
foreach (var item in errlist)
{
sberr.Add(item[0].ErrorMessage);
}
TempData["ErrorMessage"] = sberr.ToList();
}
int TravelRequestID = rfqlist.TravelRequestID.Value;
return(RedirectToAction("RFQProcessing", new { id = TravelRequestID }));
}
}
private List <TravelRequests> ViewApprovalTravelRequests(int level, string employeeCode = "")
{
using (BTCEntities db = new BTCEntities())
{
if (!string.IsNullOrEmpty(employeeCode) && level != 2)
{
using (EmployeeDetailsDBService EmpDBService = new EmployeeDetailsDBService(empCode))
{
List <string> EmpCodes = EmpDBService.EmployeesUnderDepartmentHeadDetails(empCode);
var tr = db.TravelRequests.Include(a => a.City).Include(a => a.City1).Include(a => a.Users).Include(a => a.Users1).Where(a => a.ApprovalLevel == level).ToList();
var trf = tr.Where(a => EmpCodes.Any(s => s.Equals(a.Users1.HRW_Employee.EmployeeCode))).ToList();
return(trf);
}
}
else if (level == 2)
{
var tr = db.TravelRequests.Include(a => a.City).Include(a => a.City1).Include(a => a.Users).Include(a => a.Users1).Where(a => a.ApprovalLevel == level).ToList();
return(tr);
}
else
{
var tr = db.TravelRequests.Include(a => a.City).Include(a => a.City1).Include(a => a.Users).Include(a => a.Users1).Where(a => a.ApprovalLevel == level).ToList();
return(tr);
}
}
}
private List <TravelRequests> ViewAllTravelRequests()
{
using (BTCEntities db = new BTCEntities())
{
return(db.TravelRequests.Include(a => a.City).Include(a => a.City1).Include(a => a.Users).Include(a => a.Users1).OrderBy(a => a.CreateOn).ToList());
}
}
public ActionResult HRApprovalForm(int id)
{
try
{
if (id <= 0)
{
ViewBag.ErrorMessage = "No Travel Request ID";
return(View());
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Invalid Travel Request ID");
}
using (BTCEntities db = new BTCEntities())
{
TravelRequests travelRequest = db.TravelRequests.Include(a => a.Users).Include(a => a.Users1).Include("Users1.HRW_Employee").Include("Users.HRW_Employee").SingleOrDefault(s => s.ID == id);
if (travelRequest == null)
{
ViewBag.ErrorMessage = "Invalid Travel Request ID";
return(View());
//return HttpNotFound("Invalid Travel Request ID");
}
ViewBag.Cities = db.City.ToList();
ViewBag.Currencies = db.Currency.ToList();
ViewBag.ApprovalBy = db.Users.ToList();
using (EmployeeDetailsDBService EmpDBService = new EmployeeDetailsDBService(travelRequest.Users1.HRW_Employee.EmployeeCode))
{
ViewBag.FullEmployeeDetails = EmpDBService.FullEmployeeDetails();
}
return(View(travelRequest));
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <ActionResult> EditUser(Users user, FormCollection form)
{
using (BTCEntities db = new BTCEntities())
{
ModelState.Remove("HREmployeeID");
if (ModelState.IsValid)
{
string DDLValue = form["RoleName"].ToString();
var role = db.Roles.Where(a => a.RoleName == DDLValue).FirstOrDefault();
if (!user.Roles.Contains(role))
{
user.Roles.Add(role);
}
user.HREmployeeID = Convert.ToInt32(form["HREmployeeID"]);
db.Entry(user).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("ManageUsers"));
}
user = await db.Users.Include(a => a.HRW_Employee).FirstOrDefaultAsync(i => i.ID == user.ID);
ViewBag.RoleName = user.Roles.FirstOrDefault().RoleName;
}
return(View(user));
}
public async Task <ActionResult> AddQuotation(int id)
{
using (BTCEntities db = new BTCEntities())
{
if (id <= 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RFQ rFQ = await db.RFQ.Include(a => a.TravelRequests).Include(a => a.TravelAgency).Include(a => a.Users).Include(a => a.TravelRequests.Quotation).Include("Quotation.ATQuotation").Include("Quotation.HSQuotation").Include("Quotation.PCQuotation").Where(a => a.ID == id).FirstOrDefaultAsync();
if (rFQ == null)
{
return(HttpNotFound());
}
ViewBag.TravelAgency = db.TravelAgency.ToList();
ViewBag.Cities = db.City.ToList();
ViewBag.Currencies = db.Currency.ToList();
ViewBag.ApprovalBy = db.Users.ToList();
using (EmployeeDetailsDBService EmpDBService = new EmployeeDetailsDBService("", rFQ.TravelRequests.Users1.HREmployeeID.ToString()))
{
ViewBag.FullEmployeeDetails = EmpDBService.FullEmployeeDetails();
}
//ViewBag.fileUploader = db.AttachmentLink.Where(a => a.AttachmentFor.Contains(rFQ.TravelRequests.ApplicationNumber)).Select(x => x.Attachments).Include(a => a.AttachmentLink).Include(a => a.Users)?.ToList();
return(View(rFQ));
}
}
public async Task <ActionResult> EditTravelAgency([Bind(Include = "ID,AgencyCode,CompanyName,Address,Telephone,Fax,Mobile,Landline,ContactPerson,Email,IsActive")] TravelAgency travelAgency)
{
if (ModelState.IsValid)
{
using (BTCEntities db = new BTCEntities())
{
db.Entry(travelAgency).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("ManageTravelAgency"));
}
}
else
{
var errlist = ModelState.Values.Where(e => e.Errors.Count > 0).Select(a => a.Errors);
List <string> sberr = new List <string>();
foreach (var item in errlist)
{
sberr.Add(item[0].ErrorMessage);
}
TempData["ErrorMessage"] = sberr.ToList();
}
CheckErrorMessages();
return(View(travelAgency));
}
private List <TravelRequests> ViewMyTravelRequests()
{
using (BTCEntities db = new BTCEntities())
{
return(db.TravelRequests.Include(a => a.City).Include(a => a.City1).Include(a => a.Users).Include(a => a.Users1).Where(a => a.CreatedBy == (db.Users.Where(u => u.Username == user.UserName).FirstOrDefault()).ID).OrderBy(a => a.CreateOn).ToList());
}
}
public async Task <ActionResult> TravelRequestsList()
{
using (BTCEntities db = new BTCEntities())
{
var travelRequests = db.TravelRequests.Include(t => t.City).Include(t => t.City1).Include(t => t.Currency).Include(t => t.Users1).Include(t => t.Users).Where(a => a.IsSubmitted);
return(View(await travelRequests.ToListAsync()));
}
}
// GET: LPO
public async Task <ActionResult> Index(int?id)
{
using (BTCEntities db = new BTCEntities())
{
var lpos = db.LPO.Include(a => a.RFQ).Include(a => a.Quotation).Include(a => a.RFQ).Include("RFQ.TravelRequests").Include("Quotation.ATQuotation").Include("Quotation.HSQuotation").Include("Quotation.PCQuotation").Where(a => a.RFQ.TravelRequestID == id);
return(View(await lpos.ToListAsync()));
}
}
public async Task <ActionResult> RFQFinalPreview(int?id)
{
using (BTCEntities db = new BTCEntities())
{
ViewBag.TravelAgency = db.TravelAgency.ToList();
ViewBag.Cities = db.City.ToList();
ViewBag.Currencies = db.Currency.ToList();
ViewBag.ApprovalBy = db.Users.ToList();
RFQ rfqlist = await db.RFQ.Include(a => a.TravelRequests).Include(a => a.TravelAgency).Include(a => a.Users).Where(a => a.ID == id).FirstOrDefaultAsync();
ViewBag.fileUploader = db.AttachmentLink.Where(a => a.AttachmentFor == (rfqlist.RFQName + "Pro" + rfqlist.ProcessingSection + "Trav" + rfqlist.TravelAgencyID)).Select(x => x.Attachments).ToList();
MasterRFQ = rfqlist;
if (rfqlist.ProcessingSection == (int)ProcessingSections.AT || rfqlist.ProcessingSection == (int)ProcessingSections.ATHS || rfqlist.ProcessingSection == (int)ProcessingSections.ATHSPC || rfqlist.ProcessingSection == (int)ProcessingSections.ATPC)
{
ATQuotation atquot = new ATQuotation();
atquot.DestinationID = rfqlist.TravelRequests.PortOfDestinationID;
atquot.DepartureDate = rfqlist.TravelRequests.DepartureDate;
atquot.DepartureTime = rfqlist.TravelRequests.DepartureTime;
atquot.OriginID = rfqlist.TravelRequests.PortOfOriginID;
atquot.ReturnDate = rfqlist.TravelRequests.ReturnDate;
atquot.ReturnTime = rfqlist.TravelRequests.ReturnTime;
atquot.TicketClass = rfqlist.TravelRequests.TicketClass;
ViewBag.ATQuotation = atquot;
}
if (rfqlist.ProcessingSection == (int)ProcessingSections.ATHS || rfqlist.ProcessingSection == (int)ProcessingSections.ATHSPC || rfqlist.ProcessingSection == (int)ProcessingSections.HS || rfqlist.ProcessingSection == (int)ProcessingSections.HSPC)
{
HSQuotation hsquot = new HSQuotation();
hsquot.CheckInDate = rfqlist.TravelRequests.CheckInDate;
hsquot.CheckInTime = rfqlist.TravelRequests.CheckInTime;
hsquot.CheckOutDate = rfqlist.TravelRequests.CheckOutDate;
hsquot.CheckOutTime = rfqlist.TravelRequests.CheckOutTime;
hsquot.HotelCategory = rfqlist.TravelRequests.HotelCategory;
hsquot.HotelName = rfqlist.TravelRequests.HotelName;
hsquot.RoomCategory = rfqlist.TravelRequests.RoomCategory;
hsquot.RoomType = rfqlist.TravelRequests.RoomType;
ViewBag.HSQuotation = hsquot;
}
if (rfqlist.ProcessingSection == (int)ProcessingSections.ATHSPC || rfqlist.ProcessingSection == (int)ProcessingSections.ATPC || rfqlist.ProcessingSection == (int)ProcessingSections.HSPC || rfqlist.ProcessingSection == (int)ProcessingSections.PC)
{
PCQuotation pcquot = new PCQuotation();
pcquot.DropOffDate = rfqlist.TravelRequests.DropOffDate;
pcquot.DropoffLocation = rfqlist.TravelRequests.DropOffLocation;
pcquot.DropOffTime = rfqlist.TravelRequests.DropOffTime;
pcquot.PickUpDate = rfqlist.TravelRequests.PickUpDate;
pcquot.PickupLocation = rfqlist.TravelRequests.PickUpLocation;
pcquot.PickUpTime = rfqlist.TravelRequests.PickUpTime;
pcquot.PreferredVehicle = rfqlist.TravelRequests.PreferredVehicle;
ViewBag.PCQuotation = pcquot;
}
using (EmployeeDetailsDBService EmpDBService = new EmployeeDetailsDBService("", rfqlist.TravelRequests.Users1.HREmployeeID.ToString()))
{
ViewBag.FullEmployeeDetails = EmpDBService.FullEmployeeDetails();
}
return(View(rfqlist));
}
}
public ActionResult ManageUsers()
{
List <Users> usersList = new List <Users>();
using (BTCEntities db = new BTCEntities())
{
usersList = db.Users.Include(a => a.Roles).Include(a => a.HRW_Employee).Where(a => a.IsDeleted == false).OrderByDescending(a => a.ID).ToList();
}
return(View(usersList));
}
public ActionResult RFQPostMerger(int?id)
{
using (BTCEntities db = new BTCEntities())
{
List <RFQ> rfqlist = db.RFQ.Include(a => a.TravelRequests).Include(a => a.Users).Include(a => a.TravelAgency).Include(a => a.LPO).Where(a => a.TravelRequestID == id && a.Processing > 0).ToList();
ViewBag.TravelAgency = db.TravelAgency.ToList();
return(View(rfqlist));
}
}
// GET: RFQ
public async Task <ActionResult> Index()
{
using (BTCEntities db = new BTCEntities())
{
//var RFQ = db.RFQ.Include(r => r.TravelAgency).Include(r => r.TravelRequests).Include(r => r.Users);
//return View(await RFQ.ToListAsync());
var travelRequests = db.TravelRequests.Include(t => t.City).Include(t => t.City1).Include(t => t.Currency).Include(t => t.RFQ).Include(t => t.Users).Include(t => t.Users1).Include(t => t.RFQ).Include("RFQ.TravelAgency");
return(View(await travelRequests.ToListAsync()));
}
}
public ActionResult CreateTravelAgency()
{
using (BTCEntities db = new BTCEntities())
{
TravelAgency travelAgency = new TravelAgency();
travelAgency.AgencyCode = db.TravelAgency.Count() > 0 ? GenerateNextAgencyID(db.TravelAgency.OrderByDescending(a => a.ID).FirstOrDefault().AgencyCode) : "HRD-BTC-0HQ-001";
CheckErrorMessages();
return(View(travelAgency));
}
}
protected override void Dispose(bool disposing)
{
using (BTCEntities db = new BTCEntities())
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
using (BTCEntities db = new BTCEntities())
{
RFQ rFQ = await db.RFQ.FindAsync(id);
db.RFQ.Remove(rFQ);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
public async Task <ActionResult> DeleteTravelAgencyConfirmed(int id)
{
using (BTCEntities db = new BTCEntities())
{
TravelAgency travelAgency = await db.TravelAgency.FindAsync(id);
travelAgency.IsActive = false;
db.Entry(travelAgency).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("ManageTravelAgency"));
}
}
public async Task <ActionResult> Index()
{
using (BTCEntities db = new BTCEntities())
{
ViewBag.TravelAgency = db.TravelAgency.ToList();
ViewBag.Cities = db.City.ToList();
ViewBag.Currencies = db.Currency.ToList();
ViewBag.ApprovalBy = db.Users.ToList();
var RFQ = db.RFQ.Include(r => r.TravelAgency).Include(r => r.TravelRequests).Include(r => r.Users).Where(a => a.Processing > 0 && a.IsDeleted == false);
return(View(await RFQ.ToListAsync()));
}
}
public ActionResult DeleteATQuotation(int id)
{
using (BTCEntities db = new BTCEntities())
{
var dbatquote = db.ATQuotation.Find(id);
dbatquote.IsDeleted = true;
db.ATQuotation.Attach(dbatquote);
var entry = db.Entry(dbatquote);
entry.Property(a => a.IsDeleted).IsModified = true;
db.SaveChanges();
return(RedirectToAction("AddQuotation", new { id = dbatquote.Quotation.RFQID }));
}
}
public async Task <ActionResult> DeleteUserConfirmed(int id)
{
using (BTCEntities db = new BTCEntities())
{
Users user = await db.Users.FindAsync(id);
user.IsActive = false;
user.IsDeleted = true;
db.Entry(user).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
await db.SaveChangesAsync();
return(RedirectToAction("ManageUsers"));
}
}
public ActionResult CreateUser()
{
using (BTCEntities db = new BTCEntities())
{
List <Roles> allRoles = db.Roles.ToList();
List <FullEmployeeDetail> allEmployees = new List <FullEmployeeDetail>();
using (EmployeeDetailsDBService employeeDetailsDBService = new EmployeeDetailsDBService(empCode))
{
allEmployees = employeeDetailsDBService.AllEmployeeDetails();
}
ViewBag.allRoles = allRoles;
ViewBag.allEmployees = allEmployees;
CheckErrorMessages();
return(View());
}
}
public ActionResult AdminDashboard()
{
List <Users> usersList = new List <Users>();
using (BTCEntities db = new BTCEntities())
{
ViewBag.usersList = db.Users.Include(a => a.Roles).Include(a => a.HRW_Employee).ToList();
}
List <FullEmployeeDetail> employeeList = new List <FullEmployeeDetail>();
using (EmployeeDetailsDBService db = new EmployeeDetailsDBService(empCode))
{
ViewBag.employeeList = db.AllEmployeeDetails(50);
}
return(View());
}
// GET: RFQ/Delete/5
public async Task <ActionResult> Delete(int?id)
{
using (BTCEntities db = new BTCEntities())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RFQ rFQ = await db.RFQ.FindAsync(id);
if (rFQ == null)
{
return(HttpNotFound());
}
return(View(rFQ));
}
}
public ActionResult LPOCreation(string id)
{
try
{
int i = Convert.ToInt32(id);
if (i > 0)
{
using (BTCEntities db = new BTCEntities())
{
var lpodata = db.LPO.Where(a => a.QuotationID == i).FirstOrDefault();
if (lpodata.IsDeleted == null || (bool)lpodata.IsDeleted)
{
lpodata.IsDeleted = false;
db.Entry(lpodata).State = EntityState.Modified;
db.LPO.Attach(lpodata);
db.Entry(lpodata).Property(x => x.IsDeleted).IsModified = true;
db.SaveChanges();
var rfq = db.RFQ.Where(a => a.ID == lpodata.RFQID).FirstOrDefault();
rfq.Processing = (int)ProcessingStatus.Processed;
var travelreq = db.TravelRequests.Where(a => a.ID == rfq.TravelRequestID).FirstOrDefault();
travelreq.ApprovalLevel = (int)ApprovalLevels.ApprovedbyTravelCo;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
}
return(Json("LPO Successfully Created", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("LPO Creation Failed", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("LPO Creation Failed", JsonRequestBehavior.AllowGet));
throw;
}
}
public async Task <ActionResult> Edit([Bind(Include = "ID,TravelAgencyID,TravelRequestID,UserID,Remarks,Processing,ProcessingSection,IsDeleted")] RFQ rFQ)
{
using (BTCEntities db = new BTCEntities())
{
if (ModelState.IsValid)
{
db.Entry(rFQ).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.TravelAgencyID = new SelectList(db.TravelAgency, "AgencyID", "AgencyCode", rFQ.TravelAgencyID);
ViewBag.TravelRequestID = new SelectList(db.TravelRequests, "TravelRequestID", "ApplicationNumber", rFQ.TravelRequestID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "Username", rFQ.UserID);
return(View(rFQ));
}
}
