public ActionResult GetEmployees()
{
EmployeesFinance employees = Manager.Instance().GetEmployeesFinance();
List <EmployeeFinanceModel> Salaries = Manager.Instance().CastToEmployeesFinanceModel(employees);
List <EmployeeFinanceModel> Employees = new List <EmployeeFinanceModel>();
foreach (EmployeeFinanceModel emp in Salaries)
{
bool exists = false;
foreach (var item in Employees)
{
if (item.Id == emp.Id)
{
exists = true;
break;
}
}
if (!exists)
{
Employees.Add(emp);
}
}
List <EmployeeFinanceModel> SortedList = Employees.OrderBy(e => e.Name).ToList();
return(View(SortedList));
}
public EmployeesFinance GetEmployeeFinance()
{
EmployeesFinance employees = new EmployeesFinance();
using (SqlConnection con = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.GetSalaries", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EmployeeFinance employee = new EmployeeFinance();
employee.Id = Int32.Parse(reader[0].ToString());
employee.Name = reader[1].ToString();
employee.LastName = reader[2].ToString();
int e = 0;
Int32.TryParse(reader[3].ToString(), out e);
employee.Salary = e;
DateTime d;
DateTime.TryParse(reader[4].ToString(), out d);
employee.SalaryDate = d;
employees.Employees.Add(employee);
}
}
return(employees);
}
public EmployeesFinance GetEmployeesFinance()
{
EmployeesFinance deserialized = new EmployeesFinance();
string baseUrl = ConfigurationManager.ConnectionStrings["FinanceServerName"].ConnectionString;
string url = baseUrl + DestinationNames.GetFinanceEmployees;
deserialized = Communicator.GetEntitiesList <EmployeesFinance>(url);
return(deserialized);
}
public byte[] SerializeEmployeeFinance()
{
EmployeesFinance employees = this.GetEmployeesFinance();
MemoryStream memorystream = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
bf.Serialize(memorystream, employees);
memorystream.Flush();
memorystream.Position = 0;
byte[] Bytes = memorystream.ToArray();
return(Bytes);
}
public List <EmployeeFinanceModel> CastToEmployeesFinanceModel(EmployeesFinance employees)
{
List <EmployeeFinanceModel> Salaries = new List <EmployeeFinanceModel>();
foreach (EmployeeFinance employee in employees.Employees)
{
EmployeeFinanceModel emp = new EmployeeFinanceModel();
emp.Id = employee.Id;
emp.Name = employee.Name;
emp.LastName = employee.LastName;
emp.Salary = employee.Salary;
emp.SalaryDate = employee.SalaryDate;
Salaries.Add(emp);
}
return(Salaries);
}
public EmployeesFinance GetEmployeeFinance()
{
EmployeesFinance employees = new EmployeesFinance();
EmployeeFinance employee1 = new EmployeeFinance();
employee1.Id = 1;
employee1.Name = "Jane";
employee1.Salary = 2000;
employees.Employees.Add(employee1);
EmployeeFinance employee2 = new EmployeeFinance();
employee2.Id = 2;
employee2.Name = "Jack";
employee2.Salary = 1000;
employees.Employees.Add(employee2);
return(employees);
}
public ActionResult SalaryChart(int Id)
{
EmployeesFinance Employees = Manager.Instance().GetEmployeesFinance();
List <EmployeeFinanceModel> Salaries = Manager.Instance().CastToEmployeesFinanceModel(Employees);
List <SalaryChartModel> empl = new List <SalaryChartModel>();
for (int i = Salaries.Count() - 1; i >= 0; --i)
{
if (Salaries[i].Id == Id)
{
SalaryChartModel e = new SalaryChartModel();
e.Salary = Salaries[i].Salary;
e.date = Salaries[i].SalaryDate;
empl.Add(e);
}
}
return(View(empl));
}
public EmployeesFinance GetEmployeesFinance()
{
EmployeesFinance deserialized = new EmployeesFinance();
string baseUrl = ConfigurationManager.ConnectionStrings["DALServerName"].ConnectionString;
string url = baseUrl + DestinationNames.GetEmployees;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "GET";
WebResponse response = request.GetResponse();
using (Stream stream = response.GetResponseStream())
{
MemoryStream memStr = new MemoryStream();
stream.CopyTo(memStr);
memStr.Flush();
memStr.Position = 0;
BinaryFormatter bfd = new BinaryFormatter();
deserialized = bfd.Deserialize(memStr) as EmployeesFinance;
}
return(deserialized);
}