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) { } }