public string DeleteEmployeeFinance(byte[] bytes)
{
MemoryStream stream = new MemoryStream(bytes);
EmployeeFinanceForGetAndDelete employee =
Communicator.ParseResponse <EmployeeFinanceForGetAndDelete>(stream);
_sqlProvider.DeleteEmployeeFinance(employee);
return("Deleted.");
}
public EmployeeFinance GetEmployeeFinanceById(EmployeeFinanceForGetAndDelete employee)
{
EmployeeFinance Employee = new EmployeeFinance();
Employee.Id = employee.Id;
Employee.Name = "Jane";
Employee.Salary = 2000;
return(Employee);
}
public string DeleteEmployee(byte[] bytes)
{
string baseUrl = ConfigurationManager.ConnectionStrings["DALServerName"].ConnectionString;
string url = baseUrl + DestinationNames.DeleteEmployee;
EmployeeFinanceForGetAndDelete deserialized = Communicator.SendRequest <EmployeeFinanceForGetAndDelete>
(bytes, url, "POST");
return("Success");
}
public string DeleteEmployeeFinance(EmployeeFinanceId employee)
{
EmployeeFinanceForGetAndDelete Employee = new EmployeeFinanceForGetAndDelete();
Employee.Id = employee.Id;
string baseUrl = ConfigurationManager.ConnectionStrings["FinanceServerName"].ConnectionString;
string url = baseUrl + DestinationNames.DeleteEmployeeFinance;
EmployeeFinanceForGetAndDelete deserialized = Communicator.SendRequest <EmployeeFinanceForGetAndDelete, EmployeeFinanceForGetAndDelete>
(Employee, url, "POST", "application/octet-stream");
return("Success");
}
public string DeleteEmployeeFinance(EmployeeFinanceForGetAndDelete employee)
{
using (SqlConnection con = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.DeleteSalary", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", employee.Id);
con.Open();
cmd.ExecuteNonQuery();
}
return("Deleted.");
}
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 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 EmployeeFinance GetEmployeeFinanceById(EmployeeFinanceId employee)
{
EmployeeFinanceForGetAndDelete Employee = new EmployeeFinanceForGetAndDelete();
EmployeeFinance deserialized = null;
Employee.Id = employee.Id;
string baseUrl = ConfigurationManager.ConnectionStrings["FinanceServerName"].ConnectionString;
string url = baseUrl + DestinationNames.GetEmployeeFinanceById;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/octet-stream";
using (Stream strRequest = request.GetRequestStream())
{
MemoryStream memorystream = new MemoryStream();
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(memorystream, Employee);
memorystream.Flush();
memorystream.Position = 0;
byte[] Bytes = memorystream.ToArray();
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;
BinaryFormatter bfd = new BinaryFormatter();
deserialized = bfd.Deserialize(memStr) as EmployeeFinance;
}
return(deserialized);
}
public string DeleteEmployeeFinance(EmployeeFinanceForGetAndDelete employee)
{
throw new NotImplementedException();
}
