public bool AddTarifAgent(TarifAgentModel tarif) { if (tarif.Id == null) { using (SqlConnection conn = new SqlConnection(_connectionStringAdmin)) { conn.Open(); SqlCommand cmd = new SqlCommand("dbo.AddTarifAgent", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@agentId", tarif.AgentId); cmd.Parameters.AddWithValue("@tarifId", tarif.TarifId); cmd.Parameters.AddWithValue("@tarifSum", tarif.TarifSum); return(Convert.ToBoolean(cmd.ExecuteScalar())); } } else { using (SqlConnection conn = new SqlConnection(_connectionStringAdmin)) { conn.Open(); SqlCommand cmd = new SqlCommand("dbo.ChangeTarifAgent", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", tarif.Id); cmd.Parameters.AddWithValue("@tarifSum", tarif.TarifSum); return(Convert.ToBoolean(cmd.ExecuteScalar())); } } }
public List <TarifAgentModel> GetAgentTarifs() { List <TarifAgentModel> agentTarifs = new List <TarifAgentModel>(); using (SqlConnection conn = new SqlConnection(_connectionStringAdmin)) { conn.Open(); SqlCommand cmd = new SqlCommand("dbo.GetAgentTarifs", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TarifAgentModel agentTarif = new TarifAgentModel(); agentTarif.Id = reader["Id"] != DBNull.Value ? Convert.ToInt32(reader["Id"]) : 0; agentTarif.TarifId = reader["TarifId"] != DBNull.Value ? Convert.ToInt32(reader["TarifId"]) : 0; agentTarif.AgentId = reader["AgentId"] != DBNull.Value ? Convert.ToInt32(reader["AgentId"]) : 0; agentTarif.TarifSum = reader["TarifSum"] != DBNull.Value ? Convert.ToInt32(reader["TarifSum"]) : 0; agentTarif.TarifName = reader["TarifName"] != DBNull.Value ? Convert.ToString(reader["TarifName"]) : string.Empty; agentTarif.AgentName = reader["AgentName"] != DBNull.Value ? Convert.ToString(reader["AgentName"]) : string.Empty; agentTarifs.Add(agentTarif); } } return(agentTarifs); }