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