public ActionResult Delete_Project(int id)
{
DataBaseFuncController db = new DataBaseFuncController();
db.RemoveProject(id);
return(Json(new { result = 1 }, JsonRequestBehavior.AllowGet));
}
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 ActionResult Index(PROJECT project)
{
DataBaseFuncController db = new DataBaseFuncController();
db.AddProject(project);
return(Json(new { result = 1 }));
}
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 AllUsersReqAssign(int id1, int id2)
{
DataBaseFuncController db = new DataBaseFuncController();
ACTOR_PROJECT act_proj = new ACTOR_PROJECT()
{
ACTOR_ID = id1, PROJECT_ID = id2
};
db.AddProjectActor(act_proj);
return(Json(new { result = 12 }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(PROJECT project)
{
if (!ModelState.IsValid)
{
return(View("Index", project));
}
DataBaseFuncController db = new DataBaseFuncController();
db.AddProject(project);
return(Json(new { result = 1 }));
}
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 ActionResult Index(PROJECT project)
{
if (!ModelState.IsValid)
{
return(View("Index", project));
}
DataBaseFuncController db = new DataBaseFuncController();
project.PROJECT_OWNER = Session["UserName"].ToString();
project.P_STATUS = false;
IA_ProjectEntities x = new IA_ProjectEntities();
db.AddProject(project);
return(Json(new { result = 1 }));
}
public JsonResult ResetPassword(string coderes, string emailf)
{
DataBaseFuncController db = new DataBaseFuncController();
var actinfo = db.GetActorData(emailf);
DateTime localDate = DateTime.Now;
int seconds = (int)(localDate - actinfo.RESETTIME).Value.TotalSeconds;
if (coderes == actinfo.CODE.ToString())
{
return(Json(22, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(25, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AcceptReq(int id)
{
DataBaseFuncController db = new DataBaseFuncController();
ACTOR_PROJECT x = new ACTOR_PROJECT()
{
AssignStatus = true
};
if (db.UpdateActorProject(id, x) == 1)
{
return(Json(12, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(13, JsonRequestBehavior.AllowGet));
}
}
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 string prof(string pageid, string pageurl, string actorid)
{
try
{
/*DataBaseFuncController x = new DataBaseFuncController();
* x.page(obj);
* return View();*/
S_PAGE s = new S_PAGE()
{
PAGE_URL = pageurl, ACTOR_ID_P = Int32.Parse(actorid), PAGE_ID = Int32.Parse(pageid)
};
DataBaseFuncController x = new DataBaseFuncController();
x.page(s);
return("done");
}catch (Exception ex)
{
return("failed");
}
}
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));
}
}