public DataTable ViewAudioList(UploadVideoSchema UploadVideo_Schema)
{
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[2];
cmdParameter[0] = new SqlParameter("@Langid", SqlDbType.Int);
cmdParameter[0].Value = UploadVideo_Schema.langid;
cmdParameter[1] = new SqlParameter("@Keyword", SqlDbType.NVarChar);
cmdParameter[1].Value = UploadVideo_Schema.Keyword;
sqlQuery = "Select VideoID, VideoName, VideoPath, Description as AudioDesc from Video where Type='Audio' and Langid=@Langid ";
sqlQuery += " and ((VideoName like '%' + @Keyword + '%') or (Description like '%' + @Keyword + '%') or @Keyword='') ";
sqlQuery += " order by VideoName";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery, cmdParameter);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public Int64 DeleteVideoRecord(UploadVideoSchema objUploadVideoSchema)
{
try
{
conn = SQLHelper.OpenConnection();
objtran = conn.BeginTransaction();
SqlParameter[] cmdParameters = new SqlParameter[3];
cmdParameters[0] = new SqlParameter("@VideoID", SqlDbType.BigInt);
cmdParameters[0].Value = objUploadVideoSchema.VideoID;
cmdParameters[1] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
cmdParameters[1].Value = objUploadVideoSchema.CreatedBy;
cmdParameters[2] = new SqlParameter("@IPAddress", SqlDbType.NVarChar);
cmdParameters[2].Value = objUploadVideoSchema.IPAddress;
intCount = SQLHelper.ExecuteNonQuery(conn, objtran, CommandType.StoredProcedure, "spDeleteVideo", cmdParameters);
objtran.Commit();
return(intCount);
}
catch (Exception)
{
objtran.Rollback();
return(0);
}
finally
{
SQLHelper.CloseConnection(conn);
intCount = 0;
}
}
public DataTable ViewVideoList(UploadVideoSchema UploadVideo_Schema)
{
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[1];
cmdParameter[0] = new SqlParameter("@Keyword", SqlDbType.NVarChar);
cmdParameter[0].Value = UploadVideo_Schema.Keyword;
sqlQuery = "Select VideoID, VideoName, VideoPath, '../../Site/Upload/Video/' + ImagePath as VideoImage,Description as VideoDesc from Video where IsActive=1";
//sqlQuery += "where((VideoName like '%' + @Keyword + '%') or (Descriptions like '%' + @Keyword + '%') or @Keyword='') ";
//sqlQuery += " order by VideoName";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery, cmdParameter);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public Int64 InsertVideoRecord(UploadVideoSchema objUploadVideoSchema)
{
try
{
conn = SQLHelper.OpenConnection();
objtran = conn.BeginTransaction();
SqlParameter[] cmdParameters = new SqlParameter[10];
cmdParameters[0] = new SqlParameter("@VideoID", SqlDbType.BigInt);
if (objUploadVideoSchema.VideoID == null)
{
cmdParameters[0].Value = DBNull.Value;
}
else
{
cmdParameters[0].Value = objUploadVideoSchema.VideoID;
}
cmdParameters[1] = new SqlParameter("@VideoName", SqlDbType.NVarChar);
cmdParameters[1].Value = objUploadVideoSchema.VideoName;
cmdParameters[2] = new SqlParameter("@VideoPath", SqlDbType.NVarChar);
cmdParameters[2].Value = objUploadVideoSchema.VideoPath;
cmdParameters[3] = new SqlParameter("@ImagePath", SqlDbType.NVarChar);
cmdParameters[3].Value = objUploadVideoSchema.ImagePath;
cmdParameters[4] = new SqlParameter("@Description", SqlDbType.NVarChar);
cmdParameters[4].Value = objUploadVideoSchema.Description;
cmdParameters[5] = new SqlParameter("@Type", SqlDbType.VarChar);
cmdParameters[5].Value = objUploadVideoSchema.Type;
cmdParameters[6] = new SqlParameter("@Flag", SqlDbType.VarChar, 10);
cmdParameters[6].Value = objUploadVideoSchema.Flag;
cmdParameters[7] = new SqlParameter("@Langid", SqlDbType.Int);
cmdParameters[7].Value = objUploadVideoSchema.langid;
cmdParameters[8] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
cmdParameters[8].Value = objUploadVideoSchema.CreatedBy;
cmdParameters[9] = new SqlParameter("@IPAddress", SqlDbType.NVarChar);
cmdParameters[9].Value = objUploadVideoSchema.IPAddress;
intCount = SQLHelper.ExecuteNonQuery(conn, objtran, CommandType.StoredProcedure, "spVideoGalleryAdd", cmdParameters);
objtran.Commit();
return(intCount);
}
catch (Exception)
{
objtran.Rollback();
return(0);
}
finally
{
SQLHelper.CloseConnection(conn);
intCount = 0;
}
}
public Int64 DeleteVideoRecord(UploadVideoSchema objUploadVideoSchema)
{
try
{
UploadVideoDAL objUploadVideo_DAL = new UploadVideoDAL();
return(objUploadVideo_DAL.DeleteVideoRecord(objUploadVideoSchema));
}
catch (Exception)
{
return(0);
}
finally
{
}
}
public Int64 InsertVideoGallery(UploadVideoSchema objUploadVideoSchema)
{
try
{
UploadVideoDAL objUploadVideo_DAL = new UploadVideoDAL();
return(objUploadVideo_DAL.InsertVideoGallery(objUploadVideoSchema));
}
catch (Exception)
{
return(0);
}
finally
{
}
}
public DataTable ViewAudioList(UploadVideoSchema UploadVideo_Schema)
{
try
{
UploadVideoDAL objUploadVideo_DAL = new UploadVideoDAL();
DataTable dt = new DataTable();
dt = objUploadVideo_DAL.ViewAudioList(UploadVideo_Schema);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
}
}
