public List <InteriorColors> GetAllInteriorColors()
{
List <InteriorColors> interiorColors = new List <InteriorColors>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("InteriorColorsSelectAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
InteriorColors currentRow = new InteriorColors();
currentRow.InteriorColorId = (int)dr["InteriorColorId"];
currentRow.InteriorColorDescription = dr["InteriorColorDescription"].ToString();
interiorColors.Add(currentRow);
}
}
}
return(interiorColors);
}
public void SetInterior(IEnumerable <InteriorColor> interiorColor)
{
foreach (var color in interiorColor)
{
InteriorColors.Add(new SelectListItem()
{
Value = color.InteriorColorId.ToString(),
Text = color.Description
});
}
}
public void SetInteriorColor(IEnumerable <LookupValue> interiorColor)
{
foreach (var ic in interiorColor)
{
InteriorColors.Add(new SelectListItem()
{
Value = ic.Description.ToString(),
Text = ic.Description.ToString()
});
}
}
public void Add(InteriorColors interiorColor)
{
using (var sqlConnection = new System.Data.SqlClient.SqlConnection())
{
sqlConnection.ConnectionString = ConfigurationManager
.ConnectionStrings["DefaultConnection"]
.ConnectionString;
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@InteriorColorsId", dbType: DbType.Int32, direction: ParameterDirection.Output);
dynamicParameters.Add("@InteriorColorsName", interiorColor.InteriorColorName);
sqlConnection.Query <InteriorColors>("AddInteriorColors", dynamicParameters,
commandType: CommandType.StoredProcedure);
}
}
public Response AddInteriorColors(InteriorColors interiorColor)
{
Response response = new Response();
if (interiorColorRepository.GetAll().Any(t => t.InteriorColorName == interiorColor.InteriorColorName))
{
response.Success = false;
response.Message = "ERROR: InteriorColor name already exists";
}
else
{
interiorColorRepository.Add(interiorColor);
response.Success = true;
response.Message = "InteriorColor added";
}
return(response);
}
public void Add(InteriorColors interiorColor)
{
interiorColors.Add(interiorColor);
}