public ActionResult Create([Bind(Include = "Eid,Ename,ESal,EGen,EDOB,Did")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Did = new SelectList(db.Departments, "Did", "Dname", employee.Did); return(View(employee)); }
protected internal bool Insert(Employee emp) { try { OE.Employees.Add(emp); OE.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
protected internal bool Insert(Department dep) { try { OE.Departments.Add(dep); OE.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public void DeleteEmpliyee(string empid, string phone) { OrganizationEntities OE = new OrganizationEntities(); var employee = OE.EmployeeDetails.SingleOrDefault(x => x.EmployeeID == empid); OE.EmployeeDetails.Attach(employee); OE.EmployeeDetails.Remove(employee); OE.SaveChanges(); }
public void DeleteDepartment(string deptid, string empid) { OrganizationEntities OE = new OrganizationEntities(); var dept = OE.DepartmentDetails.SingleOrDefault(x => x.DepartmentID == deptid); OE.DepartmentDetails.Attach(dept); OE.DepartmentDetails.Remove(dept); OE.SaveChanges(); }
public void UpdateDepartment(string depid, string depname, int totalemployees) { OrganizationEntities OE = new OrganizationEntities(); var dept = OE.DepartmentDetails.SingleOrDefault(x => x.DepartmentID == depid); dept.DepartmentName = depname; dept.TotalEmployee = totalemployees; OE.SaveChanges(); }
public void AddNewEmployee(int empid, string empname, string emailId, int phone, int salary, string city) { OrganizationEntities NewOE = new OrganizationEntities(); var newEmp = new EmployeeDetail { EmployeeID = empid.ToString(), EmployeeName = empname, EmailID = emailId, Phone = phone.ToString(), Salary = Convert.ToInt32(salary), City = city }; NewOE.EmployeeDetails.Add(newEmp); NewOE.SaveChanges(); }
public void AddNewDepartment(string depid, string depname, int totalemployees, string empid) { OrganizationEntities NewOE = new OrganizationEntities(); var newDept = new DepartmentDetail { DepartmentID = depid, DepartmentName = depname, TotalEmployee = totalemployees, EmployeeID = empid }; NewOE.DepartmentDetails.Add(newDept); NewOE.SaveChanges(); }
public void UpdateEmployee(string empid, string empname, string emailId, string phone, int salary, string city) { OrganizationEntities OE = new OrganizationEntities(); var emp = OE.EmployeeDetails.SingleOrDefault(x => x.EmployeeID == empid); emp.EmployeeName = empname; emp.EmailID = emailId; emp.Phone = phone; emp.Salary = salary; emp.City = city; OE.SaveChanges(); }
protected internal bool Insert(string roleName) { try { AuthenticationLibrary.Model.Role obj = new AuthenticationLibrary.Model.Role(); obj.RoleName = roleName; OE.Roles.Add(obj); OE.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
protected internal bool Insert(string userName, string password) { try { AuthenticationLibrary.Model.User obj = new AuthenticationLibrary.Model.User(); obj.UserName = userName; obj.Password = password; OE.Users.Add(obj); OE.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
protected internal bool Insert(AuthenticationLibrary.Model.User user, AuthenticationLibrary.Model.Role role) { try { AuthenticationLibrary.Model.UserRole obj = new AuthenticationLibrary.Model.UserRole(); obj.Role = new AuthenticationLibrary.Model.Role { RoleId = role.RoleId, RoleName = role.RoleName }; obj.User = new AuthenticationLibrary.Model.User { UserId = user.UserId, Password = user.Password, UserName = user.UserName }; OE.UserRoles.Add(obj); OE.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }