public ActionResult Register(UserRegister registerModel)
{
GetRolesForCurrentUsers();
if (ModelState.IsValid)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
bool isUserExist = WebSecurity.UserExists(registerModel.UserName);
if (isUserExist)
{
ModelState.AddModelError("UserName", "UserName already exist");
}
else
{
registerModel.Account = registerModel.Role;
WebSecurity.CreateUserAndAccount(registerModel.UserName, registerModel.Password, new { registerModel.Account, status = 1 });
Roles.AddUserToRole(registerModel.UserName, registerModel.Role);
var userid = (db.Users.OrderByDescending(s => s.UserId).Select(s => s.UserId)).FirstOrDefault();
UsersDetail userModel = new UsersDetail();
userModel.UserId = userid;
db.UsersDetails.Add(userModel);
db.SaveChanges();
ViewBag.Message = "User Added";
}
}
}
return(View());
}
private void updateLikeDislikePost(WorkFlowDbContext db, int PId, bool v)
{
var UpdateId = db.PostLikes.Where(x => (x.PostId == PId && x.UserId == WebSecurity.CurrentUserId)).FirstOrDefault();
UpdateId.PostLike1 = v;
db.SaveChanges();
}
public ActionResult RequestPaperApprovel(Paper paperModel)
{
if (ModelState.IsValid)
{
if (paperModel.fileUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(paperModel.fileUpload.FileName);
string extension = Path.GetExtension(paperModel.fileUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
paperModel.FilePath = "~/AppFiles/Files/" + fileName;
paperModel.fileUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Files/"), fileName));
}
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
paperModel.UserId = WebSecurity.CurrentUserId;
db.Papers.Add(paperModel);
db.SaveChanges();
ViewBag.Message = "Data added";
return(RedirectToAction("PaperStatus", "Employee"));
}
}
return(View());
}
public ActionResult UserProfile(UserDetail UsersModel)
{
try
{
if (ModelState.IsValid)
{
var imageUpdate = "";
if (UsersModel.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(UsersModel.ImageUpload.FileName);
string extension = Path.GetExtension(UsersModel.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
UsersModel.ImagePath = "~/AppFiles/Images/" + fileName;
UsersModel.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
else
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
imageUpdate = db.UsersDetails.Where(s => s.UserId == WebSecurity.CurrentUserId).Select(s => s.ImagePath).FirstOrDefault();
}
}
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
if (UsersModel.ImageUpload == null)
{
UsersModel.ImagePath = imageUpdate;
}
UsersModel.UserId = WebSecurity.CurrentUserId;
UsersDetail ud = new UsersDetail();
ud.UserDetailId = UsersModel.UserDetailId;
ud.UserId = UsersModel.UserId;
ud.FirstName = UsersModel.FirstName;
ud.LastName = UsersModel.LastName;
ud.Email = UsersModel.Email;
ud.Mobile = UsersModel.Mobile;
ud.UserAddress = UsersModel.UserAddress;
ud.About = UsersModel.About;
ud.ImagePath = UsersModel.ImagePath;
db.Entry(ud).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewBag.Message = "Your profile has been updated!";
}
}
else
{
return(View(UsersModel));
}
return(View(UsersModel));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateProject(TotalLikesPostsCommentsModel Addproject)
{
var projectdata = Addproject.CreateNewProject;
if (ModelState.IsValid)
{
if (projectdata.fileUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(projectdata.fileUpload.FileName);
string extension = Path.GetExtension(projectdata.fileUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
projectdata.FilePath = "~/AppFiles/ProjectFiles/" + fileName;
projectdata.fileUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/ProjectFiles/"), fileName));
}
projectdata.CreatedBy = WebSecurity.CurrentUserName;
projectdata.CreatedDate = DateTime.Now.ToShortDateString();
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
db.Projects.Add(projectdata);
db.SaveChanges();
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult BlockComments(int CommentId)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
var finddata = db.PostComments.Find(CommentId);
finddata.Status = false;
db.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Completed(int id)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
var verab = db.Projects.Find(id);
verab.Status = true;
db.SaveChanges();
}
return(RedirectToAction("Index", "Employee"));
}
public ActionResult LeaveReject(Leaf leave, int id)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
leave = db.Leaves.Find(id);
leave.Status = false;
db.Entry(db.Leaves.Where(x => x.LeaveId == id).FirstOrDefault()).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("AproveLeave", "Admin"));
}
}
private void InsertRecord(WorkFlowDbContext db, int likeId, bool status)
{
PostLike NewLikeDislike = new PostLike();
NewLikeDislike.PostId = likeId;
NewLikeDislike.UserId = WebSecurity.CurrentUserId;
NewLikeDislike.PostLike1 = status;
db.PostLikes.Add(NewLikeDislike);
db.SaveChanges();
}
public ActionResult PaperReject(Paper pap, int id)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
pap = db.Papers.Find(id);
pap.PaperStatus = false;
db.Entry(db.Papers.Where(x => x.PaperId == id).FirstOrDefault()).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ApprovePaper", "Admin"));
}
}
public ActionResult RequestLeave(Leaf leav)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
if (ModelState.IsValid)
{
leav.UserId = WebSecurity.CurrentUserId;
db.Leaves.Add(leav);
db.SaveChanges();
return(RedirectToAction("ViewLeaveStatus", "Employee"));
}
}
return(View());
}
public ActionResult AddTopic(string TopicName)
{
if (TopicName != "")
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
Topic AddTopicData = new Topic();
AddTopicData.TopicName = TopicName;
AddTopicData.CreatedBy = WebSecurity.CurrentUserName;
db.Topics.Add(AddTopicData);
db.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateProject(EmployeeViewModel Addproject)
{
var projectdata = Addproject.CreateNewProject;
if (ModelState.IsValid)
{
projectdata.AssignedBy = WebSecurity.CurrentUserName;
projectdata.CreatedDate = DateTime.Now.ToShortDateString();
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
db.ProjectTasks.Add(projectdata);
db.SaveChanges();
}
}
return(RedirectToAction("Index", "Employee"));
}
public ActionResult AddPost(Post AddNewPost)
{
GetTopicsForCurrentPost();
if (ModelState.IsValid)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
AddNewPost.UserId = WebSecurity.CurrentUserId;
AddNewPost.CreatedTime = DateTime.Now.ToShortDateString();
AddNewPost.Status = true;
db.Posts.Add(AddNewPost);
db.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = false }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddNewComment(int PostId, string Description)
{
PostComment addnewcomment = new PostComment();
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
string CurrentUserName = db.UsersDetails.Where(s => s.UserId == WebSecurity.CurrentUserId).Select(s => (s.FirstName + " " + s.LastName)).FirstOrDefault();
addnewcomment.PostId = PostId;
addnewcomment.UserId = WebSecurity.CurrentUserId;
addnewcomment.CommentContent = Description;
addnewcomment.CommentTime = DateTime.Now.ToShortDateString();
addnewcomment.Status = true;
addnewcomment.UserFullName = CurrentUserName;
db.PostComments.Add(addnewcomment);
db.SaveChanges();
var newComment = db.PostComments.Join(db.UsersDetails, pc => pc.UserId, ud => ud.UserId, (pc, ud) => new { pc, ud }).OrderByDescending(p => p.pc.CommentId).Select(s => new { commentContent = s.pc.CommentContent, name = (s.ud.FirstName + " " + s.ud.LastName) }).FirstOrDefault();
return(Json(new { status = true, mycomment = newComment }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult updateViewdNotification(Meeting m)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
var status = db.Meetings.Where(s => (s.UserId == WebSecurity.CurrentUserId && s.IsViewd != true)).Select(s => s.IsViewd).FirstOrDefault();
if (status != true)
{
var id = db.Meetings.Where(s => (s.UserId == WebSecurity.CurrentUserId && s.IsViewd != true)).Select(s => s.MeetingId).ToList();
foreach (var itemid in id)
{
m = db.Meetings.Find(itemid);
m.IsViewd = true;
db.Entry(m).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateMeeting(Meeting addNewMeeting)
{
GetTopicsForCurrentPost();
if (ModelState.IsValid)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
string meetingCreatedBy = String.Empty;
if (User.IsInRole("Principle"))
{
meetingCreatedBy = "Principle";
}
else if (User.IsInRole("HOD"))
{
meetingCreatedBy = "HOD";
}
addNewMeeting.CreatedBy = meetingCreatedBy;
db.Meetings.Add(addNewMeeting);
db.SaveChanges();
ViewBag.Message = "Meeting Added";
}
}
return(Json(new { status = true, message = "Meeting Created successfully!" }, JsonRequestBehavior.AllowGet));
}
public void AddWorkFlow(workFlow workFlow)
{
db.WorkFlows.Add(workFlow);
db.SaveChanges();
}
public void AddStep(Step step)
{
Db.Steps.Add(step);
Db.SaveChanges();
}
void IApplicationRepository.AddApplication(Application _application)
{
DB.Applications.Add(_application);
DB.SaveChanges();
}
private static void updateUserStatus(int id, WorkFlowDbContext db, User u, bool _status)
{
u.Status = _status;
db.Entry(db.Users.Where(x => x.UserId == id).FirstOrDefault()).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}