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);
}
}
