protected virtual iVehicleImage GetVehicleImageFromReader(IDataReader reader, bool singleRecord) { if (singleRecord) { reader.Read(); } iVehicleImage vehicleimage = new iVehicleImage( Convert.ToInt32(reader["id"]), Convert.ToInt32(reader["vehicleid"]), Helpers.ConvertNullToBlank(reader["path"]), Helpers.ConvertNullToBlank(reader["image1"]), Helpers.ConvertNullToBlank(reader["image2"]), Helpers.ConvertNullToBlank(reader["image3"]), Helpers.ConvertNullToBlank(reader["image4"]), Helpers.ConvertNullToBlank(reader["image5"]), Helpers.ConvertNullToBlank(reader["image6"]), Helpers.ConvertNullToBlank(reader["image7"]), Helpers.ConvertNullToBlank(reader["image8"]), Helpers.ConvertNullToBlank(reader["image9"]), Helpers.ConvertNullToBlank(reader["image10"]), Helpers.ConvertNullToBlank(reader["image11"]), Helpers.ConvertNullToBlank(reader["image12"]), Helpers.ConvertNullToBlank(reader["image13"]), Helpers.ConvertNullToBlank(reader["image14"]), Helpers.ConvertNullToBlank(reader["image15"]), Helpers.ConvertNullToBlank(reader["image16"]), Helpers.ConvertNullToBlank(reader["image17"]), Helpers.ConvertNullToBlank(reader["image18"]), Helpers.ConvertNullToBlank(reader["image19"]), Helpers.ConvertNullToBlank(reader["image20"]), Helpers.ConvertNullToBlank(reader["video"]), Helpers.ConvertNullToBlank(reader["youtubelink"]), Helpers.ConvertNullToBlank(reader["videoformat"]) ); return(vehicleimage); }
public abstract bool Insert(iVehicleImage c);
public abstract bool Update(iVehicleImage c);
public override bool Insert(iVehicleImage vi) { using (SqlConnection conn = new SqlConnection(ConnectionString)) { string q = string.Empty; SqlCommand cmd = new SqlCommand(q, conn); q = @" INSERT INTO [dbo].[vehicleimages] ([vehicleid] ,[path] ,[image1] ,[image2] ,[image3] ,[image4] ,[image5] ,[image6] ,[image7] ,[image8] ,[image9] ,[image10] ,[image11] ,[image12] ,[image13] ,[image14] ,[image15] ,[image16] ,[image17] ,[image18] ,[image19] ,[image20] ,[video] ,[youtubelink] ,[videoformat]) VALUES (@pVehicleId ,@pPath ,@pImage1 ,@pImage2 ,@pImage3 ,@pImage4 ,@pImage5 ,@pImage6 ,@pImage7 ,@pImage8 ,@pImage9 ,@pImage10 ,@pImage11 ,@pImage12 ,@pImage13 ,@pImage14 ,@pImage15 ,@pImage16 ,@pImage17 ,@pImage18 ,@pImage19 ,@pImage20 ,@pVideo ,@pYouTube ,@pFormat)"; cmd.CommandText = q; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@pVehicleId", SqlDbType.Int).Value = vi.VehicleId; cmd.Parameters.Add("@pPath", SqlDbType.VarChar).Value = vi.ImgPath; if (vi.Img1 != null) { cmd.Parameters.Add("@pImage1", SqlDbType.VarChar).Value = vi.Img1; } else { cmd.Parameters.Add("@pImage1", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img2 != null) { cmd.Parameters.Add("@pImage2", SqlDbType.VarChar).Value = vi.Img2; } else { cmd.Parameters.Add("@pImage2", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img3 != null) { cmd.Parameters.Add("@pImage3", SqlDbType.VarChar).Value = vi.Img3; } else { cmd.Parameters.Add("@pImage3", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img4 != null) { cmd.Parameters.Add("@pImage4", SqlDbType.VarChar).Value = vi.Img4; } else { cmd.Parameters.Add("@pImage4", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img5 != null) { cmd.Parameters.Add("@pImage5", SqlDbType.VarChar).Value = vi.Img5; } else { cmd.Parameters.Add("@pImage5", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img6 != null) { cmd.Parameters.Add("@pImage6", SqlDbType.VarChar).Value = vi.Img6; } else { cmd.Parameters.Add("@pImage6", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img7 != null) { cmd.Parameters.Add("@pImage7", SqlDbType.VarChar).Value = vi.Img7; } else { cmd.Parameters.Add("@pImage7", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img8 != null) { cmd.Parameters.Add("@pImage8", SqlDbType.VarChar).Value = vi.Img8; } else { cmd.Parameters.Add("@pImage8", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img9 != null) { cmd.Parameters.Add("@pImage9", SqlDbType.VarChar).Value = vi.Img9; } else { cmd.Parameters.Add("@pImage9", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img10 != null) { cmd.Parameters.Add("@pImage10", SqlDbType.VarChar).Value = vi.Img10; } else { cmd.Parameters.Add("@pImage10", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img11 != null) { cmd.Parameters.Add("@pImage11", SqlDbType.VarChar).Value = vi.Img11; } else { cmd.Parameters.Add("@pImage11", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img12 != null) { cmd.Parameters.Add("@pImage12", SqlDbType.VarChar).Value = vi.Img12; } else { cmd.Parameters.Add("@pImage12", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img13 != null) { cmd.Parameters.Add("@pImage13", SqlDbType.VarChar).Value = vi.Img13; } else { cmd.Parameters.Add("@pImage13", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img14 != null) { cmd.Parameters.Add("@pImage14", SqlDbType.VarChar).Value = vi.Img14; } else { cmd.Parameters.Add("@pImage14", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img15 != null) { cmd.Parameters.Add("@pImage15", SqlDbType.VarChar).Value = vi.Img15; } else { cmd.Parameters.Add("@pImage15", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img16 != null) { cmd.Parameters.Add("@pImage16", SqlDbType.VarChar).Value = vi.Img16; } else { cmd.Parameters.Add("@pImage16", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img17 != null) { cmd.Parameters.Add("@pImage17", SqlDbType.VarChar).Value = vi.Img17; } else { cmd.Parameters.Add("@pImage17", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img18 != null) { cmd.Parameters.Add("@pImage18", SqlDbType.VarChar).Value = vi.Img18; } else { cmd.Parameters.Add("@pImage18", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img19 != null) { cmd.Parameters.Add("@pImage19", SqlDbType.VarChar).Value = vi.Img19; } else { cmd.Parameters.Add("@pImage19", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Img20 != null) { cmd.Parameters.Add("@pImage20", SqlDbType.VarChar).Value = vi.Img20; } else { cmd.Parameters.Add("@pImage20", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.Video != null) { cmd.Parameters.Add("@pVideo", SqlDbType.VarChar).Value = vi.Video; } else { cmd.Parameters.Add("@pVideo", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.YouTubeLink != null) { cmd.Parameters.Add("@pYouTube", SqlDbType.VarChar).Value = vi.YouTubeLink; } else { cmd.Parameters.Add("@pYouTube", SqlDbType.VarChar).Value = DBNull.Value; } if (vi.VideoFormat != null) { cmd.Parameters.Add("@pFormat", SqlDbType.VarChar).Value = vi.VideoFormat; } else { cmd.Parameters.Add("@pFormat", SqlDbType.VarChar).Value = DBNull.Value; } try { conn.Open(); int rc = ExecuteNonQuery(cmd); return(rc == 1); } catch (SqlException ex) { ErrorHandler.writeSQLExceptionToLogFile(ex); return(false); } } }