protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session["UserId"] != null)
{
txtUserId.Text = Session["UserId"].ToString();
string ShortFilmId = Request.QueryString["shortfilm"];
string userId1 = Request.QueryString["userId"];
txtVideoUserId.Text = userId1;
txtShortFilmId.Text = ShortFilmId;
if (Request.QueryString["shortfilm"] == null)
{
string Advertisement = Request.QueryString["Advertisement"];
DisplayOnly_Add(Advertisement);
}
else
{
DataSet objDataSet = MasterCode.RetrieveQuery("select Short_film_Id,Title,Video as Shortfilm,CONVERT(varchar(12),CreatedDate,100)as Publish,Description,Visits,'../Video_Images/'+Short_film_Image as Short_film_Image from tbl_Short_film where Short_film_Id=" + ShortFilmId);
if (objDataSet.Tables[0].Rows.Count > 0)
{
add.InnerHtml = "<img Width='773px' Height='435px' src='" + objDataSet.Tables[0].Rows[0]["Short_film_Image"].ToString() + "'/>";
lblTitle.Text = objDataSet.Tables[0].Rows[0]["Title"].ToString();
Display_List(lstMostLiked, "Select top 4 Short_film_Id,Title,Hero,Video,Visits,'frmSingle.aspx?shortfilm='+cast(Short_film_Id as varchar(max)) as shortfilm,'../Video_Images/'+Short_film_Image as Short_film_Image,RIGHT(CONVERT(CHAR(8),DATEADD(second,Duration,0),108),5)as Duration from tbl_Short_film where Isactive='True' and Status='Approve' and Channel in (Select Channel from tbl_Short_film where Short_film_Id=" + ShortFilmId + ") order by Short_film_Id desc ");
lblPublished.Text = objDataSet.Tables[0].Rows[0]["Publish"].ToString();
lblDescription.Text = objDataSet.Tables[0].Rows[0]["Description"].ToString();
lblViews.Text = objDataSet.Tables[0].Rows[0]["Visits"].ToString();
}
//Display_Film(ShortFilmId, userId1);
}
}
else
{
Response.Redirect("~/Login.aspx", false);
}
}
}
catch (Exception Ex)
{
}
}
protected void btnTransfer_Click(object sender, EventArgs e)
{
try
{
if (txtTransferAmount.Text.Trim() != "")
{
if (Convert.ToDecimal(txtTransferAmount.Text.Trim()) <= Convert.ToDecimal(lblDumpEarningAmt.Text.Trim()))
{
DataSet objDataSet = MasterCode.ExcuteOneParameter(txtTransferAmount.Text.Trim(), "Sp_Amount_Transfer", Session["UserId"].ToString());
if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
{
Master.Amount = (Convert.ToDecimal(Master.Amount) + Convert.ToDecimal(txtTransferAmount.Text)).ToString();
txtTransferAmount.Text = "";
//DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Register_User set User_Budget="+txtTransferAmount.Text.Trim()+" where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"] + ")");
ShowNotification("Amount Transfer", "Amount Transfer Successfully..", NotificationType.success);
DataSet objDataSetE = MasterCode.RetrieveQuery("Select EarningAmt from tbl_Register_User where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + ")");
if (objDataSetE.Tables[0].Rows.Count > 0)
{
lblEarning.Text = objDataSetE.Tables[0].Rows[0][0].ToString();
}
else
{
lblEarning.Text = "0.00";
}
Master.EarningAmount = "( " + lblEarning.Text + " )";
txtEarningAmt.Text = lblEarning.Text;
lblDumpEarningAmt.Text = lblEarning.Text;
}
}
else
{
ShowNotification("Amount Transfer", "Invalid Amount..", NotificationType.error);
}
}
else
{
ShowNotification("Amount Transfer", "Please Enter Transfer Amount..", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
public void Send_To_DB()
{
try
{
Admin_User objAdmin_User = new Admin_User();
objAdmin_User.Address = txtAddress.Text.Trim();
objAdmin_User.EmailId = txtEmailId.Text.Trim();
objAdmin_User.Mobile = txtMobileNumber.Text.Trim();
objAdmin_User.Name = txtName.Text.Trim();
objAdmin_User.DOB = Convert.ToDateTime("1999-1-1");
objAdmin_User.RegisterId = 0;
objAdmin_User.DumpEmailId = "";
objAdmin_User.Img = "";
objAdmin_User.CityId = Convert.ToInt32(ddlCity.SelectedValue.ToString());
objAdmin_User.UserId = 0;
objAdmin_User.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
DataSet objDataSet12 = Admin_User.Send_User_To_DB(objAdmin_User);
if (objDataSet12.Tables[0].Rows[0][1].ToString() == "1")
{
objDataSet = MasterCode.RetrieveQuery("select User_Id,Isactive,Username,UserCode,UserRights from tbl_user where Username='******'");
DataTable menuData = new DataTable();
menuData = GetMenuData(objDataSet.Tables[0].Rows[0]["UserRights"].ToString());
AddTopMenuItems(menuData);
Session["Menu"] = menu.Replace("<ul></ul>", "");
//if (objDataSet.Tables[0].Rows[0]["User_Id"].ToString() == "1" || objDataSet.Tables[0].Rows[0]["User_Id"].ToString() == "2" || objDataSet.Tables[0].Rows[0]["User_Id"].ToString() == "3")
if (Session["RedirectURL"] == null)
{
Response.Redirect("Admin/frmHome.aspx", false);
}
else
{
Response.Redirect(Session["RedirectURL"].ToString(), false);
Session["RedirectURL"] = null;
}
}
else
{
ShowNotification("Login", "Sorry! EmailId already exist Please use another one..!", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
String myUrl = Request.RawUrl.ToString();
var result = Path.GetFileName(myUrl);
String Folder = Path.GetDirectoryName(myUrl);
string[] SplitOffer = Folder.Split('\\');
for (int i = 0; i < SplitOffer.Length; i++)
{
if (i == 1)
{
Master.master_lblUrl = "../" + SplitOffer[i] + "/" + result;
}
}
DataSet objDataSet = MasterCode.RetrieveQuery("select count(*) from tbl_Admin_Channel where CreatedById=" + Session["UserId"].ToString());
if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) > 0)
{
Response.Redirect("frmProductionList.aspx", false);
btnSubmit.Visible = false;
}
else
{
btnSubmit.Visible = true;
}
//Productions_List(gvProduction, "select Channel_Id,Channel_Name,Isactive,Description from tbl_Admin_Channel where CreatedById=" + Session["UserId"].ToString() + " Order by Channel_Name");
txtProduction.Focus();
Display_List(lstOther, "select Channel_Id,Channel_Name,Isactive,Description,'../ProductionImg/'+Img as Img from tbl_Admin_Channel where Isactive='true' Order by Channel_Name");
//ShowNotification("Production", "Please Create Production First..", NotificationType.info);
}
}
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("Production", dispErrorMsg, NotificationType.error);
SendLogFile.SendMail();
}
}
protected void ddlTitle_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Title_Id,Title_Name,Languages,Tag,Isactive from tbl_Register_Title where Isactive='true' and Title_Id=" + ddlTitle.SelectedValue.ToString());
if (objDataSet.Tables[0].Rows.Count > 0)
{
txtTitle.Text = objDataSet.Tables[0].Rows[0]["Title_Name"].ToString();
ddlTitle.ClearSelection();
if (ddlTitle.Items.FindByText(objDataSet.Tables[0].Rows[0]["Title_Name"].ToString()) != null)
{
ddlTitle.Items.FindByText(objDataSet.Tables[0].Rows[0]["Title_Name"].ToString()).Selected = true;
}
lblID.Text = objDataSet.Tables[0].Rows[0]["Title_Id"].ToString();
//lblDName.Text = (gvTitle.Rows[index].FindControl("lblGridTitle") as Label).Text;
txtTag.Text = objDataSet.Tables[0].Rows[0]["Tag"].ToString();
DropDownList(ddlLanguage, "Language_Id", "Language_Name", "Select Language_Id,Language_Name from tbl_admin_language where Isactive='true' and Language_Id in (0" + objDataSet.Tables[0].Rows[0]["Languages"].ToString() + "0) order by Language_Name", "Select");
//CheckBoxList(lstLanguage, "Language_Id", "Language_Name", "Select Language_Id,Language_Name from tbl_admin_language where Isactive='true' order by Language_Name");
//lstLanguage.ClearSelection();
//string[] Split = (objDataSet.Tables[0].Rows[0]["Languages"].ToString()).Split(',');
//if (Split.Length > 0)
// for (int i = 0; i < Split.Length; i++)
// foreach (ListItem li in lstLanguage.Items)
// if (li.Value == Split[i])
// li.Selected = true;
if (objDataSet.Tables[0].Rows[0]["Isactive"].ToString() == "True")
{
rdbActiveNoTitle.Checked = false; rdbActiveYesTitle.Checked = true;
}
else
{
rdbActiveYesTitle.Checked = false; rdbActiveNoTitle.Checked = true;
}
}
}
catch (Exception Ex)
{
}
}
protected void lnkView_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = sender as LinkButton;
GridViewRow Row = (GridViewRow)lnk.NamingContainer;
DataSet objDataSet1 = MasterCode.RetrieveQuery("Update tbl_Advertisement set Isactive='false' where Advertisement_Id=" + lnk.CommandName);
ShowNotification("Advertisement", "Advertisement Deleted Successfully..!", NotificationType.success);
Search();
}
catch (Exception Ex)
{
}
}
protected void lnkView_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = sender as LinkButton;
GridViewRow Row = (GridViewRow)lnk.NamingContainer;
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Language_Short_FilmId set Isactive='false' where Lan_Short_film_Id=" + lnk.CommandName);
ShowNotification("Short Film", "Short Film Deleted Successfully..!", NotificationType.success);
Search();
}
catch (Exception Ex)
{
}
}
public void User_Profile()
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Register_Id,Name,Mobile_No,EmailId,Address,CONVERT(varchar(12),DOB,100)as DOB,Photo,City_Id,(Select District_Id from tbl_admin_city C where C.City_Id=U.City_Id)as District_Id,(Select (select State_Id from tbl_admin_district AD where AD.District_Id=C.District_Id) from tbl_admin_city C where C.City_Id=U.City_Id)as State_Id from tbl_Register_User U where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + ")");
if (objDataSet.Tables[0].Rows.Count > 0)
{
ddlState.ClearSelection();
if (ddlState.Items.FindByValue(objDataSet.Tables[0].Rows[0]["State_Id"].ToString()) != null)
{
ddlState.Items.FindByValue(objDataSet.Tables[0].Rows[0]["State_Id"].ToString()).Selected = true;
}
DropDownList(ddlDistrict, "District_Id", "District_Name", "Select District_Id,District_Name from tbl_admin_district where Isactive='True' and State_Id=" + ddlState.SelectedValue.ToString() + " Order by District_Name", "Select");
ddlDistrict.ClearSelection();
if (ddlDistrict.Items.FindByValue(objDataSet.Tables[0].Rows[0]["District_Id"].ToString()) != null)
{
ddlDistrict.Items.FindByValue(objDataSet.Tables[0].Rows[0]["District_Id"].ToString()).Selected = true;
}
DropDownList(ddlCity, "City_Id", "City_Name", "Select City_Id,City_Name from tbl_admin_city where Isactive='True' and District_Id=" + ddlDistrict.SelectedValue + " Order by City_Name", "Select");
ddlCity.ClearSelection();
if (ddlCity.Items.FindByValue(objDataSet.Tables[0].Rows[0]["City_Id"].ToString()) != null)
{
ddlCity.Items.FindByValue(objDataSet.Tables[0].Rows[0]["City_Id"].ToString()).Selected = true;
}
txtName.Text = objDataSet.Tables[0].Rows[0]["Name"].ToString();
txtMobileNumber.Text = objDataSet.Tables[0].Rows[0]["Mobile_No"].ToString();
txtAddress.Text = objDataSet.Tables[0].Rows[0]["Address"].ToString();
txtEmailId.Text = objDataSet.Tables[0].Rows[0]["EmailId"].ToString();
lblRegisterId.Text = objDataSet.Tables[0].Rows[0]["Register_Id"].ToString();
lblDumpEmailId.Text = objDataSet.Tables[0].Rows[0]["EmailId"].ToString();
if (objDataSet.Tables[0].Rows[0]["DOB"].ToString() != "")
{
txtDateofBirth.Text = Convert.ToDateTime(objDataSet.Tables[0].Rows[0]["DOB"].ToString()).ToString("yyyy-MM-dd");
}
imgPhoto.ImageUrl = "~/User_Photos/" + objDataSet.Tables[0].Rows[0]["Photo"].ToString();
}
}
catch (Exception Ex)
{
}
}
protected void gvUserList_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("detail"))
{
string AddColum = "";
int index = Convert.ToInt32(e.CommandArgument);
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_user set Isactive='true',ModifiedDate='" + DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00.000' where Username='******'");
DataSet objDataSet23 = MasterCode.RetrieveQuery("Update tbl_Register_User set Isactive='true',ModifiedDate=getdate() where Register_Id in (Select Staff_Id from tbl_user where Username='******')");
DataSet objDataSet1 = MasterCode.RetrieveQuery("Delete from tbl_LoginFailed where UserName='******' and DateTime='" + DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00.000'");
ShowNotification("User", "Active Successfully..", NotificationType.success);
if (txtSearchName.Text != "")
{
AddColum = AddColum + " Name Like '" + txtSearchName.Text.Trim() + "%' and ";
}
if (AddColum != "")
{
AddColum = AddColum.Remove(AddColum.Length - 4, 4);
Display_List(gvUserList, "SELECT [Register_Id],[Name],[Mobile_No],[EmailId],[Address] ,convert(varchar(12),DOB,103)as [DOB],'../User_Photos/'+Photo as Photo,U.Isactive,(Select Username from tbl_user TU where TU.Staff_Id=U.Register_Id)as Username,(Select Password from tbl_user TU where TU.Staff_Id=U.Register_Id)as Password FROM tbl_Register_User U Join tbl_user T on U.Register_Id=T.Staff_Id where T.Isactive='false' and " + AddColum + " Order by Register_Id desc");
}
else
{
Display_List(gvUserList, "SELECT [Register_Id],[Name],[Mobile_No],[EmailId],[Address] ,convert(varchar(12),DOB,103)as [DOB],'../User_Photos/'+Photo as Photo,U.Isactive,(Select Username from tbl_user TU where TU.Staff_Id=U.Register_Id)as Username,(Select Password from tbl_user TU where TU.Staff_Id=U.Register_Id)as Password FROM tbl_Register_User U Join tbl_user T on U.Register_Id=T.Staff_Id where T.Isactive='false' Order by Register_Id desc");
}
//lblName.Text = (gvUserList.Rows[index].FindControl("lblName") as Label).Text;
//lblUsrname.Text = (gvUserList.Rows[index].FindControl("lblgridUsername") as Label).Text;
//rdbActiveYesState.Checked = true;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModalScript", "divPopup()", true);
}
}
catch (Exception Ex)
{
}
}
public void Display_Add(string ShortFilmId)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Advertisement_Id,Title,'../Videos/'+Video as Advertisement,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Advertisement where Isactive='True' and ShortFilmId=" + ShortFilmId);
if (objDataSet.Tables[0].Rows.Count > 0)
{
DataSet obj = MasterCode.RetrieveQuery("select Short_film_Id,Title,'../Videos/'+Video as Shortfilm,CONVERT(varchar(12),CreatedDate,100)as Publish,Description,Visits from tbl_Short_film where Short_film_Id=" + ShortFilmId);
lblNextVideo.Text = obj.Tables[0].Rows[0]["Shortfilm"].ToString();
id.Attributes.Add("data-href", "http://www.nscreens.com/Admin/frmSingle.aspx?shortfilm=" + ShortFilmId);
lblTitle.Text = obj.Tables[0].Rows[0]["Title"].ToString();
//Video.Attributes.Add("src", objDataSet.Tables[0].Rows[0]["Advertisement"].ToString());
add.InnerHtml = "<video id='Video' height='376px' width='100%' autoplay onended='Display()'><source id='add123' src='" + objDataSet.Tables[0].Rows[0]["Advertisement"].ToString() + "' type='video/mp4'>";
lblPublished.Text = obj.Tables[0].Rows[0]["Publish"].ToString();
lblDescription.Text = obj.Tables[0].Rows[0]["Description"].ToString();
lblViews.Text = obj.Tables[0].Rows[0]["Visits"].ToString();
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + objDataSet.Tables[0].Rows[0]["Advertisement_Id"].ToString());
}
else
{
DataSet objDataSet1 = MasterCode.RetrieveQuery("Select Advertisement_Id,Title,'../Videos/'+Video as Advertisement,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Advertisement where Isactive='True'");
if (objDataSet1.Tables[0].Rows.Count > 0)
{
DataSet obj = MasterCode.RetrieveQuery("select Short_film_Id,Title,'../Videos/'+Video as Shortfilm,CONVERT(varchar(12),CreatedDate,100)as Publish,Description,Visits from tbl_Short_film where Short_film_Id=" + ShortFilmId);
lblNextVideo.Text = obj.Tables[0].Rows[0]["Shortfilm"].ToString();
id.Attributes.Add("data-href", "http://www.nscreens.com/Admin/frmSingle.aspx?shortfilm=" + ShortFilmId);
lblTitle.Text = obj.Tables[0].Rows[0]["Title"].ToString();
//Video.Attributes.Add("src", objDataSet1.Tables[0].Rows[0]["Advertisement"].ToString());
add.InnerHtml = "<video id='Video' height='376px' width='100%' autoplay onended='Display()'><source id='add123' src='" + objDataSet1.Tables[0].Rows[0]["Advertisement"].ToString() + "' type='video/mp4'>";
lblPublished.Text = obj.Tables[0].Rows[0]["Publish"].ToString();
lblDescription.Text = obj.Tables[0].Rows[0]["Description"].ToString();
lblViews.Text = obj.Tables[0].Rows[0]["Visits"].ToString();
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + objDataSet1.Tables[0].Rows[0]["Advertisement_Id"].ToString());
}
}
Display_List(lstMostLiked, "Select top 4 Short_film_Id,Title,Hero,Video,Visits,'frmSingle.aspx?shortfilm='+cast(Short_film_Id as varchar(max)) as shortfilm,'../Video_Images/'+Short_film_Image as Short_film_Image,RIGHT(CONVERT(CHAR(8),DATEADD(second,Duration,0),108),5)as Duration from tbl_Short_film where Isactive='True' and Status='Approve' and Channel in (Select Channel from tbl_Short_film where Short_film_Id=" + ShortFilmId + ") order by Short_film_Id desc ");
Display_List(lstRelatedVideos, "Select top 3 Short_film_Id,Title,Hero,Video,Visits,'frmSingle.aspx?shortfilm='+cast(Short_film_Id as varchar(max)) as shortfilm,'../Video_Images/'+Short_film_Image as Short_film_Image,RIGHT(CONVERT(CHAR(8),DATEADD(second,Duration,0),108),5)as Duration from tbl_Short_film where Isactive='True' and Status='Approve' and Channel in (Select Channel from tbl_Short_film where Short_film_Id=" + ShortFilmId + ") order by Short_film_Id desc ");
Display_List(lstMost, "Select top 2 Short_film_Id,Title,Hero,Video,Visits,'frmSingle.aspx?shortfilm='+cast(Short_film_Id as varchar(max)) as shortfilm,'../Video_Images/'+Short_film_Image as Short_film_Image,RIGHT(CONVERT(CHAR(8),DATEADD(second,Duration,0),108),5)as Duration from tbl_Short_film where Isactive='True' and Status='Approve' and Channel in (Select Channel from tbl_Short_film where Short_film_Id=" + ShortFilmId + ") order by Visits desc ");
}
catch (Exception Ex)
{
}
}
public void Display_List(GridView gv, string Query)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery(Query);
if (objDataSet.Tables[0].Rows.Count > 0)
{
gv.DataSource = objDataSet;
gv.DataBind();
}
else
{
Display_List(gvArtist, "select null as Id,null as Artist_Id,''as Artist,'' as Name,''as NameId,'' as Short_Artist_Id");
}
}
catch (Exception Ex)
{
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (txtDescriptionArtist.Text.Trim() != "")
{
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Short_film set Description='" + txtDescriptionArtist.Text.Trim() + "' where Short_film_Id=" + lblShortId.Text);
string Image1 = fupImage.FileName;
if (Image1 != "")
{
fupImage.SaveAs(Server.MapPath("~/Video_Images/") + "Shortfilm_" + lblShortId.Text + ".jpg");
}
}
}
catch (Exception Ex)
{
}
}
protected void lnkAdd_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = sender as LinkButton;
GridViewRow Row = (GridViewRow)lnk.NamingContainer;
if ((Row.FindControl("ddlArtist") as DropDownList).SelectedIndex != 0)
{
string ff = (Row.FindControl("ddlArtist") as DropDownList).SelectedValue.ToString();
DataSet objDataSet = MasterCode.RetrieveQuery("insert into tbl_Short_Artist(Artist_Id,Short_Film_Id,Language_Short_Id) values(" + (Row.FindControl("ddlAName") as DropDownList).SelectedValue.ToString() + "," + lblShortId.Text + "," + lblShortId.Text + ")");
Display_List(gvArtist, "Select Short_Artist_Id,AD.Name as NameId,Artist_Details_Id as Name,Interest_Areas as Artist_Id,(Select Artist_Name from tbl_admin_Artist AA where AA.Artist_Id=AD.Interest_Areas)as Artist from tbl_Artist_Details AD join tbl_Short_Artist SA on AD.Artist_Details_Id=SA.Artist_Id where Short_Film_Id=" + lblShortId.Text);
DropDownList((gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList), "Artist_Id", "Artist_Name", "Select Artist_Id,Artist_Name from tbl_admin_Artist where Isactive='True' Order by Artist_Name", "Select");
}
}
catch (Exception Ex)
{
}
}
public void DisplayOnly_Add(string ShortFilmId)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Advertisement_Id,Title,Video as Advertisement,CONVERT(varchar(12),CreatedDate,100)as Publish,Description,Visits from tbl_Advertisement where Isactive='True' and Advertisement_Id=" + ShortFilmId);
if (objDataSet.Tables[0].Rows.Count > 0)
{
id.Attributes.Add("data-href", "http://www.nscreens.com/Admin/frmSingle.aspx?shortfilm=" + ShortFilmId);
lblTitle.Text = objDataSet.Tables[0].Rows[0]["Title"].ToString();
//add.InnerHtml = "<video id='Video' height='376px' width='100%' autoplay onended='Add_Budget()'><source id='add123' src='" + objDataSet.Tables[0].Rows[0]["Advertisement"].ToString() + "' type='video/mp4'>";
txtNextPN.Text = "AddB";
add.InnerHtml = "<iframe id='player1' runat='server' src='" + objDataSet.Tables[0].Rows[0]["Advertisement"].ToString() + "?autoplay=1&api=1&player_id=player1' width='630' height='354' frameborder='0' webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>";
lblPublished.Text = objDataSet.Tables[0].Rows[0]["Publish"].ToString();
lblDescription.Text = objDataSet.Tables[0].Rows[0]["Description"].ToString();
lblViews.Text = objDataSet.Tables[0].Rows[0]["Visits"].ToString();
DataSet objDataSetGetBudget = MasterCode.RetrieveQuery("Select Short_Film,Admin,Promoter,Video_Sharing from tbl_Budget_Settings where Budget_Settings_Id in (Select case when PromoCode IS NULL then 2 else 1 end from tbl_Register_User where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + "))");
if (objDataSetGetBudget.Tables[0].Rows.Count > 0)
{
DataSet objDataSetVisits12 = MasterCode.RetrieveQuery("insert into tbl_Advertizment_Visits(Advertisement_Id,User_Id,Date_Time,City_Id,IPAddress,User_Budget,Promoter_Budget,Admin_Budget,Video_Sharing) values(" + objDataSet.Tables[0].Rows[0]["Advertisement_Id"].ToString() + "," + Session["UserId"].ToString() + ",'" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd HH:mm") + "','Eluru','" + Request.UserHostAddress + "'," + objDataSetGetBudget.Tables[0].Rows[0]["Short_Film"] + "," + objDataSetGetBudget.Tables[0].Rows[0]["Promoter"] + "," + objDataSetGetBudget.Tables[0].Rows[0]["Admin"] + "," + objDataSetGetBudget.Tables[0].Rows[0]["Video_Sharing"] + ")");
}
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + objDataSet.Tables[0].Rows[0]["Advertisement_Id"].ToString());
}
string Gender = "", DOB = "";
DataSet objDataSetA = MasterCode.RetrieveQuery("Select Gender,DATEDIFF(hour,DOB,GETDATE())/8766 AS AgeYearsIntTrunc from tbl_Register_User R join tbl_user U on R.Register_Id=U.Staff_Id where U.Username='******'");
if (objDataSetA.Tables[0].Rows.Count > 0)
{
Gender = objDataSetA.Tables[0].Rows[0][0].ToString();
DOB = objDataSetA.Tables[0].Rows[0][1].ToString();
}
Display_List(lstMostLiked, "Select top 4 Advertisement_Id,Title,Video,Visits,'frmSingle.aspx?Advertisement='+cast(Advertisement_Id as varchar(max)) as shortfilm,'../Video_Images/'+Advertisement_Image as Short_film_Image,Visits from tbl_Advertisement where Isactive='True' and Status='Approve' and NoofVisits>Visits and Gender in ('ALL','" + Gender + "') and " + DOB + " >= Agefrom and " + DOB + " <= Ageto and EndDate>'" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' and StartDate<='" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' order by Advertisement_Id desc ");
Display_List(lstRelatedVideos, "Select top 3 Advertisement_Id,Title,Video,Visits,'frmSingle.aspx?Advertisement='+cast(Advertisement_Id as varchar(max)) as shortfilm,'../Video_Images/'+Advertisement_Image as Short_film_Image,Visits,'0' as Duration from tbl_Advertisement where Isactive='True' and Status='Approve' and NoofVisits>Visits and Gender in ('ALL','" + Gender + "') and " + DOB + " >= Agefrom and " + DOB + " <= Ageto and EndDate>'" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' and StartDate<='" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' order by Advertisement_Id desc ");
Display_List(lstMost, "Select top 2 Advertisement_Id,Title,Video,Visits,'frmSingle.aspx?Advertisement='+cast(Advertisement_Id as varchar(max)) as shortfilm,'../Video_Images/'+Advertisement_Image as Short_film_Image,Visits,'0' as Duration from tbl_Advertisement where Isactive='True' and Status='Approve' and NoofVisits>Visits and Gender in ('ALL','" + Gender + "') and " + DOB + " >= Agefrom and " + DOB + " <= Ageto and EndDate>'" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' and StartDate<='" + DateTime.Now.AddHours(Connection.SetHours).ToString("yyyy-MM-dd") + "' order by Advertisement_Id desc ");
}
catch (Exception Ex)
{
}
}
protected void btnApproval_Click(object sender, EventArgs e)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Trailer set Status='" + ddlAppStatus.SelectedItem.ToString() + "' where Trailer_Id=" + lblAdvertisementId.Text);
DataSet objDataSet2 = MasterCode.RetrieveQuery("Select Username from tbl_user where User_Id in (Select CreatedById from tbl_Trailer where Trailer_Id=" + lblAdvertisementId.Text + ")");
SendMessage objSendMessage = new SendMessage();
objSendMessage.SendFrom = Session["UserId"].ToString();
objSendMessage.SendTo = objDataSet2.Tables[0].Rows[0]["Username"].ToString();
objSendMessage.Message = "Hello " + Session["Name"].ToString() + ",<br/><br/> Your trailer " + txtAppTitle.Text + " has been approved successfully.<br/><br/>With Love,<br/>Nscreens";
objSendMessage.CreatedDate = DateTime.Now;
objSendMessage.Subject = "Approve " + txtAppTitle.Text;
DataSet objDataSet1 = SendMessage.Send_Message(objSendMessage);
ShowNotification("Short film", "Short film " + ddlAppStatus.SelectedItem.ToString() + " Successfully..", NotificationType.success);
if (Convert.ToInt32(Session["UserId"].ToString()) == 1)
{
Display_List(gvShortFilm, "SELECT Lan_Short_film_Id,SF.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,LS.Status,LS.Video,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,(Select Language_Name from tbl_admin_language where Language_Id=LS.Language)as Language,(Select (Select EmailId from tbl_Register_User R where R.Register_Id=U.Staff_Id) from tbl_user U where U.User_Id=SF.CreatedById)as EmailId 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.Status='Requested'");
}
else
{
Display_List(gvShortFilm, "SELECT Lan_Short_film_Id,SF.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,LS.Status,LS.Video,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,(Select Language_Name from tbl_admin_language where Language_Id=LS.Language)as Language,(Select (Select EmailId from tbl_Register_User R where R.Register_Id=U.Staff_Id) from tbl_user U where U.User_Id=SF.CreatedById)as EmailId 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.Status='Requested' and LS.CreatedById=" + Convert.ToInt32(Session["UserId"].ToString()));
}
ShowNotification("Trailer", "" + ddlAppStatus.SelectedItem.ToString() + " Successfully..", NotificationType.success);
if (Convert.ToInt32(Session["UserId"].ToString()) == 1)
{
Display_List(gvShortFilm, "SELECT Trailer_Id,Title_Name,Tag,(Select Channel_Name from tbl_admin_channel AC where AC.CreatedById=SF.CreatedById)as Channel_Name,T.Status,Trailer_Url as Video,T.Isactive,case when T.Status='Approve' then 'label label-success' else case when T.Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,(Select Language_Name from tbl_admin_language L where L.Language_Id=T.LanguageId)as Language FROM tbl_Register_Title SF Join tbl_Trailer T on SF.Title_Id=T.Register_Title_Id where T.Isactive='True' and T.Status='Requested'");
}
else
{
Display_List(gvShortFilm, "SELECT Trailer_Id,Title_Name,Tag,(Select Channel_Name from tbl_admin_channel AC where AC.CreatedById=SF.CreatedById)as Channel_Name,T.Status,Trailer_Url as Video,T.Isactive,case when T.Status='Approve' then 'label label-success' else case when T.Status='Unapprove' then 'label label-danger' else 'label label-warning' end end as StatusClr,(Select Language_Name from tbl_admin_language L where L.Language_Id=T.LanguageId)as Language FROM tbl_Register_Title SF Join tbl_Trailer T on SF.Title_Id=T.Register_Title_Id where T.Isactive='True' and T.Status='Requested' and CreatedById=" + Convert.ToInt32(Session["UserId"].ToString()));
}
}
catch (Exception Ex)
{
}
}
public string GetData()
{
string Plots = "call();";
//DataSet objDataSet = MasterCode.RetrieveQuery("select Plot_ID,Plot_UI_Id,Road_Facing,Plot_N0,House_Facing,Length,Breadth,case when Status=1 then '#9dcc77' else '#ed719e' end as Available,Price,((Length*Breadth)/9) as Area_In_Yards,(Select Status_Name from tbl_admin_Status TA where TA.Status_Id=AP.Status)as Status_Name from tbl_admin_Add_Plot AP where Isactive='True' and Layout_Name_ID=2");
//if (objDataSet.Tables[0].Rows.Count > 0)
// for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
// Plots = Plots + "addEvent('" + objDataSet.Tables[0].Rows[i]["Plot_UI_Id"].ToString() + "');";
if (lblAddId.Text.Trim() != "")
{
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + lblAddId.Text.Trim());
DataSet objDataSetUp = MasterCode.RetrieveQuery("update tbl_Register_User set User_Budget=User_Budget+(Select Budget from tbl_Budget_Settings where Budget_Settings_Id=2) where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + ")");
DataSet objDataSet2 = MasterCode.RetrieveQuery("Select User_Budget from tbl_Register_User where Isactive='True' and Register_Id in (select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + ")");
if (objDataSet2.Tables[0].Rows.Count > 0)
{
this.Master.Amount = objDataSet2.Tables[0].Rows[0][0].ToString();
}
}
return(Plots);
}
public void Display_List(GridView gv, string Query)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery(Query);
if (objDataSet.Tables[0].Rows.Count > 0)
{
gv.DataSource = objDataSet;
gv.DataBind();
}
else
{
gv.DataSource = "";
gv.DataBind();
}
}
catch (Exception Ex)
{
}
}
protected void lstAllPromoters_ItemCommand(object sender, ListViewCommandEventArgs e)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Register_Id,Name,Mobile_No,EmailId,Address,CONVERT(varchar(12),DOB,100)as DOB,PromoCode,'../User_Photos/'+Photo as Photo,Photo as MainPhoto,(Select City_Name from tbl_admin_City C where C.City_Id=ru.Promo_CityId)as City_Name,(Select (Select District_Name from tbl_admin_district D where D.District_Id=C.District_Id) from tbl_admin_City C where C.City_Id=ru.Promo_CityId)as District_Name,(Select (Select (Select State_Name from tbl_admin_state S where S.State_Id=D.State_Id) from tbl_admin_district D where D.District_Id=C.District_Id) from tbl_admin_City C where C.City_Id=ru.Promo_CityId)as State_Name,Contact_info,Promo_Img from tbl_Register_User ru jOIN tbl_user U ON U.Staff_Id=RU.Register_Id where RU.Isactive='true' and PromoCode is not null and U.User_Id='" + Session["UserId"].ToString() + "'");
if (objDataSet.Tables[0].Rows.Count > 0)
{
DropDownList(ddlPromoState, "State_Id", "State_Name", "Select State_Id,State_Name from tbl_admin_state where Isactive='true' Order by State_Name", "All States");
if (ddlPromoState.Items.FindByText(objDataSet.Tables[0].Rows[0]["State_Name"].ToString()) != null)
{
ddlPromoState.Items.FindByText(objDataSet.Tables[0].Rows[0]["State_Name"].ToString()).Selected = true;
}
DropDownList(ddlPromoDistrict, "District_Id", "District_Name", "Select District_Id,District_Name from tbl_admin_district where Isactive='true' and State_Id='" + ddlPromoState.SelectedValue.ToString() + "' order by District_Name", "All Districts");
if (ddlPromoDistrict.Items.FindByText(objDataSet.Tables[0].Rows[0]["District_Name"].ToString()) != null)
{
ddlPromoDistrict.Items.FindByText(objDataSet.Tables[0].Rows[0]["District_Name"].ToString()).Selected = true;
}
DropDownList(ddlPromoCity, "City_Id", "City_Name", "Select City_Id,City_Name from tbl_admin_city where Isactive='true' and District_Id=" + ddlPromoDistrict.SelectedValue.ToString() + " Order by City_Name", "All Locations");
if (ddlPromoCity.Items.FindByText(objDataSet.Tables[0].Rows[0]["City_Name"].ToString()) != null)
{
ddlPromoCity.Items.FindByText(objDataSet.Tables[0].Rows[0]["City_Name"].ToString()).Selected = true;
}
imgpromo.ImageUrl = objDataSet.Tables[0].Rows[0]["Photo"].ToString();
txtpromoName.Text = objDataSet.Tables[0].Rows[0]["Name"].ToString();
txtContactinfo.Text = objDataSet.Tables[0].Rows[0]["Contact_info"].ToString();
txtState.Text = objDataSet.Tables[0].Rows[0]["State_Name"].ToString();
txtDistrict.Text = objDataSet.Tables[0].Rows[0]["District_Name"].ToString();
lblEmailId.Text = objDataSet.Tables[0].Rows[0]["EmailId"].ToString();
lblAddress.Text = objDataSet.Tables[0].Rows[0]["Address"].ToString();
txtCity.Text = objDataSet.Tables[0].Rows[0]["City_Name"].ToString();
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModalScript", "divPopupEdit()", true);
}
catch (Exception Ex)
{
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
int n = 4;
for (int i = 1; i <= n; i++)
{
string Email1 = "", SMS1 = "";
if (i == 1)
{
Email1 = chkRegisterEmail.Checked.ToString();
SMS1 = chkRegisterSMS.Checked.ToString();
}
if (i == 2)
{
Email1 = chkChangePasswordEmail.Checked.ToString();
SMS1 = chkChangePasswordSMS.Checked.ToString();
}
if (i == 3)
{
Email1 = chkForgetPasswordEmail.Checked.ToString();
SMS1 = chkForgetPasswordSMS.Checked.ToString();
}
if (i == 4)
{
Email1 = chkWalletAmountEmail.Checked.ToString();
SMS1 = chkWalletAmountSMS.Checked.ToString();
}
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Settings set Email='" + Email1 + "',SMS='" + SMS1.ToString() + "' where Sent_Settings_Id=" + i.ToString());
ShowNotification("Settings", "Changed Successfully..", NotificationType.success);
}
}
catch (Exception Ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
string Artist_Id = Request.QueryString["Id"];
DataSet objDataSet = MasterCode.RetrieveQuery("Select Artist_Id,Artist_Name from tbl_admin_Artist where Artist_Id=" + Artist_Id);
if (objDataSet.Tables[0].Rows.Count > 0)
{
lblArtistType.Text = objDataSet.Tables[0].Rows[0][1].ToString();
}
Artists_List(gvArtist, "SELECT Artist_Details_Id,Name,Description,Gender,Artist_Name,AD.Isactive FROM tbl_Artist_Details AD Join tbl_admin_Artist TA on AD.Interest_Areas=TA.Artist_Id and Interest_Areas='" + Artist_Id + "'");
}
}
catch (Exception Ex)
{
}
}
public string AddBudget()
{
try
{
string url = Request.Url.AbsoluteUri;
string[] Split = url.Split('/');
DataSet objDataSetGetBudget = MasterCode.RetrieveQuery("Select Short_Film,Admin,Promoter from tbl_Budget_Settings where Budget_Settings_Id in (Select case when PromoCode IS NULL then 2 else 1 end from tbl_Register_User where Register_Id in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + "))");
if (objDataSetGetBudget.Tables[0].Rows.Count > 0)
{
objDataSetGetBudget = MasterCode.RetrieveQuery("insert into tbl_Budget(User_Budget,Promoter_Budget,Admin_Budget,Short_Film_Id,CreatedDate,CreatedById) values(" + objDataSetGetBudget.Tables[0].Rows[0]["Short_Film"] + "," + objDataSetGetBudget.Tables[0].Rows[0]["Promoter"] + "," + objDataSetGetBudget.Tables[0].Rows[0]["Admin"] + "," + Split[Split.Length - 2] + ",'" + DateTime.Now.AddHours(Connection.SetHours).ToShortDateString() + "'," + Session["UserId"].ToString() + ")");
}
DataSet objDataSetUp = MasterCode.RetrieveQuery("update tbl_Short_film set Visits=Visits+1 where Short_film_Id=" + Split[Split.Length - 2]);
}
catch (Exception Ex)
{
}
return("");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string Block = "";
if (rdbActiveYesState.Checked)
{
Block = "false";
}
else
{
Block = "true";
}
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_user set Isactive='" + Block + "',ModifiedDate=getdate() where Username='******'");
DataSet objDataSet23 = MasterCode.RetrieveQuery("Update tbl_Register_User set Isactive='" + Block + "',ModifiedDate=getdate() where Register_Id in (Select Staff_Id from tbl_user where Username='******')");
DataSet objDataSet1 = MasterCode.RetrieveQuery("Delete from tbl_LoginFailed where UserName='******' and DateTime='" + DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00.000'");
ShowNotification("User", "Active Successfully..", NotificationType.success);
string AddColum = "";
if (txtSearchName.Text != "")
{
AddColum = AddColum + " Name Like '" + txtSearchName.Text.Trim() + "%' and ";
}
if (AddColum != "")
{
AddColum = AddColum.Remove(AddColum.Length - 4, 4);
Display_List(gvUserList, "SELECT [Register_Id],[Name],[Mobile_No],[EmailId],[Address] ,convert(varchar(12),DOB,103)as [DOB],'../User_Photos/'+Photo as Photo,U.Isactive,(Select Username from tbl_user TU where TU.Staff_Id=U.Register_Id)as Username,(Select Password from tbl_user TU where TU.Staff_Id=U.Register_Id)as Password FROM tbl_Register_User U Join tbl_user T on U.Register_Id=T.Staff_Id where T.Isactive='false' and " + AddColum + " Order by Register_Id desc");
}
else
{
Display_List(gvUserList, "SELECT [Register_Id],[Name],[Mobile_No],[EmailId],[Address] ,convert(varchar(12),DOB,103)as [DOB],'../User_Photos/'+Photo as Photo,U.Isactive,(Select Username from tbl_user TU where TU.Staff_Id=U.Register_Id)as Username,(Select Password from tbl_user TU where TU.Staff_Id=U.Register_Id)as Password FROM tbl_Register_User U Join tbl_user T on U.Register_Id=T.Staff_Id where T.Isactive='false' Order by Register_Id desc");
}
}
catch (Exception Ex)
{
}
}
protected void lstRecentVideos_ItemCommand(object sender, ListViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Display"))
{
DataSet objDataSet = MasterCode.RetrieveQuery("delete from tbl_Artist_Details where Artist_Details_Id=" + (e.Item.FindControl("lblGridArtistId") as Label).Text);
Display_List(lstRecentVideos, "Select Artist_Details_Id,Name,Description,'../Artist_Photo/'+Photo as Photo,Gender,Interest_Areas as Artist_Name,Isactive from tbl_Artist_Details where Isactive='true'and CreatedById=" + Session["UserId"].ToString() + " order by Name");
ShowNotification("Artist", "Deleted Successfully..!", NotificationType.success);
//DropDownList(ddlUpdateInterestArea, "Artist_Id", "Artist_Name", "Select Artist_Id,Artist_Name from tbl_admin_Artist where Isactive='True' Order by Artist_Name", "Select");
//ddlUpdateInterestArea.ClearSelection();
//string dsdd = (e.Item.FindControl("lblGridInterest_Areas") as Label).Text;
//if (ddlUpdateInterestArea.Items.FindByValue((e.Item.FindControl("lblGridInterest_Areas") as Label).Text) != null)
// ddlUpdateInterestArea.Items.FindByValue((e.Item.FindControl("lblGridInterest_Areas") as Label).Text).Selected = true;
//if ((e.Item.FindControl("lblGridGender") as Label).Text == "Female") { rdbUpdateFemale.Checked = true; rdbUpdateMale.Checked = true; }
//else { rdbUpdateFemale.Checked = false; rdbUpdateMale.Checked = true; }
//txtUpdateDescription.Text = (e.Item.FindControl("lblGridDescription") as Label).Text;
//txtUpdateArtist.Text = (e.Item.FindControl("lblGridArtist") as Label).Text;
//lblID.Text = (e.Item.FindControl("lblGridArtistId") as Label).Text;
//lblDName.Text = (e.Item.FindControl("lblGridArtist") as Label).Text;
//if ((e.Item.FindControl("lblGridArtistIsactive") as Label).Text == " Active ") { rdbActiveNoArtist.Checked = false; rdbActiveYesArtist.Checked = true; }
//else { rdbActiveYesArtist.Checked = false; rdbActiveNoArtist.Checked = true; }
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModalScript", "divPopup()", true);
}
}
catch (Exception Ex)
{
}
}
public void Citys_List(GridView gv, string Query)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery(Query);
if (objDataSet.Tables[0].Rows.Count > 0)
{
gv.DataSource = objDataSet;
gv.DataBind();
lblCityListList.Text = objDataSet.Tables[0].Rows.Count.ToString();
}
else
{
gv.DataSource = "";
gv.DataBind();
lblCityListList.Text = "0";
}
}
catch (Exception Ex)
{
}
}
public void Languages_List(GridView gdv, string Query)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery(Query);
if (objDataSet.Tables[0].Rows.Count > 0)
{
gdv.DataSource = objDataSet;
gdv.DataBind();
}
else
{
ShowNotification("Language", "List is empty..!", NotificationType.info);
gdv.DataSource = "";
gdv.DataBind();
}
}
catch (Exception Ex)
{
ShowNotification("Language", "kgfkjghfkdjghdfkghkf", NotificationType.error);
}
}
public void CheckBoxList(ListBox cbl, string DataValueField, string DataTextField, string Query)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery(Query);
if (objDataSet.Tables[0].Rows.Count > 0)
{
cbl.DataSource = objDataSet;
cbl.DataValueField = DataValueField;
cbl.DataTextField = DataTextField;
cbl.DataBind();
}
else
{
cbl.DataSource = "";
cbl.DataBind();
}
}
catch (Exception Ex)
{
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
string fud = fupImage.FileName;
if (fud != "" && ddlCity.SelectedIndex != 0 && txtContactinfo.Text.Trim() != "")
{
DataSet objDataSet1 = MasterCode.RetrieveQuery("Select Photo from tbl_Register_User where Register_Id in (Select Staff_Id from tbl_User where User_Id=" + Session["UserId"].ToString() + ")");
if (objDataSet1.Tables[0].Rows.Count > 0)
{
if (fud != "")
{
fupImage.SaveAs(Server.MapPath("~/User_Photos/") + objDataSet1.Tables[0].Rows[0]["Photo"].ToString());
}
int length = 6;
const string valid = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
StringBuilder res = new StringBuilder();
Random rnd = new Random();
while (0 < length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
DataSet objDataSet = MasterCode.RetrieveQuery("Update tbl_Register_User set Contact_info='" + txtContactinfo.Text.Trim() + "',Promo_CityId=" + ddlCity.SelectedValue.ToString() + ",PromoCode='" + res.ToString() + "' where Register_Id in (Select Staff_Id from tbl_user where User_Id='" + Convert.ToInt32(Session["UserId"].ToString()) + "')");
ShowNotification("Promo Code", " Created Successfully..", NotificationType.success);
Button_Status();
}
}
else
{
ShowNotification("Promoter", "Please Select Image and City..", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
public static string Recharge_Bal(string MobileNo, decimal amt, string rcode, string transid)
{
try
{
string output = "";
System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create("http://www.simpleapi.in/recharge.ashx?uid=7893123555&pwd=12345&mobileno=" + MobileNo + "&amt=" + amt + "&rcode=" + rcode + "&transid=" + transid + "");
System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
using (var sr = new StreamReader(response.GetResponseStream()))
{
string text = sr.ReadToEnd();
output = text;
DataSet objDataSet1 = MasterCode.RetrieveQuery("update Request set ResponseCode= '" + text.ToString() + "' where ClientTXT='" + transid + "'");
}
return(output);//SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "Sp_Offers", objSqlParameter);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void Display_Add(string ShortFilmId)
{
try
{
DataSet objDataSet = MasterCode.RetrieveQuery("Select Advertisement_Id,Title,'../Videos/'+Video as Advertisement,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Advertisement where Isactive='True' and ShortFilmId=" + ShortFilmId);
if (objDataSet.Tables[0].Rows.Count > 0)
{
DataSet obj = MasterCode.RetrieveQuery("select Short_film_Id,Title,'../Videos/'+Video as Shortfilm,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Short_film where Short_film_Id=" + ShortFilmId);
lblNextVideo.Text = obj.Tables[0].Rows[0]["Shortfilm"].ToString();
id.Attributes.Add("data-href", "http://www.nscreens.com/Admin/frmSingle.aspx?shortfilm=" + ShortFilmId);
lblTitle.Text = objDataSet.Tables[0].Rows[0]["Title"].ToString();
//Video.Attributes.Add("src", objDataSet.Tables[0].Rows[0]["Advertisement"].ToString());
add.InnerHtml = "<video id='Video' height='376px' width='100%' autoplay onended='Display()'><source id='add123' src='" + objDataSet.Tables[0].Rows[0]["Advertisement"].ToString() + "' type='video/mp4'>";
//lblPublished.Text = objDataSet.Tables[0].Rows[0]["Publish"].ToString();
//lblDescription.Text = objDataSet.Tables[0].Rows[0]["Description"].ToString();
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + objDataSet.Tables[0].Rows[0]["Advertisement_Id"].ToString());
}
else
{
DataSet objDataSet1 = MasterCode.RetrieveQuery("Select Advertisement_Id,Title,'../Videos/'+Video as Advertisement,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Advertisement where Isactive='True'");
if (objDataSet1.Tables[0].Rows.Count > 0)
{
DataSet obj = MasterCode.RetrieveQuery("select Short_film_Id,Title,'../Videos/'+Video as Shortfilm,CONVERT(varchar(12),CreatedDate,100)as Publish,Description from tbl_Short_film where Short_film_Id=" + ShortFilmId);
lblNextVideo.Text = obj.Tables[0].Rows[0]["Shortfilm"].ToString();
id.Attributes.Add("data-href", "http://www.nscreens.com/Admin/frmSingle.aspx?shortfilm=" + ShortFilmId);
lblTitle.Text = objDataSet1.Tables[0].Rows[0]["Title"].ToString();
//Video.Attributes.Add("src", objDataSet1.Tables[0].Rows[0]["Advertisement"].ToString());
add.InnerHtml = "<video id='Video' height='376px' width='100%' autoplay onended='Display()'><source id='add123' src='" + objDataSet1.Tables[0].Rows[0]["Advertisement"].ToString() + "' type='video/mp4'>";
//lblPublished.Text = objDataSet1.Tables[0].Rows[0]["Publish"].ToString();
//lblDescription.Text = objDataSet1.Tables[0].Rows[0]["Description"].ToString();
DataSet objDataSetVisits = MasterCode.RetrieveQuery("Update tbl_Advertisement set Visits=Visits+1 where Advertisement_Id=" + objDataSet1.Tables[0].Rows[0]["Advertisement_Id"].ToString());
}
}
}
catch (Exception Ex)
{
}
}
protected void lnkView_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = sender as LinkButton;
GridViewRow Row = (GridViewRow)lnk.NamingContainer;
DataSet objDataSet = MasterCode.RetrieveQuery("Select EmailId from tbl_Register_User where Register_Id in (Select Staff_Id from tbl_user where User_Id in (Select CreatedById from tbl_Advertisement where Advertisement_Id=" + lnk.CommandName + "))");
if (objDataSet.Tables[0].Rows.Count > 0)
{
lblDumpEmail.Text = objDataSet.Tables[0].Rows[0]["EmailId"].ToString();
}
else
{
lblDumpEmail.Text = "";
}
Display_List(gvViews, "Select Visits_Id,Advertisement_Id,Username,CONVERT(varchar(max),Date_Time,100)as Date_Time,City_Id,IPAddress,(Select Name from tbl_Register_User R where R.Register_Id=U.Staff_Id)as Name,(Select EmailId from tbl_Register_User R where R.Register_Id=U.Staff_Id)as EmailId from tbl_Advertizment_Visits V,tbl_user U where Advertisement_Id=" + lnk.CommandName + " and V.User_Id=U.User_Id");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModalScript", "divPopup()", true);
}
catch (Exception Ex)
{
}
}
