public static bool Login(string userName, string password) { using (IndiaEvents2Entities entities = new IndiaEvents2Entities()) { return(entities.users.Any(x => x.userName.Equals(userName, StringComparison.OrdinalIgnoreCase) && x.password == password)); } }
public JsonResult CreateUser(user userDetails) { IndiaEvents2Entities ie = new IndiaEvents2Entities(); response message = new response(); //string message = ""; try { int mobileNumber = ie.users.Where(x => x.mobile == userDetails.mobile).Count(); if (mobileNumber == 0) { user u = new user(); u.userName = userDetails.userName; u.email = userDetails.email; u.mobile = userDetails.mobile; u.password = userDetails.password; ie.users.Add(u); ie.SaveChanges(); message.htmlContent = "<button id='logout' class='btn btn-info btn-rounded btn-sm waves-effect waves-light'>Log Out<i class='fas fa-sign-out-alt'></i></button>"; message.message = "Saved Successfully..!"; } else { message.htmlContent = "<button type='button' class='btn purple-gradient btn-sm waves-effect waves-light' data-toggle='modal' data-target='#LoginModal' id='login'>Login</button>"; message.message = "Mobile number was already in use please try with forgot password"; } } catch (Exception ex) { message.htmlContent = ""; message.message = ex.Message.ToString(); } return(Json(message, JsonRequestBehavior.AllowGet)); }
public JsonResult showEvents() { IndiaEvents2Entities e = new IndiaEvents2Entities(); List <Event> en = new List <Event>(); List <Event> eve = new List <Event>(); en = (from q in e.Events select q).OrderBy(x => x.EventFromDate).ToList(); foreach (var ev in en) { Event ee = new Event(); ee.EventName = ev.EventName; ee.EventType = ev.EventType; ee.EventFee = ev.EventFee; ee.EventFromDate = ev.EventFromDate; ee.EventToDate = ev.EventToDate; ee.CollegeName = ev.CollegeName; ee.Department = ev.Department; ee.City = ev.City; ee.State = ev.State; ee.Address = ev.Address; if (ev.Poster != null) { ee.Posters = "data:image/jpeg;base64," + Convert.ToBase64String(ev.Poster); } ee.Website = ev.Website; ee.EventID = ev.EventID; eve.Add(ee); } return(Json(eve, JsonRequestBehavior.AllowGet)); }
public JsonResult StoreFiles(string eventID) { if (Request.Files.Count > 0) { try { HttpFileCollectionBase files = Request.Files; //string eventID = Request.Params["EventID"].ToString(); Event eventsDetails = new Event(); IndiaEvents2Entities e = new IndiaEvents2Entities(); int eID = Int32.Parse(eventID); eventsDetails = (from ev in e.Events where (ev.EventID == eID) select ev).FirstOrDefault(); HttpPostedFileBase file = files[0]; eventsDetails.Poster = new byte[file.ContentLength]; // file1 to store image in binary formate file.InputStream.Read(eventsDetails.Poster, 0, file.ContentLength); e.SaveChanges(); //for (int i = 0; i < files.Count; i++) //{ // HttpPostedFileBase file = files[i]; // string fname; // if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER") // { // string[] testfiles = file.FileName.Split(new char[] { '\\' }); // fname = testfiles[testfiles.Length - 1]; // } // else // { // fname = file.FileName; // } // //fname = Path.Combine(Server.MapPath("~/Content/Img"), fname); // //file.SaveAs(fname); //} return(Json("File Uploaded Successfully!")); } catch (Exception ex) { return(Json("Error occurred. Error details: " + ex.Message)); } } return(Json("", JsonRequestBehavior.AllowGet)); }
public JsonResult Login(user user) { IndiaEvents2Entities ie = new IndiaEvents2Entities(); user userDetails = (from u in ie.users where u.userName == user.userName && u.password == user.password select u).SingleOrDefault(); response message = new response(); message.message = "Please check your credentials..!"; message.htmlContent = "<button type='button' class='btn purple-gradient btn-sm waves-effect waves-light' data-toggle='modal' data-target='#LoginModal' id='login'>Login</button>"; if (userDetails != null) { FormsAuthentication.SetAuthCookie(user.userName, true); message.message = "Logged In successfully..!"; message.htmlContent = "<button id='logout' class='btn btn-info btn-rounded btn-sm waves-effect waves-light'>Log Out<i class='fas fa-sign-out-alt'></i></button>"; } return(Json(message, JsonRequestBehavior.AllowGet)); }
public JsonResult PostEvent(Event eventDetails) { //HttpFileCollectionBase files = eventDetails.Poster; //HttpPostedFileBase file = files[0]; //string fname = file.FileName; //fname = Path.Combine(Server.MapPath("~/Content/img"), fname); //file.SaveAs(fname); List <subevents> s = new List <subevents>(); IndiaEvents2Entities e = new IndiaEvents2Entities(); Event events = new Event(); events.Events = JsonConvert.SerializeObject(eventDetails.Events); events.EventName = eventDetails.EventName; events.EventFee = eventDetails.EventFee; events.EventType = eventDetails.EventType; events.EventFromDate = eventDetails.EventFromDate; events.EventToDate = eventDetails.EventToDate; events.Website = eventDetails.Website; events.CollegeName = eventDetails.CollegeName; events.Department = eventDetails.Department; events.City = eventDetails.City; events.State = eventDetails.State; events.Address = eventDetails.Address; e.Events.Add(events); e.SaveChanges(); int eventID = (from eve in e.Events where (eve.EventName == eventDetails.EventName) select eve.EventID).FirstOrDefault(); response message = new response(); //List<string> msg = new List<string>() { "Event Create Successfully..!", eventID.ToString() }; message.message = "Event Create Successfully..!"; message.eventID = eventID; message.htmlContent = "<button id='logout' class='btn btn-info btn-rounded btn-sm waves-effect waves-light'>Log Out<i class='fas fa-sign-out-alt'></i></button>"; return(Json(message, JsonRequestBehavior.AllowGet)); }
public JsonResult getEventsTypes() { IndiaEvents2Entities e = new IndiaEvents2Entities(); Guid lookupType = (from LookupTypes in e.LookupTypes where LookupTypes.lookupType1 == "Eventtypes" select LookupTypes.lookupID).SingleOrDefault(); List <Lookup> l = (from ls in e.Lookups where ls.lookupID == lookupType select ls).ToList(); List <clslookups> lk = new List <clslookups>(); if (l.Count > 0) { foreach (var s in l) { clslookups values = new clslookups(); values.lookups = s.lookups; values.lookupsID = s.lookupID; lk.Add(values); } } return(Json(lk, JsonRequestBehavior.AllowGet)); }
//public string GenerateToken(int maxSize = 15) //{ // char[] chars = new char[62]; // chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890".ToCharArray(); // byte[] data = new byte[1]; // using (RNGCryptoServiceProvider crypto = new RNGCryptoServiceProvider()) // { // crypto.GetNonZeroBytes(data); // data = new byte[maxSize]; // crypto.GetNonZeroBytes(data); // } // StringBuilder result = new StringBuilder(maxSize); // foreach (byte b in data) // { // result.Append(chars[b % (chars.Length)]); // } // return result.ToString(); //} public JsonResult Authendicate(user us) { IndiaEvents2Entities e = new IndiaEvents2Entities(); loginHistory lh = new loginHistory(); lh.userID = us.sno; lh.loginHistory1 = DateTime.Now; lh.authTokens = Convert.ToBase64String(Guid.NewGuid().ToByteArray()); e.loginHistories.Add(lh); byte[] time = BitConverter.GetBytes(DateTime.UtcNow.ToBinary()); byte[] key = Guid.NewGuid().ToByteArray(); string token = Convert.ToBase64String(time.Concat(key).ToArray()); byte[] data = Convert.FromBase64String(token); DateTime when = DateTime.FromBinary(BitConverter.ToInt64(data, 0)); if (when < DateTime.UtcNow.AddHours(-24)) { // too old } return(Json("", JsonRequestBehavior.AllowGet)); }