public issue_management_systemEntities1 Databaseobject()
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
return(db);
}
}
public ActionResult saveList(string userList_json)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) //method for load the map acordinto the surevisor line
{
JArray list_user = JArray.Parse(userList_json) as JArray;
foreach (JObject user in list_user)
{
//get line id of particular line name
String line_name = user["line_id"].ToString();
var line = db.lines.Where(x => x.line_name == line_name).FirstOrDefault();
//get issue id of particular issue
String issue_name = user["issue_id"].ToString();
var issue = db.issues.Where(x => x.issue1 == issue_name).FirstOrDefault();
string query_1 = @"INSERT INTO [dbo].[issue_line_person]
([issue_id],[line_id],[EmployeeNumber],[assigned_date],[email],[call],
[message],[callRepetitionTime],[sendAlertAfter],[levelOfResponsibility],[issue_line_person_id])
VALUES(" + issue.issue_id + "," + line.line_id + "," + user["EmployeeNumber"] + ",'" + user["assigned_date"] + "',"
+ user["email"] + "," + user["call"] + "," + user["message"] + ",'" + user["callRepetitionTime"] + "','"
+ user["sendAlertAfter"] + "'," + user["levelOfResponsibility"] + "," + user["issue_line_person_id"] + ")";
System.Diagnostics.Debug.WriteLine(query_1);
db.Database.ExecuteSqlCommand(query_1);
}
return(Content("List Saved", MediaTypeNames.Text.Plain));
}
}
[HttpPost] //add Breakedown to database
public ActionResult AddIssueBreakedown(issue_occurrence issueModel)
{
var time = DateTime.Now;
string current_time = time.ToString("yyyy-MM-dd HH:mm:ss");//get today to string variable
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
if (ModelState.IsValid)
{
int userID = (int)Session["userID"];
var lineInfo = db.line_supervisor.Where(x => x.supervisor_emp_id == userID).FirstOrDefault();
issueModel.line_line_id = lineInfo.line_line_id;
issueModel.issue_satus = "1";
issueModel.issue_issue_ID = 1; //Issue id is 1 for Machine Brakedown
issueModel.responsible_person_emp_id = 5; //get specific employee
var date = DateTime.ParseExact(current_time, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
issueModel.date_time = date;
issueModel.location = (string)Session["location"];
db.issue_occurrence.Add(issueModel);
db.SaveChanges();
if (issueModel.issue_occurrence_id > 0)
{
var line = db.lines.Where(x => x.line_id == lineInfo.line_line_id).FirstOrDefault();
string msg = line.line_name + " line IT/SoftWare issue has been occurred at " + date + ". Special Note of Line supervisor - " + issueModel.description;
var displayInfo = db.displays.Where(x => x.line_id == lineInfo.line_line_id).FirstOrDefault();
com.lightON("1", displayInfo.raspberry_ip_address);//turn on the Light
sendCD(lineInfo.line_line_id, 1, msg, "Machine Brakedown has been occurred");
}
ModelState.Clear();
}
}
return(RedirectToAction("selectIssue", "Supervisor"));
}
private void sendCD(int?line_line_id, int issueId, string msg, string subject)
{
var time = DateTime.Now;
string current_time = time.ToString("yyyy-MM-dd HH:mm:ss");
var date = DateTime.ParseExact(current_time, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
var userDetails = db.User_tbl.Where(x => x.Role == "manager").ToList();
foreach (var item in userDetails)
{
string query = "INSERT INTO tbl_Notifications ([Status],[Message],[Type],[EmployeeNumber],[Date]) VALUES( 1,'" + msg + "','issue','" + item.EmployeeNumber + "','" + date + "') ";
db.Database.ExecuteSqlCommand(query);
}
var communicationInfo = db.issue_line_person.Where(x => x.line_id == line_line_id && x.issue_id == issueId).ToList();
foreach (var item in communicationInfo)
{
var personInfo = db.User_tbl.Where(y => y.EmployeeNumber == item.EmployeeNumber).FirstOrDefault();
CommunicationData cd = new CommunicationData(personInfo.Phone, msg, personInfo.EMail, item.email, item.call, item.message, personInfo.EmployeeNumber, subject);
com.setCD(cd);
}
}
}
public ActionResult getUserDetails(string userID)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) //method for load the map acordinto the surevisor line
{
String query_1 = "SELECT Name,Department,Position,Phone,EMail,EmployeeNumber FROM User_tbl WHERE User_tbl.EmployeeNumber ='" + userID + "'";
var c = db.Database.SqlQuery <user_temp>(query_1).ToList();
return(Json(c, JsonRequestBehavior.AllowGet));
}
}
public ActionResult fillNameDropDown(string department)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) //method for load the map acordinto the surevisor line
{
String query_1 = "SELECT CONCAT(User_tbl.EmployeeNumber,' - ',User_tbl.Name) AS Users FROM User_tbl WHERE User_tbl.Department='" + department + "'";
var c = db.Database.SqlQuery <string>(query_1).ToList();
return(Json(c, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Autherize(IssueManagementSystem.Models.User_tbl userModel)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
var userDetails = db.User_tbl.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Wrong UserName or Password.";//show login erroe message
return(View("Index", userModel));
}
else
{
Session["userID"] = userDetails.EmployeeNumber; //retrive Userid of login user
Session["userName"] = userDetails.UserName.Trim(); //retrive USerName of login user
Session["name"] = userDetails.Name.Trim();
Session["email"] = userDetails.EMail.Trim();
Session["location"] = userDetails.Location.Trim();
Session["department"] = userDetails.Department.Trim();
string username = Session["userName"].ToString();
string role = userDetails.Role.ToString().Trim(); //retrive the user role
if (role.Equals("supervisor")) //if user is supervisor goto the supervisor page
{
return(RedirectToAction("selectIssue", "Supervisor"));
}
else if (role.Equals("display")) //if user is display goto the display page
{
return(RedirectToAction("Rasp", "Display"));
}
else if (role.Equals("admin"))
{
return(RedirectToAction("SelectBranch", "Admin"));
}
else if (role.Equals("manager"))
{
return(RedirectToAction("Index", "Manager"));
}
else if (role.Equals("CellEngineer"))
{
return(RedirectToAction("DashBord", "CellEngineer"));
}
else if (role.Equals("responsiblePerson"))
{
return(RedirectToAction("Index", "ResponsiblePerson"));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
}
}
public ActionResult Rasp(int id)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) {
ViewBag.id = id;
ViewBag.issueoccourInfo = db.issue_occurrence.Where(x => x.line_line_id == id && x.issue_satus == "1").ToList();
}
return(View());
}
public JsonResult hideNotification(int?notificationId)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
string query = "UPDATE tbl_Notifications SET Status = 0 WHERE NotificationId = " + notificationId;
db.Database.ExecuteSqlCommand(query);
}
return(Json(true));
}
// GET: Supervisor
public ActionResult selectIssue()// select issue view
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
int userID = (int)Session["userID"];
var lineInfo = db.line_supervisor.Where(x => x.supervisor_emp_id == userID).FirstOrDefault();
ViewBag.lineID = lineInfo.line_line_id;
List <issue_occurrence> issue = db.issue_occurrence.ToList();
return(View(issue));
}
}
public JsonResult getlineInfo(int?list_id)
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
var lineInfo = db.lines.Where(x => x.line_id == list_id).FirstOrDefault();
line line = new line {
line_id = lineInfo.line_id,
line_name = lineInfo.line_name,
};
return(Json(line, JsonRequestBehavior.AllowGet));
}
}
private void doCommunicate()
{
if (gsm_status)
{
CommunicationData communicateData = (CommunicationData)numberList.Dequeue();
try
{
var time = DateTime.Now;
string current_time = time.ToString("yyyy-MM-dd HH:mm:ss");
var date = DateTime.ParseExact(current_time, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
gsm_status = false;
var msg = communicateData.getMsg();
var emailAddress = communicateData.getEmailAddress();
var mobileNumber = communicateData.getNumber();
if (communicateData.getEmail() == 1 && emailAddress != null)
{
sendMail(emailAddress, msg, communicateData.getsubject());
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
string query = "INSERT INTO tbl_Notifications ([Status],[Message],[Type],[EmployeeNumber],[Date]) VALUES( 1,'" + msg + "','email','" + communicateData.getEmployeeNumber() + "','" + date + "') ";
db.Database.ExecuteSqlCommand(query);
}
}
if (communicateData.getMessage() == 1 && mobileNumber != null)
{
send_SMS(mobileNumber, msg);
}
if (communicateData.getCall() == 1 && mobileNumber != null)
{
take_Call(mobileNumber, msg);
}
gsm_status = true;
}
catch (Exception ex)
{
Debug.WriteLine(ex);
gsm_status = true;
}
}
else
{
int milliseconds = 2000;
Thread.Sleep(milliseconds);
doCommunicate();
}
}
public ActionResult MachinBreakdown() //machine breakedown view
{
int userID = (int)Session["userID"]; // get current supervisorID
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) //method for load the map acordinto the surevisor line
{
var lineInfo = db.line_supervisor.Where(x => x.supervisor_emp_id == userID).FirstOrDefault();
var mapInfo = db.line_map.Where(y => y.line_id == lineInfo.line_line_id).FirstOrDefault();
ViewData["map"] = mapInfo.map.ToString().Trim();//get the map arry to ViewData
return(View());
}
}
public ActionResult NotificationsManagement()
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1()) //method for load the map acordinto the surevisor line
{
List <User_tbl> userList = db.User_tbl.ToList();
List <department> departments = db.departments.ToList();
dynamic mymodel = new ExpandoObject();
mymodel.users = userList;
mymodel.departments = departments;
return(View(mymodel));
}
}
public ActionResult getBlinkingMachinesList(string line)
{
int lineID = Int32.Parse(line);
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
//List<issue_occurrence> c = db.issue_occurrence.Where(x=>x.line_line_id== lineID && x.issue_issue_ID == 1).ToList();
//foreach (issue_occurrence x in c) { System.Diagnostics.Debug.WriteLine(x.machine_machine_id); }
String query_1 = "SELECT issue_occurrence.machine_machine_id FROM issue_occurrence WHERE issue_occurrence.line_line_id =" + line + " AND issue_occurrence.issue_issue_ID=1";
var c = db.Database.SqlQuery <machines_temp>(query_1).ToList();
return(Json(c, JsonRequestBehavior.AllowGet));
}
}
// GET: Manager
public ActionResult Index()
{
using (issue_management_systemEntities1 db = new issue_management_systemEntities1())
{
if ((string)Session["department"] == "MD")
{
ViewBag.BrakedownCount = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 1).Count();
ViewBag.MaterialDelayCount = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 2).Count();
ViewBag.TechnicalIssue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 3).Count();
ViewBag.QualityIsuue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 4).Count();
ViewBag.ITIsuue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 5).Count();
}
else
{
string location = Session["location"].ToString();
ViewBag.BrakedownCount = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 1 && location == x.location).Count();
ViewBag.MaterialDelayCount = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 2 && x.location == location).Count();
ViewBag.TechnicalIssue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 3 && x.location == location).Count();
ViewBag.QualityIsuue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 4 && x.location == location).Count();
ViewBag.ITIsuue = db.issue_occurrence.Where(x => x.issue_satus == "1" && x.issue_issue_ID == 5 && x.location == location).Count();
}
}
return(View());
}
[HttpPost]//solovedIssueMethod
public JsonResult SolvedIssue(int?issueId, int?issueOccourId)
{
//update Issueststus as 0
issue_management_systemEntities1 db = new issue_management_systemEntities1();
var issueoccourInfo = db.issue_occurrence.Where(x => x.issue_occurrence_id == issueOccourId).FirstOrDefault();
issueoccourInfo.issue_satus = "0";
db.SaveChanges();
int userID = (int)Session["userID"];
var lineInfo = db.line_supervisor.Where(x => x.supervisor_emp_id == userID).FirstOrDefault();
var line_id = lineInfo.line_line_id;
//get the list of Issuueoccurrence table
List <issue_occurrence> issue = db.issue_occurrence.ToList();
int count = 0;
foreach (var item in issue)
{ //check issue id == to clicked issueid
if (item.issue_issue_ID == issueId && item.line_line_id == line_id)
{
//if any status is there under selected issueid and line id cout will up
if (item.issue_satus == "1")
{
count++;
}
}
}
if (count == 0) // if cout ==0 light will off
{
var displayInfo = db.displays.Where(x => x.line_id == line_id).FirstOrDefault();
//com.lightOFF(issueId.ToString(), displayInfo.raspberry_ip_address);
}
return(Json(true));
}
