public string ResetPassword(ResetPassword model) { using (MyDbEntities db = new MyDbEntities()) { var singelUser = db.Admins.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault(); if (singelUser != null) { singelUser.Password = Crypto.Hash(model.NewPassword); singelUser.ResetPasswordCode = ""; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return("New password Updated Successfully"); } return(""); } }
public List <string> showUsers() { var context = new MyDbEntities(); //step1 1 if (context != null) { context.Dispose(); context = new MyDbEntities(); } var q = from t in context.UserTable select t.UserName; //step 3 return(q.ToList()); }
public static string IdToTicker(int symbolId) { string ticker = string.Empty; using (var db = new MyDbEntities()) { var query = from s in db.Symbols where (s.SymbolID == symbolId) select s.Ticker; foreach (var q in query) { ticker = q.ToString(); } } return(ticker); }
public ActionResult Index() { using (MyDbEntities DB = new MyDbEntities()) { var A = DB.UserDatas; var totalUsers = DB.UserDatas.Count(); var totalAdmins = DB.Admins.Count(); var totalCelebrities = DB.Celebrities.Count(); var blocks = DB.UserDatas.Where(t => t.BlockStatus == true).Count(); FrontPageModel fr = new FrontPageModel(); fr.tAdmins = totalAdmins; fr.tCelebrities = totalCelebrities; fr.tUsers = totalUsers; fr.blockedUsers = blocks; return(View(fr)); } }
public static void SymbolInsert(ObservableCollection <Symbol> symbols) { using (var db = new MyDbEntities()) { try { foreach (var s in symbols) { var symbol = new Symbol(); symbol = s; db.Symbols.Add(symbol); } db.SaveChanges(); } catch { } } }
public static void PriceInsert(BindableCollection <Price> prices) { using (var db = new MyDbEntities()) { try { foreach (var p in prices) { var price = new Price(); price = p; db.Prices.Add(price); } db.SaveChanges(); } catch { } } }
public HttpResponseMessage Register([FromBody] UserData user) { string message = ""; if (ModelState.IsValid) { //Email is already exist var isExist = IsEmailExist(user.Email); if (isExist) { message = "Email is already existed"; return(Request.CreateErrorResponse(HttpStatusCode.NotFound, message)); } //password encoding user.Password = Crypto.Hash(user.Password); user.ActiveStatus = true; // add face API recognition here // using Http MultiPart method -not done //------------- implement the code ---------- // verify a new user by the face //save to database using (MyDbEntities db = new MyDbEntities()) { UserViewModel model = new UserViewModel(); //var ProfilePic = db.UserPhotos.Where(c => c.UploaderID == user.UserId).FirstOrDefault(); //model.Link = ProfilePic.Link; db.UserDatas.Add(user); db.SaveChanges(); model.UploaderID = user.UserId; model.Link = ""; // map user detail with profile 4to return(Request.CreateResponse(HttpStatusCode.OK, model)); // create the user profile and load it in the home page of mobile app } } else { message = "Connection Error! Try Again"; return(Request.CreateResponse(HttpStatusCode.BadRequest, message)); } }
public int NewCelebrity([FromBody] Celebrity celebrity) { if (ModelState.IsValid) { using (MyDbEntities db = new MyDbEntities()) { db.Celebrities.Add(celebrity); db.SaveChanges(); int id = celebrity.CelebrityId; return(id); } } else { return(0); } }
public Boolean VerifyAccount(string id) { using (MyDbEntities db = new MyDbEntities()) { db.Configuration.ValidateOnSaveEnabled = false; var validActivation = db.Admins.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (validActivation != null) { validActivation.IsEmailVerified = true; db.SaveChanges(); return(true); } else { return(false); } } }
public ActionResult ChangeSetting(Admin admin) { admin.Email = System.Web.HttpContext.Current.User.Identity.Name; using (MyDbEntities db = new MyDbEntities()) { Admin account = db.Admins.Where(a => a.Email == admin.Email).FirstOrDefault(); if (account != null) { account.FirstName = admin.FirstName; account.LastName = admin.LastName; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { return(View(admin)); } } }
public IEnumerable <LocationData> SearchLocation([FromBody] LocationViewModel model) { if (ModelState.IsValid) { using (MyDbEntities db = new MyDbEntities()) { var x = db.LocationDatas.Where(a => a.Latitude > model.MinLatitude && a.Latitude <model.MaxLatitude && a.Longitude> model.MinLongitude && a.Longitude < model.MaxLongitude).ToList(); if (x.Count() != 0) { return(x); } return(null); } } else { return(null); } }
public string Register([FromBody] AdminRegisterViewModel adminModel) { string message = ""; if (ModelState.IsValid) { //Email is already exist var isExist = IsEmailExist(adminModel.Email); if (isExist) { return("EmailExist"); } //password encoding adminModel.Password = Crypto.Hash(adminModel.Password); adminModel.ConfirmPassword = Crypto.Hash(adminModel.ConfirmPassword); Admin admin = new Admin(); admin.FirstName = adminModel.FirstName; admin.LastName = adminModel.LastName; admin.Email = adminModel.Email; admin.Password = adminModel.Password; admin.IsEmailVerified = false; //Generate Activation code admin.ActivationCode = Guid.NewGuid(); //save to database using (MyDbEntities db = new MyDbEntities()) { db.Admins.Add(admin); db.SaveChanges(); //send Email SendVerificationLinkEmail(adminModel.Email, admin.ActivationCode.ToString()); message = "For activation check your email."; return(message); } } else { return("Invalid Request"); } }
public string CelebrityPhoto([FromBody] CelebrityPhoto model) { if (ModelState.IsValid) { //save to database using (MyDbEntities db = new MyDbEntities()) { db.CelebrityPhotoes.Add(model); db.SaveChanges(); return("Success"); } } else { return(""); } }
public ActionResult SetProfilePic(int id, int pId) { using (MyDbEntities db = new MyDbEntities()) { var photos = db.CelebrityPhotoes.Where(a => a.CelibrityID == id).ToList(); foreach (var img in photos) { if (img.PhotoID != pId) { img.ProfilePic = false; } else { img.ProfilePic = true; } } db.SaveChanges(); return(RedirectToAction("CelebrityProfile", new { id = id })); } }
public HttpResponseMessage UpdateLocation([FromBody] Location ulocation) { using (MyDbEntities db = new MyDbEntities()) { var location = db.Locations.Where(a => a.UserID == ulocation.UserID).FirstOrDefault(); if (location != null) { location.Latitude = ulocation.Latitude; location.Longitude = ulocation.Longitude; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Location setting failed")); } } }
public List <CelebritySuggestion> suggestions(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord) { MyDbEntities db = new MyDbEntities(); var v = (from a in db.CelebritySuggestions select a ); totalRecord = v.Count(); v = v.OrderBy(sort + " " + sortdir); if (pageSize > 0) { v = v.Skip(skip).Take(pageSize); } return(v.ToList()); }
public string FogetPassword(string email) { using (MyDbEntities db = new MyDbEntities()) { var singlUeser = db.Admins.Where(a => a.Email == email).FirstOrDefault(); if (singlUeser != null) { string resetCode = Guid.NewGuid().ToString(); SendVerificationLinkEmail(singlUeser.Email, resetCode, "ResetPassword"); singlUeser.ResetPasswordCode = resetCode; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return("Reset password link has been sent your Email."); } else { return("Account Not found !"); } } }
public HttpResponseMessage SearchName([FromBody] CelebrityPhoto search) { string message = ""; if (ModelState.IsValid) { using (MyDbEntities db = new MyDbEntities()) { var faceSearch = db.Celebrities.Where(a => a.CelebrityId == search.CelibrityID).ToList(); if (faceSearch != null) { return(Request.CreateResponse(HttpStatusCode.OK, faceSearch)); } return(Request.CreateResponse(HttpStatusCode.NotFound, "Connection Error! Try Again")); } } else { message = "Connection Error! Try Again"; return(Request.CreateResponse(HttpStatusCode.BadRequest, message)); } }
public List <reportedPerson> reportedUsers(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord) { MyDbEntities db = new MyDbEntities(); var v = (from a in db.reportedPersons where a.FirstName.Contains(search) || a.LastName.Contains(search) select a ); totalRecord = v.Count(); v = v.OrderBy(sort + " " + sortdir); if (pageSize > 0) { v = v.Skip(skip).Take(pageSize); } return(v.ToList()); }
public static ObservableCollection <StockData> GetStockDataFromDatabase(string ticker, DateTime startDate, DateTime endDate) { ObservableCollection <StockData> res = new ObservableCollection <StockData>(); using (var db = new MyDbEntities()) { var query = (from s in db.Symbols join p in db.Prices on s.SymbolID equals p.SymbolID where s.Ticker == ticker && p.Date >= startDate && p.Date <= endDate select new { s.Ticker, p.Date, p.PriceOpen, p.PriceHigh, p.PriceLow, p.PriceClose, p.PriceAdj, p.Volume }).OrderBy(x => x.Date); foreach (var p in query) { res.Add(new StockData { Ticker = ticker, Date = p.Date, Open = p.PriceOpen, High = p.PriceHigh, Low = p.PriceLow, Close = p.PriceClose, AdjClose = p.PriceAdj, Volume = p.Volume }); } } return(res); }
//creat a new userLogin.cs file -done public HttpResponseMessage ForgotPassword([FromBody] UserLogin userLogin) { using (MyDbEntities db = new MyDbEntities()) { var user = db.UserDatas.Where(a => a.Email == userLogin.Email).FirstOrDefault(); if (user != null) { Random rnd = new Random(); int code = rnd.Next(1000, 9999); SendVerificationLinkEmail(user.Email, code); user.ResetCode = code; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid credential Provided")); } } }
public HttpResponseMessage Code([FromBody] ForgotPasswordModel model) { using (MyDbEntities db = new MyDbEntities()) { var user = db.UserDatas.Where(a => a.Email == model.Email).FirstOrDefault(); if (user != null) { if (user.ResetCode == model.ResetCode) { user.Password = model.Password; return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid Credential Provided")); } } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid Credential Provided")); } } }
public HttpResponseMessage SearchName([FromBody] SearchKeyword search) { string message = ""; if (ModelState.IsValid) { using (MyDbEntities db = new MyDbEntities()) { var nameSearch = db.Celebrities.Where(a => a.FirstName == search.Keyword || a.LastName == search.Keyword).ToList(); //var userProfile = db.UserPhotos.Where(c => c.UploaderID == user.UserId).FirstOrDefault(); //model.Link = ProfilePic.Link; // map user detail with profile 4to return(Request.CreateResponse(HttpStatusCode.OK, nameSearch)); // create the user profile and load it in the home page of mobile app } } else { message = "Connection Error! Try Again"; return(Request.CreateResponse(HttpStatusCode.BadRequest, message)); } }
public CelebrityViewModel ViewCelebrity(int id) { try { using (MyDbEntities db = new MyDbEntities()) { CelebrityViewModel model = new CelebrityViewModel(); var celebrity = db.Celebrities.Where(a => a.CelebrityId == id).FirstOrDefault(); if (celebrity != null) { var ProfilePic = db.CelebrityPhotoes.Where(c => c.CelibrityID == id && c.ProfilePic == true).FirstOrDefault(); model.CelebrityId = celebrity.CelebrityId; model.FirstName = celebrity.FirstName; model.LastName = celebrity.LastName; model.Gender = celebrity.Gender; model.Feild = celebrity.Feild; model.Description = celebrity.Description; model.ActiveStatus = celebrity.ActiveStatus; model.Rating = celebrity.Rating; model.ProfilePic = ProfilePic.Link; return(model); } else { return(null); } } } catch (Exception e) { return(null); } }
public HttpResponseMessage UserPhoto([FromBody] UserPhoto model) { if (ModelState.IsValid) { //save to database using (MyDbEntities db = new MyDbEntities()) { UserViewModel user = new UserViewModel(); user.UploaderID = model.UploaderID; user.Link = model.Link; db.UserPhotoes.Add(model); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, model)); } } else { string message = "Photo Upload Failed! Try Again"; return(Request.CreateResponse(HttpStatusCode.BadRequest, message)); } }
// GET: SuggestionReport public ActionResult celebritySuggestionList(int page = 1, string sort = "firstName", string sortDir = "asc", string search = "") { MyDbEntities db = new MyDbEntities(); int pageSize = 10; int totalRecord = 0; if (page < 1) { page = 1; } int skip = (page * pageSize) - pageSize; var v = (from a in db.CelebritySuggestions select a ); var data = v.ToList(); ViewBag.TotalRows = totalRecord; return(View(data)); }
public async Task <ActionResult> AddPhoto(CreateCelebrityViewModel model) { string message = ""; HttpPostedFileBase file = model.imageBrowes; // Image i = Image.FromStream(file.InputStream, true, true); MemoryStream ms = new MemoryStream(); i.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] imgData = ms.ToArray(); Face0 faceAPI = new Face0(); using (var fileStream = new MemoryStream(imgData)) { int[] face = await faceAPI.search(fileStream); for (int j = 0; j < 5; j++) { if (model.CelebrityId == face[j]) { DateTime dTime = DateTime.Now; string time = dTime.ToString(); time = time.Replace(" ", "_") + ".jpg"; if (file.ContentLength > 0) { CloudStorageAccount storageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=faceitphotos;AccountKey=" + ConfigurationManager.AppSettings["StorageKey"].ToString()); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer container = blobClient.GetContainerReference("celebrityimages"); container.CreateIfNotExists(); CloudBlockBlob blockBlob = container.GetBlockBlobReference(model.CelebrityId.ToString() + "_" + time); /*Image i = Image.FromStream(file.InputStream, true, true); * MemoryStream ms = new MemoryStream(); * i.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); * byte[] imgData = ms.ToArray();*/ using (var fileStream2 = new MemoryStream(imgData)) { await blockBlob.UploadFromStreamAsync(fileStream2); } using (MyDbEntities db = new MyDbEntities()) { var photos = db.CelebrityPhotoes.Where(a => a.CelibrityID == model.CelebrityId).ToList(); foreach (var photo in photos) { photo.ProfilePic = false; db.SaveChanges(); } } // CelebrityPhoto photoModel = new CelebrityPhoto(); photoModel.Link = "https://faceitphotos.blob.core.windows.net/celebrityimages/" + model.CelebrityId + "_" + time; photoModel.ProfilePic = true; photoModel.CelibrityID = model.CelebrityId; var serializer = new JavaScriptSerializer(); var json2 = serializer.Serialize(photoModel); var stringContent2 = new StringContent(json2, Encoding.UTF8, "application/json"); HttpResponseMessage response = await client.PostAsync("api/Celebrity/CelebrityPhoto", stringContent2); if (response.IsSuccessStatusCode) { message = response.Content.ReadAsAsync <string>().Result; if (message == "Success") { ViewBag.Message = "Upload Success"; return(RedirectToAction("CelebrityProfile", new { id = model.CelebrityId })); } else { ViewBag.Message = "Upload Failed"; return(RedirectToAction("ViewImage", new { id = model.CelebrityId })); } } else { ViewBag.Message = "Upload Failed"; return(RedirectToAction("ViewImage", new { id = model.CelebrityId })); } // } } ViewBag.Status = true; ViewBag.Message = "not this person face"; return(View("ViewImage")); } } // ViewBag.Message = "Upload Failed"; return(RedirectToAction("ViewImage", new { id = model.CelebrityId })); }
public async Task <ActionResult> Search(HttpPostedFileBase imageBrowes) { Image i = Image.FromStream(imageBrowes.InputStream, true, true); MemoryStream ms = new MemoryStream(); i.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] imgData = ms.ToArray(); Face0 faceAPI = new Face0(); using (var fileStream = new MemoryStream(imgData)) { int s1, s2, s3, s4, s5, count = 0; int[] message = await faceAPI.search(fileStream); /*for(int k = 0; k < 5; k++) * { * if (message[k] < 5000) * { * message[k] = 0; * } * }*/ s1 = message[0]; s2 = message[1]; s3 = message[2]; s4 = message[3]; s5 = message[4]; for (int j = 0; j < 5; j++) { if (message[j] == -1) { ViewBag.Status = true; ViewBag.Message = "Not Faces in Image"; return(View()); } else if (message[j] != 0) { count++; } } if (count == 0) { //no one identify ViewBag.Status = true; ViewBag.Message = "No one Identified"; return(View()); } else { using (MyDbEntities db = new MyDbEntities()) { IEnumerable <UserDataExtended2> userSet = db.UserDataExtended2.Where(a => a.UserId == s1 || a.UserId == s2 || a.UserId == s3 || a.UserId == s4 || a.UserId == s5).ToList(); if (userSet.Count() != 0) { return(View("NameSearch", userSet)); } else { ViewBag.Status = true; ViewBag.Message = "No one Identified"; return(View()); } } } } }