public byte[] GetEmployeeById(byte[] bytes)
{
EmployeeFinance deserialized = null;
BinaryFormatter bfd = new BinaryFormatter();
string baseUrl = ConfigurationManager.ConnectionStrings["DALServerName"].ConnectionString;
string url = baseUrl + DestinationNames.GetEmployeeById;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/octet-stream";
using (Stream strRequest = request.GetRequestStream())
{
strRequest.Write(bytes, 0, bytes.Length);
}
WebResponse response = request.GetResponse();
using (Stream stream = response.GetResponseStream())
{
MemoryStream memStr = new MemoryStream();
stream.CopyTo(memStr);
memStr.Flush();
memStr.Position = 0;
deserialized = bfd.Deserialize(memStr) as EmployeeFinance;
}
MemoryStream memorystream = new MemoryStream();
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(memorystream, deserialized);
memorystream.Flush();
memorystream.Position = 0;
byte[] Bytes = memorystream.ToArray();
return(Bytes);
}
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 string UpdateEmployeeFinance(byte[] bytes)
{
MemoryStream stream = new MemoryStream(bytes);
EmployeeFinance employee = Communicator.ParseResponse <EmployeeFinance>(stream);
_sqlProvider.AddEmployeeFinance(employee);
return("Added.");
}
public EmployeeFinance GetEmployeeFinanceById(EmployeeFinanceForGetAndDelete employee)
{
EmployeeFinance Employee = new EmployeeFinance();
Employee.Id = employee.Id;
Employee.Name = "Jane";
Employee.Salary = 2000;
return(Employee);
}
public string UpdateEmployee(byte[] bytes)
{
string baseUrl = ConfigurationManager.ConnectionStrings["DALServerName"].ConnectionString;
string url = baseUrl + DestinationNames.UpdateEmployee;
EmployeeFinance deserialized = Communicator.SendRequest <EmployeeFinance>
(bytes, url, "POST");
return("Success");
}
public EmployeeFinance CreateEmployee(EmployeeFinanceModel employee)
{
EmployeeFinance Employee = new EmployeeFinance();
Employee.Id = employee.Id;
Employee.Name = employee.Name;
Employee.Salary = employee.Salary;
return(Employee);
}
public EmployeeFinanceModel CastToEmployeeFinance(EmployeeFinance employee)
{
EmployeeFinanceModel emp = new EmployeeFinanceModel();
emp.Id = employee.Id;
emp.Name = employee.Name;
emp.LastName = employee.LastName;
emp.Salary = employee.Salary;
return(emp);
}
public string UpdateEmployeeFinance(EmployeeFinanceModel employee)
{
EmployeeFinance Employee = this.CreateEmployee(employee);
string baseUrl = ConfigurationManager.ConnectionStrings["FinanceServerName"].ConnectionString;
string url = baseUrl + DestinationNames.UpdateEmployeeFinance;
EmployeeFinance deserialized = Communicator.SendRequest <EmployeeFinance, EmployeeFinance>
(Employee, url, "POST", "application/octet-stream");
return("Success");
}
public void CallGenericSendRequest()
{
EmployeeFinance elf = new EmployeeFinance();
elf.Salary = 123434;
StatusBase status = ERPS.Utils.Functionals.Communicator.SendRequest <StatusBase, EmployeeFinance>(elf, "http://hellomelloyello.com", "POST", "application/octet-stream");
int i = 0;
++i;
}
public ActionResult GetEmployeeById(int id)
{
string urlBase = Utils.Functionals.RouteHandler.GetUrlBase(Request, Url);
ViewBag.urlBase = urlBase;
ViewBag.GetEmployeeById = "Finance/GetEmployeeById";
EmployeeFinanceId empl = new EmployeeFinanceId();
empl.Id = id;
EmployeeFinance employee = Manager.Instance().GetEmployeeFinanceById(empl);
EmployeeFinanceModel Employee = Manager.Instance().CastToEmployeeFinance(employee);
return(View("GetEmployeeById", Employee));
}
public string AddEmployeeFinance(EmployeeFinance employee)
{
using (SqlConnection con = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.UpdateSalary", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", employee.Id);
cmd.Parameters.AddWithValue("@Name", employee.Name);
cmd.Parameters.AddWithValue("@LastName", employee.Name);
cmd.Parameters.AddWithValue("@Salary", employee.Salary);
con.Open();
cmd.ExecuteNonQuery();
}
return("Added.");
}
public byte[] GetEmployeeFinanceById(byte[] bytes)
{
MemoryStream stream = new MemoryStream(bytes);
EmployeeFinanceForGetAndDelete employee =
Communicator.ParseResponse <EmployeeFinanceForGetAndDelete>(stream);
EmployeeFinance Employee = new EmployeeFinance();
Employee = this._sqlProvider.GetEmployeeFinanceById(employee);
MemoryStream memorystream = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
bf.Serialize(memorystream, Employee);
memorystream.Flush();
memorystream.Position = 0;
byte[] Bytes = memorystream.ToArray();
return(Bytes);
}
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 EmployeeFinance GetEmployeeFinanceById(EmployeeFinanceForGetAndDelete employee)
{
EmployeeFinance emp = new EmployeeFinance();
using (SqlConnection con = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.GetEmployeeFinanceById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", employee.Id);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
emp.Id = Int32.Parse(reader[0].ToString());
emp.Name = reader[1].ToString();
emp.LastName = reader[2].ToString();
emp.Salary = Int32.Parse(reader[3].ToString());
}
}
return(emp);
}
public string DeleteEmployeeFinance(EmployeeFinance employee)
{
return(null);
}
public string AddEmployeeFinance(EmployeeFinance employee)
{
return(null);
}