private user Authenticate(string username, string password)
{
using (emedEntities db = new emedEntities())
{
return(db.users.FirstOrDefault(u => u.username == username && u.password == password));
}
}
private template GetTemplate(int id)
{
using (emedEntities db = new emedEntities())
{
return(db.templates.FirstOrDefault(t => t.template_id == id));
}
}
void UpdateCart(temp_service tempService)
{
var result = InitServicePreview();
if (comboServices.Text == string.Empty)
{
txtCode.Text = string.Empty;
txtPrice.Text = string.Empty;
MessageBox.Show("Please select a service from drop down", "Message");
}
else
{
MessageBox.Show(Convert.ToString(result.service_id));
using (emedEntities db = new emedEntities())
{
//_editItemFromCart.creator_id = StartPage._loggedInUser.user_id;
//_editItemFromCart.service_id = result.service_id;
//_editItemFromCart.price = result.price;
//db.Entry(tempService).State = EntityState.Modified;
//db.SaveChanges();
//MessageBox.Show("Service Updated Successfully!", "Message");
//Close();
var cart = db.temp_service.Find(_editItemFromCart.temp_service_id);
cart.creator_id = StartPage._loggedInUser.user_id;
cart.service_id = result.service_id;
cart.price = result.price;
db.SaveChanges();
MessageBox.Show("Updated Successfully!", "Message");
Close();
}
}
}
private void ServiceCart_Load(object sender, EventArgs e)
{
isLoaded = true;
dbHelper = new emedEntities();
InitEditItemToControl();
LoadServiceCatlog();
}
private static List <PatientCartDto> LoadCartToGridView(int patientId)
{
var patientCart = new List <PatientCartDto>();
using (emedEntities db = new emedEntities())
{
patientCart = (
from t in db.temp_service
join u in db.users on t.creator_id equals u.user_id
join s in db.services on t.service_id equals s.service_id
join sc in db.service_catalog on s.service_catalog_id equals sc.service_catalog_id
where t.patient_id == patientId
select new PatientCartDto
{
Id = t.temp_service_id,
Code = s.code,
ServiceDescription = s.description,
ServiceType = sc.name,
CreatorName = u.firstname,
Price = t.price,
Quantity = t.quantity
}).ToList();
}
return(patientCart);
}
private service GetServiceNameList(string serviceName)
{
using (emedEntities db = new emedEntities())
{
return(db.services.FirstOrDefault(s => s.description == serviceName));
}
}
private void Invoice_Load(object sender, EventArgs e)
{
dbHelper = new emedEntities();
LoadCurrentPatientBills();
InitTotalBill();
//CalculateTotalAmountInCart(_curentPatient.patient_id);
}
private qm_sop SearchDocument(string title)
{
using (emedEntities db = new emedEntities())
{
return(db.qm_sop.FirstOrDefault(q => q.title == title));
}
}
private void ReadChild(qm_tree item, List <TreeNode> childNodes, List <qm_tree> items, Tree tree)
{
emedEntities db = new emedEntities();
if (item != null && item.childs != null)
{
foreach (string n in item.childs.Split(','))
{
qm_tree current_tree = items.FirstOrDefault(t => t.title == n);
List <TreeNode> current_childNodes = new List <TreeNode>();
if (current_tree == null)
{
continue;
}
List <qm_sop> documentInNode = db.qm_sop.Where(sop => sop.qm_tree_id == current_tree.qm_tree_id && sop.status.Value == 1).ToList();
ReadDocument(documentInNode, current_childNodes);
ReadChild(current_tree, current_childNodes, items, null);
TreeNode temp = new TreeNode(n, current_childNodes.ToArray());
string parentIcon = @"C:\Users\iME\Documents\MyProj\FinalProject\Icons\folder_open.png";
registerIcon(parentIcon);
temp.ImageKey = parentIcon;
temp.Tag = current_tree;
childNodes.Add(temp);
}
}
}
private void CreateFolder()
{
bool isChildNode = false;
if (selectedNode.Text.ToLower() != "qualitymanagementsystem" || selectedNode == null)
{
qm_tree current_tree = db.qm_tree.FirstOrDefault(tree => tree.title == selectedNode.Text);
if (current_tree.childs == null)
{
current_tree.childs = txtFolderName.Text;
}
else
{
current_tree.childs = current_tree.childs + "," + txtFolderName.Text;
}
db.SaveChanges();
isChildNode = true;
Close();
}
TreeNode node = new TreeNode();
tree.title = txtFolderName.Text;
tree.created_at = DateTime.Now;
tree.creator_id = StartPage._loggedInUser.user_id;
tree.isChild = isChildNode;
using (emedEntities db = new emedEntities())
{
db.qm_tree.Add(tree);
db.SaveChanges();
MessageBox.Show("Added Successfully!");
}
Close();
}
/*private void LoadUserTimeRecording(user selectedUser)
* {
* var yesterday = DateTime.Now.Date;
* selectedUser = GetUserTimeRecording(toolStripComboSelectUser.Text);
* var entry = dbHelper.time_recording.Where(t => t.user_id == selectedUser.user_id && t.created_at > yesterday).ToList();
* if(entry.Count == 0)
* {
* btnClockIn.Enabled = true;
* dataGridView1.DataSource = null;
* return;
* }
* else
* {
* btnClockIn.Enabled = false;
* dataGridView1.DataSource = entry.ToList();
* }
* }*/
private void btnClockIn_Click(object sender, EventArgs e)
{
if (toolStripComboSelectUser.Text == string.Empty)
{
MessageBox.Show("Please select a user", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Convert.ToDateTime(dateTimePicker1.Text) > DateTime.Now)
{
MessageBox.Show("This is a future date", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var selectedUser = GetUserTimeRecording(toolStripComboSelectUser.Text);
using (emedEntities db = new emedEntities())
{
time_recording tr = new time_recording();
tr.creator_id = StartPage._loggedInUser.user_id;
tr.user_id = selectedUser.user_id;
tr.state = 1;
tr.created_at = DateTime.Now;
tr.date_from = Convert.ToDateTime(dateTimePicker1.Text);
tr.trt_id = 1;
db.time_recording.Add(tr);
db.SaveChanges();
btnClockIn.Enabled = false;
MessageBox.Show("You have clocked in", "Message");
//LoadUserTimeRecording(selectedUser);
LoadUserAttendance(selectedUser);
}
}
}
private void UpdateUserSetting(user user)
{
user.firstname = txtFirstName.Text.Trim();
user.lastname = txtLastName.Text.Trim();
user.skin_name = comboBoxStyle.Text.Trim();
user.password = txtPassword.Text.Trim();
user.confirm_password = txtConfirmPassword.Text.Trim();
var passwordValid = PaswordChecker(user.password, user.confirm_password);
if (!passwordValid)
{
MessageBox.Show("Password is not valid or does not match", "Error");
}
else
{
using (emedEntities db = new emedEntities())
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("User Preference Saved Successfully", "Message");
Close();
UserLookAndFeel.Default.SetSkinStyle(comboBoxStyle.Text);
}
}
}
//Load Data :TODO
private void RefreshData()
{
emedEntities db = new emedEntities();
List <user> users = db.users.ToList();
UserAccountControl.fromUserAccountControl.dataGridView1.DataSource = users;
}
private IEnumerable <service> Search2(int favourite = 0)
{
using (emedEntities db = new emedEntities())
{
return(db.services.Where(s => s.isFavourite.Value == favourite).ToList());
}
}
private void PatientDashboard_Load(object sender, EventArgs e)
{
isLoaded = true;
dbHelper = new emedEntities();
RefreshCaseNoteGrid();
fromPatientDash = this;
}
private service_catalog GetServiceCatalogName(string serviceCatalogname)
{
using (emedEntities db = new emedEntities())
{
return(db.service_catalog.FirstOrDefault(s => s.name == serviceCatalogname));
}
}
private IEnumerable <service> Search(string name)
{
using (emedEntities dbHelper = new emedEntities())
{
return(dbHelper.services.Where(s => s.code.Contains(name)).ToList());
}
}
public void LoadServiceCatalog()
{
using (emedEntities db = new emedEntities())
{
dataGridView1.DataSource = db.service_catalog.ToList();
}
}
private List <service_catalog> GetServiceCatalog()
{
using (emedEntities db = new emedEntities())
{
return(db.service_catalog.ToList());
}
}
private List <messaging> GetMessagingEmailConfig()
{
using (emedEntities db = new emedEntities())
{
return(db.messagings.ToList());
}
}
public void RefreshData()
{
emedEntities db = new emedEntities();
List <messaging> msg = db.messagings.ToList();
dataGridViewEmailConfig.DataSource = msg;
}
void Clockout()
{
var result = GetUserTimeRecord(new time_recording());
if (result == null)
{
MessageBox.Show("No user selected or user not clocked in", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (emedEntities db = new emedEntities())
{
var data = db.time_recording.Find(result.tc_id);
data.date_to = DateTime.Now;
TimeSpan hours = (data.date_to - data.date_from).Value;
time_recording_details trd = new time_recording_details();
trd.tc_id = data.tc_id;
trd.user_id = data.user1.user_id;
trd.created_at = DateTime.Now;
trd.duration2 = (long)hours.TotalMinutes;
data.time_recording_details.Add(trd);
db.SaveChanges();
MessageBox.Show("You have successfully clocked out!", "Message");
LoadUserAttendance(data.user1);
}
}
}
private List <category> Search(string name, string acronym)
{
using (emedEntities db = new emedEntities())
{
return(db.categories.Where(c => c.name.Contains(name) || c.acronym.Contains(acronym)).ToList());
}
}
public void PopulateTree()
{
treeViewQMS.Nodes.Clear();
using (emedEntities db = new emedEntities())
{
var q = (from i in db.qm_tree
select i);
TreeNode treeNode = new TreeNode("QualityManagementSystem");
treeViewQMS.Nodes.Add(treeNode);
this.treeViewQMS.SelectedNode = this.treeViewQMS.Nodes[0];
foreach (var item in q)
{
if (item.isChild.Value)
{
continue;
}
List <TreeNode> childNodes = new List <TreeNode>();
ReadChild(item, childNodes, q.ToList(), null);
TreeNode nodes = new TreeNode(item.title, childNodes.ToArray());
nodes.Tag = item;
treeNode.Nodes.Add(nodes);
}
}
}
private void Delete()
{
//Get selected row from user
//Delete related services in service catalog if any
//delete service catalog
if (dataGridView1.CurrentRow.Index != -1)
{
serviceCatalog.service_catalog_id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["service_catalog_id"].Value);
serviceCatalog.name = Convert.ToString(dataGridView1.CurrentRow.Cells["name"].Value);
if (MessageBox.Show($"Are you sure you want to delete {serviceCatalog.name} with its related services?. Proceed with caution", "Delete Service Catalog", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DeleteServiceRelatedToServiceCatalog();
using (emedEntities db = new emedEntities())
{
var result = db.Entry(serviceCatalog);
if (result.State == EntityState.Detached)
{
db.service_catalog.Attach(serviceCatalog);
}
db.service_catalog.Remove(serviceCatalog);
db.SaveChanges();
MessageBox.Show("Service Catalog Deleted Successfully", "Message");
}
LoadServiceCatalog();
RefreshDGVService();
}
}
}
private List <department> Department()
{
using (emedEntities db = new emedEntities())
{
return(db.departments.ToList());
}
}
private List <user> Search(string firstname, string lastname)
{
using (emedEntities db = new emedEntities())
{
return(db.users.Where(u => u.firstname.Contains(firstname) || u.lastname.Contains(lastname)).ToList());
}
}
private void TakeAttendance_Load(object sender, EventArgs e)
{
// isLoaded = true;
dbHelper = new emedEntities();
LoadUsers();
//LoadUserTimeRecording(1);
}
public void RefreshDGVService()
{
List <service> list = GetServiceFromServiceCatalog();
using (emedEntities db = new emedEntities())
{
dataGridViewService.DataSource = list;
}
}
private void UserAccount_Load(object sender, EventArgs e)
{
foreach (SkinContainer cn in SkinManager.Default.Skins)
{
comboBoxStyle.Items.Add(cn.SkinName);
}
//LoadUserDept(_editUserHelper.user_id);
db = new emedEntities();
LoadUserDept();
}
