public List <Group> getGroupID(int?pid)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var result = from t in db.Groups where t.IsActive == true && t.ProjectID == pid select t;
return(result.ToList());
}
public ActionResult ViewRoles()
{
var isReporting = (bool)Session["IsRerportingPerson"];
ModelState.Clear();
int userId = int.Parse(Session["UserID"].ToString());
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage();
List <Manage> RoleValue = new List <Manage>();
var RoleName = MasterEnum.NewuserRole.NewEmployeeRole;
ViewBag.RoleName = RoleName;
var RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == RoleName).RoleID;
RoleValue = (from p in db.Master_Roles
where (p.IsActive == true)
select new Manage()
{
RoleID = p.RoleID,
RoleName = p.RoleName
}).ToList();
return(View(RoleValue));
}
public ActionResult ViewRoles(FormCollection form)
{
List <Manage> RoleValue = new List <Manage>();
if (ModelState.IsValid)
{
var isReporting = (bool)Session["IsRerportingPerson"];
int userId = int.Parse(Session["UserID"].ToString());
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
bool status = form["Inactive"].Contains("true");
DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage();
if (Convert.ToInt32(Session["RoleID"]) == 59)
{
RoleValue = (from p in db.Master_Roles
select new Manage()
{
RoleID = p.RoleID,
RoleName = p.RoleName
}).ToList();
}
RoleValue = RoleValue.Distinct().ToList();
return(View(RoleValue));
}
else
{
DSRCManagementSystem.Models.Manage obj = new DSRCManagementSystem.Models.Manage();
return(View(RoleValue));
}
}
public ActionResult GetDepartments(int BranchId)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
IEnumerable <SelectListItem> FilterDepart = new List <SelectListItem>();
try
{
if (BranchId != 0)
{
List <int> validDepart = new List <int>();
validDepart = db.Departments.Where(d => d.BranchID == BranchId && d.IsActive == true).Select(d => d.DepartmentId).ToList();
FilterDepart = (from lt in db.Departments.Where(o => validDepart.Contains(o.DepartmentId))
select new FilterDepartment()
{
DepartmentId = lt.DepartmentId,
DepartmentName = lt.DepartmentName
}).AsEnumerable().Select(m => new SelectListItem()
{
Value = Convert.ToString(m.DepartmentId), Text = m.DepartmentName
});
}
return(Json(new SelectList(FilterDepart, "Value", "Text"), JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View());
}
public ActionResult AssignRole()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var userId = (int)Session["UserId"];
return(View());
}
public string SaveApplicationSetting(EmailConfigure data)
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var Host = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Host Name");
Host.AppValue = data.Host;
var Port = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Port");
Port.AppValue = data.Port.ToString();
var UserName = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "UserName");
UserName.AppValue = data.UserName.Trim();
var Password = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "Password");
Password.AppValue = data.Password;
var From = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "From");
From.AppValue = data.From.Trim();
var To = db.Master_ApplicationSettings.FirstOrDefault(o => o.AppKey == "To");
To.AppValue = data.To.Trim();
db.SaveChanges();
return("success");
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
return("failed");
}
}
public ActionResult ManageRoll()
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var rolldetails = (from u in db.CustomReports
where u.IsActive == true
select new ReportMOD()
{
ReportID = u.ReportID,
Name = u.ReportName,
Description = u.ReportDescription,
sp = u.ReportQuery
}).ToList();
return(View(rolldetails));
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
return(Json("Failed", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetProjectMembers(int id)
{
try
{
var EmployeeList = new List <SelectListItem>();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var Employees = (from a in db.UserProjects
where a.ProjectID == id
join b in db.Users
on a.UserID equals b.UserID
select new
{
EmployeeId = b.UserID,
EmployeeName = (b.FirstName + " " + (b.LastName ?? "")).Trim()
}).ToList();
foreach (var item in Employees)
{
EmployeeList.Add(new SelectListItem {
Text = item.EmployeeName, Value = item.EmployeeId.ToString()
});
}
}
return(Json(EmployeeList, JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
throw Ex;
}
}
private List <SelectListItem> GetRoles()
{
try
{
var RoleList = new List <SelectListItem>(new[] { new SelectListItem {
Text = "---Select---", Value = "0"
} });
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
List <RoleType> Names = (from data in db.Master_Roles
select new RoleType
{
RoleID = data.RoleID,
RoleName = data.RoleName,
}).ToList();
foreach (var item in Names)
{
RoleList.Add(new SelectListItem {
Text = item.RoleName, Value = item.RoleID.ToString()
});
}
}
return(RoleList);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EmployeeTimeSheet(EmployeeTimeSheet model)
{
var selectedtimeSheetData = new List <SelectedTimeSheet>();
try
{
//int uid = int.Parse(Session["UserID"].ToString());
int pid = Convert.ToInt32(model.ProjectName);
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
selectedtimeSheetData = (from data in dbHrms.TimesheetDatas
join
userdata in dbHrms.Users on data.UserID equals userdata.UserID
join
projectdata in dbHrms.Projects on data.ProjectID equals projectdata.ProjectID
where data.UserID == model.EmployeeId && data.ProjectID == pid && EntityFunctions.TruncateTime(data.DateOFSheet) >= model.StartDate && EntityFunctions.TruncateTime(data.DateOFSheet) <= model.EndDate
select new SelectedTimeSheet()
{
EmployeeName = ((userdata.FirstName) + " " + (userdata.LastName ?? "")).Trim(),
ProjectName = projectdata.ProjectName,
Date = data.DateOFSheet,
ProjectId = data.ProjectID,
UserId = data.UserID
}).ToList();
return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet));
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewTimeSheetValues(string Value)
{
bool?type = null;
var json_serializer = new JavaScriptSerializer();
SelectedTimeSheet val = json_serializer.Deserialize <SelectedTimeSheet>(Value);
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
type = (from t in db.TimesheetTypes where t.ProjectID == val.ProjectId select t.IsGrouped).SingleOrDefault();
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
if (type.Value)
{
return(RedirectToAction("ViewGroupedtimeSheet", new { ProjectId = val.ProjectId, Date = val.Date }));
}
else
{
return(RedirectToAction("ViewNonGroupedtimeSheet", new { ProjectId = val.ProjectId, Date = val.Date }));
}
}
public ActionResult CalculateAggregate(int TrainingID)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int?Id = TrainingID;
db.Sp_FeedbackCalculation(Id);
var AggreList = (from fa in db.TrainingFeedbackAggregates
join tfc in db.TrainingFeedBackCalcs on fa.TrainingId equals tfc.TrainingId
where fa.TrainingId == TrainingID
select new FeedbackAggregareModel
{
ContentRating = fa.ContentRating,
PresentRating = fa.PresentRating,
FacultyRating = fa.FacultyQRating,
OverallRating = fa.OverAllRating,
learntinprog = tfc.LearntInPgm
}).FirstOrDefault();
//AggreList.Comments = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID).Select(o => o.Comments).ToList();
AggreList.Comments = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID && x.Comments != "Not given yet ").Select(o => o.Comments).ToList();
AggreList.Learn = db.TrainingFeedBackCalcs.Where(x => x.TrainingId == TrainingID && x.LearntInPgm != "Not given yet ").Select(o => o.LearntInPgm).ToList();
return(View(AggreList));
}
public ActionResult Edit(int TrainingID)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DateTime myDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
var obj = (from rc in db.Trainings
where rc.IsActive == true && rc.TrainingId == TrainingID
join l in db.Master_TrainingLevel on rc.LevelId equals l.LevelId
join t in db.Master_TrainingTechnology on rc.TechnologyId equals t.TechnologyId
join s in db.Master_TrainingStatus on rc.StatusId equals s.StatusId
join i in db.Users on rc.InstructorId equals i.UserID
select new ManageTrainingModel()
{
TrainingID = rc.TrainingId,
SeatingCapacity = rc.SeatingCapacity,
ScheduledDate = rc.ScheduledDate,
Starttime = rc.StartTime,
TrainingName = rc.TrainingName,
Technology = t.TechnologyName,
Level = l.LevelName,
Instructor = ((i.FirstName.Length > 0 ? i.FirstName : "") + " " + (i.LastName.Length > 0 ? i.LastName : "")),
Nominations = rc.NumberOfNominated,
StatusID = rc.StatusId,
Status = s.StatusName,
Endtime = rc.EndTime,
IsToday = (rc.ScheduledDate <= myDate) ? true : false,
MailDepartments = rc.MailDepartments,
NotifyUsers = rc.NotifyUsers
}).OrderByDescending(o => o.ScheduledDate.Value.Year).ThenByDescending(o => o.ScheduledDate.Value.Month).ThenByDescending(o => o.ScheduledDate.Value.Day).FirstOrDefault();
return(View(obj));
}
public List <Master_ColumnTypes> getColumnTypeID()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var result = from t in db.Master_ColumnTypes select t;
return(result.ToList());
}
public static List <TeamMember> GetTeamMemberList(int UserId)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int BranchId = (int)db.Users.FirstOrDefault(o => o.UserID == UserId).BranchId;
List <TeamMember> memberList = new List <TeamMember>();
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
memberList = (from usr_ropt in dbHrms.UserReportings
join
usr in dbHrms.Users.Where(o => o.IsActive != false) on usr_ropt.UserID equals usr.UserID
where usr_ropt.ReportingUserID == UserId && usr_ropt.UserID != UserId && usr.BranchId == BranchId
select new TeamMember()
{
MemberId = usr.EmpID,
MemberName = ((usr.FirstName + " " + usr.LastName) ?? "").Trim() // added on 9/12
}).Where(usr => usr.MemberName != null && usr.MemberName != "").OrderBy(o => o.MemberName).ToList();
memberList.Insert(0, new TeamMember()
{
MemberId = "0",
MemberName = "All"
}
);
return(memberList);
}
}
public static List <MenuList> GetMenuList()
{
List <DSRCManagementSystem.Models.MenuList> menulist = new List <DSRCManagementSystem.Models.MenuList>();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
//menulist = (from function_module in db.FunctionModules
// join modules in db.Modules on function_module.PageModuleID equals modules.PageModuleID
// select new DSRCManagementSystem.Models.MenuList
// {
// FunctionId = function_module.FunctionID,
// PageModuleId = function_module.PageModuleID,
// ModuleName = modules.ModuleName
// }).OrderBy(x => x.FunctionId).ToList();
menulist = (from function_module in db.FunctionModules
join modules in db.Modules on function_module.PageModuleID equals modules.PageModuleID
join defaultmodulesceorder in db.DefaultModulePrecedanceOrders on modules.PageModuleID equals defaultmodulesceorder.PageModuleID
where modules.IsActive == true
orderby defaultmodulesceorder.PreceedanceOrder ascending
select new DSRCManagementSystem.Models.MenuList
{
FunctionId = function_module.FunctionID,
PageModuleId = function_module.PageModuleID,
ModuleName = modules.ModuleName
}).ToList();
}
return(menulist);
}
public ActionResult SendMail()
{
EmailConfigure MailObj = new EmailConfigure();
try{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var AppSettings = db.Master_ApplicationSettings.Select(o => o).ToList();
MailObj.Host = AppSettings.FirstOrDefault(o => o.AppKey == "Host Name").AppValue;
MailObj.Port = Convert.ToInt32(AppSettings.FirstOrDefault(o => o.AppKey == "Port").AppValue);
MailObj.UserName = AppSettings.FirstOrDefault(o => o.AppKey == "UserName").AppValue;
MailObj.Password = AppSettings.FirstOrDefault(o => o.AppKey == "Password").AppValue;
MailObj.ConfirmPassword = AppSettings.FirstOrDefault(o => o.AppKey == "Password").AppValue;
MailObj.From = AppSettings.FirstOrDefault(o => o.AppKey == "From").AppValue;
MailObj.To = AppSettings.FirstOrDefault(o => o.AppKey == "To").AppValue;
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(MailObj));
}
public ActionResult AddExpenditure()
{
List <DSRCManagementSystem.Models.Expenditure> UserList = new List <DSRCManagementSystem.Models.Expenditure>();
try
{
int ExpenditureId = Convert.ToInt32(Session["ExpenditureID"]);
ModelState.Clear();
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Expenditure objUser = new DSRCManagementSystem.Models.Expenditure();
UserList = (from u in db.Expenditures.Where(o => o.IsActive != false)
select new DSRCManagementSystem.Models.Expenditure()
{
ExpenditureID = u.ExpenseID,
ExpenseDescription = u.ExpenseDescription,
ExpenseDate = u.ExpenseDate,
ExpenseAmount = u.ExpenseAmount,
IsActive = u.IsActive,
CreatedAt = u.CreatedAt,
}).OrderByDescending(o => o.ExpenseDate.Value.Year)
.ThenByDescending(o => o.ExpenseDate.Value.Month)
.ThenByDescending(o => o.ExpenseDate.Value.Day)
.ToList();
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(UserList));
}
public ActionResult ChangeColor(string ColorId)
{
int ID = 0;
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
try
{
if (ColorId == "")
{
ID = 1;
}
else
{
ID = Convert.ToInt32(ColorId);
}
var Themecolor = objdb.Master_ApplicationSettings.Where(x => x.AppID == 6).Select(o => o).FirstOrDefault();
if (Themecolor != null)
{
Themecolor.AppValue = objdb.Master_ThemeColors.Where(x => x.ColorId == ID).Select(o => o.ColorName).FirstOrDefault();
objdb.SaveChanges();
Session["Theme"] = Themecolor.AppValue;
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(ID, JsonRequestBehavior.AllowGet));
}
public static List <WorkData> GetTimeWorked(int userId)
{
try
{
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
var UserDetails = dbHrms.Users.FirstOrDefault(x => x.UserID == userId);
var EmpId = UserDetails.EmpID;
var BranchId = UserDetails.BranchId;
DateTime dt1 = DateTime.Parse(TimeSpan.FromMinutes(330).ToString());
DateTime dt2 = DateTime.Parse(TimeSpan.FromMinutes(330).ToString());
var WorkingHoursData = dbHrms.TimeManagements.Where(x => x.EmpID == EmpId && x.BranchId == BranchId).OrderByDescending(x => x.Date).Take(10).Select(x => new WorkData
{
Date = EntityFunctions.TruncateTime(x.Date) ?? DateTime.Now,
//minsWorked = x.OutTimeMin == 0 ? null : x.OutTimeMin - x.InTimeMin,
minsWorked = x.TotalTime == 0 ? null : x.TotalTime,
//Convert.ToInt32(Convert.ToDateTime(InTime).TimeOfDay.TotalMinutes);
IsOutEntry = (x.OutTimeMin != 0),
IsAbsent = (x.OutTimeMin == 0 && x.InTimeMin == 0),
InTime = x.InTime,
OutTime = x.OutTime,
InTmieMin = x.InTimeMin
}).ToList();
return(WorkingHoursData);
}
}
catch
{
return(new List <WorkData>());
}
}
public ActionResult ReportsPermission(List <int> From, List <int> To)
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var deleteuser = db.ReportsPermissions.Where(x => x.IsAuthorized == true).Select(o => o).ToList();
foreach (var deluser in deleteuser)
{
db.ReportsPermissions.DeleteObject(deluser);
}
db.SaveChanges();
for (int j = 0; j < To.Count(); j++)
{
DSRCManagementSystem.ReportsPermission objaccess = new DSRCManagementSystem.ReportsPermission();
objaccess.UserId = To[j];
objaccess.IsAuthorized = true;
db.AddToReportsPermissions(objaccess);
db.SaveChanges();
}
return(Json("Authorize", JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
return(Json("Failed", JsonRequestBehavior.AllowGet));
}
}
public static List <MessageUpdates> GetMessages(int userId)
{
try
{
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
DateTime currentDate = DateTime.Now;
//EntityFunctions.TruncateTime(x.DateTimeStart) == currentDate.Date
var Messages = dbHrms.UserMessages.Where(user => user.EmployeeId == userId && user.Status == null).Join(dbHrms.communicationMessages.
Where(x => (EntityFunctions.TruncateTime(x.Valid_From) <= currentDate.Date && EntityFunctions.TruncateTime(x.Valid_To) >= currentDate.Date)),
x => x.MessageId, y => y.MessageId, (x, y) =>
new MessageUpdates()
{
messageId = y.MessageId,
messageText = y.MessageText.Replace("<br />", "\n"),
messageType = (commMessageType)y.MessageType,
showComments = y.ShowComments,
Comments = x.Comments ?? ""
}
).ToList();
return(Messages);
}
}
catch
{
return(new List <MessageUpdates>());
}
}
public ActionResult Delete(int ID)
{
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var obj = db.Assets.FirstOrDefault(x => x.AssetID == ID);
obj.ISDelete = true;
db.SaveChanges();
var obj1 = db.Assets.Where(x1 => x1.AssetID == ID).Select(s => s.Name_Model_No).FirstOrDefault();
string va = Convert.ToString(obj1);
var obj2 = db.Assets.Where(c => c.Name_Model_No == va).ToList();
foreach (var items in obj2)
{
var update = db.Assets.Where(x => x.AssetID == items.AssetID).FirstOrDefault();
update.Name_Model_No = null;
TryUpdateModel(update);
db.SaveChanges();
}
bool exis = db.ComputerAssigneds.Any(s => s.UPSID == obj1);
if (exis)
{
var updateComputer = db.ComputerAssigneds.Where(m => m.UPSID == obj1).ToList();
foreach (var items in updateComputer)
{
var update = db.ComputerAssigneds.Where(m => m.Assignid == items.Assignid).FirstOrDefault();
update.UPSID = null;
TryUpdateModel(update);
db.SaveChanges();
}
}
db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
}
public static List <ViewMessage> ViewMessage(int UserId, int messageid)
{
dynamic messages;
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
messages = (from message in dbHrms.communicationMessages.Where(o => o.UserID == UserId)
join
usermessage in dbHrms.UserMessages.Where(o => o.Comments != null || o.Comments == null) on message.MessageId equals usermessage.MessageId
join
user in dbHrms.Users on usermessage.EmployeeId equals user.UserID
select new ViewMessage
{
UserId = user.UserID,
MessageId = message.MessageId,
UserName = user.FirstName + " " + user.LastName,
Message = message.MessageText.Replace("<br />", "\n"),
Comment = usermessage.Comments,
MessageinitiatesDate = EntityFunctions.TruncateTime(message.Valid_From),
MessageValidUpto = EntityFunctions.TruncateTime(message.Valid_To),
Isreplyable = message.ShowComments,
IsYesOrNo = usermessage.IsYesPressed,
MessageType = message.MessageType
//}).Where(o => o.MessageId == messageid).ToList();
}).OrderByDescending(o => o.MessageinitiatesDate).ToList();
}
return(messages);
}
public ActionResult AssignNewRoles(AssignRole model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var UserIDs = model.unemployees.Split(',');
var DataId = model.RoleID;
var Data = Convert.ToInt32(DataId);
foreach (string userID in UserIDs)
{
int RoleID = Convert.ToByte(Data);
int UserID = Convert.ToInt32(userID);
var x = db.UserRoles.Where(o => o.UserID == UserID).ToList();
foreach (var y in x)
{
db.UserRoles.DeleteObject(y);
db.SaveChanges();
var user = db.UserRoles.CreateObject();
int z = Convert.ToInt32(y.UserID);
user.UserID = z;
user.RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == MasterEnum.NewuserRole.NewEmployeeRole).RoleID;
db.UserRoles.AddObject(user);
db.SaveChanges();
}
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public static List <ViewMessage> GetNewMessageOnly()
// public static ViewMessage GetNewMessageOnly()
{
dynamic messages;
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
messages = (from message in dbHrms.communicationMessages
join
usermessage in dbHrms.UserMessages on message.MessageId equals usermessage.MessageId
join
user in dbHrms.Users on usermessage.EmployeeId equals user.UserID
// where usermessage.time>= EntityFunctions.AddSeconds(DateTime.Now,-3)
select new ViewMessage
{
UserId = user.UserID,
UserName = user.FirstName + " " + user.LastName,
Message = message.MessageText.Replace("<br />", "\n"),
Comment = usermessage.Comments,
MessageinitiatesDate = EntityFunctions.TruncateTime(message.Valid_From).Value,
MessageValidUpto = EntityFunctions.TruncateTime(message.Valid_To),
Isreplyable = message.ShowComments,
IsYesOrNo = usermessage.IsYesPressed,
MessageType = message.MessageType
//}).ToList();
}).OrderByDescending(o => o.MessageinitiatesDate).ToList();
}
return(messages);
}
public ActionResult EditRole(Manage model)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var Name = model.Name.Trim();
int ID = model.ID;
var temp = objdb.Master_Roles.Where(r => r.RoleID != ID && r.IsActive == true).Select(f => f.RoleName);
foreach (var Edit in temp)
{
if (Edit == Name)
{
ModelState.AddModelError("RoleName", "Role Name Already Exists");
@ViewBag.ID = ID;
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
}
//if (temp == Name)
//{
// ModelState.AddModelError("RoleName", "Role Name Already Exists");
// @ViewBag.ID = ID;
// return Json("Warning", JsonRequestBehavior.AllowGet);
//}
//else
{
var x = objdb.Master_Roles.Where(o => o.RoleID == ID).FirstOrDefault();
x.RoleName = Name;
objdb.SaveChanges();
}
return(Json("Success1", JsonRequestBehavior.AllowGet));
}
public static void SendMessage(communicationModel commModel, DateTime validFrom, DateTime validTo, int UserID)
{
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
communicationMessage commMessage = new communicationMessage();
commMessage.MessageText = commModel.Message.Replace(System.Environment.NewLine, "<br />");
commMessage.UserID = UserID;
commMessage.ShowComments = commModel.showComments;
commMessage.ShowToAll = commModel.showToAll;
commMessage.Valid_From = validFrom /*commModel.dateFrom*/;
commMessage.Valid_To = validTo /*commModel.dateTo*/;
commMessage.MessageType = commModel.messageTypeId;
dbHrms.AddTocommunicationMessages(commMessage);
dbHrms.SaveChanges();
//commModel.selectedMembers.ForEach(x =>
commModel.UserList.ForEach(x =>
{
UserMessage userMessage = new UserMessage();
userMessage.EmployeeId = Convert.ToInt32(x);
userMessage.MessageId = commMessage.MessageId;
dbHrms.AddToUserMessages(userMessage);
dbHrms.SaveChanges();
});
}
}
public List <Master_ProjectTypes> GetProjectTypeList()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var projectTypes = from t in db.Master_ProjectTypes select t;
return(projectTypes.ToList());
}
private List <SelectListItem> GetProjects()
{
try
{
var ProjectList = new List <SelectListItem>();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
int UserID = int.Parse(Session["UserID"].ToString());
List <DSRCProjects> projects = (from usrproj in db.UserProjects
join
proj in db.Projects on usrproj.ProjectID equals proj.ProjectID
where usrproj.UserID == UserID
select new DSRCProjects
{
ProjectId = usrproj.ProjectID,
ProjectName = proj.ProjectName
}).ToList();
foreach (var item in projects)
{
ProjectList.Add(new SelectListItem {
Text = item.ProjectName, Value = item.ProjectId.ToString()
});
}
}
return(ProjectList);
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
throw Ex;
}
}
