public ActionResult AssignTelephone() { string baNumber = Request["baNumber"].ToString(); string name = Request["name"].ToString(); string rank = Request["rank"].ToString(); string telephoneNumber = Request["telephoneNumber"].ToString(); string address = Request["address"].ToString(); string sex = string.Empty; if (Request["sex"] != null) { sex = Request["sex"].ToString(); } if (baNumber.Trim().Length == 0 || name.Trim().Length == 0 || rank.Trim().Length == 0 || telephoneNumber.Trim().Length == 0 || address.Trim().Length == 0 || sex.Trim().Length == 0) { ViewData["Message"] = "Error! Fields can not left blank"; return View("AddTelephone"); } string outputMessage = string.Empty; Telephone aTelephone = new Telephone(); bool success = aTelephone.AssignNewTelephone(baNumber, name, rank, telephoneNumber, address, sex, out outputMessage); if (!success) { ViewData["Message"] = outputMessage; return View("AddTelephone"); } ViewData["Message"] = "Telephone User Successfully Added"; return View("AddTelephone"); }
public JsonResult TelephoneDataProviderAction(JQueryDataTableParamModel aModel) { List<string> columnlist = new List<string>(new string[] { "BANumber", "Name", "Rank", "NewPhoneNumber", "Address", "Gender", "Status", "ConnectedDate", "DisconnectedDate" }); string serachValue = Request["columns[0][search][value]"]; var roleId = Request.Params["max"]; var banumberFilter = Convert.ToString(Request["sSearch_0"]).Trim(); var nameFilter = Convert.ToString(Request["sSearch_1"]).Trim(); var rankFilter = Convert.ToString(Request["sSearch_2"]).Trim(); var phoneFilter = Convert.ToString(Request["sSearch_3"]).Trim(); // var addressFilter = Convert.ToString(Request["sSearch_4"]).Trim(); var phoneTypeFilter = Convert.ToString(Request["sSearch_4"]).Trim(); var homeAddressFilter = Convert.ToString(Request["sSearch_5"]).Trim(); var officeAddressFilter = Convert.ToString(Request["sSearch_6"]); var genderFilter = Convert.ToString(Request["sSearch_7"]); var complainFilter = Convert.ToString(Request["sSearch_5"]); var hourlyFilter = Convert.ToString(Request["sSearch_8"]); var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]); DateTime fromDate = DateTime.MinValue; DateTime toDate = DateTime.MaxValue; if (hourlyFilter.Contains("-yadcf_delim-")) { string a1 = hourlyFilter.Replace("-yadcf_delim-", "~"); //Split date range filters with ~ fromDate = a1.Split('~')[0] == "" ? DateTime.MinValue : Convert.ToDateTime(a1.Split('~')[0]); toDate = a1.Split('~')[1] == "" ? DateTime.MaxValue : Convert.ToDateTime(a1.Split('~')[1]).AddHours(23.99); } string sSearch = string.Empty; if (aModel.sSearch == null) { sSearch = ""; } else { sSearch = aModel.sSearch.ToString(); } var banameSortDirection = Request["sSortDir_0"]; TelphoneUser aTelephoneUser = new TelphoneUser(); // List<TelphoneUser> aUsersList = aTelephoneUser.GetTelphoneUsers(); Telephone aTelephone = new Telephone(); FilteredLists filterTelphoneUsers = aTelephone.GetFilteredPhoneList(sSearch, banumberFilter, phoneFilter, nameFilter, rankFilter, homeAddressFilter, officeAddressFilter, phoneTypeFilter, genderFilter, fromDate, toDate, aModel.iDisplayStart, aModel.iDisplayLength, aModel.sSortDir_0, aModel.iSortCol_0); var result = from c in filterTelphoneUsers.aTelePhoneUserList select new[] { c.BANumber, c.Name, c.Rank, c.NewPhoneNumber, c.PhoneType, c.HomeAddress, c.OfficeAddress, c.Gender, c.ConnectedDate, "Edit", Convert.ToString(c.ID) }; List<string[]> resultList = result.ToList(); List<string> aRankList = new List<string>(); List<string> banumberList = new List<string>(); List<string> complainTypeList = new List<string>(); List<string> statusList=new List<string>(); return Json(new { sEcho = aModel.sEcho, yadcf_data_0 = filterTelphoneUsers.BaNumberList, yadcf_data_2 = filterTelphoneUsers.RankList, yadcf_data_4 = filterTelphoneUsers.PhoneTypeList, // yadcf_data_6 = statusList, iTotalRecords = filterTelphoneUsers.TotalSize, iTotalDisplayRecords = filterTelphoneUsers.FilteredSize, aaData = resultList }, JsonRequestBehavior.AllowGet); }
public ActionResult SubmitComplains() { string phoneUserInfoId = Request["phoneUserInfoId"].ToString(); string allPhoneInfoID = Request["allPhoneInfoID"].ToString(); string complainTypeId = Request["type"].ToString(); string description = Request["description"].ToString(); Telephone aTelephone = new Telephone(); bool success = aTelephone.SubmitNewComplain(phoneUserInfoId, allPhoneInfoID, description, complainTypeId); ViewData["Message"] = "Submitted Complains"; return View("NewComplain"); }
public ActionResult SearchResolvedComplains() { string phoneNumber = Request["search"].ToString(); Telephone telephone = new Telephone(); List<Dictionary<string, string>> resolved = new List<Dictionary<string, string>>(); resolved = telephone.GetResolvedComplainsByPhoneNumber(phoneNumber); ViewData["Resolved"] = resolved; return View("ResolvedComplains"); }
public ActionResult SearchActiveTelephoneInfo() { string telephoneNumber = Request["search"].ToString(); Telephone telephone = new Telephone(); Dictionary<string, string> userInfo = telephone.GetUserInfo(telephoneNumber); if (userInfo.Count == 0) { ViewData["Message"] = "Error! Telephone Number Not in use...."; return View("NewComplain"); } ViewData["AllPhoneInfoID"] = userInfo["AllPhoneInfoID"]; ViewData["PhoneNumber"] = userInfo["PhoneNumber"]; ViewData["BANumber"] = userInfo["BANumber"]; ViewData["FullName"] = userInfo["FullName"]; ViewData["PhoneUserPersoanlInfoID"] = userInfo["PhoneUserPersoanlInfoID"]; ViewData["Rank"] = userInfo["Rank"]; ViewData["Address"] = userInfo["Address"]; ViewData["Message"] = "Searched Result"; return View("NewComplain"); }
public ActionResult ResolvedComplains() { Telephone telephone = new Telephone(); List<Dictionary<string, string>> resolved = new List<Dictionary<string, string>>(); resolved = telephone.GetResolvedComplains(); ViewData["Resolved"] = resolved; return View(); }
public static void EditComplain(TelephoneComplain aTelephoneComplain, string updateQuery) { string complainStatus; DBGateway aGateway = new DBGateway(); if (aTelephoneComplain.Status == "0") { complainStatus = "Pending"; updateQuery = "UPDATE `signalappdb`.`complains` SET `Description`='" + aTelephoneComplain.Description + "', `Status`='" + complainStatus + "', `MenuComplainTypeId`=" + aTelephoneComplain.ComplainType + " WHERE `Id`=" + aTelephoneComplain.ComplainId + ";"; string updateResult = aGateway.Update(updateQuery); } else if (aTelephoneComplain.Status == "1") { Telephone aTelephone = new Telephone(); string convertedDateText = aTelephone.DMYToMDY(aTelephoneComplain.ResolvedDate); DateTime dt = DateTime.Parse(convertedDateText); string userName = UtilityLibrary.GetUserId(); complainStatus = "Resolved"; updateQuery = "UPDATE `signalappdb`.`complains` SET `Description`='" + aTelephoneComplain.Description + "', `Status`='" + complainStatus + "', `Remarks`='" + aTelephoneComplain.Remarks + "', `MenuComplainTypeId`=" + aTelephoneComplain.ComplainType + ", `ResolvedDate`='" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "', `ActionTaken`='" + aTelephoneComplain.ActionTaken + "', `ResolvedBy`='" + userName + "' WHERE `Id`=" + aTelephoneComplain.ComplainId + ";"; //string insertQuery = "INSERT INTO `signalappdb`.`resolvedcomplains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`, `ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`, `AllPhoneInfoID`) VALUES ('"+aTelephoneComplain.Description+"', 'resolved', "+aTelephoneComplain.ProblemTypes+", (select ), '2015-12-17 23:07:26', '2015-12-19 23:07:26', 'o', 'dd', 'maruf', 10);"; string insertQuery = "INSERT INTO `signalappdb`.`resolvedcomplains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`,`AllPhoneInfoID`,`ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`) select description,status, MenuComplainTypeId,TelephoneUserId,AllPhoneInfoID,ComplainDate,'" +dt.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + aTelephoneComplain.Remarks + "', '" + aTelephoneComplain.ActionTaken + "', '" + aTelephoneComplain.ResolveBy + "' from complains WHERE ID=" + aTelephoneComplain.ComplainId + ";"; int insertCount = aGateway.Insert(insertQuery); string deleteQuery = "Delete From Complains where id=" + aTelephoneComplain.ComplainId + ""; string delMsg = aGateway.Delete(deleteQuery); } }