public static DataSet Short_Film_Send_To_DB(Short_Film objShort_Film, DataTable Artist)
{
try
{
SqlParameter[] objSqlParameter = new SqlParameter[16];
objSqlParameter[0] = new SqlParameter("@Title", objShort_Film.Title);
objSqlParameter[1] = new SqlParameter("@Tag", objShort_Film.Tag);
objSqlParameter[2] = new SqlParameter("@Image", objShort_Film.Image);
objSqlParameter[3] = new SqlParameter("@Short_film_Id", objShort_Film.Short_film_Id);
objSqlParameter[4] = new SqlParameter("@Artist", Artist);
objSqlParameter[5] = new SqlParameter("@Category", objShort_Film.Category);
objSqlParameter[6] = new SqlParameter("@Language", objShort_Film.Language);
objSqlParameter[7] = new SqlParameter("@Description", objShort_Film.Description);
objSqlParameter[8] = new SqlParameter("@Channel", objShort_Film.Channel);
objSqlParameter[9] = new SqlParameter("@Video", objShort_Film.Video);
objSqlParameter[10] = new SqlParameter("@UserId", objShort_Film.UserId);
objSqlParameter[11] = new SqlParameter("@CreatedDate", objShort_Film.CreatedDate);
objSqlParameter[12] = new SqlParameter("@ShortIds", objShort_Film.ShortIds);
objSqlParameter[13] = new SqlParameter("@Duration", objShort_Film.Duration);
objSqlParameter[14] = new SqlParameter("@Trailer", objShort_Film.Trailer);
objSqlParameter[15] = new SqlParameter("@Available", objShort_Film.Available);
return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_Short_Film", objSqlParameter));
}
catch (Exception Ex)
{
throw Ex;
}
}
public static DataSet Trailer_Send_To_DB(Short_Film objShort_Film, DataTable Artist)
{
try
{
SqlParameter[] objSqlParameter = new SqlParameter[5];
objSqlParameter[0] = new SqlParameter("@Short_film_Id", objShort_Film.Short_film_Id);
objSqlParameter[1] = new SqlParameter("@UserId", objShort_Film.UserId);
objSqlParameter[2] = new SqlParameter("@CreatedDate", objShort_Film.CreatedDate);
objSqlParameter[3] = new SqlParameter("@Trailer", objShort_Film.Trailer);
objSqlParameter[4] = new SqlParameter("@Language", objShort_Film.Language);
return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_Trailer", objSqlParameter));
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
string CategoryIds = ",";
for (int i = 0; i < lstCategory.Items.Count; i++)
{
if (lstCategory.Items[i].Selected)
{
CategoryIds = CategoryIds + lstCategory.Items[i].Value + ",";
}
}
//string Video = fudUploadVideo.FileName;
string Image = fupImage.FileName;
if (txtTitle.Text.Trim() != "" && CategoryIds != "" && txtDescription.Text.Trim() != "" && Image != "" && ddlLanguage.SelectedIndex != 0)
{
if (txtURL.Text.Trim() != "" || txtURLTRailer.Text.Trim() != "")
{
Short_Film objShort_Film = new Short_Film();
//string FileExt = Path.GetExtension(fudUploadVideo.FileName);
string[] Split123 = (txtTitle.Text.Trim()).Split('_');
objShort_Film.Title = Split123[0].ToString();
objShort_Film.Tag = txtTag.Text.Trim();
objShort_Film.Category = CategoryIds;
objShort_Film.Language = ddlLanguage.SelectedValue.ToString();
objShort_Film.Channel = Convert.ToInt32(ddlProduction.SelectedValue.ToString());
string Url = txtURL.Text.Trim();
string[] SplitUrl = Url.Split('/');
string NewUrl = "";
if (SplitUrl.Length != 0)
{
for (int i = 0; i < SplitUrl.Length; i++)
{
if (i == 1)
{
NewUrl = NewUrl + "//player." + SplitUrl[i].ToString();
}
else if (i == 3)
{
NewUrl = NewUrl + "/video/" + SplitUrl[i].ToString();
}
else
{
NewUrl = NewUrl + SplitUrl[i].ToString();
}
}
}
objShort_Film.Video = NewUrl;
objShort_Film.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
objShort_Film.UserId = Convert.ToInt32(Session["UserId"].ToString());
objShort_Film.Description = txtDescription.Text.Trim();
objShort_Film.ShortIds = "";
objShort_Film.Image = Image;
objShort_Film.Short_film_Id = 0;
objShort_Film.Duration = 0;
string Url1 = txtURLTRailer.Text.Trim();
string[] SplitUrl1 = Url1.Split('/');
string NewUrl1 = "";
if (SplitUrl1.Length != 0)
{
for (int i = 0; i < SplitUrl1.Length; i++)
{
if (i == 1)
{
NewUrl1 = NewUrl1 + "//player." + SplitUrl1[i].ToString();
}
else if (i == 3)
{
NewUrl1 = NewUrl1 + "/video/" + SplitUrl1[i].ToString();
}
else
{
NewUrl1 = NewUrl1 + SplitUrl1[i].ToString();
}
}
}
objShort_Film.Trailer = NewUrl1;
objShort_Film.Available = lblAvailable.Text;
//lblAvailable.Text
DataSet objDataSet = Short_Film.Short_Film_Send_To_DB(objShort_Film, (DataTable)ViewState["Artist"]);
if (objDataSet.Tables[0].Rows[0][1].ToString() == "1")
{
//if (Video != "")
// fudUploadVideo.SaveAs(Server.MapPath("~/Videos/") + "Shortfilm_" + objDataSet.Tables[0].Rows[0][0].ToString() + FileExt);
if (Image != "")
{
fupImage.SaveAs(Server.MapPath("~/Video_Images/") + "Shortfilm_" + objDataSet.Tables[0].Rows[0][2].ToString() + ".jpg");
}
if (lblAvailable.Text == "1")
{
if (Image != "")
{
fupImage.SaveAs(Server.MapPath("~/Video_Images/") + "Reg" + objDataSet.Tables[1].Rows[0][0].ToString() + ".jpg");
}
}
ShowNotification("Short Film", "Your film is uploaded successfully and we will inform you shortly once it got approved", NotificationType.success);
if (Convert.ToInt32(Session["UserId"].ToString()) == 1)
{
Display_List(gvShortFilm, "SELECT top 10 LS.Short_film_Id,Title,Tag,Category,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,case when LS.Status='Approve' then 'Approved' else 'Unapproved' end as Status,LS.Video,LS.CreatedDate,LS.CreatedById,LS.ModifiedDate,LS.ModifiedById,LS.Isactive,case when LS.Status='Approve' then 'label label-success' else case when LS.Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,LS.Visits,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(LS.Language,',',1))FOR XML PATH (''))as Language FROM tbl_Short_film SF join tbl_Language_Short_FilmId LS on SF.Short_film_Id=LS.Short_Film_Id where LS.Isactive='True' Order by LS.Short_film_Id desc");
}
else
{
Display_List(gvShortFilm, "SELECT top 10 LS.Short_film_Id,Title,Tag,Category,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,case when LS.Status='Approve' then 'Approved' else 'Unapproved' end as Status,LS.Video,LS.CreatedDate,LS.CreatedById,LS.ModifiedDate,LS.ModifiedById,LS.Isactive,case when LS.Status='Approve' then 'label label-success' else case when LS.Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,LS.Visits,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(LS.Language,',',1))FOR XML PATH (''))as Language FROM tbl_Short_film SF join tbl_Language_Short_FilmId LS on SF.Short_film_Id=LS.Short_Film_Id where LS.Isactive='True' and LS.CreatedById=" + Convert.ToInt32(Session["UserId"].ToString()) + " Order by LS.Short_film_Id desc");
}
Clear_Short_Film();
}
}
else
{
ShowNotification("Short Film", "Please Select Video..!", NotificationType.error);
}
}
else
{
ShowNotification("Short Film", "Please Fill All Fields..!", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
Button btn = sender as Button;
switch (btn.CommandName)
{
case "Save":
if (txtURL.Text.Trim() != "" && lblID.Text.Trim() != "" && ddlLanguage.SelectedIndex != 0)
{
Short_Film objShort_Film = new Short_Film();
objShort_Film.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
objShort_Film.UserId = Convert.ToInt32(Session["UserId"].ToString());
objShort_Film.Short_film_Id = Convert.ToInt32(lblID.Text.Trim());
string Url1 = txtURL.Text.Trim();
string[] SplitUrl1 = Url1.Split('/');
string NewUrl1 = "";
if (SplitUrl1.Length != 0)
{
for (int i = 0; i < SplitUrl1.Length; i++)
{
if (i == 1)
{
NewUrl1 = NewUrl1 + "//player." + SplitUrl1[i].ToString();
}
else if (i == 3)
{
NewUrl1 = NewUrl1 + "/video/" + SplitUrl1[i].ToString();
}
else
{
NewUrl1 = NewUrl1 + SplitUrl1[i].ToString();
}
}
}
objShort_Film.Trailer = NewUrl1;
objShort_Film.Language = ddlLanguage.SelectedValue.ToString();
DataSet objDataSet = Short_Film.Trailer_Send_To_DB(objShort_Film, (DataTable)ViewState["Artist"]);
if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
{
ShowNotification("Trailer", "Your trailer is uploaded successfully and we will inform you shortly once it got approved", NotificationType.success);
ddlTitle.SelectedIndex = 0;
txtTag.Text = "";
ddlLanguage.SelectedIndex = 0;
lblID.Text = "";
if (Session["UserName"] == "admin")
{
Titles_List(gvTitle, "select Title_Id,Title_Name,Isactive,Tag,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Languages,',',1))FOR XML PATH (''))as Languages,CreatedById,Languages as Languages1 from tbl_Register_Title Order by Title_Name");
}
else
{
Titles_List(gvTitle, "select Title_Id,Title_Name,Isactive,Tag,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Languages,',',1))FOR XML PATH (''))as Languages,Languages as Languages1 from tbl_Register_Title where CreatedById='" + Session["UserId"].ToString() + "' Order by Title_Name");
}
}
}
else
{
ShowNotification("Trailer", "Please Select Trailer..!", NotificationType.error);
}
break;
case "Clear":
ddlTitle.SelectedIndex = 0;
txtTag.Text = "";
ddlLanguage.SelectedIndex = 0;
lblID.Text = "";
break;
case "Update":
string ULanguesIds = ",";
for (int i = 0; i < lstUpdateLanguage.Items.Count; i++)
{
if (lstUpdateLanguage.Items[i].Selected)
{
ULanguesIds = ULanguesIds + lstUpdateLanguage.Items[i].Value.ToString() + ",";
}
}
btnClose.Focus();
break;
case "Seach":
break;
}
}
catch (Exception Ex)
{
StackTrace objStackTrace = new StackTrace();
string calledMethodName = objStackTrace.GetFrame(1).GetMethod().Name;
string dispErrorMsg = string.Format("Error occurred in {0} method.", calledMethodName);
LogFile.WriteToLog(dispErrorMsg, Ex);
ShowNotification("Title", dispErrorMsg, NotificationType.error);
SendLogFile.SendMail();
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
if (txtURLTRailer.Text.Trim() != "")
{
Short_Film objShort_Film = new Short_Film();
objShort_Film.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
objShort_Film.UserId = Convert.ToInt32(Session["UserId"].ToString());
objShort_Film.Short_film_Id = Convert.ToInt32(lblShortFilmId.Text.Trim());
string Url1 = txtURLTRailer.Text.Trim();
string[] SplitUrl1 = Url1.Split('/');
string NewUrl1 = "";
if (SplitUrl1.Length != 0)
{
for (int i = 0; i < SplitUrl1.Length; i++)
{
if (i == 1)
{
NewUrl1 = NewUrl1 + "//player." + SplitUrl1[i].ToString();
}
else if (i == 3)
{
NewUrl1 = NewUrl1 + "/video/" + SplitUrl1[i].ToString();
}
else
{
NewUrl1 = NewUrl1 + SplitUrl1[i].ToString();
}
}
}
objShort_Film.Trailer = NewUrl1;
DataSet objDataSet = Short_Film.Trailer_Send_To_DB(objShort_Film, (DataTable)ViewState["Artist"]);
if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
{
ShowNotification("Trailer", "inserted Successfully..", NotificationType.success);
if (Convert.ToInt32(Session["UserId"].ToString()) == 1)
{
Display_List(gvShortFilm, "SELECT Short_film_Id,Title,Tag,Category,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,Status,Video,CreatedDate,CreatedById,ModifiedDate,ModifiedById,Isactive,case when Status='Approve' then 'label label-success' else case when Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,Visits,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Language,',',1))FOR XML PATH (''))as Language FROM tbl_Short_film SF where Isactive='True' Order by Short_film_Id desc");
}
else
{
Display_List(gvShortFilm, "SELECT Short_film_Id,Title,Tag,Category,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,Status,Video,CreatedDate,CreatedById,ModifiedDate,ModifiedById,Isactive,case when Status='Approve' then 'label label-success' else case when Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,Visits,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Language,',',1))FOR XML PATH (''))as Language FROM tbl_Short_film SF where Isactive='True' and CreatedById=" + Convert.ToInt32(Session["UserId"].ToString()));
}
Clear_Short_Film();
}
}
else
{
ShowNotification("Trailer", "Please Select Trailer..!", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
string Video = fudUploadVideo.FileName;
string Image = fupImage.FileName;
if (txtTitle.Text.Trim() != "" && txtTag.Text.Trim() != "" && ddlCategory.SelectedIndex != 0 && ddlChannel.SelectedIndex != 0 && txtDescription.Text.Trim() != "" && Video != "" && Image != "" && ViewState["Artist"] != null)
{
Short_Film objShort_Film = new Short_Film();
string FileExt = Path.GetExtension(fudUploadVideo.FileName);
objShort_Film.Title = txtTitle.Text.Trim();
objShort_Film.Tag = txtTag.Text.Trim();
objShort_Film.Category = ddlCategory.SelectedValue.ToString();
objShort_Film.Language = ddlLanguage.SelectedItem.ToString();
objShort_Film.Channel = Convert.ToInt32(ddlChannel.SelectedValue.ToString());
objShort_Film.Video = FileExt;
objShort_Film.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
objShort_Film.UserId = Convert.ToInt32(Session["UserId"].ToString());
objShort_Film.Description = txtDescription.Text.Trim();
objShort_Film.ShortIds = "";
objShort_Film.Image = Image;
objShort_Film.Short_film_Id = 0;
objShort_Film.Duration = Convert.ToDecimal(txtDuration.Text.Trim());
DataSet objDataSet = Short_Film.Short_Film_Send_To_DB(objShort_Film, (DataTable)ViewState["Artist"]);
if (objDataSet.Tables[0].Rows[0][1].ToString() == "1")
{
if (Video != "")
{
fudUploadVideo.SaveAs(Server.MapPath("~/Videos/") + "Shortfilm_" + objDataSet.Tables[0].Rows[0][0].ToString() + FileExt);
}
if (Image != "")
{
fupImage.SaveAs(Server.MapPath("~/Video_Images/") + "Shortfilm_" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");
}
ShowNotification("Short Film", "inserted Successfully..", NotificationType.success);
if (Convert.ToInt32(Session["UserId"].ToString()) == 1)
{
Display_List(gvShortFilm, "SELECT Short_film_Id,Title,Tag,Hero,Heroine,Technician,Category,Language,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,Status,Video,CreatedDate,CreatedById,ModifiedDate,ModifiedById,Isactive,case when Status='Approve' then 'label label-success' else case when Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,Visits FROM tbl_Short_film SF where Isactive='True' Order by Short_film_Id desc");
}
else
{
Display_List(gvShortFilm, "SELECT Short_film_Id,Title,Tag,Hero,Heroine,Technician,Category,Language,(Select Channel_Name from tbl_admin_channel AC where AC.Channel_Id=SF.Channel)as Channel_Name,Channel,Description,Status,Video,CreatedDate,CreatedById,ModifiedDate,ModifiedById,Isactive,case when Status='Approve' then 'label label-success' else case when Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,Visits FROM tbl_Short_film SF where Isactive='True' and CreatedById=" + Convert.ToInt32(Session["UserId"].ToString()));
}
Clear_Short_Film();
}
}
else
{
ShowNotification("Short Film", "Please Fill All Fields..!", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}