private void button_Click(object sender, RoutedEventArgs e) { //if (textusername.Text == "user" && textpassword.Text == "pass123") //{ // Window1 w1 = new Window1(); // this.Hide(); // w1.Show(); //} EmployeeDB db = new EmployeeDB(); IEnumerable <string> productNames = from p in db.User select p.UserName; MessageBox.Show(productNames.ToString()); //if (textusername.Text != string.Empty || textpassword.Text != string.Empty) //{ // var user = db.User.FirstOrDefault(a => a.UserName.Equals(textusername.Text)); // if (user != null) // { // if (user.Password.Equals(textpassword.Text)) // { // Window1 w1 = new Window1(); // this.Hide(); // w1.Show(); // } // } // MessageBox.Show(user.UserName); //} }
public void Initialize() { var builder = new DbContextOptionsBuilder(); _ = builder.UseInMemoryDatabase("AddMultipleEmployees"); employeeDB = new EmployeeDB(new EmployeeContext()); }
public ActionResult Create(Employee employee) { employee.Type = EmployeeTypeDB.GetInstance().FindEmployeeType(employee.Type.Id); employee.Status = EmployeeStatusDB.GetInstance().FindEmployeeStatus(employee.Status.Id); EmployeeDB.GetInstance().AddEmployee(employee); return(Redirect("Index")); }
public AdminViewModel(Page page) : base(page) { Title = "Employee Roll Check Admin"; AdminData = new ObservableCollection<AdminModel>(); EmpDb = new EmployeeDB(); }
public ActionResult Employee(string firstName, string lastName, string emailAddress, DateTime dateOfBirth, string title, double salary, string worksRemotely) { if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress) || string.IsNullOrEmpty(title) || string.IsNullOrEmpty(worksRemotely)) { return(View("~/Views/Shared/Error.cshtml")); } else { using (var db = new EmployeeDB()) { var employee = new MyEntity(); employee.FirstName = firstName; employee.LastName = lastName; employee.EmailAddress = emailAddress; employee.DateOfBirth = dateOfBirth; employee.Title = title; employee.Salary = Convert.ToDouble(salary); employee.WorksRemotely = CheckBool(worksRemotely); db.MyEntities.Add(employee); db.SaveChanges(); } return(View("Success")); } }
public int lastIDPlusOne() { employee = new Employee(); employeeDB = new EmployeeDB(); employeeDB.selectLastID(employee); return(employee.getID() + 1); }
public void fillListViewForEvaluation(ListView listView, string sourceName, string dateFrom, string dateTo) { listView.Items.Clear(); locationControl = new LocationControl(); sourceControl = new SourceControl(); employee = new Employee(); employeeDB = new EmployeeDB(); connection = new DBConnection(); int sourceID = sourceControl.selectID(sourceName); employee.setSourceID(sourceID); employee.setDateFrom(dateFrom); employee.setDateTo(dateTo); SqlDataReader reader = employeeDB.fillListViewRelatedToSource(employee); while (reader.Read()) { ListViewItem lvi = new ListViewItem(reader["ID"].ToString()); lvi.SubItems.Add(reader["name"].ToString()); lvi.SubItems.Add(reader["position"].ToString()); int locationID = int.Parse(reader["locationID"].ToString()); string locationName = locationControl.getLocationName(locationID); lvi.SubItems.Add(locationName); listView.Items.Add(lvi); } connection.close(); }
public IEnumerable <AngEmployee> Get() { using (EmployeeDB entites = new EmployeeDB()) { return(entites.AngEmployees.ToList()); } }
protected void Page_Load(object sender, EventArgs e) { Label2.Visible = false; lblDiasAcumulados.Visible = false; if (Session["ID"] != null) { int id = Convert.ToInt32(Session["ID"]); EmployeeDB bd = new EmployeeDB(); Employee employee = bd.Select(id); if (!IsAdmin(employee.Type)) { Response.Redirect("../ErrorPages/AccessDanied.aspx"); } else { lblMensage.Text = "Bem-vindo, " + employee.Name; LoadCharts(); if (!Page.IsPostBack) { LoadFinishedBudgets(); //string orcamento_id = ddlFinishedBudgets.SelectedItem.Value; //LoadLeadTimeKpi(orcamento_id); } //possivel solucao eh chamar o metodo aqui e esquecer o botao, ai faz o post } } else { Response.Redirect("../ErrorPages/AccessDanied.aspx"); } }
private void button1_Click(object sender, EventArgs e) { lbError.Text = ""; string EmpID = txtEmpID.Text; string pass = txtPassword.Text; EmployeeDB db = new EmployeeDB(); string role = db.CheckLogin(EmpID, pass); if (role == "") { lbError.Text = "Sorry, this account is not exist!"; } else if (role == "admin") { this.Hide(); frmMaintainBooks frm = new frmMaintainBooks(); frm.ShowDialog(); } else if (role == "employee") { this.Hide(); Employee ee = new Employee() { EmpID = EmpID, EmpPassword = pass }; frmChangeAccount frm = new frmChangeAccount(ee); frm.ShowDialog(); } }
public AdminViewModel(Page page) : base(page) { Title = "Employee Roll Check Admin"; AdminData = new ObservableCollection <AdminModel>(); EmpDb = new EmployeeDB(); }
public bool Update(EmployeeDB employee) { try { using (Employee_RecoredEntities db = new Employee_RecoredEntities()) { Employee item = (from x in db.Employees where x.Id == employee.Id select x).FirstOrDefault(); if (item == null) { return(false); } item.EmpName = employee.EmpName; item.Email = employee.Email; item.DateofBirth = employee.DateofBirth; item.Phone = employee.Phone; item.Gender = employee.Gender; item.Address = employee.Address; item.City = employee.City; item.Department = employee.Department; item.Salary = employee.Salary; item.JoiningDate = employee.JoiningDate; db.SaveChanges(); return(true); } } catch (Exception) { throw; } }
public ActionResult Edit(Employee employee) { ///Update employee employee.Type = EmployeeTypeDB.GetInstance().FindEmployeeType(employee.Type.Id); EmployeeDB.GetInstance().UpdateEmployee(employee); return(Redirect("Index")); }
private void btnLogin_Click(object sender, EventArgs e) { string id = txtEmID.Text; string pass = txtEmPass.Text; EmployeeDB edb = new EmployeeDB(); Employee em = edb.Login(id, pass); if (em == null) { MessageBox.Show("Wrong ID or Password"); } else { if (em.EmpRole == false) { frmChangeAccount change = new frmChangeAccount(em); this.Hide(); change.ShowDialog(); this.Show(); } else { frmMaintainBook main = new frmMaintainBook(); this.Hide(); main.ShowDialog(); this.Show(); } } }
public HttpResponseMessage Put([FromBody] Employee emp) { try { using (EmployeeDB db = new EmployeeDB()) { var employee = db.Employees.FirstOrDefault(x => x.ID == emp.ID); if (employee == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The Employee is not found")); } else { employee.FirstName = emp.FirstName; employee.LastName = emp.LastName; employee.Gender = emp.Gender; employee.Salary = emp.Salary; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "The Employee with ID " + emp.ID.ToString() + " is modified successfully")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));; } }
private void button1_Click(object sender, EventArgs e) { //<connectionStrings> // <add name="TestDBContext" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=E:\Backup_100916\VS2013\EFTest\EFTest\DB\Sample.mdf;Integrated Security=True" providerName="System.Data.SqlClient" /> //</connectionStrings> //AppDomain.CurrentDomain.SetData("DataDirectory", @"c:\users\tridip.bbakolkata\documents\visual studio 2013\Projects\EFTest\EFTest"); //Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AG.mdf;Database=AG;Integrated Security=True;User Instance=True;Trusted_Connection=Yes AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory + "App_Data"); EmployeeDB db = new EmployeeDB(); var data = db.Employees.ToList(); /* good way to find parent directory*/ //string dataDir = AppDomain.CurrentDomain.BaseDirectory; //if (dataDir.EndsWith(@"\bin\Debug\") // || dataDir.EndsWith(@"\bin\Release\")) //{ // dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName; // AppDomain.CurrentDomain.SetData("DataDirectory", dataDir); //} }
// PUT api/employee/5 //public void Put(int id, [FromBody]EmployeeModel employee) //{ // try // { // using (var empDbContext = new EmployeeDB()) // { // var employeeList = empDbContext.emps.ToList(); // var employeeToBeUpdated = employeeList.Find(x => x.empno == id); // emp emp = AdaptToDBEntity(employee); // employeeToBeUpdated.ename = emp.ename; // employeeToBeUpdated.hiredate = emp.hiredate; // employeeToBeUpdated.job = emp.job; // employeeToBeUpdated.sal = emp.sal; // empDbContext.emps.AddOrUpdate(employeeToBeUpdated); // empDbContext.SaveChanges(); // } // } // catch (Exception e) // { // Console.WriteLine(e); // throw; // } //} //public HttpResponseMessage Put(int id, [FromBody]EmployeeModel employee) //{ // try // { // using (var empDbContext = new EmployeeDB()) // { // var employeeList = empDbContext.emps.ToList(); // var employeeToBeUpdated = employeeList.Find(x => x.empno == id); // emp emp = AdaptToDBEntity(employee); // employeeToBeUpdated.ename = emp.ename; // employeeToBeUpdated.hiredate = emp.hiredate; // employeeToBeUpdated.job = emp.job; // employeeToBeUpdated.sal = emp.sal; // empDbContext.emps.AddOrUpdate(employeeToBeUpdated); // empDbContext.SaveChanges(); // return Request.CreateResponse(HttpStatusCode.Accepted); // } // } // catch (Exception e) // { // Console.WriteLine(e); // return Request.CreateErrorResponse(HttpStatusCode.BadRequest, e); // } //} public IHttpActionResult Put(int id, [FromBody] EmployeeModel employee) { try { using (var empDbContext = new EmployeeDB()) { var employeeList = empDbContext.emps.ToList(); var employeeToBeUpdated = employeeList.Find(x => x.empno == id); emp emp = AdaptToDBEntity(employee); employeeToBeUpdated.ename = emp.ename; employeeToBeUpdated.hiredate = emp.hiredate; employeeToBeUpdated.job = emp.job; employeeToBeUpdated.sal = emp.sal; empDbContext.emps.AddOrUpdate(employeeToBeUpdated); empDbContext.SaveChanges(); return(Ok()); } } catch (Exception e) { Console.WriteLine(e); return(Content(HttpStatusCode.BadRequest, e)); } }
private void ListEmployeeReport() { try { grdList.Rows.Clear(); EmployeeDB empdb = new EmployeeDB(); List <employee> emplist = empdb.getEmployees(); foreach (employee mh in emplist) { grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["mSerialNo"].Value = grdList.Rows.Count; grdList.Rows[grdList.RowCount - 1].Cells["mEmployeeID"].Value = mh.empID; grdList.Rows[grdList.RowCount - 1].Cells["mEmpoyeeName"].Value = mh.empName; grdList.Rows[grdList.RowCount - 1].Cells["mOffice"].Value = mh.office; grdList.Rows[grdList.RowCount - 1].Cells["mReportingOfficer"].Value = mh.reportingofficer; grdList.Rows[grdList.RowCount - 1].Cells["mDesignation"].Value = mh.designation; grdList.Rows[grdList.RowCount - 1].Cells["mDepartment"].Value = mh.department; } if (grdList.Rows.Count != 0) { btnExportToExcell.Visible = true; } else { btnExportToExcell.Visible = false; } } catch (Exception ex) { MessageBox.Show("Error in PR Listing"); } setButtonVisibility("init"); pnlList.Visible = true; }
private static void Main() { // Db setup var db = new EmployeeDB(); // Add some employees db.AddEmployee(new Employee("Anne", 3000, 51)); db.AddEmployee(new Employee("Berit", 4000, 25)); db.AddEmployee(new Employee("Christel", 1000, 37)); // Setup compile var compiledDb = new CompileDB(db); var reportGenerator = new ReportGenerator(compiledDb); //Default (name-first) report reportGenerator.GenerateReport(); Console.WriteLine(""); Console.WriteLine(""); // Create a salary-first report reportGenerator.SetOutputFormat(ReportOutputFormatType.SalaryFirst); reportGenerator.GenerateReport(); Console.WriteLine(""); Console.WriteLine(""); // Create an age-first report reportGenerator.SetOutputFormat(ReportOutputFormatType.AgeFirst); reportGenerator.GenerateReport(); Console.ReadLine(); }
// GET api/employee/5 //public EmployeeModel GetEmployee(int id) //{ // try // { // using (var empDbContext = new EmployeeDB()) // { // var employeeList = empDbContext.emps.ToList(); // List<EmployeeModel> employees = AdaptToEmployeeModel(employeeList); // if (employees != null) // { // return employees.Find(x => x.EmpId == id); // } // return null; // } // } // catch (Exception e) // { // Console.WriteLine(e); // throw; // } //} //public HttpResponseMessage GetEmployee(int id) //{ // try // { // using (var empDbContext = new EmployeeDB()) // { // var employeeList = empDbContext.emps.ToList(); // List<EmployeeModel> employees = AdaptToEmployeeModel(employeeList); // var employee = employees?.Find(x => x.EmpId == id); // if (employee != null) // { // return Request.CreateResponse(HttpStatusCode.OK, employee); // } // return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id = " + id + " not found"); ; // } // } // catch (Exception e) // { // Console.WriteLine(e); // return Request.CreateErrorResponse(HttpStatusCode.BadRequest, e); // } //} public IHttpActionResult GetEmployee(int id) { try { using (var empDbContext = new EmployeeDB()) { var employeeList = empDbContext.emps.ToList(); List <EmployeeModel> employees = AdaptToEmployeeModel(employeeList); var employee = employees?.Find(x => x.EmpId == id); if (employee != null) { return(Ok(employee)); } // return NotFound(); // For giving custom message use the below return return(Content(HttpStatusCode.NotFound, "Employee with id = " + id + " not found")); } } catch (Exception e) { Console.WriteLine(e); // return BadRequest(); return(Content(HttpStatusCode.BadRequest, e)); } }
public EmployeeDB Insert(EmployeeDB employee) { try { Employee emp = new Employee(); emp.EmpName = employee.EmpName; emp.Email = employee.Email; emp.DateofBirth = employee.DateofBirth; emp.Phone = employee.Phone; emp.Gender = employee.Gender; emp.Address = employee.Address; emp.City = employee.City; emp.Department = employee.Department; emp.Salary = employee.Salary; emp.JoiningDate = employee.JoiningDate; using (Employee_RecoredEntities db = new Employee_RecoredEntities()) { db.Employees.Add(emp); db.SaveChanges(); } employee.Id = emp.Id; return(employee); } catch (Exception ex) { Console.Write(ex.Message); throw; } }
public IEnumerable <EmployeeLog> GetEmployeeLog(string phone) { EmpDb = new EmployeeDB(); var dCurrent = DateTime.Now; var empsorted = new List <EmployeeLog>(); try { var IempLogs = EmpDb.GetEmployeeLogList(); var empDetails = EmpDb.GetEmployeeDetails(); var firstEmp = empDetails.FirstOrDefault(c => c.Phone == phone); var empId = firstEmp.Id; var empLogs = IempLogs.Where(c => c.EmpId == empId).ToList(); var emplogDetails = empLogs.Select(c => new EmployeeLog() { EmpID = c.EmpId, LogTime = Convert.ToDateTime(c.LogTime), LogType = c.LogType }).ToList(); empsorted = emplogDetails.OrderByDescending(c => c.LogTime.Value).ToList(); } catch (Exception ex) { string msg = ex.Message; } return(empsorted); }
protected void btnDelete_Click(object sender, EventArgs e) { Employee emp = new Employee(); if (!(EmployeeDB.IsDuplicateId(Convert.ToInt32(tbEmployeeId.Text)))) { if (Validation.IsValidName(tbFirstName.Text) && Validation.IsValidName(tbLastName.Text)) { emp.EmployeeId = Convert.ToInt32(tbEmployeeId.Text); emp.FirstName = tbFirstName.Text; emp.LastName = tbLastName.Text; emp.JobTitle = tbJobType.Text; emp.DeleteEmployee(emp); MessageBox.Show("Data Deleted,Thanks", "Confirmation"); tbEmployeeId.Text = tbFirstName.Text = tbLastName.Text = tbJobType.Text = null; } else { MessageBox.Show("Enter Valid Name", "Error"); } } else { MessageBox.Show("ID does not exist", "Error"); } }
public IHttpActionResult Post(List <EmployeeData> data) { string token = string.Empty; IEnumerable <string> headerValues; if (Request.Headers.TryGetValues("X-Fourth-Token", out headerValues)) { token = headerValues.FirstOrDefault(); } //Validate token string expirationDate = GetExpirationTime(token); DateTime expirationDateTime = DateTime.ParseExact(expirationDate, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); if (expirationDate != null && expirationDateTime < DateTime.Now) { return(Unauthorized()); } //Save EmployeeId and Time into DB foreach (EmployeeData item in data) { var db = new EmployeeDB(); db.Arrivals.Add(new Arrival { EmployeeID = item.EmployeeId, Time = item.When }); db.SaveChanges(); } return(Ok()); }
static void Main(string[] args) { string connectionString = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; var employeeDb = new EmployeeDB(connectionString); IList <EmployeeDetails> employeeList = employeeDb.GetEmployees(); foreach (var employeeDetailse in employeeList) { Console.WriteLine("\n\t{0} {1} {2}", employeeDetailse.TitleOfCourtesy, employeeDetailse.FirstName, employeeDetailse.LastName); } Console.ReadKey(); Console.Clear(); var employee = new EmployeeDetails() { FirstName = "Elizavete", LastName = "Ivanova", TitleOfCourtesy = "Ms" }; employeeDb.InsertEmployee(employee); foreach (var employeeDetailse in employeeDb.GetEmployees()) { Console.WriteLine("\n\t{0} {1} {2}", employeeDetailse.TitleOfCourtesy, employeeDetailse.FirstName, employeeDetailse.LastName); } }
public string getNationalID(int ID) { employee = new Employee(); employeeDB = new EmployeeDB(); employee.setID(ID); employeeDB.selectNationalID(employee); return(employee.getNationalID()); }
private void PopulateGridviewSearchResult() { DataTable searchResultsDataTable = EmployeeDB.GetEmployeeWithAddressBySearchCriteria(searchBy, searchString); gViewSearchResults.DataSource = searchResultsDataTable; gViewSearchResults.DataBind(); lblSearchResultCount.Text = "Search Results . . . . . Found " + searchResultsDataTable.Rows.Count + " row(s)."; }
public ActionResult DeleteConfirmed(int id) { EmployeeDB employeeDB = db.EmployeeDBs.Find(id); db.EmployeeDBs.Remove(employeeDB); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Load() { XmlSerializer serializer = new XmlSerializer(typeof(EmployeeDB)); FileStream stream = new FileStream(Application.dataPath + "/Saves/save.xml", FileMode.Open); employeeDB = serializer.Deserialize(stream) as EmployeeDB; stream.Close(); }
public string getPosition(int ID) { employee = new Employee(); employeeDB = new EmployeeDB(); employee.setID(ID); employeeDB.selectPosition(employee); return(employee.getPosition()); }
public EmployeeMainViewModel(IDevice device) : base(device) { Message = String.Format("Hello Xamarin Forms Labs MVVM Basics!! How is your {0} device", device.Manufacturer); Title = "Employee Roll Checker"; Message = "Employee Roll Check"; EmpDb = new EmployeeDB(); }
public EmployeeMainViewModel(Page page, string phone) : base(page) { Title = "Employee Roll Checker"; phoneNumber = phone; if(!string.IsNullOrEmpty(phoneNumber)) GetEmployeeDetails(phone); BtnName = login; EmpDb = new EmployeeDB(); }
public static void Clock(string phone, LogType logtype) { var EmpDb = new EmployeeDB(); var d = DateTime.Now; var clockTime = DateTimeSQLite.Value(d); var emp = EmpDb.GetEmployeeDetails().FirstOrDefault(c => c.Phone == phone); var log = new LogDetails() { EmpId = emp.Id, LogType = logtype.ToString(), LogTime = clockTime, }; EmpDb.AddEmployeeLog(log); }
static void Main(string[] args) { var db = new EmployeeDB(); // Add some employees db.AddEmployee(new Employee("Anne", 3000, 10)); db.AddEmployee(new Employee("Berit", 2000, 12)); db.AddEmployee(new Employee("Christel", 1000, 4)); var reportGenerator = new ReportGenerator(db); // Create a default (name-first) report reportGenerator.CompileReport(); Console.WriteLine(""); Console.WriteLine(""); // Create a salary-first report reportGenerator.CompileReport(); }
public EmployeeMainViewModel() { Title = "Employee Roll Checker"; Message = "Employee Roll Check"; EmpDb = new EmployeeDB(); }
public IEnumerable<EmployeeLog> GetEmployeeLog(string phone) { EmpDb = new EmployeeDB(); var dCurrent = DateTime.Now; var empsorted = new List<EmployeeLog>(); try { var IempLogs = EmpDb.GetEmployeeLogList(); var empDetails = EmpDb.GetEmployeeDetails(); var firstEmp = empDetails.FirstOrDefault(c => c.Phone == phone); var empId = firstEmp.Id; var empLogs = IempLogs.Where(c => c.EmpId == empId).ToList(); var emplogDetails = empLogs.Select(c => new EmployeeLog() { EmpID = c.EmpId, LogTime = Convert.ToDateTime(c.LogTime), LogType = c.LogType }).ToList(); empsorted = emplogDetails.OrderByDescending(c => c.LogTime.Value).ToList(); } catch (Exception ex) { string msg = ex.Message; } return empsorted; }