public issue_types getIssueTypeByTitle(string title)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
var issueType = dbContext.issue_types.Where(i => i.issue_title.Equals(title)).FirstOrDefault <issue_types>();
return(issueType);
}
}
public issue_types getIssueTypeById(int ID)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
var issueType = dbContext.issue_types.Where(i => i.issue_type_id.Equals(ID)).FirstOrDefault <issue_types>();
return(issueType);
}
}
public issue getIssueById(int id)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
issue iss = dbContext.issues.Where(i => i.issue_id.Equals(id)).FirstOrDefault <issue>();
return(iss);
}
}
public reminder getReminder(int issueId, int userId)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
reminder rem = dbContext.reminders.SingleOrDefault(r => r.reminder_issue_id == issueId && r.reminder_user_id == userId);
return(rem);
}
}
public int getUserIdFromUsername(string username)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
ud = dbContext.users.Where(u => u.user_username.Equals(username)).FirstOrDefault <user>();
}
return(ud.user_id);
}
public void saveUser(user u)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
dbContext.users.Add(u);
dbContext.SaveChanges();
}
}
public void addAction(action a)
{
DateTime date = DateTime.Now;
a.action_description = date.ToString() + ": " + SessionInfo.userName + " " + a.action_description;
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
dbContext.actions.Add(a);
dbContext.SaveChanges();
}
}
public List <action> getAllActionsForIssue(int issueId)
{
List <action> actions = new List <action>();
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
actions = dbContext.actions.Where(a => a.issue_id.Equals(issueId)).ToList();
}
return(actions);
}
public Boolean check_user_exists(String username)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
var userData = dbContext.users.Where(u => u.user_username.Equals(username)).FirstOrDefault <user>();
if (userData is null)
{
return(false);
}
}
return(true);
}
public void toggleIssueStatusTo(bool status, int issueId)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
var result = dbContext.issues.SingleOrDefault(i => i.issue_id == issueId);
if (result != null)
{
result.issue_ongoing = status;
dbContext.SaveChanges();
}
}
}
public void updateReminder(int issueId, int userId, DateTime date, Boolean status)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
reminder rem = dbContext.reminders.SingleOrDefault(r => r.reminder_issue_id == issueId && r.reminder_user_id == userId);
if (rem != null)
{
rem.remider_date = date;
rem.reminder_enabled = status;
dbContext.SaveChanges();
}
}
}
public List <issue_types> getAllIssues()
{
List <issue_types> issueTypes = new List <issue_types>();
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
foreach (issue_types it in dbContext.issue_types)
{
issueTypes.Add(it);
}
}
return(issueTypes);
}
private void AddIssue_Load(object sender, EventArgs e)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
ArrayList issues = new ArrayList();
foreach (issue_types issue in dbContext.issue_types)
{
issues.Add(issue.issue_title);
issueType_combo.Items.Add(issue.issue_title);
}
}
issueType_combo.SelectedIndex = 0;
}
public Boolean reminderEnabled(int issueId, int userId)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
reminder rem = dbContext.reminders.SingleOrDefault(r => r.reminder_issue_id == issueId && r.reminder_user_id == userId);
if (rem != null && rem.reminder_enabled == true)
{
return(true);
}
else
{
return(false);
}
}
}
public int saveIssue(issue i)
{
try
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
dbContext.issues.Add(i);
dbContext.SaveChanges();
return(1);
}
}
catch
{
return(0);
}
}
public void updateIssueData(int issueId, string description, string name, string id, string tel, int issueTypeId)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
issue isue = dbContext.issues.SingleOrDefault(i => i.issue_id == issueId);
if (isue != null)
{
isue.issue_description = description;
isue.issuer_name = name;
isue.issuer_id = id;
isue.issuer_tel = tel;
isue.issue_type_id = issueTypeId;
dbContext.SaveChanges();
}
}
}
public Boolean db_connection_available()
{
try
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
dbContext.Database.Connection.Open();
dbContext.Database.Connection.Close();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public int verified(String username)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
ud = dbContext.users.Where(u => u.user_username.Equals(username)).FirstOrDefault <user>();
try
{
if (ud.user_approved == true)
{
return(1);
}
}
catch (Exception) { return(2); }
return(0);
}
}
public List <issue> searchIssue(string searchText)
{
List <issue> issues = new List <issue>();
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
//issues = dbContext.issues.Where(i => SqlFunctions.PatIndex(searchText, i.issue_title) > 0).ToList();
issues = (from i in dbContext.issues where (i.issue_title.Contains(searchText) || i.issue_description.Contains(searchText)) select i).ToList();
/*foreach (issue i in dbContext.issues)
* {
* if(SqlFunctions.PatIndex(i.issue_title, searchText) > 0)
* {
* issues.Add(i);
* }
* }*/
}
return(issues);
}
public void saveReminder(int issueId, int userId, DateTime date, bool status)
{
using (var dbContext = new Service_Requests_Data_GOVEntities())
{
reminder re = dbContext.reminders.SingleOrDefault(r => r.reminder_issue_id == issueId && r.reminder_user_id == userId);
if (re == null)
{
reminder remind = new reminder();
remind.reminder_issue_id = issueId;
remind.reminder_user_id = userId;
remind.remider_date = date;
remind.reminder_enabled = status;
dbContext.reminders.Add(remind);
dbContext.SaveChanges();
}
else
{
updateReminder(issueId, userId, date, status);
}
}
}
