private void btnEdit_Click(object sender, EventArgs e) { string userName = txtID.Text; string Add = txtDiaChi.Text; string Phone = txtSDT.Text; string name = txtHoTen.Text; if (userName == "") { MessageBox.Show("Nhấp chọn vào nhân viên cần edit", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (Add == "" || Phone == "" || name == "") { MessageBox.Show("Thông tin không được để trông", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var user = db.NhanViens.Where(s => s.MaNv == userName).FirstOrDefault(); if (user != null) { //DataGridViewRow row = this.dgvListNV.Rows[local]; var query = ("Update NhanVien set TenNV = N'" + txtHoTen.Text + "' ,DiaChi = N'" + txtDiaChi.Text + "',SDT='" + txtSDT.Text + "' where MaNV=N'" + txtID.Text + "'"); db.Database.ExecuteSqlCommand(query); db.SaveChanges(); Entities3 a = new Entities3(); var lst = a.NhanViens.ToList(); dgvListNV.DataSource = lst; } else { MessageBox.Show("Không tìm thấy ID trong database", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public ActionResult AddStaff(RegisterViewModel newModel) { var userStore = new UserStore <IdentityUser>(); var manager = new UserManager <IdentityUser>(userStore); var user = new IdentityUser() { Email = newModel.Email, UserName = newModel.Email }; IdentityResult result = manager.Create(user, newModel.Password); try { // traversing the database using (Entities3 db = new Entities3()) { // executing SQL comman db.Database.ExecuteSqlCommand("insert into [dbo].[userrolesbridging]([UserId], [RoleId]) values ('" + user.Id + "',2);"); } ModelState.Clear(); ViewBag.Message = "success"; return(View()); } catch { ViewBag.Message = "error"; return(View()); } }
public ActionResult ShowDetails(string query, int query2) { using (var context = new Entities3()) { // for implementing the functionality of staff member checking booking details var customerDetails = (from u in context.AspNetUsers where u.Id == query select new CustomerModel() { Id = u.Id, Email = u.Email }).ToArray(); var customerBookingDetails = (from bd in context.CustomerBookings where bd.customer_booking_id == query2 select new CustomerBookingModelForStaff() { customer_booking_id = bd.customer_booking_id, vehicle_id = bd.vehicle_id, to_date = bd.to_date, from_date = bd.from_date }).ToList(); var customerBookingLocations = (from c in context.CustomerBookingLocations where c.customer_booking_id == query2 select new CustomerBookingLocationForStaff() { longitude = c.longitude, latitude = c.latitude }).ToList(); ViewBag.customerDetails = customerDetails; ViewBag.customerBookingDetails = customerBookingDetails; ViewBag.customerBookingLocations = customerBookingLocations; return(View()); } }
public ActionResult AddVehicle(StaffCarUploadModel newUpload) { //bd44b938 - 8f13 - 45c4 - 96ee - 08dd988b5d9c string path = Server.MapPath("~/App_Data/File"); string fileName = Path.GetFileName(newUpload.carPicture.FileName); string fullPath = Path.Combine(path, fileName); string userId = User.Identity.GetUserId(); try { using (Entities3 db = new Entities3()) { // This sql command inserts a vehicle into the database. db.Database.ExecuteSqlCommand("insert into [dbo].[Vehicle] ([Name],[Model],[userId],[image_path]) Values ('" + newUpload.name + "', '" + newUpload.model + "', '" + userId + "', '" + fullPath + "');"); } newUpload.carPicture.SaveAs(fullPath); ViewBag.Message = "success"; } catch { ViewBag.Message = "error"; } return(View()); }
public ActionResult Index() { // checks if the user is authenticated if (User.Identity.IsAuthenticated) { //gets the current user string currentUserId = User.Identity.GetUserId(); using (var context = new Entities3()) { // finds the role of the user. This is done to show specific navigation bar // to specific roles of users. var result = (from u in context.AspNetUsers join ur in context.userrolesbridgings on u.Id equals ur.UserId join ro in context.AspNetRoles on ur.RoleId equals ro.Id where u.Id == currentUserId select ro.Name).ToArray(); ViewBag.message = result[0]; } } else { ViewBag.message = "nothing"; } return(View()); }
public ActionResult ViewFleet() { Entities3 db = new Entities3(); ViewBag.first = db.AspNetUsers.ToList(); ViewBag.ItemData = db.Vehicles.ToList(); return(View()); }
public EmptyResult DeleteLocations() { using (var context = new Entities3()) { } return(null); // return View(); }
// GET: Customer // This controller loads the index page with data from the database. public ActionResult Index() { using (var context = new Entities3()) { //ViewBag.ItemData = db.Vehicles.ToList(); ViewBag.ItemData = context.Vehicles.ToList(); } return(View()); }
// This controller opens the bulk email page public ActionResult SendBulkEmail() { using (var context = new Entities3()) { var req = (from u in context.AspNetUsers select u.Email).ToList(); ViewBag.emails = req; } return(View()); }
// This function checks the role of the user trying to login by // checking the email with the userroles from the database public String[] roleChecker(string email) { using (var context = new Entities3()) { var result = (from u in context.AspNetUsers join ur in context.userrolesbridgings on u.Id equals ur.UserId join ro in context.AspNetRoles on ur.RoleId equals ro.Id where u.Email == email select ro.Name).ToArray(); return(result); } return(null); }
public ActionResult SendBulkEmail(BulkEmailViewModel emailMessage) { if (emailMessage.messageSubject == null || emailMessage.messageBody == null) { ViewBag.Result = "error"; return(View()); } else { try { String to = ""; using (var context = new Entities3()) { var req = (from u in context.AspNetUsers select u.Email).ToList(); to = req[0]; for (int i = 1; i < req.Count(); i++) { to = to + "," + req[i]; } } String messageSubject = emailMessage.messageSubject; String messageBody = emailMessage.messageBody; BulkEmailSenderClass bs = new BulkEmailSenderClass(); if (emailMessage.attachment != null) { string path = Server.MapPath("~/App_Data/File"); string fileName = Path.GetFileName(emailMessage.attachment.FileName); string fullPath = Path.Combine(path, fileName); emailMessage.attachment.SaveAs(fullPath); bs.send(to, messageSubject, messageBody, fullPath, fileName); } else { bs.send(to, messageSubject, messageBody, "nothing", "nothing"); } ModelState.Clear(); ViewBag.Result = "success"; return(View()); } catch (Exception e) { ViewBag.Result = "error"; return(View()); } } }
public async Task <ActionResult> ExternalLoginConfirmation(ExternalLoginConfirmationViewModel model, string returnUrl) { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Manage")); } if (ModelState.IsValid) { // Get the information about the user from the external login provider var info = await AuthenticationManager.GetExternalLoginInfoAsync(); if (info == null) { return(View("ExternalLoginFailure")); } var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user); if (result.Succeeded) { result = await UserManager.AddLoginAsync(user.Id, info.Login); using (Entities3 db = new Entities3()) { db.Database.ExecuteSqlCommand("insert into [dbo].[userrolesbridging]([UserId], [RoleId]) values ('" + user.Id + "',3);"); } if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); return(RedirectToLocal(returnUrl)); } } AddErrors(result); } ViewBag.ReturnUrl = returnUrl; return(View(model)); }
public JsonResult CheckBookingDate(string inputDates) { var response = ""; String[] spearator = { "," }; String[] result = inputDates.Split(spearator, StringSplitOptions.RemoveEmptyEntries); int car_id = Int32.Parse(result[0].Trim('\t', '"')); DateTime date_from = Convert.ToDateTime(result[1].Trim('\t', '"')); DateTime date_to = Convert.ToDateTime(result[2].Trim('\t', '"')); var date_from_converted = date_from.ToString("yyyy-MM-dd"); var date_to_converted = date_to.ToString("yyyy-MM-dd"); DateTime date_from_date = Convert.ToDateTime(date_from_converted); DateTime date_to_date = Convert.ToDateTime(date_to_converted); using (var context = new Entities3()) { try { // Linq command where my booking constraint is implemented var isBooked = (from c in context.CustomerBookings where ((c.from_date >= date_from_date && c.from_date <= date_to_date) || (c.to_date >= date_to_date && c.to_date <= date_to_date) || (c.from_date <= date_from_date && c.to_date >= date_to_date)) && c.vehicle_id == car_id select c.vehicle_id).ToList(); Console.WriteLine(isBooked); if (isBooked.Count > 0) { response = "already booked"; } else { response = "not booked"; } } catch (Exception e) { Console.WriteLine(e); } } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult ShowAnalytics() { AdminAnalyticsUserAmount userAnalytics = new AdminAnalyticsUserAmount(); using (var context = new Entities3()) { string num = "2"; string num2 = "3"; // Linq statement to find data for analytics userAnalytics.customerNumber = (from u in context.AspNetUsers join roles in context.userrolesbridgings on u.Id equals roles.UserId where roles.RoleId == num2 select u.Id).ToList().Count(); userAnalytics.staffNumber = (from u in context.AspNetUsers join roles in context.userrolesbridgings on u.Id equals roles.UserId where roles.RoleId == num select u.Id).ToList().Count(); } // serializing the object to make it easier to send it by json response JavaScriptSerializer js = new JavaScriptSerializer(); var json = js.Serialize(userAnalytics); return(Json(json, JsonRequestBehavior.AllowGet)); }
// GET: Staff public ActionResult Index() { // gets the current user string userId = User.Identity.GetUserId(); using (var context = new Entities3()) { // collects all the staff data and puts them inside ViewBag. var viewModel = (from u in context.AspNetUsers join c in context.CustomerBookings on u.Id equals c.userId select new StaffViewCustomerBookingInDashboard() { Id = u.Id, Email = u.Email, customer_booking_id = c.customer_booking_id, from_date = c.from_date, to_date = c.to_date, vehicle_id = c.vehicle_id }).ToList(); ViewBag.itemData = viewModel; return(View()); } }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { // This saves the user added as customer if (model.isStaff == "false") { string userId = user.Id; using (Entities3 db = new Entities3()) { db.Database.ExecuteSqlCommand("insert into [dbo].[userrolesbridging]([UserId], [RoleId]) values ('" + user.Id + "',3);"); } } await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Index", "Home")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public ActionResult Index(user_table usr) { //get username and password from the user //check it against the database user table Entities3 dbObject = new Entities3(); var checkUser = dbObject.user_tables.Where(l => l.user_name.Equals(usr.user_name) && l.user_password.Equals(usr.user_password)).FirstOrDefault(); if (checkUser != null) { var loggeduser = dbObject.user_tables.Where(l => l.user_name.Equals(usr.user_name)).FirstOrDefault(); Session["user_name"] = loggeduser.user_name.ToString(); Session["u_id"] = loggeduser.u_id.ToString(); Session["user_type"] = loggeduser.user_type.ToString(); return(RedirectToAction("Dashboard")); } else { ViewBag.msg = "Invalid Username or Password"; } return(View()); }
public IHttpActionResult getmembersbyid(string id) { List <getmemberID_Result> x = new List <getmemberID_Result>(); var test = new Entities3(); var reslist = test.getmemberID(id).ToList(); foreach (var pen in reslist.ToList()) { x.Add( new getmemberID_Result { DISTR_ID = pen.DISTR_ID, ANAME = pen.ANAME, DISTR_IDENT = pen.DISTR_IDENT, ADDRESS = pen.ADDRESS, TELEPHONE = pen.TELEPHONE, E_MAIL = pen.E_MAIL, AREA_ID = pen.AREA_ID, AREA_NAME = pen.AREA_NAME } ); } return(Ok(x)); }
public JsonResult CreateBooking(string sendInfo) { string userId = User.Identity.GetUserId(); //string date_from; //string date_to; string car_id; string latitude; string longitude; double distance = 0.0; double price = 0.0; List <LocationModel> location = new List <LocationModel>(); String[] spearator = { "," }; String[] result = sendInfo.Split(spearator, StringSplitOptions.RemoveEmptyEntries); foreach (String s in result) { Console.WriteLine(result); } DateTime date_from = Convert.ToDateTime(result[0].Trim('\t', '[', '"')); DateTime date_to = Convert.ToDateTime(result[1].Trim('\t', '[', '"')); var date_from_converted = date_from.ToString("yyyy-MM-dd"); var date_to_converted = date_to.ToString("yyyy-MM-dd"); DateTime date_from_date = Convert.ToDateTime(date_from_converted); DateTime date_to_date = Convert.ToDateTime(date_to_converted); car_id = result[2].Trim('\t', '[', '"'); var abc = result[3].Trim('\t', '[', '"'); distance = Convert.ToDouble(abc); var vehicle_id = Int32.Parse(car_id); price = distance * 3; try { using (var context = new Entities3()) { // this SQL command is executed to insert the booking into the database context.Database.ExecuteSqlCommand("insert into " + "[dbo].[CustomerBooking]([userId],[vehicle_id]," + "[isAccepted],[to_date],[from_date],[pickup_location],[dropoff_location],[distance],[price]) " + "values('" + userId + "', '" + car_id + "', 'false', '" + date_to_converted + "'," + "'" + date_from_converted + "','location1','location2', '" + distance + "', '" + price + "')"); var lastId = (from c in context.CustomerBookings where c.userId == userId && c.vehicle_id == vehicle_id select c.customer_booking_id).ToArray(); for (int i = 4; i <= result.Length - 2; i = i + 2) { latitude = result[i].Trim('[', ']'); int j = i; longitude = result[j + 1].Trim('[', ']'); context.Database.ExecuteSqlCommand("insert into " + "[dbo].[CustomerBookingLocation](customer_booking_id,latitude,longitude)" + "values('" + lastId[0] + "', '" + latitude + "', '" + longitude + "')"); } } } catch (Exception e) { return(Json("error", JsonRequestBehavior.AllowGet)); } CustomerResponse cs = new CustomerResponse(); cs.response = "success"; cs.distance = distance; cs.price = price; cs.message = "Thank you for using our services. Our staff will be in contact with you soon."; JavaScriptSerializer js = new JavaScriptSerializer(); var json = js.Serialize(cs); return(Json(json, JsonRequestBehavior.AllowGet)); }