public ActionResult getdata()
{
try
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
var listvalue = (from q in entities.questiontbls select q).ToList();
List <Questionmodel> questions = new List <Questionmodel>();
foreach (var item in listvalue)
{
Questionmodel question = new Questionmodel();
question.q_id = item.q_id;
question.questions = item.question;
questions.Add(question);
}
// List<questiontbl> listvalue = entities.questiontbls.ToList<questiontbl>();
return(Json(new { data = questions }, JsonRequestBehavior.AllowGet));
}
}catch (Exception ex)
{
throw;
}
}
public ActionResult Index(FormCollection form)
{
//int va = valueid;
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
string[] questions = Request.Form.GetValues("questionid");
int userid = Convert.ToInt32(Session["isuserId"]);
int roleno = Convert.ToInt32(Session["RoleID"]);
//List<Submitsurvey> submitsurveys = new List<Submitsurvey>();
foreach (var question in questions)
{
String rat = Request.Form.Get("rank+" + question);
String comment = Request.Form.Get("comment+" + question);
String surveryid = Request.Form.Get("surveryid+" + question);
Submitsurvey submitsurvey = new Submitsurvey();
submitsurvey.rating = Convert.ToInt32(rat);
submitsurvey.comment = comment;
submitsurvey.sur_id = Convert.ToInt32(surveryid);
submitsurvey.u_id = userid;
submitsurvey.role_id = roleno;
submitsurvey.sq_id = Convert.ToInt32(question);
entities.Submitsurveys.Add(submitsurvey);
entities.SaveChanges();
}
}
// string[] value = Request.Form.GetValues("Country");
return(RedirectToAction("Index", "Rating"));
}
public UserDisplayViewModel isdetail(int isuservalue)
{
// int isuservalue = isUserAvailable(Objlogin);
// List<UserDisplayViewModel> UD = new List<UserDisplayViewModel>();
UserDisplayViewModel userdep = new UserDisplayViewModel();
try
{
using (var entity = new HapinessSurveyEntities())
{
var UDlist = (from u in entity.UserTbls
join d in entity.departmenttbls
on u.Dep_id equals d.dep_id
where u.user_id == isuservalue
select new
{
u.user_name,
d.dep_name
}).ToList();
foreach (var listud in UDlist)
{
userdep.user_name = listud.user_name;
userdep.dep_name = listud.dep_name;
//UD.Add(userdep);
}
}
}
catch (Exception ex)
{
}
return(userdep);
}
public int isUserAvailable(Loginmodel Objlogin)
{
//user avaliable return user id
// bool isusermatch = false;
try
{
using (var entity = new HapinessSurveyEntities())
{
// var obj = from u in entity.UserTbls where u.user_mail = Objlogin.user_mail && u.user_Pass = Objlogin.user_pass select u.
var obj = entity.UserTbls.Where(a => a.user_mail.Equals(Objlogin.user_mail) && a.user_Pass.Equals(Objlogin.user_pass)).FirstOrDefault();
if (obj != null)
{
isuservalue = obj.user_id;
// isusermatch = true;
}
else
{
isuservalue = 0;
// isusermatch = false;
}
}
}
catch (Exception ex)
{
}
// return isusermatch;
return(isuservalue);
}
public static List <SelectListItem> getusers(int dep_id)
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
List <SelectListItem> userlist = (from u in entities.UserTbls
join d in entities.departmenttbls.AsEnumerable() on u.Dep_id equals d.dep_id
select new SelectListItem {
Text = u.user_name, Value = u.user_id.ToString()
}).ToList();
userlist.Insert(0, new SelectListItem {
Text = "--Select User--", Value = "0"
});
return(userlist);
}
}
// GET: Rating
public ActionResult Index()
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
if (Session["RoleID"] == null)
{
return(RedirectToAction("Login", "Home"));
}
int id = Convert.ToInt32(Session["isuserId"]);
//select sq.sq_id,q.question,us.sur_id from questiontbl as q
// inner join surveyquestion as sq on sq.q_id = q.q_id
// full join userSurvey as us on sq.sur_id = us.sur_id
// where us.user_id = 7
var list = (from q in entities.questiontbls
join qs in entities.surveyquestions on q.q_id equals qs.q_id
join us in entities.userSurveys on qs.sur_id equals us.sur_id
where us.user_id == id
select new
{
qs.sq_id,
q.question,
q.q_id,
us.sur_id
}).ToList();
List <Ratingmodel> questionmodelList = new List <Ratingmodel>();
foreach (var l in list)
{
Ratingmodel questionmodel = new Ratingmodel();
questionmodel.sur_id = l.sur_id;
questionmodel.sq_id = l.sq_id;
questionmodel.ques = l.question;
questionmodelList.Add(questionmodel);
}
return(View(questionmodelList));
// return View();
}
}
public ActionResult ForgetPass(FormCollection form)
{
using (HapinessSurveyEntities db = new HapinessSurveyEntities())
{
try
{
string ml = Request.Form["EmailID"].ToString();
var pas = (from m in db.UserTbls where m.user_mail == ml select m.user_Pass).FirstOrDefault();
EmailOperation.SendEmail(ml, "Forget Password", "Happiness Password is = " + pas);
ViewBag.messge = "mail sended";
}
catch (Exception ex)
{
return(View("ForgetPass"));
}
return(View("Login"));
}
}
private static List <SelectListItem> Getproject()
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
List <SelectListItem> projectList = (from p in entities.projecttbls.AsEnumerable()
select new SelectListItem
{
Text = p.pro_name.ToString(),
Value = p.pro_id.ToString()
}).ToList();
//Add Default Item at First Position.
projectList.Insert(0, new SelectListItem {
Text = "--Select Project--", Value = "0"
});
return(projectList);
}
}
private static List <SelectListItem> Getrole()
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
List <SelectListItem> roleList = (from p in entities.roletbls.AsEnumerable().Where(p => p.role_id > 3)
select new SelectListItem
{
Text = p.role_name.ToString(),
Value = p.role_id.ToString()
}).ToList();
//Add Default Item at First Position.
roleList.Insert(0, new SelectListItem {
Text = "--Select Role--", Value = "0"
});
return(roleList);
}
}
public ActionResult Edit(Questionmodel questionmodel)
{
try
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
var modiques = entities.questiontbls.Where(a => a.q_id.Equals(questionmodel.q_id)).First();
// questionmodel.q_id = modiques.q_id;
// List < Questionmodel > qlist = new List<Questionmodel>();
modiques.question = questionmodel.questions;
entities.SaveChanges();
return(View("question"));
}
}
catch (Exception)
{
throw;
}
//eturn View("Edit", questionmodel);
}
public ActionResult Edit(int?ID)
{
try
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
Questionmodel questionmodel = new Questionmodel();
List <Questionmodel> qlist = new List <Questionmodel>();
var question = (from q in entities.questiontbls
where q.q_id == ID
select q).FirstOrDefault();
questionmodel.q_id = question.q_id;
questionmodel.questions = question.question;
return(View("Edit", questionmodel));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Create(Questionmodel questionmodel)
{
try
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
//var addques = entities.questiontbls.Where(a => a.q_id.Equals(questionmodel.q_id)).First();
questiontbl ques = new questiontbl();
// List < Questionmodel > qlist = new List<Questionmodel>();
ques.question = questionmodel.questions;
entities.questiontbls.Add(ques);
entities.SaveChanges();
return(View("question"));
}
}
catch (Exception)
{
throw;
}
// return View("Edit");
}
public JsonResult delete(int?id)
{
try
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
if (id == null)
{
return(Json(new { data = "Not Deleted" }, JsonRequestBehavior.AllowGet));
}
var deleteques = entities.questiontbls.Find(id);
entities.questiontbls.Remove(deleteques);
entities.SaveChanges();
return(Json(new { data = "Delete" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
throw;
}
}
// GET: Survey
public ActionResult Index()
{
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
if (Session["RoleID"] == null)
{
RedirectToAction("Login", "Home");
}
int rid = Convert.ToInt32(Session["RoleID"]);
if (rid == 4)
{
}
if (rid == 5)
{
}
if (rid == 6)
{
}
}
return(View());
}
// GET: GenerateSurvey
public ActionResult Index()
{
if (Session["RoleID"] == null)
{
return(RedirectToAction("Login", "Home"));
}
List <SelectListItem> items = new List <SelectListItem>();
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
//var depdata = new SelectList(entities.departmenttbls.ToList(),"dep_id","dep_name").to;
//List < SelectListItem > departmentlist = Getdepartment();
// ViewData["Department"] = departmentlist;
// var prodata = new SelectList(entities.projecttbls.ToList(), "pro_id", "pro_name");
List <SelectListItem> projectlist = Getproject();
ViewData["Project"] = projectlist;
// var roledata = new SelectList(entities.roletbls.ToList(), "role_id", "role_name");
List <SelectListItem> rolelist = Getrole();
ViewData["Role"] = rolelist;
var qlist = from q in entities.questiontbls select new { q.q_id, q.question };
foreach (var v in qlist)
{
items.Add(new SelectListItem
{
Value = v.q_id.ToString(),
Text = v.question.ToString()
});
}
}
return(View("Questionlist", items));
}
public int isUserRoleID(Loginmodel Objlogin)
{
//get Roll iD for controller dashboard
var role = 0; var roleid = 0;
try {
using (var entity = new HapinessSurveyEntities())
{
teamtbl teamobj = new teamtbl();
role = (int)entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).LongCount();
if (role == 1)
{
roleid = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).FirstOrDefault();
//if assign any one role.
}
else if (role == 0)
{
roleid = role;
//if not assign any role
}
else if (role == 2)
{
//if teamlead and teammember role
// var roleid1 = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).ToList();
// roleid = roleid1.Min();
roleid = 6;
// roleid = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).Min();
}
}
}
catch (Exception ex)
{
}
return(roleid);
}
public ActionResult Index(List <SelectListItem> items, FormCollection form)
{
// string ddldep =Request.Form["Departmentddl"].ToString();
string ddlproj = Request.Form["Projectddl"].ToString();
string ddlrole = Request.Form["Roleddl"].ToString();
using (HapinessSurveyEntities entities = new HapinessSurveyEntities())
{
int id, ids;
var surveyCre = new surveytbl();
{
surveyCre.role_id = Convert.ToInt32(ddlrole);
surveyCre.Start_date = DateTime.Today;
surveyCre.End_date = DateTime.Today.Date.AddDays(3);
surveyCre.proj_id = Convert.ToInt32(ddlproj);
surveyCre.Dep_id = 0;
entities.surveytbls.Add(surveyCre);
entities.SaveChanges();
ids = surveyCre.sur_id;
entities.SaveChanges();
}
// ViewBag.Message = "Selected Items:\\n";
foreach (SelectListItem item in items)
{
if (item.Selected)
{
try
{
//surveyCre.role_id = 1;
//surveyCre.Start_date = DateTime.Today.Date;
//surveyCre.End_date = DateTime.Today.Date.AddDays(3);
//surveyCre.proj_id = 1;
//surveyCre.Dep_id = 1;
//entities.surveytbls.Add(surveyCre);
//entities.SaveChanges();
//ids = surveyCre.sur_id;
if (ids != 0)
{
surveyquestion surveyq = new surveyquestion();
{
// var surcreid = (from q in entities.surveytbls select q.sur_id).FirstOrDefault();
surveyq.sur_id = ids;
surveyq.q_id = Convert.ToInt32(item.Value);
entities.surveyquestions.Add(surveyq);
entities.SaveChanges();
// id = surveyq.sq_id;
}
}
}
catch (Exception ex)
{
}
// ViewBag.Message += string.Format("{0}\\n", item.Text);
}
else
{
ViewBag.Message = "Select Question";
}
}
int pid = Convert.ToInt32(ddlproj);
int rid = Convert.ToInt32(ddlrole);
if (rid != 0)
{
var listusers = (from t in entities.teamtbls where t.pro_id == pid && t.role_id == rid select new { t.user_id }).ToList();
userSurvey surveyusers = new userSurvey();
foreach (var l in listusers)
{
surveyusers.user_id = l.user_id;
surveyusers.sur_id = ids;
surveyusers.Active = true;
entities.userSurveys.Add(surveyusers);
entities.SaveChanges();
}
}
else
{
var listusers = (from t in entities.teamtbls where t.pro_id == pid select new { t.user_id }).ToList();
userSurvey surveyusers = new userSurvey();
foreach (var l in listusers)
{
surveyusers.user_id = l.user_id;
surveyusers.sur_id = ids;
surveyusers.Active = true;
entities.userSurveys.Add(surveyusers);
entities.SaveChanges();
}
}
}
return(RedirectToAction("Dashboard", "Home"));
}
