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; } }
protected void dtgData_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "delete") { var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text); try { ContentVideoDB.Delete(_contentId, id); VideoDB.Delete(id); lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS; } catch { lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR; } } if (e.CommandName == "updaterow") { try { var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text); var info = VideoDB.GetInfo(id); var txtPriority = (TextBox)e.Item.FindControl("txtPriority"); var chkVisible = (CheckBox)e.Item.FindControl("chkVisible"); info.Video_Visible = ConvertUtility.ToBoolean(chkVisible.Checked); VideoDB.Update(info); var ctinfo = ContentVideoDB.GetInfo(_contentId, id); ctinfo.Priority = ConvertUtility.ToInt32(txtPriority.Text); ContentVideoDB.Update(ctinfo); lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS; } catch { lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR; //ex.ToString(); } } if (e.CommandName == "editrow") { lblStatusUpdate.Text = lblStatusUpdate2.Text = string.Empty; var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text); var info = VideoDB.GetInfo(id); dropType.ClearSelection(); MiscUtility.SetSelected(dropType.Items, info.Video_Type); chkVisible.Checked = info.Video_Visible; txtFile.Text = info.Video_File; txtYoutube.Text = info.Video_YouTube; txtName.Text = info.Video_Name; txtTeaser.Text = info.Video_Description; txtID.Text = id.ToString(); } }