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) { } }
protected void chkBlock_CheckedChanged(object sender, EventArgs e) { try { //DataSet objDataSet = MasterCode.RetrieveQuery("Update "); LinkButton chk = sender as LinkButton; GridViewRow Row = (GridViewRow)chk.NamingContainer; DataSet objDataSet = MasterCode.ExcuteOneParameter((Row.FindControl("lblGridRegister_Id") as Label).Text, "Sp_Delete_User", ""); if (objDataSet.Tables[0].Rows[0][0].ToString() == "1") { ShowNotification("Block User", "User Blocked Successfully..", NotificationType.success); Display_List(gvUserlist, "SELECT Register_Id,Name,Mobile_No,EmailId,Address,Isactive,(Select City_Name from tbl_admin_city C where C.City_Id=RU.City_Id)as City_Name,Photo,convert(varchar(12),DOB,103)as DOB,(Select Username from tbl_user U where U.Staff_Id=RU.Register_Id)as Username,(Select Password from tbl_user U where U.Staff_Id=RU.Register_Id)as Password FROM tbl_Register_User RU where Isactive='True' order by Register_Id desc"); } } catch (Exception Ex) { } }
protected void lstOther_ItemCommand(object sender, ListViewCommandEventArgs e) { try { if (e.CommandName.Equals("Display")) { DataSet objDataSet = MasterCode.ExcuteOneParameter((e.Item.FindControl("lbllstChannel") as Label).Text, "Sp_Delete_Production", ""); if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) == 1) { ShowNotification("Production", "Production Deleted Successfully..", NotificationType.success); Search(); } else { ShowNotification("Production", "Production is not Deleted..!", NotificationType.error); } } } catch (Exception Ex) { } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["UserName"] != null && Session["Menu"] != null) { if (!IsPostBack) { //string shortfilm = Request.QueryString["shortfilm"]; //if (shortfilm != null) //{ //} DataSet objDataSetLogin = MasterCode.ExcuteOneParameter(lblUrl.Text, "Sp_Find_UserForm", Session["UserName"].ToString()); if (objDataSetLogin.Tables[0].Rows.Count > 0) { lt_Menu.Text = Session["Menu"].ToString(); lblUsername.Text = "Hi " + Session["Name"].ToString(); Button_Status(); DataSet objDataSetIn = MasterCode.RetrieveQuery("Select COUNT(*) from tbl_SendMessage where IsRead='false' and SendTo in (Select Staff_Id from tbl_user where User_Id=" + Session["UserId"].ToString() + ")"); if (Convert.ToInt32(objDataSetIn.Tables[0].Rows[0][0].ToString()) > 0) { lblInbox.Text = objDataSetIn.Tables[0].Rows[0][0].ToString(); //Add.Attributes.Add("class", "pull-right inbox"); } else { lblEarningMoney.Text = "0"; //Add.Attributes.Add("class", ""); } if (Session["UserName"].ToString() == "admin") { //DataSet objDataSetE = MasterCode.RetrieveQuery("Select (Select case when SUM(Promoter_Budget) is null then 0 else SUM(Promoter_Budget) end +case when SUM(User_Budget) is null then 0 else SUM(User_Budget) end from tbl_Short_Film_Visits where Short_Film_Id in (Select Lan_Short_film_Id from tbl_Language_Short_FilmId where CreatedById=" + Session["UserId"].ToString() + "))+(Select case when SUM(Video_Sharing) is null then 0 else SUM(Video_Sharing) end from tbl_Short_Film_Visits where User_Share_Id=" + Session["UserId"].ToString() + ")+(Select case when sum(User_Budget) is null then 0 else sum(User_Budget) end +case when sum(Promoter_Budget) is null then 0 else sum(Promoter_Budget) end from tbl_Advertizment_Visits where Advertisement_Id in (Select Advertisement_Id from tbl_Advertisement where CreatedById=" + Session["UserId"].ToString() + "))"); 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) { lblEarningMoney.Text = "( " + objDataSetE.Tables[0].Rows[0][0].ToString() + " )"; } else { lblEarningMoney.Text = "0.00"; } } else { 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) { lblEarningMoney.Text = "( " + objDataSetE.Tables[0].Rows[0][0].ToString() + " )"; } else { lblEarningMoney.Text = "0.00"; } } DataSet objDataSet1234 = 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 (objDataSet1234.Tables[0].Rows.Count > 0) { lblAmount.Text = objDataSet1234.Tables[0].Rows[0][0].ToString(); } else { lblAmount.Text = "0.00"; } } else { Session["LoginId"] = null; Response.Redirect("~/Login.aspx", false); } } } else { btnCreate.Visible = false; lblCode.Text = ""; lblCode.Visible = false; Session["RedirectURL"] = Request.Url.AbsoluteUri; Response.Redirect("~/Login.aspx", false); } HtmlMeta keywords4 = new HtmlMeta(); keywords4.Attributes.Add("property", "fb:app_id"); keywords4.Content = "566086956918274"; MetaPlaceHolder.Controls.Add(keywords4); HtmlMeta keywords3 = new HtmlMeta(); keywords3.Attributes.Add("property", "og:image"); keywords3.Content = Session["Short_film_Image"].ToString(); MetaPlaceHolder.Controls.Add(keywords3); HtmlMeta keywords2 = new HtmlMeta(); keywords2.Attributes.Add("property", "og:description"); keywords2.Content = Session["Description"].ToString(); MetaPlaceHolder.Controls.Add(keywords2); HtmlMeta keywords12 = new HtmlMeta(); keywords12.Attributes.Add("property", "og:title"); keywords12.Content = Session["Title"].ToString(); MetaPlaceHolder.Controls.Add(keywords12); HtmlMeta keywords = new HtmlMeta(); keywords.Attributes.Add("property", "og:url"); keywords.Content = Session["URL"].ToString(); MetaPlaceHolder.Controls.Add(keywords); HtmlMeta keywords1 = new HtmlMeta(); keywords1.Attributes.Add("property", "og:type"); keywords1.Content = "video.movie"; MetaPlaceHolder.Controls.Add(keywords1); } catch (Exception Ex) { } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { DataSet objDataSet = MasterCode.ExcuteOneParameter(DateTime.Now.AddHours(Connection.SetHours).ToShortDateString(), "Sp_Home", DateTime.Now.AddHours(Connection.SetHours).AddDays(1).ToShortDateString()); if (objDataSet.Tables[0].Rows.Count > 0) { lblTotalBuses.Text = objDataSet.Tables[0].Rows[0][0].ToString(); lblRunningBuses.Text = objDataSet.Tables[2].Rows[0][0].ToString(); lblVacantBuses.Text = objDataSet.Tables[1].Rows[0][0].ToString(); lblHoldedBuses.Text = objDataSet.Tables[3].Rows[0][0].ToString(); if (objDataSet.Tables[4].Rows.Count > 5) { pnlRelesing.ScrollBars.Equals("Vertical"); } if (objDataSet.Tables[5].Rows.Count > 5) { pnlBilling.ScrollBars.Equals("Vertical"); } if (objDataSet.Tables[6].Rows.Count > 5) { pnlGoing.ScrollBars.Equals("Vertical"); } if (objDataSet.Tables[6].Rows.Count > 5) { pnlPending.ScrollBars.Equals("Vertical"); } if (objDataSet.Tables[7].Rows.Count > 5) { pnlPendingQuotations.ScrollBars.Equals("Vertical"); } gvNewBus.DataSource = objDataSet.Tables[4]; gvNewBus.DataBind(); gvQuotation.DataSource = objDataSet.Tables[5]; gvQuotation.DataBind(); gvVendors.DataSource = objDataSet.Tables[6]; gvVendors.DataBind(); gvPendingWork.DataSource = objDataSet.Tables[8]; gvPendingWork.DataBind(); gvPendingQuotations.DataSource = objDataSet.Tables[7]; gvPendingQuotations.DataBind(); gvunallocateQuotations.DataSource = objDataSet.Tables[9]; gvunallocateQuotations.DataBind(); } } } 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); decimal WalletAmt = 0; 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) { WalletAmt = Convert.ToDecimal(objDataSetE.Tables[0].Rows[0][0].ToString()); } else { WalletAmt = 0; } Master.EarningAmount = "( " + WalletAmt.ToString() + " )"; txtEarningAmt.Text = WalletAmt.ToString(); lblDumpEarningAmt.Text = WalletAmt.ToString(); string Short = Request.QueryString["shortfilm"]; string ShrUserId = Request.QueryString["userId"]; if (Short != null) { if (ShrUserId == null) { Response.Redirect("frmSingle.aspx?shortfilm=" + Short, false); } else { Response.Redirect("frmSingle.aspx?shortfilm=" + Short + "&userId=" + ShrUserId, false); } } } } else { ShowNotification("Amount Transfer", "Invalid Amount..", NotificationType.error); } } else { ShowNotification("Amount Transfer", "Please Enter Transfer Amount..", NotificationType.error); } } catch (Exception Ex) { } }