public String UpdateActor(int id, S_ACTORS act)
{
using (IA_ProjectEntities _entities = new IA_ProjectEntities())
{
try
{
var obj = _entities.S_ACTORS.FirstOrDefault(c => c.ACTOR_ID == id);
if (obj == null)
{
return("Null Object");
}
obj.JOB_DESC = act.JOB_DESC;
obj.LNAME = act.LNAME;
obj.MOBILE = act.MOBILE;
obj.FNAME = act.FNAME;
obj.EMAIL = act.EMAIL;
obj.PASSWORD = act.PASSWORD;
_entities.SaveChanges();
return("Done, Updated");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
}
public ActionResult getNotifreq()
{
DataBaseFuncController db = new DataBaseFuncController();
List <S_ACTORS> users = new List <S_ACTORS>();
NOTIF act = new NOTIF();
S_ACTORS actors = new S_ACTORS();
var notifs = db.GetAllNotif().ToList();
foreach (var x in notifs)
{
if (x.ACTOR_ID_TO.ToString() == Session["ActorId"].ToString())
{
users.Add(db.GetActorDataByID(x.ACTOR_ID_FROM));
}
}
Notification pum = new Notification()
{
Users = users,
};
return(PartialView("../Shared/_Req", pum));
}
public JsonResult Login(string loginEmail, string loginPass)
{
var result = "fail";
Console.WriteLine(loginEmail + loginPass);
using (IA_ProjectEntities db = new IA_ProjectEntities())
{
S_ACTORS act = new S_ACTORS();
var userDetail = db.S_ACTORS.FirstOrDefault(x => x.EMAIL == loginEmail);
if (userDetail != null)
{
if (userDetail.PASSWORD == loginPass.ToString())
{
Session["ActorId"] = userDetail.ACTOR_ID.ToString();
Session["UserName"] = userDetail.USERNAME.ToString();
Session["status"] = "done";
result = "suc";
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
result = "wrongpass";
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
else
{
result = "notexist";
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
}
public String UpdateActorReset(int id, S_ACTORS act)
{
using (IA_ProjectEntities _entities = new IA_ProjectEntities())
{
try
{
var obj = _entities.S_ACTORS.FirstOrDefault(c => c.ACTOR_ID == id);
if (obj == null)
{
return("Null Object");
}
obj.RESETTIME = act.RESETTIME;
obj.CODE = act.CODE;
_entities.SaveChanges();
return("Done, Updated");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
}
public JsonResult Sendcode(string emailreset)
{
Random code = new Random();
randno = code.Next(10, 5000);
int res = 50;
DataBaseFuncController db = new DataBaseFuncController();
var emails = db.GetAllActors();
foreach (var element in emails)
{
if (emailreset == element.EMAIL)
{
res = 11;
break;
}
}
if (res == 11)
{
DateTime localDate = DateTime.Now;
var actinfo = db.GetActorData(emailreset);
S_ACTORS actcode = new S_ACTORS()
{
CODE = randno, RESETTIME = localDate
};
db.UpdateActorReset(actinfo.ACTOR_ID, actcode);
// Specify the from and to email address
MailMessage mailMessage = new MailMessage
("*****@*****.**", emailreset);
// Specify the email body
mailMessage.Body = "Your Code to Reset Password is: " + randno.ToString();
// Specify the email Subject
mailMessage.Subject = "Reset Password";
// No need to specify the SMTP settings as these
// are already specified in web.config
SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587);
// Finall send the email message using Send() method
smtpClient.EnableSsl = true;
smtpClient.Send(mailMessage);
return(Json(res, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit_Profile()
{
var Actor_id = Session["ActorId"];
S_ACTORS actor = new S_ACTORS();
actor = db2.GetActorDataByID(Convert.ToInt32(Actor_id));
ProjectsUsersModel pum = new ProjectsUsersModel
{
Actor = actor
};
return(PartialView("../Shared/_Update_Profile_Form", pum));
}
public ActionResult Register(string fname, string lname, string jobdesc, HttpPostedFileBase photo, string mobile, string role, string username, string password, string email)
{
byte[] photos = null;
if (photo != null)
{
try
{
string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(photo.FileName));
photo.SaveAs(path);
using (MemoryStream ms = new MemoryStream())
{
photo.InputStream.CopyTo(ms);
photos = ms.GetBuffer();
}
ViewBag.Message = "File uploaded successfully";
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
try
{
S_ACTORS act = new S_ACTORS()
{
FNAME = fname, LNAME = lname, JOB_DESC = jobdesc, MOBILE = Int32.Parse(mobile), AROLE = role, USERNAME = username, PASSWORD = password, EMAIL = email
};
DataBaseFuncController db = new DataBaseFuncController();
if (db.AddActor(act) == "Done, Updated")
{
return(Redirect("Index"));
}
else
{
return(HttpNotFound());
}
}
catch (Exception ex)
{
return(HttpNotFound());
Console.WriteLine(ex);
}
}
public ActionResult AllUserstoAssign(int id)
{
DataBaseFuncController db = new DataBaseFuncController();
S_ACTORS act = new S_ACTORS();
PROJECT project = new PROJECT();
ProjectsUsersModel pum = new ProjectsUsersModel()
{
Users = db.GetAllActors().ToList(),
project = db.GetProjectID(id)
};
return(PartialView("../Shared/_ModalAssign", pum));
}
public String AddActor(S_ACTORS act)
{
using (IA_ProjectEntities _entities = new IA_ProjectEntities())
{
try
{
_entities.S_ACTORS.Add(act);
_entities.SaveChanges();
return("Done, Updated");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
}
public JsonResult ResetNewPass(string newpass, string emailff)
{
DataBaseFuncController db = new DataBaseFuncController();
var actinfo = db.GetActorData(emailff);
S_ACTORS actcode = new S_ACTORS()
{
PASSWORD = newpass
};
if (db.UpdatePassReset(actinfo.ACTOR_ID, actcode) == "Done, Updated")
{
return(Json(60, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(66, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Register(string fname, string lname, string jobdesc, HttpPostedFileBase photo, string mobile, string role, string username, string password, string email)
{
byte[] photos = null;
if (photo != null)
{
try
{
string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(photo.FileName));
photo.SaveAs(path);
using (MemoryStream ms = new MemoryStream())
{
photo.InputStream.CopyTo(ms);
photos = ms.GetBuffer();
}
ViewBag.Message = "File uploaded successfully";
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
try
{
S_ACTORS act = new S_ACTORS()
{
FNAME = fname, LNAME = lname, JOB_DESC = jobdesc, MOBILE = Int32.Parse(mobile), AROLE = role, USERNAME = username, PASSWORD = password, EMAIL = email
};
DataBaseFuncController db = new DataBaseFuncController();
var allactors = db.GetAllActors();
foreach (var element in allactors)
{
if (username == element.USERNAME)
{
return(Json(11, JsonRequestBehavior.AllowGet));
}
}
foreach (var element in allactors)
{
if (email == element.EMAIL)
{
return(Json(12, JsonRequestBehavior.AllowGet));
}
}
if (db.AddActor(act) == "Done, Updated")
{
var result = 0;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
var result = 1;
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
