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 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 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 ActionResult AddLabel(Label model)
{
try
{
var userId = (int)Session["UserId"];
var BranchId = db.Users.Where(r => r.UserID == userId).Select(f => f.BranchId).FirstOrDefault();
var Name = model.LabelName.Trim();
var LabelName = db.Dictionaries.Where(r => r.Name == Name && r.IsActive == true).Select(f => f.Name);
foreach (var dpt in LabelName)
{
if (dpt != null)
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
}
{
var Assignobj = db.Dictionaries.CreateObject();
Assignobj.Name = Name;
Assignobj.IsActive = true;
db.Dictionaries.AddObject(Assignobj);
db.SaveChanges();
}
}
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("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 ActionResult AddSkills(Skills Model)
{
var Id = Model.Id;
var Technology = Model.Technology.Trim();
var temp = db.SkillsSpecifications.Where(r => r.Specification == Technology && r.IsActive == true).Select(f => f.Specification);
foreach (var check in temp)
{
if (check == Technology)
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
if (check.ToLower() == Technology.ToLower())
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
if (check.ToUpper() == Technology.ToUpper())
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
}
{
var Assignobj = db.SkillsSpecifications.CreateObject();
Assignobj.Specification = Technology;
Assignobj.IsActive = true;
db.SkillsSpecifications.AddObject(Assignobj);
db.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult ManageActivities(ManageActivities model)
{
try{
var ActivityName = model.ActivityName.Trim();
var ActivityDescription = model.ActivityDescription.Trim();
var temp = db.Activities.Where(r => r.Activity1 == ActivityName && r.IsActive == true).Select(f => f.Activity1);
foreach (var check in temp)
{
if (check == ActivityName)
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
}
{
var Assignobj = db.Activities.CreateObject();
Assignobj.Activity1 = ActivityName;
Assignobj.ActivityDescription = ActivityDescription;
db.Activities.AddObject(Assignobj);
db.SaveChanges();
}
}
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("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Feedback(FeedbackModel model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int UserID = Convert.ToInt32(Session["UserID"]);
int Id = Convert.ToInt32(model.TrainingId);
try
{
// var Req_Feedback = db.TrainingFeedBackCalcs.CreateObject();
//var Req_Feedback = db.TrainingFeedBackCalcs.FirstOrDefault(o => o.TrainingId == Id && o.UserId == UserID);
var Req_Feedback = db.TrainingFeedBackCalcs.Where(o => o.TrainingId == Id && o.UserId == UserID).Select(o => o).FirstOrDefault();
Req_Feedback.TrainingId = Id;
Req_Feedback.UserId = UserID;
Req_Feedback.ChoiceTopic = model.Choice;
Req_Feedback.PgmRelevance = model.Relevance;
Req_Feedback.ContentAmt = model.AmountofCourse;
Req_Feedback.AdequacyLearning = model.AdeqofLearning;
Req_Feedback.AdequacyPreparation = model.AdeqofPreparation;
Req_Feedback.ExampleDemo = model.EXpofConcepts;
Req_Feedback.ContentPresented = model.contentPres;
Req_Feedback.TimeMaintanence = model.Timemain;
Req_Feedback.Flag = true;
Req_Feedback.LearntInPgm = model.Learn;
Req_Feedback.FacultyQuality = model.Quality;
Req_Feedback.PgmUseful = (model.PrgUseful == 1) ? true : false;
Req_Feedback.Comments = model.Suggestions;
int? total = model.Choice + model.Relevance + model.AmountofCourse + model.AdeqofLearning + model.AdeqofPreparation + model.EXpofConcepts + model.contentPres + model.Timemain + model.Quality;
float overall = Convert.ToSingle(total) / (9 * 5);
float overallperc = overall * 100;
Req_Feedback.Overall = overall;
Req_Feedback.OverallPerc = overallperc;
// db.TrainingFeedBackCalcs.AddObject(Req_Feedback);
db.SaveChanges();
int Feedback_Status = db.TrainingFeedBackCalcs.Count(o => o.Flag == false && o.TrainingId == Id);
if (Feedback_Status == 0)
{
var TrainingRef = db.Trainings.FirstOrDefault(o => o.TrainingId == Id);
TrainingRef.StatusId = 6;
db.SaveChanges();
}
}
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("success", JsonRequestBehavior.AllowGet));
}
public ActionResult Report(ReportMOD model)
{
try{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var Name = model.Name.Trim();
var checkname = objdb.CustomReports.Where(x => x.ReportName == Name && x.IsActive == true).Select(o => o.ReportID).FirstOrDefault();
if (checkname != 0)
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
var Desc = "";
if (model.Description != null)
{
Desc = model.Description.Trim();
}
var sp = model.sp;
var userId = (int)Session["UserId"];
var ReturnDate = System.DateTime.Now;
var roles = model.roles.Split(',');
var Parameter = model.Parameter;
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var Assignobj = objdb.CustomReports.CreateObject();
Assignobj.ReportName = Name;
Assignobj.ReportDescription = Desc;
Assignobj.ReportQuery = sp;
Assignobj.CreatedBy = Convert.ToString(userId);
Assignobj.CreatedDate = ReturnDate;
Assignobj.IsActive = true;
objdb.CustomReports.AddObject(Assignobj);
objdb.SaveChanges();
model.ReportID = Assignobj.ReportID;
var roles1 = model.roles.Split(',');
foreach (string userID in roles1)
{
var Function = objdb.CustomReports_UserMapping.CreateObject();
Function.ReportID = model.ReportID;
Function.RoleID = Convert.ToInt32(userID);
objdb.CustomReports_UserMapping.AddObject(Function);
objdb.SaveChanges();
}
}
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("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult AssignNewRole(AssignRole model)
{
var userId = (int)Session["UserId"];
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int BranchId = (int)db.Users.FirstOrDefault(o => o.UserID == userId).BranchId;
var userIDs1 = model.unuserid;
var UserIDs = model.multiselectemployees.Split(',');
var DataId = model.RoleID;
var Data = Convert.ToInt32(DataId);
List <int> UserID = model.SelectedEmpList;
var RoleName = MasterEnum.NewuserRole.NewEmployeeRole;
var RoleID = db.Master_Roles.FirstOrDefault(o => o.RoleName == RoleName).RoleID;
var employees1 = (from rc in db.Users
join p in db.UserRoles on rc.UserID equals p.UserID
join r in db.Master_Roles on p.RoleID equals r.RoleID
//where (rc.FirstName != null && rc.LastName != null && p.RoleID == Data && r.RoleID != RoleID && rc.BranchId == BranchId)
where (p.RoleID == Data && r.RoleID != RoleID && rc.BranchId == BranchId)
select new AssignRole()
{
userid = rc.UserID,
}).Distinct().ToList();
List <int> ex = UserID.Except(employees1.Select(e => e.userid)).ToList();
foreach (int userID1 in ex)
{
var x = db.UserRoles.Where(o => o.UserID == userID1).ToList();
foreach (var y in x)
{
db.UserRoles.DeleteObject(y);
db.SaveChanges();
}
}
foreach (int userID in ex)
{
var Assignobj = db.UserRoles.CreateObject();
Assignobj.RoleID = Convert.ToByte(Data);
Assignobj.UserID = Convert.ToInt32(userID);
db.UserRoles.AddObject(Assignobj);
db.SaveChanges();
var UpdateRoleID = db.Users.Where(o => o.UserID == userID).Select(o => o).FirstOrDefault();
if (UpdateRoleID != null)
{
UpdateRoleID.RoleID = Convert.ToByte(Data);
}
db.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
//public ActionResult FinalizeDefaultTemplate(int ProjectID)
//{
// return Json(true, JsonRequestBehavior.AllowGet);
//}
public ActionResult FinalizeDefaultTemplate()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
var ProjectId = Convert.ToInt32(Session["projectID"].ToString());
var typobj = db.TimesheetTypes.Where(o => o.ProjectID == ProjectId).Select(o => o).FirstOrDefault();
if (typobj == null)
{
var dataobj = new TimesheetType();
dataobj.ProjectID = ProjectId;
dataobj.IsGrouped = false;
db.TimesheetTypes.AddObject(dataobj);
}
else
{
typobj.IsGrouped = false;
}
db.SaveChanges();
List <Column> defaultcolumnlist = db.DefaultTemplates.Select(o =>
new Column
{
ColumnName = o.ColumnName,
ColumnTypeId = o.ColumnTypeID
}).ToList();
string columnname;
foreach (var item in defaultcolumnlist)
{
columnname = item.ColumnName.Contains(" ") ? item.ColumnName.Replace(" ", "") : item.ColumnName;
var timesheetcolumnobj = db.TimeSheetColumns.CreateObject();
timesheetcolumnobj.ProjectID = ProjectId;
timesheetcolumnobj.ColumnNames = columnname;
timesheetcolumnobj.ColumnDisplayName = item.ColumnName;
timesheetcolumnobj.ColumnTypeID = item.ColumnTypeId;
timesheetcolumnobj.IsActive = true;
db.TimeSheetColumns.AddObject(timesheetcolumnobj);
db.SaveChanges();
}
}
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(true, JsonRequestBehavior.AllowGet));
}
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 EditTime(EditTimeEntry model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
if (ModelState.IsValid)
{
var obj = (from tim_mng in db.TimeManagements
where tim_mng.EmpID == model.EmployeeId && tim_mng.BranchId == model.BranchID && EntityFunctions.TruncateTime(tim_mng.Date) == EntityFunctions.TruncateTime(model.Date)
select tim_mng
).FirstOrDefault();
obj.InTime = model.InTime;
obj.OutTime = model.OutTime;
var inTime = DateTime.Parse(model.InTime);
var outTime = DateTime.Parse(model.OutTime);
obj.InTimeMin = (inTime.Hour * 60) + inTime.Minute;
obj.OutTimeMin = (outTime.Hour * 60) + outTime.Minute;
obj.TotalTime = obj.OutTimeMin - obj.InTimeMin;
db.SaveChanges();
return(Json(true, 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(model));
}
public ActionResult EditSkills(Skills Model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int Id = Model.Id;
string Technology = Model.Technology.Trim();
var data = db.SkillsSpecifications.Where(o => o.SpecificationId != Id && o.IsActive == true).Select(o => o.Specification);
foreach (var check in data)
{
if (check == Technology)
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
if (check.ToLower() == Technology.ToLower())
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
if (check.ToUpper() == Technology.ToUpper())
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
}
var datas = db.SkillsSpecifications.Where(o => o.SpecificationId == Id).Select(o => o).FirstOrDefault();
{
datas.Specification = Technology;
db.SaveChanges();
}
return(Json("Success1", JsonRequestBehavior.AllowGet));
}
public ActionResult EditVehicle(AddVehicle model, string Contact_No, string vehicleid)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
if (vehicleid != null)
{
int vechid = Convert.ToInt32(vehicleid);
}
var value = db.Vehicles.Where(x => x.VehicleId == model.vehicleid).Select(o => o).FirstOrDefault();
value.VehicleBrand_Id = Convert.ToInt32(model.VehicleBrand);
value.VehicleType_Id = Convert.ToInt32(model.VehicleType);
value.VehicleModel_Id = Convert.ToInt32(model.VehicleModel);
value.VehicleMake = model.VehicleMake;
value.Vehicle_Remarks = model.Remarks;
value.Model_Year = model.Model_Year;
value.No_of_Seat = model.No_of_Seat;
value.No_of_Trip = model.Trip;
if (value.Vehicle_Photo != null)
{
value.Vehicle_Photo = true;
}
db.SaveChanges();
return(Json("Success1", JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(string Id)
{
int id = Convert.ToInt32(Id);
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Transportation objmodel = new DSRCManagementSystem.Models.Transportation();
//var value = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == id).Select(o => o.ManageExpenseId).FirstOrDefault();
//var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault();
//// var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault();
//objvalue.Isactive = false;
var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault();
// var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault();
var values = objdb.ManageExpense_Mapping.Where(x => x.ManageExpenseId == objvalue.ManageExpenseId).Select(o => o).FirstOrDefault();
objdb.ManageExpense_Mapping.DeleteObject(values);
objvalue.Isactive = false;
objdb.SaveChanges();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
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 ActionResult Add(DSRCManagementSystem.Models.Category objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Category obj = new DSRCManagementSystem.Category();
try
{
obj.CategoryName = objmodel.CategoryName.Trim();
obj.IsActive = true;
objdb.AddToCategories(obj);
if (!objdb.Categories.Any(cobj => cobj.IsActive == true && cobj.CategoryName.Trim() == obj.CategoryName.Trim()))
{
objdb.SaveChanges();
}
else
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, 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(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditCheckList(DSRCManagementSystem.Models.Checklist objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var res = "";
try
{
objmodel.CheckListID = Convert.ToInt32(Session["CategoryId"]);
var value =
objdb.CheckLists.Where(x => x.CheckListID == objmodel.CheckListID).Select(o => o).FirstOrDefault();
if (!objdb.CheckLists.Any(cobj => cobj.IsActive == true && cobj.CheckListName.Trim() == objmodel.CheckListName.Trim()))
{
value.CheckListName = objmodel.CheckListName;
objdb.SaveChanges();
res = "Success";
}
else
{
// return Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet);
res = "Already";
}
}
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(new { Result = res, URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int ID)
{
try{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var obj = db.computermanagements.Where(x => x.managementid == ID).FirstOrDefault();
obj.ISDelete = true;
var obj1 = db.ComputerAssigneds.Where(x => x.Managementid == ID).FirstOrDefault();
if (obj1 != null)
{
if (obj.managementid == obj1.Managementid)
{
obj1.ISDelete = true;
}
}
db.SaveChanges();
}
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("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(ManageComputers model)
{
try
{
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var obj_Comp = db.computermanagements.Where(o => o.managementid == model.ID).Select(o => o).FirstOrDefault();
obj_Comp.Manufacturer = model.Manufacturer;
obj_Comp.CPUID = model.CPUID;
obj_Comp.MonitorID = model.MonitorID;
obj_Comp.OsId = Convert.ToInt32(model.OS);
obj_Comp.Memory = model.Memory;
obj_Comp.cpu = model.CPU;
obj_Comp.ComputerStatusNew = model.ComputerStatus;
obj_Comp.ComputerName = model.ComputerName;
obj_Comp.IP = model.IP;
db.SaveChanges();
return(Json("Success", 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("Success", JsonRequestBehavior.AllowGet));
}
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 ActionResult RejectRequestEmail(int Id)
{
int UId = Convert.ToInt32(System.Web.HttpContext.Current.Application["Id"]);
var userId = (int)Session["UserId"];
try
{
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var obj_server = db.Skills.Where(o => o.Id == Id).Select(o => o).FirstOrDefault();
ViewBag.IsApproved = obj_server.status == 1 ? true : false;
ViewBag.IsRejected = obj_server.status == 3 ? true : false;
ViewBag.IsCancelled = obj_server.status == 4 ? true : false;
if (ViewBag.IsApproved == false && ViewBag.IsRejected == false && ViewBag.IsCancelled == false)
{
obj_server.status = 3;
obj_server.ApprovedBy = userId;
obj_server.ApprovedDate = DateTime.Now;
db.SaveChanges();
}
}
return(View());
}
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 AddExpense(DSRCManagementSystem.Models.Transportation objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.ManageExpens objexp = new DSRCManagementSystem.ManageExpens();
DSRCManagementSystem.ManageExpense_Mapping objmap = new DSRCManagementSystem.ManageExpense_Mapping();
//var num =Convert.ToInt32(objmodel.VehicleNumber);
var vehicleid = objdb.Vehicles.Where(x => x.Vehicle_No == objmodel.VehicleNumber && x.IsActive == true).Select(o => o.VehicleId).FirstOrDefault();
var objalready = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == vehicleid).Select(o => o.ManageExpenseId).ToList();
if (objalready != null)
{
for (int i = 0; i < objalready.Count(); i++)
{
var value = Convert.ToInt32(objalready[i]);
int?already = objdb.ManageExpenses.Where(x => x.ManageExpenseId == value && x.Isactive == true).Select(o => o.ExpenseType).FirstOrDefault();
if (already == Convert.ToInt32(objmodel.ExpenseType))
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
}
objexp.Date = DateTime.Now;
objexp.Cost = objmodel.Cost;
objexp.ExpenseType = Convert.ToInt32(objmodel.ExpenseType);
objexp.Isactive = true;
objdb.AddToManageExpenses(objexp);
objdb.SaveChanges();
objmap.ManageExpenseId = objexp.ManageExpenseId;
objmap.VehicleId = vehicleid;
objdb.AddToManageExpense_Mapping(objmap);
objdb.SaveChanges();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult addnew(DSRCManagementSystem.Models.ManageDrivers objmanage)
{
var DriverName = db.Master_DriverType.ToList();
ViewBag.DriverTypeList = new SelectList(DriverName, "DriverType_Id", "DriverType");
var BloodGroup = db.Master_BloodGroup.ToList();
ViewBag.BloodGroupList = new SelectList(BloodGroup, "BloodGroupID", "BloodGroupName");
var Gender = db.Master_Gender.ToList();
ViewBag.GenderList = new SelectList(Gender, "GenderID", "GenderName");
DSRCManagementSystem.Models.ConvertByte objcb = new Models.ConvertByte();
var picture = objcb.ConvertToBytes(objmanage.Pictures);
var Doc = objcb.ConvertToBytes(objmanage.Documents);
if (ModelState.IsValid)
{
var driver = db.Drivers.CreateObject();
driver.First_Name = objmanage.First_Name;
driver.Last_Name = objmanage.Last_Name;
driver.DOB = objmanage.DOB;
driver.Gender = objmanage.Gender;
driver.Driver_Licence_No = objmanage.Driver_Licence_No;
driver.Driver_Licence_Expire_Date = objmanage.Driver_Licence_Expire_Date;
driver.DriverType_Id = objmanage.DriverType_Id;
driver.Email_Id = objmanage.Email_Id;
driver.Contact_No = objmanage.Contact_No;
driver.Blood_Group = objmanage.Blood_Group;
driver.Communication_Address = objmanage.Communication_Address;
driver.Driver_Batch_No = objmanage.Driver_Batch_No;
driver.IsActive = true;
driver.Photo = picture;
driver.Document_Proof = Doc;
db.Drivers.AddObject(driver);
db.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
//return RedirectToAction("Manage", "ManageDrivers");
}
public ActionResult AddVehicle(AddVehicle model, string Contact_No)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
// DSRCManagementSystem.Models.AddsVehicle objvehicle = new DSRCManagementSystem.Models.AddsVehicle();
DSRCManagementSystem.Vehicle objvehicle = new DSRCManagementSystem.Vehicle();
try
{
if (db.Vehicles.Any(R => R.Vehicle_No == model.Vehicle_No))
{
ModelState.AddModelError("Vehicle_No", "Vehicle Number Already Exists");
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
else if (model.Vehicle_No == null)
{
ModelState.AddModelError("Vehicle_No", "Vehicle_No");
}
else
{
var value = db.Vehicles.Where(x => x.VehicleId == model.vehicleid).Select(o => o).FirstOrDefault();
objvehicle.Vehicle_No = model.Vehicle_No;
objvehicle.VehicleMake = model.VehicleMake;
objvehicle.Vehicle_Remarks = model.Remarks;
objvehicle.VehicleBrand_Id = Convert.ToInt32(model.VehicleBrand);
objvehicle.VehicleType_Id = Convert.ToInt32(model.VehicleType);
objvehicle.VehicleModel_Id = Convert.ToInt32(model.VehicleModel);
objvehicle.Model_Year = model.Model_Year;
objvehicle.No_of_Seat = model.No_of_Seat;
objvehicle.No_of_Trip = model.Trip;
objvehicle.IsActive = true;
if (model.Vehicle_Photo != null)
{
objvehicle.Vehicle_Photo = true;
}
objvehicle.Contact_No = model.Contact_No;
db.AddToVehicles(objvehicle);
db.SaveChanges();
}
}
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("Success1", JsonRequestBehavior.AllowGet));
}
public ActionResult AddNewComputer(ManageComputers model, string cmpname)
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var Already = db.computermanagements.Where(x => x.ComputerName == model.ComputerName && x.ISDelete == false).Select(o => o).FirstOrDefault();
if (Already != null)
{
return(Json("Already", JsonRequestBehavior.AllowGet));
}
else
{
if (ModelState.IsValid)
{
// DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
if (model.ComputerStatus == "1")
{
model.ComputerStatus = "Active";
}
else
{
model.ComputerStatus = "Inactive";
}
var Compobj = db.computermanagements.CreateObject();
Compobj.Manufacturer = model.Manufacturer.Trim();
Compobj.CPUID = model.CPUID.Trim();
Compobj.MonitorID = model.MonitorID.Trim();
Compobj.Memory = model.Memory;
Compobj.ComputerStatusNew = model.ComputerStatus;
Compobj.ComputerName = model.ComputerName.Trim();
Compobj.ISDelete = false;
Compobj.IP = model.IP;
Compobj.cpu = model.CPU.Trim();
Compobj.OsId = model.OSID;
db.computermanagements.AddObject(Compobj);
db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(View());
}
}
}
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 AddNew(Email objmail)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DSRCManagementSystem.EmailPurpose objpurpose = new DSRCManagementSystem.EmailPurpose();
var already = db.EmailPurposes.Where(x => x.EmailPurposeName == objmail.Purpose && x.IsActive == true).Select(x => x).FirstOrDefault();
if (already != null)
{
return(Json(new { Result = "Already", JsonRequestBehavior.AllowGet }));
}
else
{
var val = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.EmailTemplateID).FirstOrDefault();
var val1 = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.TemplatePath).FirstOrDefault();
objmail.Template = val1;
//string temp = "";
//int count = objmail.To.Count();
//foreach (var num in objmail.To)
//{
// temp += num + ",";
//}
//string temp1 = "";
//foreach (var num in objmail.CC)
//{
// temp1 += num + ",";
//}
//string temp2 = "";
//foreach (var num in objmail.BCC)
//{
// temp2 += num + ",";
//}
objpurpose.EmailPurposeName = objmail.Purpose;
objpurpose.EmailTemplateID = val;
objpurpose.To = objmail.To != null ? objmail.To : "";
objpurpose.CC = objmail.CC != null ? objmail.CC : "";
objpurpose.BCC = objmail.BCC != null ? objmail.BCC : "";
objpurpose.Subject = objmail.Subject;
objpurpose.IsActive = true;
db.AddToEmailPurposes(objpurpose);
db.SaveChanges();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int ID)
{
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
var record = db.ManageServers.FirstOrDefault(x => x.ManageServers_Id == ID);
record.ISDelete = true;
db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddStops(DSRCManagementSystem.Models.StopList objmodel)
{
DSRCManagementSystem.Stop obj = new DSRCManagementSystem.Stop();
DSRCManagementSystem.Models.StopList obs = new DSRCManagementSystem.Models.StopList();
var val = objdb.Stops.Where(x => x.Stop_Name == objmodel.Stop_Name).Select(o => o).FirstOrDefault();
if (val == null)
{
obj.Stop_Name = objmodel.Stop_Name;
obj.IsActive = true;
objdb.AddToStops(obj);
objdb.SaveChanges();
}
else
{
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
