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(); }