public static void UpdateProduct(CarsProduct carsProduct)
{
try
{
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@CarsProductId", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductId);
objWLSql.AddParameter("@Name", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductName1);
objWLSql.AddParameter("@CarsProductDescription", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductDescription);
objWLSql.AddParameter("@CarsColor", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsColor);
objWLSql.AddParameter("@CarsDoors", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsDoors);
//objWLSql.AddParameter("@CarsImagesUrl", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsImagesUrl);
objWLSql.AddParameter("@CarsKilometers", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsKilometers);
objWLSql.AddParameter("@CarsPrice", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsPrice);
objWLSql.ExecuteNonQuery("emi_carproduct");
}
catch (Exception ex)
{
wlLogging.HandleEx(ex);
}
}
public static int AddProduct(CarsProduct carsProduct)
{
try
{
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
objWLSql.AddParameter("@CarsProductName1", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductName1);
objWLSql.AddParameter("@CarsProductDescription", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductDescription);
objWLSql.AddParameter("@CarsColor", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsColor);
objWLSql.AddParameter("@CarsDoors", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsDoors);
objWLSql.AddParameter("@CarsKilometers", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsKilometers);
objWLSql.AddParameter("@CarsPrice", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsPrice);
objWLSql.AddParameter("@IsActive", DbType.String, ParameterDirection.Input, 0, carsProduct.IsActive);
objWLSql.AddParameter("@SessionId", DbType.String, ParameterDirection.Input, 0, carsProduct.SessionId);
//objWLSql.AddParameter("@CreatedBy", DbType.String, ParameterDirection.Input, 0, carsProduct.CreatedBy);
return(Convert.ToInt32(objWLSql.ExecuteScalar("emi_carproduct")));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
