public static ContentVideoInfo GetInfo(int content_ID, int videoId)
{
ContentVideoInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_ContentVideo_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", content_ID);
dbCmd.Parameters.AddWithValue("@Video_ID", videoId);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new ContentVideoInfo();
retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]);
retVal.Video_ID = ConvertUtility.ToInt32(dr["Video_ID"]);
retVal.Priority = ConvertUtility.ToInt32(dr["Priority"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static void Update(ContentVideoInfo contentVideoInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_ContentVideo_Update", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", contentVideoInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@Video_ID", contentVideoInfo.Video_ID);
dbCmd.Parameters.AddWithValue("@Priority", contentVideoInfo.Priority);
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
}
finally
{
dbConn.Close();
}
}
public static int Insert(ContentVideoInfo contentVideoInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_ContentVideo_Insert", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", contentVideoInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@Video_ID", contentVideoInfo.Video_ID);
dbCmd.Parameters.AddWithValue("@Priority", contentVideoInfo.Priority);
dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
return((int)dbCmd.Parameters["@RETURN_VALUE"].Value);
}
finally
{
dbConn.Close();
}
}
private static ContentVideoInfo CreateEntityFromReader(IDataReader reader)
{
var item = new ContentVideoInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Content_ID")))
{
item.Content_ID = ConvertUtility.ToInt32(reader["Content_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Video_ID")))
{
item.Video_ID = ConvertUtility.ToInt32(reader["Video_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Priority")))
{
item.Priority = ConvertUtility.ToInt32(reader["Priority"]);
}
}
catch { }
return(item);
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
var info = new VideoInfo();
info.Video_Name = ConvertUtility.ToString(txtName.Text);
info.Video_Description = txtTeaser.Text;
info.Video_Type = dropType.SelectedValue;
info.Video_File = txtFile.Text;
info.Video_YouTube = txtYoutube.Text;
info.Video_Width = ConvertUtility.ToInt32(AppEnv.VideoWidth);
info.Video_Height = ConvertUtility.ToInt32(AppEnv.VideoHeight);
info.Video_CreateDate = DateTime.Now;
info.Video_View = 0;
info.User_ID = ConvertUtility.ToInt32(ckid);
info.Video_Visible = chkVisible.Checked;
try
{
var videoId = VideoDB.Insert(info);
var contentVideoInfo = new ContentVideoInfo();
contentVideoInfo.Content_ID = _contentId;
contentVideoInfo.Video_ID = videoId;
contentVideoInfo.Priority = 0;
ContentVideoDB.Insert(contentVideoInfo);
//Response.Redirect(Request.RawUrl + "#idTab4");
lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_ERROR;
}
}
