public DataSet GetViewAlbum(AlbumSchema objAlbumSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ActionType", SqlDbType.VarChar);
param[0].Value = objAlbumSchema.Actiontype;
param[1] = new SqlParameter("@PhotoType", SqlDbType.VarChar);
param[1].Value = objAlbumSchema.PhotoType;
param[2] = new SqlParameter("@PhotoAlbumID", SqlDbType.Int);
param[2].Value = objAlbumSchema.PhotoAlbumID;
param[3] = new SqlParameter("@PhotoSubAlbumID", SqlDbType.Int);
param[3].Value = objAlbumSchema.PhotoSubAlbumID;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetViewAlbum", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetAlbumDetails(AlbumSchema objAlbumSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
var param = new SqlParameter[]
{
new SqlParameter("@ActionType", objAlbumSchema.Actiontype == null ? (object)DBNull.Value : objAlbumSchema.Actiontype),
new SqlParameter("@AlbumID", Convert.ToInt32(objAlbumSchema.AlbumID) == 0 ? 0 : Convert.ToInt32(objAlbumSchema.AlbumID)),
new SqlParameter("@PhotoSubAlbumID", objAlbumSchema.PhotoSubAlbumID == 0 ? 0 : objAlbumSchema.PhotoSubAlbumID),
new SqlParameter("@Name", objAlbumSchema.Name == null ? (object)DBNull.Value : objAlbumSchema.Name)
};
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetAlbumDetails", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetPressNewsAlbumdetails(AlbumSchema objAlbumSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Type", SqlDbType.VarChar);
param[0].Value = objAlbumSchema.Type;
param[1] = new SqlParameter("@AlbumName ", SqlDbType.VarChar);
param[1].Value = objAlbumSchema.AlbumName;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetAlbumForPressNews", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public int SaveVideo(AlbumSchema objAlbumSchema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@VideoName", objAlbumSchema.VideoName == null ? (object)DBNull.Value : objAlbumSchema.VideoName),
new SqlParameter("@VideoNameLL", objAlbumSchema.VideoNameLL == null ? (object)DBNull.Value : objAlbumSchema.VideoNameLL),
new SqlParameter("@VideoNameUL", objAlbumSchema.VideoNameUL == null ? (object)DBNull.Value : objAlbumSchema.VideoNameUL),
new SqlParameter("@VideoPath", objAlbumSchema.VideoPath == null ? (object)DBNull.Value : objAlbumSchema.VideoPath),
new SqlParameter("@Description", objAlbumSchema.Description == null ? (object)DBNull.Value : objAlbumSchema.Description),
new SqlParameter("@DescriptionLL", objAlbumSchema.DescriptionLL == null ? (object)DBNull.Value : objAlbumSchema.DescriptionLL),
new SqlParameter("@DescriptionUL", objAlbumSchema.DescriptionUL == null ? (object)DBNull.Value : objAlbumSchema.DescriptionUL),
new SqlParameter("@Types", objAlbumSchema.Type == null ? (object)DBNull.Value : objAlbumSchema.Type),
new SqlParameter("@CreatedBy", objAlbumSchema.CreatedBy == null ? (object)DBNull.Value : objAlbumSchema.CreatedBy),
new SqlParameter("@IPAddress", objAlbumSchema.IPAddress == null ? (object)DBNull.Value : objAlbumSchema.IPAddress),
new SqlParameter("@ImagePath", objAlbumSchema.ImagePath == null ? (object)DBNull.Value : objAlbumSchema.ImagePath),
new SqlParameter("@Flag", objAlbumSchema.Flag == null ? (object)DBNull.Value : objAlbumSchema.Flag)
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "sp_InsertVideo", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public int DMLAlbhumForVideo(AlbumSchema objAlbumSchema)
{
try
{
result = objAlbumDAL.DMLAlbhumForVideo(objAlbumSchema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public int SaveVideo(AlbumSchema objAlbumSchema)
{
try
{
result = objAlbumDAL.SaveVideo(objAlbumSchema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public int DMLViewAlbum(AlbumSchema objAlbumSchema)
{
try
{
result = objAlbumDAL.DMLViewAlbum(objAlbumSchema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public int DMLViewAlbum(AlbumSchema objAlbumSchema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@ActionType", objAlbumSchema.Actiontype == null ? (object)DBNull.Value : objAlbumSchema.Actiontype),
new SqlParameter("@PhotoType", objAlbumSchema.PhotoType == null ? (object)DBNull.Value : objAlbumSchema.PhotoType),
new SqlParameter("@PhotoAlbumID", objAlbumSchema.PhotoAlbumID == 0 ? 0 : objAlbumSchema.PhotoAlbumID),
new SqlParameter("@PhotoSubAlbumID", objAlbumSchema.PhotoSubAlbumID == 0 ? 0 : objAlbumSchema.PhotoSubAlbumID),
new SqlParameter("@FileName", objAlbumSchema.Filename == null ? (object)DBNull.Value : objAlbumSchema.Filename),
new SqlParameter("@Name", objAlbumSchema.Name == null ? (object)DBNull.Value : objAlbumSchema.Name)
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "Usp_DMLViewAlbum", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public DataSet GetAlbumDetails(AlbumSchema objAlbumSchema)
{
try
{
ds = objAlbumDAL.GetAlbumDetails(objAlbumSchema);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}
public int DMLAlbhumForVideo(AlbumSchema objAlbumSchema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@VideoName", objAlbumSchema.VideoName == null ? (object)DBNull.Value : objAlbumSchema.VideoName),
new SqlParameter("@VideoNameLL", objAlbumSchema.VideoNameLL == null ? (object)DBNull.Value : objAlbumSchema.VideoNameLL),
new SqlParameter("@VideoPath", objAlbumSchema.VideoPath == null ? (object)DBNull.Value : objAlbumSchema.VideoPath),
new SqlParameter("@ActionType", objAlbumSchema.Actiontype == null ? (object)DBNull.Value : objAlbumSchema.Actiontype),
new SqlParameter("@VideoID", objAlbumSchema.VideoID == 0 ? 0 : objAlbumSchema.VideoID),
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "Usp_DMLAlbhumForVideo", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public int DMLAlbumForPressNews(AlbumSchema objAlbumSchema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@ActionType", objAlbumSchema.Actiontype == null ? (object)DBNull.Value : objAlbumSchema.Actiontype),
new SqlParameter("@PressNewsAlbumID", objAlbumSchema.PressNewsAlbumID == 0 ? 0 : objAlbumSchema.PressNewsAlbumID),
new SqlParameter("@AlbumName", objAlbumSchema.AlbumName == null ? (object)DBNull.Value : objAlbumSchema.AlbumName),
new SqlParameter("@ChkStatus", objAlbumSchema.ChkStatus == false ? Convert.ToBoolean(0) : objAlbumSchema.ChkStatus),
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "Usp_DMLAlbumForPressNews", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public DataSet GetAllVideosById(AlbumSchema objAlbumSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Types", SqlDbType.VarChar);
param[0].Value = objAlbumSchema.TypeId;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "usp_GetAllVideoByTypes", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
