public void UpdateCrew(ModelHairdresserCrew model)
{
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand command = connection.CreateCommand())
{
connection.Open();
command.CommandText = "SP_UpdateHairdressingCrew";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("Id", model.Id);
command.Parameters.AddWithValue("Name", model.Name);
command.Parameters.AddWithValue("Address", model.Address);
command.Parameters.AddWithValue("Phone", model.Phone);
command.Parameters.AddWithValue("Email", model.Email);
command.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
}
public ActionResult UpdateCrew(int UpdId, string UpdName, string UpdAddress, int UpdPhone, string UpdEmail)
{
DalHairdresserCrew Crew = new DalHairdresserCrew();
ModelHairdresserCrew ModelHairdresserCrew = new ModelHairdresserCrew(UpdId, UpdName, UpdAddress, UpdPhone, UpdEmail);
Crew.UpdateCrew(ModelHairdresserCrew);
return(RedirectToAction("Crew"));
}
public ActionResult InsertCrew(string InsName, string InsAddress, int InsPhone, string InsEmail)
{
DalHairdresserCrew Crew = new DalHairdresserCrew();
ModelHairdresserCrew ModelHairdresserCrew = new ModelHairdresserCrew(InsName, InsAddress, InsPhone, InsEmail);
Crew.InsetCrew(ModelHairdresserCrew);
return(RedirectToAction("Crew"));
}
public List <ModelHairdresserCrew> SearchId(int Id)
{
try
{
List <ModelHairdresserCrew> ReturnList = new List <ModelHairdresserCrew>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand command = connection.CreateCommand())
{
connection.Open();
command.CommandText = "SP_ListHairdressingCrewId";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("Id", Id);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ModelHairdresserCrew crew = new ModelHairdresserCrew()
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
Address = reader["Address"].ToString(),
Phone = Convert.ToInt32(reader["Phone"]),
Email = reader["Email"].ToString()
};
ReturnList.Add(crew);
}
}
}
return(ReturnList);
}
catch (Exception)
{
throw;
}
}