public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (PidevContext db = new PidevContext())
{
var user = db.Users.Where(x => x.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.password = Crypto.Hash(model.NewPassword);
user.ResetPasswordCode = "";
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
message = "New password updated successfully";
}
}
}
else
{
message = "Something invalid";
}
ViewBag.Message = message;
return(View(model));
}
public IEnumerable <CarPoolModel> GetByIdParent(int idp)
{
List <CarPool> car;
using (var ctx = new PidevContext())
{
car = ctx.CarPools.Where(c => c.idParent == idp).ToList();
}
List <CarPoolModel> mandatesXml = new List <CarPoolModel>();
foreach (CarPool c in car)
{
mandatesXml.Add(new CarPoolModel
{
Id = c.Id,
Title = c.Title,
From = c.From,
To = c.To,
Time = c.Time,
Date = c.Date,
Message = c.Message,
idKid = c.idKid,
Daily = c.Daily,
Weekly = c.Weekly,
EveryWeekDay = c.EveryWeekDay,
UntilDate = c.UntilDate,
NbPlaceDispo = c.NbPlaceDispo,
idParent = c.idParent,
});
}
return(mandatesXml);
}
public IEnumerable <bool> VerifyAccount(string id)
{
bool Status = false;
using (PidevContext db = new PidevContext())
{
db.Configuration.ValidateOnSaveEnabled = false;
var v = db.Users.Where(x => x.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
db.SaveChanges();
Status = true;
return(new List <bool> {
Status
});
}
}
return(new List <bool> {
false
});
}
public IHttpActionResult Create(KinderGartenModel kgm)
{
using (var ctx = new PidevContext())
{
ctx.KinderGartens.Add(new KinderGarten()
{
Name = kgm.Name,
Image = kgm.Image,
Address = kgm.Address,
NbrEmp = kgm.NbrEmp,
Cost = kgm.Cost,
Phone = kgm.Phone,
Description = kgm.Description,
DirecteurId = kgm.DirecteurId,
DateCreation = DateTime.Now,
latitude = kgm.latitude,
longitude = kgm.longitude,
Votes = "0,0,0,0,0"
});
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
ctx.SaveChanges();
}
return(Ok());
}
public IEnumerable <User> Login(string email, string password)
{
using (var ctx = new PidevContext())
{
User v = ctx.Users.Where(x => x.email == email).FirstOrDefault();
if (v != null)
{
if (v.password == Crypto.Hash(password))
{
return(new List <User> {
v
});
}
return(new List <User> {
new User()
{
idUser = -1
}
});
}
return(new List <User> {
new User()
{
idUser = 0
}
});
}
}
public IHttpActionResult GetAllClaims()
{
IList <ClaimModel> students = null;
using (var ctx = new PidevContext())
{
students = ctx.Claims.Include("StudentAddress")
.Select(s => new ClaimModel()
{
ComplaintId = s.ComplaintId,
Name = s.Name,
Description = s.Description,
ClaimDate = s.ClaimDate,
ClaimType = s.ClaimType,
ParentId = s.ParentId,
status = s.status
}).ToList <ClaimModel>();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
public IHttpActionResult PostNewFeed(CarPoolModel collection)
{
using (var ctx = new PidevContext())
{
ctx.CarPools.Add(new CarPool()
{
idParent = collection.idParent,
Id = collection.Id,
Title = collection.Title,
From = collection.From,
To = collection.To,
Time = collection.Time,
Date = collection.Date,
Message = collection.Message,
NbPlaceDispo = collection.NbPlaceDispo,
idKid = collection.idKid,
Weekly = collection.Weekly,
Daily = collection.Daily,
EveryWeekDay = collection.EveryWeekDay,
UntilDate = collection.UntilDate,
});;
ctx.SaveChanges();
}
return(Ok());
}
public JsonResult SendMessage()
{
if (Session["user"] == null)
{
return(Json(new { status = "error", message = "User is not logged in" }));
}
var currentUser = (User)Session["user"];
string socket_id = Request.Form["socket_id"];
Conversation convo = new Conversation
{
sender_id = currentUser.idUser,
message = Request.Form["message"],
receiver_id = Convert.ToInt32(Request.Form["contact"]),
};
using (var db = new PidevContext())
{
db.Conversations.Add(convo);
db.SaveChanges();
}
return(Json(convo));
}
// GET: administrator/Chat
public ActionResult Index()
{
var userId = (int)Session["idu"];
String Phone2 = userService.GetById(userId).login;
String mail = userService.GetById(userId).email;
ViewBag.home = mail;
ViewBag.phone = Phone2;
if (Session["user"] == null)
{
return(Redirect("/Login/Login"));
}
var currentUser = (User)Session["user"];
using (var db = new PidevContext())
{
ViewBag.allUsers = db.Users.Where(u => u.email != currentUser.email)
.ToList();
}
ViewBag.currentUser = currentUser;
return(View());
}
public JsonResult ConversationWithContact(int contact)
{
if (Session["user"] == null)
{
return(Json(new { status = "error", message = "User is not logged in" }));
}
var currentUser = (User)Session["user"];
var conversations = new List <Conversation>();
using (var db = new PidevContext())
{
conversations = db.Conversations.
Where(c => (c.receiver_id == currentUser.idUser &&
c.sender_id == contact) ||
(c.receiver_id == contact &&
c.sender_id == currentUser.idUser))
.OrderBy(c => c.created_at)
.ToList();
}
return(Json(
new { status = "success", data = conversations },
JsonRequestBehavior.AllowGet
));
}
public IHttpActionResult Create(PublicationVM p)
{
using (var ctx = new PidevContext())
{
ctx.Publications.Add(new Publication()
{
datePub = DateTime.Now,
imagePub = p.imagePub,
nbLike = p.nbLike,
nbDislike = p.nbDislike,
titlePub = p.titlePub,
descriptionPub = p.descriptionPub,
Dislike = p.Dislike,
Like = p.Like,
ParentFk = p.ParentFK,
nbVue = p.nbVue
});
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
ctx.SaveChanges();
}
return(Ok());
}
public IEnumerable <CommentVM> CommentsByPub(int id)
{
List <CommentVM> commentVMs = new List <CommentVM>();
using (var ctx = new PidevContext())
{
var comments = ctx.Comments.Where(c => c.PublicationFK == id).ToList();
foreach (var c in comments)
{
commentVMs.Add(new CommentVM()
{
CommentId = c.CommentId,
dateCom = c.dateCom,
nomUser = c.nomUser,
post = c.post,
PublicationFK = c.PublicationFK
});
}
}
return(commentVMs);
}
public IHttpActionResult Register(UserLogin user)
{
string message = "";
user.IsEmailVerified = false;
using (var ctx = new PidevContext())
{
User user1 = new User()
{
password = Crypto.Hash(user.password),
Confirmpassword = Crypto.Hash(user.Confirmpassword),
role = user.role,
email = user.email,
nom = user.nom,
prenom = user.prenom,
login = user.login,
ActivationCode = Guid.NewGuid(),
IsEmailVerified = false
};
ctx.Users.Add(user1);
message = "Registration Successfully done. Account activation link has been send to your email";
SendVerificationLinkEmail(user.email, user1.ActivationCode.ToString());
ctx.SaveChanges();
}
return(Ok());
}
public ActionResult ForgotPassword(string Email)
{
string message = "";
using (PidevContext db = new PidevContext())
{
var account = db.Users.Where(x => x.email == Email).FirstOrDefault();
if (account != null)
{
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.email, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
message = "Reset password link has been sent to your email";
}
else
{
message = "Account not found";
}
}
ViewBag.Message = message;
return(View());
}
public bool isEmailExist(string email)
{
using (PidevContext db = new PidevContext())
{
var v = db.Users.Where(x => x.email == email).FirstOrDefault();
return(v != null);
}
}
public ActionResult Chart()
{
var context = new PidevContext();
var CountN = context.user.SqlQuery("Select * from user where isValid=1").Count();
var CountT = context.user.SqlQuery("Select * from user where isValid=0").Count();
new Chart(width: 800, height: 200).AddSeries(chartType: "pie", xValue: new[] { "Utilisateur Actif", "User non Acif" }, yValues: new[] { CountT, CountN }).Write("png");
return(View("chart"));
}
public ActionResult Chart()
{
var context = new PidevContext();
var CountN = context.user.SqlQuery("Select * from user where potential=0").Count();
var CountT = context.user.SqlQuery("Select * from user where potential=1").Count();
new System.Web.Helpers.Chart(width: 800, height: 200).AddSeries(chartType: "pie", xValue: new[] { "actif", "non actif" }, yValues: new[] { CountT, CountN }).Write("png");
return(View("Chart"));
}
public ActionResult Chart()
{
var context = new PidevContext();
var CountN = context.evenement.SqlQuery("Select * from evenement where nbrmaxpart > 10").Count();
var CountT = context.evenement.SqlQuery("Select * from evenement where nbrmaxpart < 10").Count();
new Chart(width: 800, height: 200).AddSeries(chartType: "pie", xValue: new[] { "Capacité > 10", "Capacité < 10" }, yValues: new[] { CountT, CountN }).Write("png");
return(View("Chart"));
}
public IEnumerable <int> GetIdKidsByName(String idp)
{
Kid kids;
using (var ctx = new PidevContext())
{
kids = ctx.Kids.Where(c => c.FirstName == idp).FirstOrDefault();
}
return(new List <int>()
{
(int)kids.IdKid
});
}
public IEnumerable <User> GetUserById(int id)
{
using (var ctx = new PidevContext())
{
User v = ctx.Users.Where(x => x.idUser == id).FirstOrDefault();
if (v != null)
{
return(new List <User> {
v
});
}
return(null);
}
}
public ActionResult Login(UserLogin login)
{
string message = "";
using (PidevContext db = new PidevContext())
{
var v = db.Users.Where(x => x.email == login.email).FirstOrDefault();
if (v != null)
{
if (string.Compare(Crypto.Hash(login.password), v.password) == 0)
{
int timeout = login.RememberMe ? 43000 : 1; //One Year
var ticket = new FormsAuthenticationTicket(login.email + login.password, login.RememberMe, timeout);
string encypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encypted)
{
Expires = DateTime.Now.AddMinutes(timeout),
HttpOnly = true
};
Response.Cookies.Add(cookie);
Session["idu"] = v.idUser;
Session["v"] = v;
Session["v"] = v.role;
Session["user"] = v;
if (Session["v"].ToString() == "admin")
{
return(RedirectToAction("Index", "UserBack"));
}
else
{
return(RedirectToAction("Index", "KinderGarten"));
}
}
else
{
message = "Invalid password";
}
}
else
{
message = "Invalid Crendential provided";
}
}
ViewBag.message = message;
return(View());
}
public ActionResult Like(int id)
{
using (PidevContext ctx = new PidevContext())
{
client.BaseAddress = new Uri("http://localhost:18080/");
var deleteTask = client.DeleteAsync("pidev-web/rest/feedback/" + id.ToString());
deleteTask.Wait();
var result = deleteTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(View());
}
public IHttpActionResult PostNewFeed(FeedBackModel student)
{
using (var ctx = new PidevContext())
{
ctx.Reputations.Add(new FeedBack()
{
FeedBackId = student.FeedBackId,
Description = student.Description,
ParentId = 2,
FeedBackDate = DateTime.Today
});
ctx.SaveChanges();
}
return(Ok());
}
public ActionResult ResetPassword(string id)
{
using (PidevContext db = new PidevContext())
{
var user = db.Users.Where(x => x.ResetPasswordCode == id).FirstOrDefault();
if (user != null)
{
ResetPasswordModel model = new ResetPasswordModel();
model.ResetCode = id;
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
public IHttpActionResult DeleteComm(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid publication id"));
}
using (var ctx = new PidevContext())
{
var comment = ctx.Comments
.Where(k => k.CommentId == id)
.FirstOrDefault();
ctx.Entry(comment).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult Delete(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid KinderGarten id"));
}
using (var ctx = new PidevContext())
{
var Kinder = ctx.KinderGartens
.Where(k => k.KinderGartenId == id)
.FirstOrDefault();
ctx.Entry(Kinder).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
// DELETE: api/ClaimApi/5
public IHttpActionResult Delete(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var ctx = new PidevContext())
{
var student = ctx.Claims
.Where(s => s.ComplaintId == id)
.FirstOrDefault();
ctx.Entry(student).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewFeed(ClaimModel student)
{
using (var ctx = new PidevContext())
{
ctx.Claims.Add(new Claim()
{
Description = student.Description,
Name = student.Name,
ParentId = student.ParentId,
ClaimDate = DateTime.Today,
ClaimType = student.ClaimType,
status = "In_Progress"
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult ResetPassword(UserLogin model)
{
using (PidevContext db = new PidevContext())
{
var user = db.Users.Where(x => x.ResetPasswordCode == model.ResetPasswordCode).FirstOrDefault();
if (user != null)
{
user.password = Crypto.Hash(model.password);
user.Confirmpassword = Crypto.Hash(model.Confirmpassword);
user.ResetPasswordCode = "";
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
}
}
return(Ok());
}
public ActionResult Register([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user)
{
bool Status = false;
string message = "";
if (ModelState.IsValid)
{
var isExist = isEmailExist(user.email);
// Email is already Exist
if (isExist)
{
//ModelState.AddModelError("EmailExist", "Email already exist");
message = "Email already exist";
return(View(user));
}
user.ActivationCode = Guid.NewGuid();
user.password = Crypto.Hash(user.password);
user.Confirmpassword = Crypto.Hash(user.Confirmpassword);
user.role = user.role;
user.IsEmailVerified = false;
using (PidevContext db = new PidevContext())
{
db.Users.Add(user);
db.SaveChanges();
message = "Registration Successfully done. Account activation link has been send to your email";
SendVerificationLinkEmail(user.email, user.ActivationCode.ToString());
Status = true;
return(RedirectToAction("Login", "Login"));
}
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}