public int InsertMenedger(menedger emp1) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("Insert into turmenedger(fio,idturoperator,email,phone) values (@fio,@idturoperator,@email,@phone) SET @memberID = @@IDENTITY ", con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@fio", SqlDbType.NVarChar, 150)); cmd.Parameters["@fio"].Value = emp1.Fio; cmd.Parameters.Add(new SqlParameter("@idturoperator", SqlDbType.Int, 6)); cmd.Parameters["@idturoperator"].Value = emp1.Idturoperator; cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50)); cmd.Parameters["@email"].Value = emp1.Email; cmd.Parameters.Add(new SqlParameter("@phone", SqlDbType.NVarChar, 20)); cmd.Parameters["@phone"].Value = emp1.Phone; cmd.Parameters.Add(new SqlParameter("@memberID", SqlDbType.Int, 6)); cmd.Parameters["@memberID"].Direction = ParameterDirection.Output; try { con.Open(); cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@memberID"].Value; } catch { throw new ApplicationException("Ошибка данныx. Добавление сотрудника туроператора"); } finally { con.Close(); } }
public menedger GetMenedger(int id) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("Select fio, idturoperator, email, phone from menedger where menedger.id = @id", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 6)); cmd.Parameters["@id"].Value = id; menedger menedger = new menedger(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); menedger.Fio = (string)reader["fio"]; menedger.Idturoperator = (int)reader["idturoperator"]; menedger.Email = (string)reader["email"]; menedger.Phone = (string)reader["phone"]; reader.Close(); return menedger; } catch { throw new ApplicationException("Ошибка данныx. Вывод сотрудника"); } finally { con.Close(); } }