public ActionResult ManageCompany(string sortOrder, int?page, int?pageSize, string data, string search)
{
int pageDataSize = (pageSize ?? 10);
int pageNumber = (page ?? 1);
ViewBag.CurrentSort = sortOrder;
ViewBag.PageSize = pageDataSize;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "CreatedOn_desc" : "";
Qparams qparams = null;
if (!string.IsNullOrWhiteSpace(data))
{
qparams = Helper.Helper.DecryptParamData <Qparams>(data);
}
TempData.Remove("qparams");
TempData["qparams"] = qparams;
TempData.Keep("qparams");
SearchingParams searchingParams = Helper.Helper.GetParamData <SearchingParams>(search);
var list = _IMasterService.GetCompanyById(0).OrderByDescending(item => item.Id).ToPagedList(pageNumber, pageDataSize);
return(Request.IsAjaxRequest() ? (ActionResult)PartialView("_Companies", list) : View(list));
}
public ActionResult ManageUsers(string sortOrder, int?page, int?pageSize, string data, string search)
{
int pageDataSize = (pageSize ?? 10);
int pageNumber = (page ?? 1);
ViewBag.CurrentSort = sortOrder;
ViewBag.PageSize = pageDataSize;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "CreatedOn_desc" : "";
Qparams qparams = new Qparams();
if (!string.IsNullOrWhiteSpace(data))
{
qparams = Helper.DecryptParamData <Qparams>(data);
}
qparams.UserType = AppConstant.RoleDriver;
TempData.Remove("qparams");
TempData["qparams"] = qparams;
TempData.Keep("qparams");
SearchingParams searchingParams = Helper.GetParamData <SearchingParams>(search);
searchingParams.ReportingTo = Convert.ToInt64(UserAuthenticate.LogId);
if (qparams.AccountStatus != null)
{
searchingParams.AccountStatus = qparams.AccountStatus;
}
searchingParams.UserTypeCode = string.Empty;
searchingParams.LoggedUserTypeCode = UserAuthenticate.Role;
if (!string.IsNullOrWhiteSpace(qparams.UserType))
{
//if (!string.IsNullOrWhiteSpace(qparams.UserType))
//{
// searchingParams.UserTypeCode = qparams.UserType.Trim();
//}
}
else
{
List <UserTypeViewModel> userTypes = GetUserTypes(qparams);
ViewBag.UserTypes = userTypes;
if (searchingParams.UserTypeId == null || searchingParams.UserTypeId?.Count == 0)
{
searchingParams.UserTypeId = userTypes.Select(item => item.Id).ToList();
}
}
var list = _IUserService.GetAllUsers(searchingParams).OrderBy(x => x.FullName).ToPagedList(pageNumber, pageDataSize);
return(Request.IsAjaxRequest() ? (ActionResult)PartialView("_Users", list) : View(list));
}
public JsonResult GetUsersForDropDown(string search)
{
SearchingParams searchingParams = Helper.Helper.GetParamData <SearchingParams>(search);
searchingParams.LoggedUserTypeCode = UserAuthenticate.Role;
if (searchingParams.UserId != null)
{
searchingParams.ReportingTo = Convert.ToInt64(searchingParams.UserId);
}
else
{
searchingParams.ReportingTo = Convert.ToInt64(UserAuthenticate.LogId);
}
var list = _IUserService.GetUsersForDropDown(searchingParams);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUsers(string userId, string userTypeCode)
{
SearchingParams searchingParams = new SearchingParams();
searchingParams.UserTypeCode = userTypeCode;
searchingParams.LoggedUserTypeCode = UserAuthenticate.Role;
if (!string.IsNullOrWhiteSpace(userId))
{
searchingParams.ReportingTo = Convert.ToInt64(userId);
}
else
{
searchingParams.ReportingTo = Convert.ToInt64(UserAuthenticate.LogId);
}
var list = _IUserService.GetUsersForDropDown(searchingParams);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult SendMailAllDriver(string message)
{
string mailBody = string.Empty;
List <UserViewModel> driverList = new List <UserViewModel>();
SearchingParams searchingParams = new SearchingParams();
searchingParams.LoggedUserTypeCode = UserAuthenticate.Role;
searchingParams.UserTypeCode = AppConstant.RoleDriver;
//if (!string.IsNullOrWhiteSpace(userId))
// searchingParams.ReportingTo = Convert.ToInt64(userId);
//else
searchingParams.ReportingTo = Convert.ToInt64(UserAuthenticate.LogId);
driverList = _IUserService.GetAllUsers(searchingParams);
foreach (UserViewModel driver in driverList)
{
driver.Message = message;
mailBody = RenderPartialToString("_NotifyToAllDriver", driver, ControllerContext);
_IMasterService.SendAccountCreatationEmail("Driver Alert", mailBody, driver, Convert.ToInt64(UserAuthenticate.LogId));
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public List <UserViewModel> GetAllUsers(SearchingParams searchingParams)
{
List <UserViewModel> entities = new List <UserViewModel>();
// making values as trim
searchingParams.Name = searchingParams.Name?.Trim();
searchingParams.UserTypeCode = searchingParams.UserTypeCode?.Trim();
searchingParams.Email = searchingParams.Email?.Trim();
string userTypeIds = string.Empty;
long? userTypeId = null;
if (!string.IsNullOrWhiteSpace(searchingParams.UserTypeCode))
{
userTypeId = _Context.UserTypes.Where(item => item.Code == searchingParams.UserTypeCode).Select(item => item.Id).SingleOrDefault();
userTypeIds = Convert.ToString(userTypeId);
}
if (string.IsNullOrWhiteSpace(userTypeIds) && searchingParams.UserTypeId != null && searchingParams.UserTypeId?.Count > 0)
{
userTypeIds = String.Join(",", searchingParams.UserTypeId);
}
var userFilter = new DataTable();
userFilter.Columns.AddRange(new DataColumn[]
{
new DataColumn("Id", System.Type.GetType("System.Int64")),
new DataColumn("UserTypeId", System.Type.GetType("System.String")),
new DataColumn("Name", System.Type.GetType("System.String")),
new DataColumn("Email", System.Type.GetType("System.String")),
new DataColumn("WorkPhone", System.Type.GetType("System.String")),
new DataColumn("Gender", System.Type.GetType("System.Int32")),
new DataColumn("AccountStatus", System.Type.GetType("System.Int32")),
new DataColumn("AssignedRegionId", System.Type.GetType("System.Int64")),
new DataColumn("Createdby", System.Type.GetType("System.Int64")),
new DataColumn("UserTypeCode", System.Type.GetType("System.String"))
});
// adding some data in datatable
userFilter.Rows.Add(
searchingParams.Createdby ?? searchingParams.ReportingTo,
userTypeIds,
searchingParams.Name,
searchingParams.Email,
null,
null,
searchingParams.AccountStatus,
null,
searchingParams.Createdby,
searchingParams.LoggedUserTypeCode
);
var tblParam = new SqlParameter("@userFilters", SqlDbType.Structured);
tblParam.Value = userFilter;
tblParam.TypeName = "[dbo].[UserFilter]";
var list = _Context.Database.SqlQuery <UserViewModel>("exec [dbo].[spGetUsers] @userFilters", tblParam).ToList();
Mapper.Map(list, entities);
List <UserTypeViewModel> userTypes = GetUserTypes();
entities.ForEach(item => item.UserTypeName = userTypes.Where(usertype => usertype.Id == item.UserTypeId).Select(usertype => usertype.Name).SingleOrDefault());
return(entities);
}
