public ActionResult MessageReply(UserRequest userrequest) { userrequest.request_id = userrequest.request_id; userrequest.answer = userrequest.answer; userrequest.answer_user_id = 0; UserRequestAccess userreqAccsss = new UserRequestAccess(); //if autherizer person answered then reply send to relavent user via nortification and email int reslt = userreqAccsss.UpdateUserRequestAnswer(userrequest); if (reslt >= 0) { string body = "Title :" + userrequest.topic+ "< br />" + "Message :" + userrequest.message + "< br />" + "Answer :" + userrequest.answer + "< br />"; Email email = new Email(userrequest.email); email.SendMail(body, "Reply By Dealer Floor Plan Management Software team"); ViewBag.SuccessMsg = "Response will be delivered to your program inbox"; } else { ViewBag.SuccessMsg = "Error Occured"; } //retrieve not answersd list from database List<Models.UserRequest> result = new List<Models.UserRequest>(); UserRequest ob = new UserRequest(); UserRequestAccess userreques = new UserRequestAccess(); result = userreques.SelectDatalistForAnswer(); ob.RequestList = result; return View(ob); }
///<summary> /// Frontend page: Message Reply /// Title: create view and get messages send by users( Page bottom message section) /// Designed : Asanka Senarathna /// User story: /// Developed: Asanka Senarathna /// Date created: 3/30/2016 ///</summary> /// <returns></returns> public ActionResult MessageReply() { List<Models.UserRequest> result = new List<Models.UserRequest>(); UserRequest ob = new UserRequest(); UserRequestAccess userreques = new UserRequestAccess(); //get datalist for need to be answer and loan in view result = userreques.SelectDatalistForAnswer(); ob.RequestList = result; return View(ob); }
public ActionResult UserRequestMessagePost(UserRequest userReq) { //if (this.Session["CaptchaImageText"].ToString() == userReq.captcha) //{ string loancod = ""; string page_nam = ""; userReq.company_id = userData.Company_Id; userReq.branch_id = userData.BranchId; userReq.user_id = userData.UserId; userReq.role_id = userData.RoleId; if (Session["loanCode"] != null) { loancod = Session["loanCode"].ToString(); } if (Session["pagetitle"] != null) { page_nam = Session["pagetitle"].ToString(); } userReq.loan_code = loancod; userReq.page_name = page_nam; userReq.topic = userReq.topic; userReq.message = userReq.message; userReq.priority_level = "high"; UserRequestAccess userreqAccsss = new UserRequestAccess(); int reslt = userreqAccsss.InsertUserRequest(userReq); if (reslt >= 0) { string body = "User Name :" + userData.UserName + "< br />" + "Position :" + (string)Session["searchType"] + "< br />" + "Company :" + userData.CompanyName + "< br />" + "Branch :" + userData.BranchName + "< br />" + "Loan :" + loancod + "< br />" + "Date and Time :" + DateTime.Now + "< br />" + "Title :" + userReq.topic + "< br />" + "Message :" + userReq.message + "< br />" + "Page :" + page_nam + "< br />"; Email email = new Email("*****@*****.**"); email.SendMail(body, "User Request From Dealer Floor Plan Management Software"); ViewBag.SuccessMsg = "Response will be delivered to your program inbox"; return RedirectToAction("UserRequestMessage", "UserManagement"); } else { ViewBag.SuccessMsg = "Error Occured"; return RedirectToAction("UserRequestMessage"); } //} //else { // TempData["message"] = userReq.message; // TempData["topic"] = userReq.message; // return RedirectToAction("UserRequestMessage"); //} }
public ActionResult UserRequestAns(User user) { int currentUserId; try { currentUserId = userData.UserId; UserRequestAccess userRequest = new UserRequestAccess(); userRequest.UpdateUserViewAnswer(currentUserId); return PartialView(); } catch (Exception) { return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." }); } }
public ActionResult UserRequestAns() { List<UserRequest> RequestList = new List<UserRequest>(); try { UserRequestAccess userRequest = new UserRequestAccess(); ViewBag.Anscount = 0; DataSet dataset = userRequest.SelectRequestAns(userData); if (dataset != null && dataset.Tables.Count != 0) { foreach (DataRow dataRow in dataset.Tables[0].Rows) { UserRequest request = new UserRequest(); request.answer = dataRow["answer"].ToString(); request.is_rep_view = bool.Parse(dataRow["is_rep_view"].ToString()); RequestList.Add(request); ViewBag.Anscount = int.Parse(dataRow["Anscount"].ToString()); } var ret= RequestList; return PartialView(ret); } else { return PartialView(); } } catch { return RedirectToAction("UserLogin", "Login"); } }