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());
}
}
}
}
}
