private void SerializeCollection(string filename)
{
// Crear un Employee
Employees Emps = new Employees();
Emps.CollectionName = "Employees";
Employee John100 = new Employee("John", "100xxx");
Employee juan101 = new Employee("Juan", "101aa");
// Agrega un Employee a Employees
Emps.Add(John100);
Emps.Add(juan101);
// Serializa
XmlSerializer x = new XmlSerializer(Emps.GetType());
TextWriter writer = new StreamWriter(filename);
x.Serialize(Console.Out, Emps);
}
public Employees Save(Employees entity)
{
if(entity.Id ==0)
{
var ret = this.context.Employees.Add(entity);
this.context.SaveChanges();
return ret;
}else
{
var data = GetById(entity.Id);
data.Title = entity.Title;
data.FirstName = entity.FirstName;
data.LastName = entity.LastName;
data.BirthDate = entity.BirthDate;
data.HireDate = entity.HireDate;
data.Address = entity.Address;
data.City = entity.City;
data.Region = entity.Region;
data.Country = entity.Country;
data.PostalCode = entity.PostalCode;
data.HomePhone = entity.HomePhone;
data.Extentions = entity.Extentions;
data.Department = entity.Department;
data.ParentEmployee = entity.ParentEmployee;
data.Educations = entity.Educations;
data.Experiences = entity.Experiences;
data.Territories = entity.Territories;
this.context.SaveChanges();
return data;
}
}
internal void EditEmployee(Employees employee)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
var command = connection.CreateCommand();
command.Parameters.AddWithValue("@LastName", employee.LastName);
command.Parameters.AddWithValue("@FirstName", employee.FirstName);
command.Parameters.AddWithValue("@Title", employee.Title);
command.Parameters.AddWithValue("@TitleOfCourtesy", employee.TitleOfCourtesy);
command.Parameters.AddWithValue("@BirthDate", employee.BirthDate);
command.Parameters.AddWithValue("@HireDate", employee.HireDate);
command.Parameters.AddWithValue("@Address", employee.Address);
command.Parameters.AddWithValue("@City", employee.City);
command.Parameters.AddWithValue("@ID", employee.ID);
command.CommandText = @"UPDATE [dbo].[Employees]
SET [LastName] = @LastName
,[FirstName] = @FirstName
,[Title] = @Title
,[TitleOfCourtesy] = @TitleOfCourtesy
,[BirthDate] = @BirthDate
,[HireDate] = @HireDate
,[Address] = @Address
,[City] = @City
WHERE [EmployeeID] = @ID";
connection.Open();
command.ExecuteNonQuery();
}
}
static void Main(string[] args)
{
uint numberOfEmployees = 3;
Employees[] employees = new Employees[numberOfEmployees];
// Examples
employees[0].firstName = "Petyr";
employees[0].secondName = "Yordanov";
employees[0].age = 33;
employees[0].gender = 'm';
employees[0].IDNumber = 1111111;
employees[0].UniqueEN = 27560001;
employees[1].firstName = "Pesho";
employees[1].secondName = "Todorov";
employees[1].age = 23;
employees[1].gender = 'm';
employees[1].IDNumber = 2222222;
employees[1].UniqueEN = 27560002;
employees[2].firstName = "Aleksandra";
employees[2].secondName = "Ivanova";
employees[2].age = 22;
employees[2].gender = 'f';
employees[2].IDNumber = 3333333;
employees[2].UniqueEN = 27560003;
PrintEmployees(employees);
}
public void CreateEmployee(Employees objEmployee)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
List<SqlParameter> lstMasterEmployeeDetail = new List<SqlParameter>();
lstMasterEmployeeDetail.Add(new SqlParameter("@facultyId", objEmployee.Id));
lstMasterEmployeeDetail.Add(new SqlParameter("@name", objEmployee.Name));
lstMasterEmployeeDetail.Add(new SqlParameter("@joiningDate", objEmployee.JoiningDate));
lstMasterEmployeeDetail.Add(new SqlParameter("@gender", objEmployee.Gender));
lstMasterEmployeeDetail.Add(new SqlParameter("@createdOn", objEmployee.CreatedOn));
lstMasterEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
DataTable dt = new DataTable();
DataSet ds;
int EmployeeId;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet("spCreateEmployee", SQLTextType.Stored_Proc, lstMasterEmployeeDetail);
EmployeeId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
lstEmployeeDetail.Add(new SqlParameter("@employeeId", EmployeeId));
lstEmployeeDetail.Add(new SqlParameter("@roleId", objEmployee.RoleId));
lstEmployeeDetail.Add(new SqlParameter("@departmentId", objEmployee.DepartmentId));
lstEmployeeDetail.Add(new SqlParameter("@contactNumber", objEmployee.ContactNumber));
lstEmployeeDetail.Add(new SqlParameter("@weeklyOffDay", objEmployee.WeeklyOffDay));
lstEmployeeDetail.Add(new SqlParameter("@shiftId", objEmployee.ShiftId));
lstEmployeeDetail.Add(new SqlParameter("@createdAt", objEmployee.CreatedOn));
lstEmployeeDetail.Add(new SqlParameter("@updatedAt", objEmployee.UpdatedOn));
lstEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
objDDBDataHelper.ExecSQL("spCreateEmployeeTransc", SQLTextType.Stored_Proc, lstEmployeeDetail);
}
}
public bool UpdateEmployee(Employees objEmployee)
{
List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
lstEmployeeDetail.Add(new SqlParameter("@employeeId", objEmployee.Id));
lstEmployeeDetail.Add(new SqlParameter("@gender", objEmployee.Gender));
lstEmployeeDetail.Add(new SqlParameter("@joiningDate", objEmployee.JoiningDate));
lstEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
lstEmployeeDetail.Add(new SqlParameter("@updatedOn", DateTime.Now));
lstEmployeeDetail.Add(new SqlParameter("@password", objEmployee.Password));
lstEmployeeDetail.Add(new SqlParameter("@roleId", objEmployee.RoleId));
lstEmployeeDetail.Add(new SqlParameter("@departmentId", objEmployee.DepartmentId));
lstEmployeeDetail.Add(new SqlParameter("@contactNumber", objEmployee.ContactNumber));
lstEmployeeDetail.Add(new SqlParameter("@weeklyOffDay", objEmployee.WeeklyOffDay));
lstEmployeeDetail.Add(new SqlParameter("@shiftId", objEmployee.ShiftId));
DataTable dt = new DataTable();
try
{
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
objDDBDataHelper.ExecSQL("spUpdateEmployeeByEmployeeId", SQLTextType.Stored_Proc, lstEmployeeDetail);
}
return true;
}
catch(Exception ex)
{
return false;
}
}
protected virtual Employees MockEmployeesInShift()
{
Employees employees = new Employees();
employees.Add(1, new Employee(){ id = 1, name = "Lanny McDonald"});
//employees.Add(2, new Employee() { id = 2, name = "Allen Pitts" });
return employees;
}
protected override Employees MockEmployeesInShift()
{
Employees employees = new Employees();
//employees.Add(1, new Employee() { id = 1, name = "Lanny McDonald" });
employees.Add(2, new Employee() { id = 2, name = "Allen Pitts" });
employees.Add(4, new Employee() { id = 4, name = "Dave Sapunjis" });
return employees;
}
public void Update(Employees employee)
{
Employees empToUpdate = empContext.Employees.FirstOrDefault(emp => emp.ID == employee.ID);
empToUpdate.FirstName = employee.FirstName;
empToUpdate.LastName = employee.LastName;
empToUpdate.Gender = employee.Gender;
empToUpdate.JobTitle = employee.JobTitle;
empToUpdate.Salary = employee.Salary;
empContext.SaveChanges();
}
protected void lnkUpdateEmployee_Click(object sender, EventArgs e)
{
Employees objEmployee = new Employees();
objEmployee.Id = Convert.ToInt32(Session["EmployeeId"] == null ? 0 : Session["EmployeeId"]);
objEmployee.DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
objEmployee.JoiningDate = Convert.ToDateTime(txtDateOfJoining.Text);
objEmployee.ContactNumber = Convert.ToInt64(txtContactNumber.Text);
objEmployee.RoleId = Convert.ToInt32(ddlRoles.SelectedValue);
objEmployee.DepartmentId = Convert.ToInt32(ddlRoles.SelectedValue);
objEmployee.Password = txtPassword.Text;
objEmployee.Gender = rdrbtnMale.Checked == true ? "Male" : "Female";
ManageEmployees objManageEmployees = new ManageEmployees();
objManageEmployees.UpdateEmployee(objEmployee);
Response.Redirect("ViewEmployee.aspx");
}
static void PrintEmployees(Employees[] employees)
{
Console.WriteLine("List of employees:\n ");
for (int i = 0; i < employees.Length; i++)
{
Console.WriteLine("Name: {0} {1}", employees[i].firstName, employees[i].secondName);
Console.WriteLine("Age: {0}", employees[i].age);
Console.WriteLine("Gender: {0}",
(employees[i].gender == 'm' ? "Male" : (employees[i].gender == 'f' ? "Female" : "unknown")));
Console.WriteLine("ID Number: {0}", employees[i].IDNumber);
Console.WriteLine("Unique employee number: {0}", employees[i].UniqueEN);
Console.WriteLine();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
emps = new Employees();
string path = System.Web.Configuration.WebConfigurationManager.AppSettings["tyontekijat"];
path = Server.MapPath("~/"+path);
Serialisointi.DeSerialisoiXml(path, ref emps);
ViewState["emps"] = emps;
}
else
{
emps = (Employees)ViewState["emps"];
}
bindList();
}
private void Create(string filename)
{
Employees emps=new Employees();
/* Note that only the collection is serialized, not
* the CollectionName or any other public property of
* the class.
*/
emps.CollectionName="Employees";
Employee john100=new Employee("John", "100xxx");
emps.Add(john100);
XmlSerializer ser=new XmlSerializer(typeof(Employees));
TextWriter writer=new StreamWriter(filename);
ser.Serialize(writer, emps);
writer.Close();
}
public Employees GetEmployees()
{
if (this.employees == null)
{
// Dummy Data.
this.employees = new Employees
{
new Employee()
{
Id = "1",
Name = "John",
LastName = "Smith",
Phone = "(425) 555 8912",
Email = "*****@*****.**"
},
new Employee()
{
Id = "2",
Name = "Bonnie",
LastName = "Skelly",
Phone = "(206) 555 7301",
Email = "*****@*****.**"
},
new Employee()
{
Id = "3",
Name = "Lisa",
LastName = "Blunt",
Phone = "(425) 555 7492",
Email = "*****@*****.**"
},
new Employee()
{
Id = "4",
Name = "Kylie",
LastName = "Pugh",
Phone = "(425) 555 2836",
Email = "*****@*****.**"
},
};
}
return this.employees;
}
public Employees GetEmployees()
{
if (this.employees == null)
{
// Dummy Data.
this.employees = new Employees
{
new Employee()
{
Id = "1",
Name = "John",
LastName = "Smith",
Phone = "(425) 555 8912",
Email = "*****@*****.**"
},
new Employee()
{
Id = "2",
Name = "Bonnie",
LastName = "Skelly",
Phone = "(206) 555 7301",
Email = "*****@*****.**"
},
new Employee()
{
Id = "3",
Name = "Dana",
LastName = "Birkby",
Phone = "(425) 555 7492",
Email = "*****@*****.**"
},
new Employee()
{
Id = "4",
Name = "David",
LastName = "Probst",
Phone = "(425) 555 2836",
Email = "*****@*****.**"
},
};
}
return this.employees;
}
protected void btnSUbmit_Click(object sender, EventArgs e)
{
Employees objEmployee = new Employees();
objEmployee.Id = Convert.ToInt32(txtEmployeeId.Text);
objEmployee.Name = txtName.Text;
objEmployee.DepartmentId = Convert.ToInt32(ddlDepartments.SelectedValue);
objEmployee.RoleId = Convert.ToInt32(ddlRoles.SelectedValue);
objEmployee.CreatedOn = DateTime.Now;
objEmployee.UpdatedOn = DateTime.Now;
objEmployee.JoiningDate = DateTime.Parse(txtDateOfJoining.Text);
long contact = new long();
long.TryParse(txtContactNumber.Text, out contact);
objEmployee.ContactNumber = contact;
objEmployee.Gender = rdrbtnFemale.Checked ? "Female" : "Male";
objEmployee.ShiftId = Convert.ToInt32(ddlShifts.SelectedValue);
ManageEmployees objManageEmployee = new ManageEmployees();
objManageEmployee.CreateEmployee(objEmployee);
Response.Redirect(Request.Url.AbsoluteUri);
}
public bool dismissal(Employees employee)
{
using (NpgsqlConnection connection = getConnection())
{
connection.Open();
using (NpgsqlTransaction tran = connection.BeginTransaction())
{
using (NpgsqlCommand cmd = new NpgsqlCommand(UPDATE_CMD, connection))
{
var p = cmd.Parameters.Add(new NpgsqlParameter(":id", NpgsqlDbType.Uuid));
p.Value = employee.EmployeeId;
bool result = cmd.ExecuteNonQuery() == 1;
tran.Commit();
return result;
}
}
}
}
protected void a_Click(object sender, EventArgs e)
{
TweekPerformance_BT.Employee emp = new TweekPerformance_BT.Employee();
EmployeeBindingList.EmployeeList.Clear();
userNumbersList.Clear();
Project newProject = (Project)Application["newProject"];
emp.SearchEmployees(search.Text, newProject.ProjectStartDateTime);
List<Employees> myList = new List<Employees>();
foreach (TweekPerformance_BT.Employee inE in EmployeeBindingList.EmployeeList)
{
userNumbersList.Add(inE.UserNumber);
Employees a = new Employees();
a.FirstName = inE.FirstName;
a.Surname = inE.Surname;
a.ContactNumber = inE.ContactNumber;
myList.Add(a);
}
gvwStudents.DataSource = myList;
gvwStudents.DataBind();
}
static void Main(string[] args)
{
Employees goshko = new Employees();
Console.Write("First Name:");
goshko.firstName = Console.ReadLine();
Console.Write("Family Name:");
goshko.familyName =Console.ReadLine();
Console.Write("Gender:");
goshko.gender = Console.ReadLine();
Console.Write("Age:");
bool imput=Int32.TryParse(Console.ReadLine(), out goshko.age);
bool imput2;
bool imput4;
if(!imput)
{
do
{
Console.WriteLine("Incorrect Data!!! Try again:");
imput2=Int32.TryParse(Console.ReadLine(), out goshko.age);
}
while (!imput2);
}
Console.Write("ID:");
goshko.ID = Console.ReadLine();
Console.Write("Emplyee Number:");
long d;
bool imput3 = Int64.TryParse(Console.ReadLine(), out d);
if (!imput3 || d < 27560000 || d > 27569999)
{
do
{
Console.Write("Incorrect Data!!! Must be between 27560000 and 27569999.Try again:");
imput4 = Int64.TryParse(Console.ReadLine(), out d);
}
while (!imput4 || d < 27560000 || d > 27569999);
}
goshko.setNum(d);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Whole info:\n\n{0}",goshko.ToString());
}
internal Employees GetEmployee(string queryString, Employees employee)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
employee.ID = int.Parse(reader[0].ToString());
employee.LastName = reader[1].ToString();
employee.FirstName = reader[2].ToString();
employee.Title = reader[3].ToString();
employee.TitleOfCourtesy = reader[4].ToString();
employee.BirthDate = DateTime.Parse(reader[5].ToString());
employee.HireDate = DateTime.Parse(reader[6].ToString());
employee.Address = reader[7].ToString();
employee.City = reader[8].ToString();
}
reader.Close();
return employee;
}
}
public bool GetEmployeesByDate(DateTime date, out List<Employees> objEmployees)
{
DataTable dt, dt1, dt2;
List<Employees> objEmployees1 = new List<Employees>();
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
List<SqlParameter> list_params = new List<SqlParameter>() { new SqlParameter("@date", date) };
try
{
using (DBDataHelper helper = new DBDataHelper())
{
dt = helper.GetDataTable("Select EmployeeId from tblAttendance where Date=@date", SQLTextType.Query, list_params);
for (int i = 0; i < dt.Rows.Count; i++)
{
int EmployeeId = Convert.ToInt32(dt.Rows[i]["EmployeeId"]);
List<SqlParameter> list_params2 = new List<SqlParameter>() { new SqlParameter("@employeeId", EmployeeId) };
dt1 = helper.GetDataTable("select FirstName,MiddleName,LastName from tblEmployeesMaster where Id=@employeeId", SQLTextType.Query, list_params2);
Employees objEmployee = new Employees();
objEmployee.FirstName = Convert.ToString(dt1.Rows[0]["FirstName"]);
objEmployee.MiddleName = Convert.ToString(dt1.Rows[0]["MiddleName"]);
objEmployee.LastName = Convert.ToString(dt1.Rows[0]["LastName"]);
List<SqlParameter> list_params3 = new List<SqlParameter>() { new SqlParameter("@employeeId", EmployeeId) };
dt2 = helper.GetDataTable("Select RoleId,DepartmentId from tblEmployees where EmployeeId=@employeeId", SQLTextType.Query, list_params3);
objEmployee.RoleId = Convert.ToInt32(dt2.Rows[0]["RoleId"]);
objEmployee.DepartmentId = Convert.ToInt32(dt2.Rows[0]["DepartmentId"]);
objEmployees1.Add(objEmployee);
}
}
objEmployees = objEmployees1;
return true;
}
catch (Exception)
{
objEmployees = null;
return false;
}
}
public override IQueryable <Employees> GetEmployeeSubordinates(Employees employee)
{
return(employee.Subordinates.AsQueryable());
}
public List<Employees> GetEmployeesByDepartment(int departmentId)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
lstEmployeeDetail.Add(new SqlParameter("@departmentId", departmentId));
ds = objDDBDataHelper.GetDataSet("spGetAllEmployeesByDepartment", SQLTextType.Stored_Proc, lstEmployeeDetail);
List<Employees> lstEmployee = new List<Employees>();
int i = 0;
foreach (DataRow rows in ds.Tables[0].Rows)
{
Employees objEmployee = new Employees();
objEmployee.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
objEmployee.Name = ds.Tables[0].Rows[i][1].ToString();
objEmployee.RoleId = Convert.ToInt32(ds.Tables[0].Rows[i][2]);
objEmployee.RoleName = ds.Tables[0].Rows[i][3].ToString();
lstEmployee.Add(objEmployee);
i++;
}
return lstEmployee;
}
}
public Employees GetEmployeeById(long Id)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DBDataHelper helper = new DBDataHelper();
List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
lstEmployeeDetail.Add(new SqlParameter("@employeeId", Id));
DataSet ds;
int i = 0;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet("spGetEmployeeById", SQLTextType.Stored_Proc, lstEmployeeDetail);
Employees objEmployee = new Employees();
objEmployee.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
objEmployee.Name = ds.Tables[0].Rows[i][1].ToString();
objEmployee.Gender = ds.Tables[0].Rows[i][2] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][2].ToString();
objEmployee.JoiningDate = ds.Tables[0].Rows[i][3] == DBNull.Value ? new DateTime() : Convert.ToDateTime(ds.Tables[0].Rows[i][3]);
objEmployee.ImagePath = ds.Tables[0].Rows[i][4] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][4].ToString();
objEmployee.ContactNumber = ds.Tables[0].Rows[i][5] == DBNull.Value ? new Int64() : Convert.ToInt64(ds.Tables[0].Rows[i][5]);
objEmployee.Password = ds.Tables[0].Rows[i][6] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][6].ToString();
objEmployee.DepartmentId = ds.Tables[0].Rows[i][9] == DBNull.Value ? new Int32() : Convert.ToInt32(ds.Tables[0].Rows[i][9]);
objEmployee.DepartmentName = ds.Tables[0].Rows[i][10] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][10].ToString();
objEmployee.RoleId = ds.Tables[0].Rows[i][7] == DBNull.Value ? new Int32() : Convert.ToInt32(ds.Tables[0].Rows[i][7]); ;
objEmployee.RoleName = ds.Tables[0].Rows[i][8] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][8].ToString();
objEmployee.WeeklyOffDay = ds.Tables[0].Rows[i][11] == DBNull.Value ? 1 : Convert.ToInt32(ds.Tables[0].Rows[i][11]);
objEmployee.ShiftId = ds.Tables[0].Rows[i][12] == DBNull.Value ? 1 : Convert.ToInt32(ds.Tables[0].Rows[i][12]);
return objEmployee;
}
}
public List<Employees> GetAllEmployees()
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
int i = 0;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet("spGetAllEmployees", SQLTextType.Stored_Proc);
List<Employees> lstEmployee = new List<Employees>();
foreach (DataRow rows in ds.Tables[0].Rows)
{
Employees objEmployee = new Employees();
objEmployee.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
objEmployee.Name = ds.Tables[0].Rows[i][1].ToString();
objEmployee.Gender = ds.Tables[0].Rows[i][2] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][2].ToString();
objEmployee.JoiningDate = ds.Tables[0].Rows[i][3] == DBNull.Value ? new DateTime() : Convert.ToDateTime(ds.Tables[0].Rows[i][3]);
objEmployee.ImagePath = ds.Tables[0].Rows[i][4] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][4].ToString();
objEmployee.ContactNumber = ds.Tables[0].Rows[i][5] == DBNull.Value ? new Int64() : Convert.ToInt64(ds.Tables[0].Rows[i][5]);
objEmployee.Password = ds.Tables[0].Rows[i][6] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][6].ToString();
objEmployee.DepartmentId = ds.Tables[0].Rows[i][9] == DBNull.Value ? new Int32() : Convert.ToInt32(ds.Tables[0].Rows[i][9]);
objEmployee.DepartmentName = ds.Tables[0].Rows[i][10] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][10].ToString();
objEmployee.RoleId = ds.Tables[0].Rows[i][7] == DBNull.Value ? new Int32() : Convert.ToInt32(ds.Tables[0].Rows[i][7]); ;
objEmployee.RoleName = ds.Tables[0].Rows[i][8] == DBNull.Value ? "NULL" : ds.Tables[0].Rows[i][8].ToString();
objEmployee.WeeklyOffDay = ds.Tables[0].Rows[i][11] == DBNull.Value ? 1 : Convert.ToInt32(ds.Tables[0].Rows[i][11]);
objEmployee.ShiftId = ds.Tables[0].Rows[i][12] == DBNull.Value ? 1 : Convert.ToInt32(ds.Tables[0].Rows[i][12]);
lstEmployee.Add(objEmployee);
i++;
}
return lstEmployee;
}
}
public static Employees CreateEmployees(int employeeID, string lastName, string firstName, AddressDetails addressDetails)
{
Employees employees = new Employees();
employees.EmployeeID = employeeID;
employees.LastName = lastName;
employees.FirstName = firstName;
if ((addressDetails == null))
{
throw new global::System.ArgumentNullException("addressDetails");
}
employees.AddressDetails = addressDetails;
return employees;
}
public Task <Employee> CreateAsync(Employee item)
{
return(Employees.CreateAsync(item));
}
public override IQueryable <Territories> GetEmployeeTerritories(Employees employee)
{
return(employee.Territories.AsQueryable());
}
public override IQueryable <Orders> GetEmployeeOrders(Employees employee)
{
return(employee.Orders.AsQueryable());
}
public virtual void AddEmployee(Employee employee)
{
Employees.Add(employee.Id, employee);
employee.Employer = this;
}
// GET: Employees/Details/5
public ActionResult Employees(int id)
{
Employees employed = GetEmployedLocalApi(id);
return(View(employed));
}
private bool IsWorkStationFree(WorkStation workStation)
{
var occupiedWorkStations = Employees.Select(employee => employee.AssignedWorkStation);
return(!occupiedWorkStations.Contains(workStation));
}
public Task <IEnumerable <Employee> > CreateAsync(IEnumerable <Employee> items)
{
return(Employees.CreateAsync(items));
}
public Task <Employee> UpdateAsync(Employee item)
{
return(Employees.UpdateAsync(item));
}
public Employee(string name, Employee manager, params Employee[] employees) : this(name, manager)
{
Employees.AddRange(employees);
}
public double GetAverageSalary()
{
int empCount = CountEmployees();
return((empCount == 0)? 0 : Employees.Sum(e => e.CurrentSalary.Sum) / empCount);
}
public bool DoesEmployeeExist(Employees employee)
{
return(_employeeRepo.DoesEmployeeExist(employee));
}
/// <summary>
/// Добавяне на нов запис в буферния масив
/// </summary>
/// <param name="e">Записът, който добавяме</param>
private void addNewRecord(Employees e)
{
employeesArray.Add(e);
}
public static Employees SearchEmployee(Employees emp)
{
ProjectEntiryDbcontext db = new ProjectEntiryDbcontext();
return((db.Employees.Select(e => e).Where(e => e.employeeid == emp.employeeid)).First());
}
public override Employees GetEmployeeSuperior(Employees employee)
{
return(employee.Superior);
}
static void Main(string[] args)
{
Employees emp1 = new Employees();
emp1.Name = "Kenn";
}
private List <EmpSummary> GetEmpData()
{
if (CurrentPayrollJob == null || CurrentBranch == null)
{
return(new List <EmpSummary>());
}
int cpjob = CurrentPayrollJob.PayrollJobId;
using (var ctx = new PayrollDB())
{
try
{
var payrollItems = ctx.PayrollItems.Where(p => p.PayrollJobId == cpjob &&
p.ParentPayrollItem == null).ToList();
var emplst = Employees
.Select(e => new EmpSummary
{
Employee_Name = e.DisplayName,
PayrollItems = payrollItems.Where(x => x.EmployeeId == e.EmployeeId)
.Select(
x =>
new
{
PayrollItem = x,
Priority =
x.PayrollSetupItem == null
? x.Priority
: x.PayrollSetupItem.Priority
})
.GroupBy(
x =>
new
{
Name = x.PayrollItem.Name.Trim(),
x.PayrollItem.IncomeDeduction,
x.Priority
})
.Select(g => new PayrollSummary
{
PayrollItemName = g.Key.Name, //.ToString("D2")
IncomeDeduction = g.Key.IncomeDeduction,
Priority = g.Key.Priority,
Total = g.Sum(x => x.PayrollItem.Amount)
}).OrderByDescending(x => x.IncomeDeduction)
.ThenBy(x => x.Priority)
.ToList()
,
Total = e.NetAmount
})
.ToList();
return(emplst);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public void Add(Employees supervisor)
{
throw new NotImplementedException();
}
public async Task <Employee> GetEmployeeDetails(int employeeId)
{
return(await Task.Run(() => { return Employees.FirstOrDefault(e => e.EmployeeId == employeeId); }));
}
public ActionResult Create([Bind(Include = "EmpNum,firstName,lastName,IDNumber,gender,UserRole,hireDate,mobile,email,status,queue,deptCode,typeCode,Picture,shift")] Employees employees, HttpPostedFileBase img_upload)
{
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
var PasswordHash = new PasswordHasher();
if (ModelState.IsValid)
{
try
{
//upload Picture
byte[] data = null;
data = new byte[img_upload.ContentLength];
img_upload.InputStream.Read(data, 0, img_upload.ContentLength);
employees.Picture = data;
employees.queue = 1;
employees.hireDate = System.DateTime.Now;
employees.status = "Available";
db.employees.Add(employees);
using (var appcontext = new ApplicationDbContext())
{
if (!appcontext.Roles.Any(r => r.Name.Equals(employees.UserRole)))
{
var store = new RoleStore <IdentityRole>(appcontext);
var manager = new RoleManager <IdentityRole>(store);
var role = new IdentityRole {
Name = employees.UserRole
};
manager.Create(role);
if (!db.Users.Any(u => u.UserName == employees.EmpNum))
{
var user = new ApplicationUser
{
UserName = employees.email,
Email = employees.email,
EmailConfirmed = true,
PhoneNumber = employees.mobile,
PhoneNumberConfirmed = true,
fullName = employees.lastName + " " + employees.firstName,
UserRole = employees.UserRole,
gender = employees.gender,
IDNumber = employees.IDNumber,
PasswordHash = PasswordHash.HashPassword(employees.IDNumber.Substring(0, 6)),
};
UserManager.Create(user);
UserManager.AddToRole(user.Id, employees.UserRole);
}
}
}
if (!db.Users.Any(u => u.UserName == employees.EmpNum))
{
var user = new ApplicationUser
{
UserName = employees.email,
Email = employees.email,
EmailConfirmed = true,
PhoneNumber = employees.mobile,
PhoneNumberConfirmed = true,
fullName = employees.lastName + " " + employees.firstName,
UserRole = employees.UserRole,
gender = employees.gender,
IDNumber = employees.IDNumber,
PasswordHash = PasswordHash.HashPassword(employees.IDNumber.Substring(0, 6)),
};
UserManager.Create(user);
UserManager.AddToRole(user.Id, employees.UserRole);
}
db.SaveChanges();
TempData["Success"] = employees.firstName + " " + employees.lastName + " has successfully been added!";
return(RedirectToAction("Index"));
//return RedirectToAction("Index");
}
catch (Exception e)
{
ViewBag.Message = "Employee not added. Error: " + e.Message;
}
}
ViewBag.typeCode = new SelectList(db.typeOfContracts, "typeCode", "typeName", employees.typeCode);
ViewBag.deptCode = new SelectList(db.departments, "deptCode", "deptName", employees.deptCode);
//TempData["Success"] = employees.firstName + " " + employees.lastName + " has successfully been added!";
ModelState.Clear();
return(View(employees));
}
//C
public void AddEmployee(Employees entity)
{
_employeeManager.AddEmployee(entity);
}
partial void DeleteEmployees(Employees instance);
//U
public void UpdateEmployee(Employees entity)
{
_employeeManager.UpdateEmployee(entity);
}
public static void Initialize(CreatingDatabase context)
{
context.Database.EnsureCreated();
if (context.Categories.Any())
{
return;
}
var categories = new Categories[]
{
new Categories {
categoryId = 1001, categoryName = "Food", description = null, picture = null
},
new Categories {
categoryId = 1002, categoryName = "Clothes", description = null, picture = null
}
};
foreach (var item in categories)
{
context.Add(item);
}
if (context.Customers.Any())
{
return;
}
var customers = new Customers[]
{
new Customers {
customerId = 2001, companyName = "JIO", contactTitle = "Reliance", Address = "27 krishna nagar", city = "Mumbai",
postalCode = 15012, country = "india", phone = 708877245, fax = null
},
new Customers {
customerId = 2002, companyName = "JIO", contactTitle = "Reliance", Address = "27 krishna nagar", city = "Mumbai",
postalCode = 15012, country = "india", phone = 708877245, fax = null
},
new Customers {
customerId = 2003, companyName = "JIO", contactTitle = "Reliance", Address = "27 krishna nagar", city = "Mumbai",
postalCode = 15012, country = "india", phone = 708877245, fax = null
},
new Customers {
customerId = 2004, companyName = "JIO", contactTitle = "Reliance", Address = "27 krishna nagar", city = "Mumbai",
postalCode = 15012, country = "india", phone = 708877245, fax = null
},
new Customers {
customerId = 2005, companyName = "JIO", contactTitle = "Reliance", Address = "27 krishna nagar", city = "Mumbai",
postalCode = 15012, country = "india", phone = 708877245, fax = null
},
};
foreach (var item in customers)
{
context.Add(item);
}
var employees = new Employees[]
{
new Employees {
employeeID = 3001, lastName = "Sharma", firstName = "Himani", title = "Mrs",
titleOfCOurtesy = "Engineer", birthDate = "03-12-1993", hireDate = "07-01-2017",
Address = "2 green avenue", city = "Delhi", region = "Delhi", postalCode = 147001,
country = "India", homePhone = 708782492, extension = null, photo = null, notes = null, reportsTo = null,
photoPath = null
},
new Employees {
employeeID = 3002, lastName = "Sharma", firstName = "Himani", title = "Mrs",
titleOfCOurtesy = "Engineer", birthDate = "03-12-1993", hireDate = "07-01-2017",
Address = "2 green avenue", city = "Delhi", region = "Delhi", postalCode = 147001,
country = "India", homePhone = 708782492, extension = null, photo = null, notes = null, reportsTo = "3001",
photoPath = null
},
new Employees {
employeeID = 3003, lastName = "Sharma", firstName = "Himani", title = "Mrs",
titleOfCOurtesy = "Engineer", birthDate = "03-12-1993", hireDate = "07-01-2017",
Address = "2 green avenue", city = "Delhi", region = "Delhi", postalCode = 147001,
country = "India", homePhone = 708782492, extension = null, photo = null, notes = null, reportsTo = "3002",
photoPath = null
},
new Employees {
employeeID = 3004, lastName = "Sharma", firstName = "Himani", title = "Mrs",
titleOfCOurtesy = "Engineer", birthDate = "03-12-1993", hireDate = "07-01-2017",
Address = "2 green avenue", city = "Delhi", region = "Delhi", postalCode = 147001,
country = "India", homePhone = 708782492, extension = null, photo = null, notes = null, reportsTo = "3003",
photoPath = null
},
new Employees {
employeeID = 3005, lastName = "Sharma", firstName = "Himani", title = "Mrs",
titleOfCOurtesy = "Engineer", birthDate = "03-12-1993", hireDate = "07-01-2017",
Address = "2 green avenue", city = "Delhi", region = "Delhi", postalCode = 147001,
country = "India", homePhone = 708782492, extension = null, photo = null, notes = null, reportsTo = "3001",
photoPath = null
},
};
foreach (var item in employees)
{
context.Add(item);
}
if (context.Shippers.Any())
{
return;
}
var shippers = new Shippers[]
{
new Shippers {
shipperId = 4001, companyName = "Jio", phone = 99887766
},
new Shippers {
shipperId = 4002, companyName = "Reliance", phone = 99987766
}
};
foreach (var item in shippers)
{
context.Add(item);
}
if (context.Suppliers.Any())
{
return;
}
var suppliers = new Suppliers[]
{
new Suppliers {
supplierId = 7001, companyName = "Reliance", contactName = "Ambani",
contactTitle = "Mukesh",
Address = "Bandra", city = "Mumbai", postalCode = 14389, country = "India", phone = 988776655, homepage = null, fax = null
},
new Suppliers {
supplierId = 7002, companyName = "Reliance", contactName = "Ambani",
contactTitle = "Mukesh",
Address = "Bandra", city = "Mumbai", postalCode = 14389, country = "India", phone = 988776655, homepage = null, fax = null
}
};
foreach (var item in suppliers)
{
context.Add(item);
}
if (context.Regions.Any())
{
return;
}
var region = new Region[]
{
new Region {
regionId = 9001, regionDescription = "This covers all area in North"
},
new Region {
regionId = 9002, regionDescription = "This covers all area in South"
}
};
foreach (var item in region)
{
context.Add(item);
}
if (context.Territories.Any())
{
return;
}
var territories = new Territories[]
{
new Territories {
territoryId = 11, territoryDescription = "It covers all areas in Punjab"
, Region = null
},
new Territories {
territoryId = 12, territoryDescription = "It covers all areas in Bangalore"
, Region = null
}
};
foreach (var item in territories)
{
context.Add(item);
}
var product = new Products[]
{
new Products {
productId = 5001, Suppliers = null, Categories = null, productName = "Oil", unitPrice = 100,
quantitPerLabel = 15, reorderLevel = 0, unitsInStock = 12, unitsOnOrder = 0, discontinued = null
},
new Products {
productId = 5002, Suppliers = null, Categories = null, productName = "Jeans", unitPrice = 1000,
quantitPerLabel = 20, reorderLevel = 0, unitsInStock = 50, unitsOnOrder = 20, discontinued = "No"
},
new Products {
productId = 5003, Suppliers = null, Categories = null, productName = "Maggie", unitPrice = 100,
quantitPerLabel = 15, reorderLevel = 0, unitsInStock = 12, unitsOnOrder = 3, discontinued = null
},
new Products {
productId = 5004, Suppliers = null, Categories = null, productName = "Shirt", unitPrice = 1500,
quantitPerLabel = 11, reorderLevel = 0, unitsInStock = 14, unitsOnOrder = 0, discontinued = null
},
new Products {
productId = 5005, Suppliers = null, Categories = null, productName = "Chips", unitPrice = 50,
quantitPerLabel = 15, reorderLevel = 0, unitsInStock = 12, unitsOnOrder = 0, discontinued = null
},
};
foreach (var item in product)
{
context.Add(item);
}
var orders = new Orders[]
{
new Orders {
orderId = 6001, Customers = null, Employees = null, orderDate = "01-11-2020",
requiredDate = "05-11-2020", shippedDate = "01-11-2020", shipVia = "Blue Dart",
shipAddress = "Delhi", shipCity = "Delhi", shipCountry = "India", shipPostalCode = 13425,
shipName = null, shipRegion = "North", freigth = null
},
new Orders {
orderId = 6002, Customers = null, Employees = null, orderDate = "01-11-2020",
requiredDate = "05-11-2020", shippedDate = "01-11-2020", shipVia = "Blue Dart",
shipAddress = "Delhi", shipCity = "Delhi", shipCountry = "India", shipPostalCode = 13425,
shipName = null, shipRegion = "North", freigth = null
},
new Orders {
orderId = 6003, Customers = null, Employees = null, orderDate = "01-11-2020",
requiredDate = "05-11-2020", shippedDate = "01-11-2020", shipVia = "Blue Dart",
shipAddress = "Delhi", shipCity = "Delhi", shipCountry = "India", shipPostalCode = 13425,
shipName = null, shipRegion = "North", freigth = null
},
new Orders {
orderId = 6004, Customers = null, Employees = null, orderDate = "01-11-2020",
requiredDate = "05-11-2020", shippedDate = "01-11-2020", shipVia = "Blue Dart",
shipAddress = "Delhi", shipCity = "Delhi", shipCountry = "India", shipPostalCode = 13425,
shipName = null, shipRegion = "North", freigth = null
},
new Orders {
orderId = 6005, Customers = null, Employees = null, orderDate = "01-11-2020",
requiredDate = "05-11-2020", shippedDate = "01-11-2020", shipVia = "Blue Dart",
shipAddress = "Delhi", shipCity = "Delhi", shipCountry = "India", shipPostalCode = 13425,
shipName = null, shipRegion = "North", freigth = null
}
};
foreach (var item in orders)
{
context.Add(item);
}
var orderDetails = new OrderDetails[]
{
new OrderDetails {
Orders = null, Products = null, quantity = 12, discount = 5, unitPrice = 10
}
};
foreach (var item in orderDetails)
{
context.Add(item);
}
}
//D
public void Delete(Employees entity)
{
_orderDetailsManager.DeleteOrderDetailsByEmployeeID(entity.EmployeeID);
_orderManager.DeleteOrderByEmployeeID(entity.EmployeeID);
_employeeManager.Delete(entity);
}
private void AddEmployee(object parameter)
{
Task t = Task.Factory.StartNew(() => this.Test = "new task");
Employees.Add(Employee);
}
public IEnumerable <Employee> GetEmployees()
{
return(Employees.Include(x => x.Enterprise).ToList());
}
protected void btnSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (string.IsNullOrEmpty(txtDiscount.Text))
{
lblMsg.Text = "Invalid Discount .";
lblMsg.ForeColor = Color.Red;
return;
}
Employees _employee = new Employees();
try
{
_employee.UserName = CboUser.SelectedItem.Text;
_employee.SelectOneByUserName();
if (_employee.ErrorCode != 0)
{
lblMsg.Text = _employee.ErrorDesc.ToString();
lblMsg.ForeColor = Color.Red;
return;
}
}
catch (Exception ee) {}
try
{
EmployeeDiscounts em = new EmployeeDiscounts();
em.Discount = SqlMoney.Parse(txtDiscount.Text);
em.EmployeeID = _employee.Employee_ID;
if (Session["Prop_Action"] != "U")
{
em.DiscountStatus = 1;
em.UnitOfDiscount = Int32.Parse(CboUnit.SelectedValue);
em.CreatedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name);
bool retval = em.Insert();
if (em.ErrorCode == 0)
{
lblMsg.Text = "Data Updated successfully.";
lblMsg.ForeColor = Color.Green;
}
else
{
lblMsg.Text = em.ErrorDesc.ToString();
lblMsg.ForeColor = Color.Red;
}
// Response.Redirect("RoomTypes.aspx", true);
}
else
{
em.DiscountID = int.Parse(txtdiscountID.Value);
em.DiscountStatus = int.Parse(cboStatus.SelectedItem.Value);
em.UnitOfDiscount = Int32.Parse(CboUnit.SelectedValue);
em.LastModifiedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name);
em.LastModifiedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Now);
em.Update();
if (em.ErrorCode == 0)
{
lblMsg.Text = "Data Saved successfully.";
lblMsg.ForeColor = Color.Green;
}
else
{
lblMsg.Text = em.ErrorDesc.ToString();
lblMsg.ForeColor = Color.Red;
}
}
}
catch (Exception ex)
{
lblMsg.Text = "Data not Saved .";
lblMsg.ForeColor = Color.Red;
}
}
public void add(Employees employee)
{
Employees.Add(employee);
}
public void Remove(Employees employeeInDb)
{
throw new NotImplementedException();
}
public void SaveEmployees(Employees employee)
{
_employeeRepo.SaveEmployees(employee);
}
public DataAccessTests()
{
_repository = new EmployeesRepository();
_employee = CreateDummyEmployee();
}
/// <summary>
/// There are no comments for Employees in the schema.
/// </summary>
public void AddToEmployees(Employees employees)
{
base.AddObject("Employees", employees);
}
/// <summary>
/// Create a new Employees object.
/// </summary>
/// <param name="employeeID">Initial value of EmployeeID.</param>
/// <param name="firstName">Initial value of FirstName.</param>
/// <param name="lastName">Initial value of LastName.</param>
public static Employees CreateEmployees(int employeeID, string firstName, string lastName)
{
Employees employees = new Employees();
employees.EmployeeID = employeeID;
employees.FirstName = firstName;
employees.LastName = lastName;
return employees;
}
internal static void Main()
{
// Setup employee collection
var employees = new Employees();
employees.Attach(new Clerk());
employees.Attach(new Director());
employees.Attach(new President());
// Employees are 'visited'
employees.Accept(new IncomeVisitor());
employees.Accept(new VacationVisitor());
}
