public void PopulateViewOnlyControls(string data) { using (AccetManagementEntities db = new AccetManagementEntities()) { var empDetails = db.EMPLOYEETABLEs.Where(c => c.EMPID == data).ToList(); txtFname.Text = empDetails[0].FNAME; txtLname.Text = empDetails[0].LNAME; txtWorkno.Text = empDetails[0].WORKPHONE; txtPhone.Text = empDetails[0].MOBILEPHONE; txtEmail.Text = empDetails[0].EMAIL; txtpersonalNumber.Text = data; //var statusId = db.STATUS.Where(c => c.STATUSNAME == currentStatus).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var titleId = empDetails[0].TITLEID; var dd = db.ORGANIZATIONROLEs.Where(e => e.TITLEID == titleId).Select(e => e.TITLE).ToList(); cmbTitle.Text = dd[0].ToString(); var groupId = empDetails[0].GROUPID; var gg = db.ORGANIZATIONGROUPs.Where(a => a.GROUPID == groupId).Select(a => a.GROUPNAME).ToList(); cmbGroup.Text = gg[0].ToString(); var eStatusid = empDetails[0].STATUSID; var emstatusid = db.EMPLOYEESTATUS.Where(a => a.ID == eStatusid).Select(a => a.EMPSTATUSNAME).ToList(); cmbStatus.Text = emstatusid[0].ToString(); CommonData.SelectedEmpId = data; CommonData.Fname = txtFname.Text; CommonData.Lname = txtLname.Text; CommonData.WorkNO = txtWorkno.Text; CommonData.MobileNO = txtWorkno.Text; CommonData.Email = txtEmail.Text; CommonData.Statusid = cmbStatus.Text; CommonData.GroupId = cmbGroup.Text; CommonData.TitleId = cmbTitle.Text; CommonData.PersonalNumber = data; this.Text = "Edit Employee " + data; string fileName = db.EMPLOYEEIMAGEs.Where(f => f.EMPIMAGEID == data).Select(f => f.FILEPATH).FirstOrDefault(); if (fileName != null) { pictureBox1.Image = ResizeImage(Image.FromFile(fileName), this.Width, this.Height); } txtFname.Enabled = false; txtLname.Enabled = false; txtWorkno.Enabled = false; txtPhone.Enabled = false; txtEmail.Enabled = false; txtpersonalNumber.Enabled = false; } }
private void HistoryToolStripMenuItem_Click(object sender, EventArgs e) { dgvChqInOut.Visible = false; dgvHistory.Visible = true; dgvHistory.DataSource = null; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvHistory.AutoGenerateColumns = false; //dgvHistory.DataSource = db.VIEWCHECKOUTs.where(a => a.ASS).ToList<VIEWCHECKOUT>(); dgvHistory.DataSource = db.VIEWCHECKOUTs.Where(a => a.PERSONALNO == CommonData.PersonalNumber).ToList <VIEWCHECKOUT>(); } chqOut1.Hide(); }
private void AsseetCheckedOutToolStripMenuItem_Click(object sender, EventArgs e) { dgvHistory.Visible = false; dgvChqInOut.Visible = true; //historyControl1.Hide(); dgvChqInOut.DataSource = null; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvChqInOut.AutoGenerateColumns = false; //dgvChqInOut.DataSource = db.VIEWCHECKOUTsearches.ToList<VIEWCHECKOUTsearch>(); dgvChqInOut.DataSource = db.VIEWEMPCHECKOUTLISTs.Where(a => a.EMPID == CommonData.PersonalNumber).ToList <VIEWEMPCHECKOUTLIST>(); } chqOut1.Show(); chqOut1.BringToFront(); dgvChqInOut.BringToFront(); }
private void LoadCombobox() { //Clear combobox items first cmbTitle.Items.Clear(); cmbGroup.Items.Clear(); cmbStatus.Items.Clear(); //get the items from db using (AccetManagementEntities db = new AccetManagementEntities()) { var titlequery = db.ORGANIZATIONROLEs .Select(e => e.TITLE).ToList(); cmbTitle.DataSource = titlequery; var groupquery = db.ORGANIZATIONGROUPs .Select(a => a.GROUPNAME).ToList(); cmbGroup.DataSource = groupquery; var statusquery = db.EMPLOYEESTATUS .Select(a => a.EMPSTATUSNAME).ToList(); cmbStatus.DataSource = statusquery; } }
void SaveToDatabase() { try { using (AccetManagementEntities db = new AccetManagementEntities()) { var titleId = db.ORGANIZATIONROLEs.Where(c => c.TITLE == cmbTitle.Text).Select(c => c.TITLEID).ToList(); var groupId = db.ORGANIZATIONGROUPs.Where(c => c.GROUPNAME == cmbGroup.Text).Select(c => c.GROUPID).ToList(); var statusId = db.EMPLOYEESTATUS.Where(c => c.EMPSTATUSNAME == cmbStatus.Text).Select(c => c.ID).ToList(); // Save Image //save Picture var pathe = CommonData.EMPFilename ?? ""; var checkIfEmployeeExists = db.EMPLOYEETABLEs.SingleOrDefault(c => c.EMPID == txtpersonalNumber.Text.ToString().Trim()); if (checkIfEmployeeExists == null) { List <Employee> employees = new List <Employee> { new Employee() { EmpId = txtpersonalNumber.Text.ToString().Trim(), Fname = txtFname.Text.ToString().Trim().ToUpper(), Lname = txtLname.Text.ToString().Trim().ToUpper(), Workno = txtWorkno.Text.ToString().Trim(), MobilePhone = txtPhone.Text.ToString().Trim().ToUpper(), Email = txtEmail.Text.ToString().Trim(), Statusid = statusId[0], GROUPID = groupId[0], TITLEID = titleId[0], IMAGEID = 1 } }; saveEmp.SaveMember(employees); if (pictureBox1.Image != null) { EMPLOYEEIMAGE eMPLOYEEIMAGE = new EMPLOYEEIMAGE { EMPIMAGEID = txtpersonalNumber.Text.ToString().Trim(), FILEPATH = pathe }; db.EMPLOYEEIMAGEs.Add(eMPLOYEEIMAGE); } } else { var empImage = db.EMPLOYEEIMAGEs.SingleOrDefault(x => x.EMPIMAGEID == txtpersonalNumber.Text.ToString().Trim()); var fileNamePth = pathe; if (empImage == null) { if (pictureBox1.Image != null) { EMPLOYEEIMAGE employeeImage = new EMPLOYEEIMAGE { EMPIMAGEID = txtpersonalNumber.Text.ToString().Trim(), FILEPATH = pathe }; db.EMPLOYEEIMAGEs.Add(employeeImage); } } else { empImage.EMPIMAGEID = txtpersonalNumber.Text.ToString().Trim(); empImage.FILEPATH = fileNamePth; } checkIfEmployeeExists.EMAIL = txtEmail.Text.ToString().Trim(); checkIfEmployeeExists.EMPID = txtpersonalNumber.Text.ToString().Trim(); checkIfEmployeeExists.FNAME = txtFname.Text.ToString().Trim().ToUpper(); checkIfEmployeeExists.GROUPID = groupId[0]; checkIfEmployeeExists.IMAGEID = 1; checkIfEmployeeExists.LNAME = txtLname.Text.ToString().Trim().ToUpper(); checkIfEmployeeExists.MOBILEPHONE = txtPhone.Text.ToString().Trim().ToUpper(); checkIfEmployeeExists.STATUSID = statusId[0]; checkIfEmployeeExists.TITLEID = titleId[0]; checkIfEmployeeExists.WORKPHONE = txtWorkno.Text.ToString().Trim(); } db.SaveChanges(); //db.EMPLOYEETABLEs.Add(employeeTable); //db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart(); } } catch (Exception) { throw; } }