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);
}
}
}
