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 BtnCreateComission_Click(object sender, EventArgs e)
{
int Ano;
int.TryParse(TbAno.Text, out Ano);
if (!Page.IsValid)
{
return;
}
ApplicationDbContext context = new ApplicationDbContext();
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
string user = User.Identity.GetUserId();
BtnCreateComission.Enabled = false; //Prevenir Flood
Random rnd = new Random();
if (LbOficinas.GetSelectedIndices().Count() > 1)
{
int var, groupno;
do
{
groupno = rnd.Next(1, 10000);
var = Commissions.CheckIfGroupExists(groupno);
if (var == -1)
{
Response.Redirect("~/Error.aspx");
}
} while (var != 0);
foreach (int i in LbOficinas.GetSelectedIndices())
{
if (Commissions.CreateComissionGroup(TbModelo.Text, DdlTipo.SelectedValue, LbOficinas.Items[i].Value, Ano, TbDetails.Text, user, groupno) == false)
{
Response.Redirect("~/Error.aspx");
}
}
}
else
{
foreach (int i in LbOficinas.GetSelectedIndices())
{
if (Commissions.CreateComission(TbModelo.Text, DdlTipo.SelectedValue, LbOficinas.Items[i].Value, Ano, TbDetails.Text, user) == false)
{
Response.Redirect("~/Error.aspx");
}
}
}
Response.Redirect("ComissionCreated.aspx");
}
