protected void DdlOficinasRegiao_SelectedIndexChanged(object sender, EventArgs e) { string proc = "GetWorkshopsInRegionExceptSelf"; if (DdlOficinasRegiao.SelectedValue == "0") { LbOficinas.Items.Clear(); return; } if (DdlOficinasRegiao.SelectedValue == "Total") { proc = "GetWorkshopNames"; } SqlConnection con = GetSqlCon.GetCon(); SqlDataAdapter com = new SqlDataAdapter(proc, con); com.SelectCommand.CommandType = CommandType.StoredProcedure; com.SelectCommand.Parameters.AddWithValue("@param1", User.Identity.GetUserId()); com.SelectCommand.Parameters.AddWithValue("@param2", DdlOficinasRegiao.SelectedValue); DataSet ds1 = new DataSet(); if (com != null) { com.Fill(ds1); } con.Open(); LbOficinas.DataSource = ds1; LbOficinas.DataTextField = "WorkshopName"; LbOficinas.DataValueField = "WorkshopName"; LbOficinas.DataBind(); con.Close(); }
protected void GetWorkshopDetails(string workshopname) { SqlConnection con = GetSqlCon.GetCon(); SqlDataAdapter com = new SqlDataAdapter("GetWorkshopDetails", con); com.SelectCommand.CommandType = CommandType.StoredProcedure; com.SelectCommand.Parameters.AddWithValue("@param1", workshopname); DataTable dtWorkshops = new DataTable(); com.Fill(dtWorkshops); DescOficina.DataSource = dtWorkshops; DescOficina.DataBind(); //rating double rating = Commissions.GetAvgRating(Users.GetWorkshopId(workshopname)); Label ratinglb = DescOficina.FindControl("ratinglabel") as Label; if (rating == -1) { ratinglb.Text = "Sem Avaliação"; } else { ratinglb.Text = rating.ToString() + "/5" + "★"; } }
protected int populate_DDL() { int val; SqlConnection con = GetSqlCon.GetCon(); SqlDataAdapter com = new SqlDataAdapter("GetWorkshopNamesByRegion", con); com.SelectCommand.CommandType = CommandType.StoredProcedure; com.SelectCommand.Parameters.AddWithValue("@param1", DdlRegiao.SelectedValue); DataSet ds1 = new DataSet(); if (com != null) { com.Fill(ds1); } con.Open(); DdlOficinas.DataSource = ds1; DdlOficinas.DataTextField = "WorkshopName"; DdlOficinas.DataValueField = "WorkshopName"; DdlOficinas.DataBind(); con.Close(); val = Badges.CountWorkshopsInRegion(DdlRegiao.SelectedValue); if (val == -1) { Response.Redirect("~/Error.aspx"); } return(val); }
protected void Populate_Details(int groupno) { string storedprocedure = "GetComissionDetails"; SqlConnection cn = GetSqlCon.GetCon(); if (cn == null) { Response.Redirect("~/Error.aspx"); } DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(storedprocedure, cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@param1", groupno); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); GridViewGroupDetails.DataSource = dt; GridViewGroupDetails.DataBind(); cn.Close(); GridViewGroupDetails.Visible = true; foreach (GridViewRow row in GridViewGroupDetails.Rows) { int id, price; int.TryParse(row.Cells[0].Text, out id); price = Commissions.GetPrice(id); Label LabelPrice = row.FindControl("LabelPrice") as Label; if (price != 0) { LabelPrice.Text = price.ToString(); } else { Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button; Button BtnRejectComission = row.FindControl("BtnRejectComission") as Button; BtnAcceptComission.Visible = false; BtnRejectComission.Visible = false; LabelPrice.Text = "N/A"; } } }
protected void PopulateGridViews() { //-----Client------// ApplicationDbContext context = new ApplicationDbContext(); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); var user = UserManager.FindById(User.Identity.GetUserId()); //Active string storedprocedure = "GetActiveComissions"; SqlConnection cn = GetSqlCon.GetCon(); if (cn == null) { Response.Redirect("~/Error.aspx"); } DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(storedprocedure, cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); GridViewActiveComissions.DataSource = dt; GridViewActiveComissions.DataBind(); cn.Close(); //Pending - Singles string storedprocedure2 = "GetPendingComissions"; SqlConnection cn2 = GetSqlCon.GetCon(); if (cn2 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt2 = new DataTable(); SqlCommand cmd2 = new SqlCommand(storedprocedure2, cn2); cmd2.CommandType = System.Data.CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(dt2); GridViewComissionsPending.DataSource = dt2; GridViewComissionsPending.DataBind(); cn2.Close(); //Pending - Group string storedprocedure8 = "GetPendingGroupComissions"; SqlConnection cn8 = GetSqlCon.GetCon(); if (cn8 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt8 = new DataTable(); SqlCommand cmd8 = new SqlCommand(storedprocedure8, cn8); cmd8.CommandType = System.Data.CommandType.StoredProcedure; cmd8.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da8 = new SqlDataAdapter(cmd8); da8.Fill(dt8); GridViewGroupComissions.DataSource = dt8; GridViewGroupComissions.DataBind(); cn8.Close(); //History string storedprocedure3 = "HistoryOfcomissions"; SqlConnection cn3 = GetSqlCon.GetCon(); if (cn3 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt3 = new DataTable(); SqlCommand cmd3 = new SqlCommand(storedprocedure3, cn3); cmd3.CommandType = System.Data.CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da3 = new SqlDataAdapter(cmd3); da3.Fill(dt3); HistoryOfComissions.DataSource = dt3; HistoryOfComissions.DataBind(); cn3.Close(); //-----Workshop-----// //Active string storedprocedure4 = "GetActiveComissionsWorkshop"; SqlConnection cn4 = GetSqlCon.GetCon(); if (cn4 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt4 = new DataTable(); SqlCommand cmd4 = new SqlCommand(storedprocedure4, cn4); cmd4.CommandType = System.Data.CommandType.StoredProcedure; cmd4.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da4 = new SqlDataAdapter(cmd4); da4.Fill(dt4); ActiveComissions.DataSource = dt4; ActiveComissions.DataBind(); //Pending string storedprocedure5 = "GetPendingComissionsWorkshop"; SqlConnection cn5 = GetSqlCon.GetCon(); if (cn5 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt5 = new DataTable(); SqlCommand cmd5 = new SqlCommand(storedprocedure5, cn5); cmd5.CommandType = System.Data.CommandType.StoredProcedure; cmd5.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da5 = new SqlDataAdapter(cmd5); da5.Fill(dt5); PendingComissions.DataSource = dt5; PendingComissions.DataBind(); //History string storedprocedure6 = "GetHistoryOfComissionsWorkshop"; SqlConnection cn6 = GetSqlCon.GetCon(); if (cn6 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt6 = new DataTable(); SqlCommand cmd6 = new SqlCommand(storedprocedure6, cn6); cmd6.CommandType = System.Data.CommandType.StoredProcedure; cmd6.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da6 = new SqlDataAdapter(cmd6); da6.Fill(dt6); HistoryOfComissionsWorkshop.DataSource = dt6; HistoryOfComissionsWorkshop.DataBind(); //Clients string storedprocedure7 = "GetWorkshopClients"; SqlConnection cn7 = GetSqlCon.GetCon(); if (cn7 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt7 = new DataTable(); SqlCommand cmd7 = new SqlCommand(storedprocedure7, cn7); cmd7.CommandType = System.Data.CommandType.StoredProcedure; cmd7.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da7 = new SqlDataAdapter(cmd7); da7.Fill(dt7); Clientes.DataSource = dt7; Clientes.DataBind(); }
protected void PopulateGridViews() { ApplicationDbContext context = new ApplicationDbContext(); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); var user = UserManager.FindById(User.Identity.GetUserId()); //Active string storedprocedure = "GetActiveComissionsWorkshop"; SqlConnection cn = GetSqlCon.GetCon(); if (cn == null) { Response.Redirect("~/Error.aspx"); } DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(storedprocedure, cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); ActiveComissions.DataSource = dt; ActiveComissions.DataBind(); //Pending string storedprocedure2 = "GetPendingComissionsWorkshop"; SqlConnection cn2 = GetSqlCon.GetCon(); if (cn2 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt2 = new DataTable(); SqlCommand cmd2 = new SqlCommand(storedprocedure2, cn2); cmd2.CommandType = System.Data.CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(dt2); PendingComissions.DataSource = dt2; PendingComissions.DataBind(); //History string storedprocedure3 = "GetHistoryOfComissionsWorkshop"; SqlConnection cn3 = GetSqlCon.GetCon(); if (cn3 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt3 = new DataTable(); SqlCommand cmd3 = new SqlCommand(storedprocedure3, cn3); cmd3.CommandType = System.Data.CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da3 = new SqlDataAdapter(cmd3); da3.Fill(dt3); HistoryOfComissions.DataSource = dt3; HistoryOfComissions.DataBind(); //Clients string storedprocedure4 = "GetWorkshopClients"; SqlConnection cn4 = GetSqlCon.GetCon(); if (cn4 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt4 = new DataTable(); SqlCommand cmd4 = new SqlCommand(storedprocedure4, cn4); cmd4.CommandType = System.Data.CommandType.StoredProcedure; cmd4.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da4 = new SqlDataAdapter(cmd4); da4.Fill(dt4); Clientes.DataSource = dt4; Clientes.DataBind(); }
protected void PopulateGridViews() { ApplicationDbContext context = new ApplicationDbContext(); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); var user = UserManager.FindById(User.Identity.GetUserId()); //Active string storedprocedure = "GetActiveComissions"; SqlConnection cn = GetSqlCon.GetCon(); if (cn == null) { Response.Redirect("~/Error.aspx"); } DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(storedprocedure, cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); GridViewActiveComissions.DataSource = dt; GridViewActiveComissions.DataBind(); cn.Close(); //Pending - Singles string storedprocedure2 = "GetPendingComissions"; SqlConnection cn2 = GetSqlCon.GetCon(); if (cn2 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt2 = new DataTable(); SqlCommand cmd2 = new SqlCommand(storedprocedure2, cn2); cmd2.CommandType = System.Data.CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(dt2); GridViewComissionsPending.DataSource = dt2; GridViewComissionsPending.DataBind(); cn2.Close(); //Pending - Group string storedprocedure8 = "GetPendingGroupComissions"; SqlConnection cn8 = GetSqlCon.GetCon(); if (cn8 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt8 = new DataTable(); SqlCommand cmd8 = new SqlCommand(storedprocedure8, cn8); cmd8.CommandType = System.Data.CommandType.StoredProcedure; cmd8.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da8 = new SqlDataAdapter(cmd8); da8.Fill(dt8); GridViewGroupComissions.DataSource = dt8; GridViewGroupComissions.DataBind(); cn8.Close(); //History string storedprocedure3 = "HistoryOfcomissions"; SqlConnection cn3 = GetSqlCon.GetCon(); if (cn3 == null) { Response.Redirect("~/Error.aspx"); } DataTable dt3 = new DataTable(); SqlCommand cmd3 = new SqlCommand(storedprocedure3, cn3); cmd3.CommandType = System.Data.CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@param1", user.Id); SqlDataAdapter da3 = new SqlDataAdapter(cmd3); da3.Fill(dt3); HistoryOfComissions.DataSource = dt3; HistoryOfComissions.DataBind(); cn3.Close(); }