public void ListaPlacaParaReparo() { try { string UserLogado = HttpContext.Current.User.Identity.GetUserId();//AQUI RECUPERA O ID USUARIO LOGADO PARA REGISTRAR NO BANCO string UserLogadoName = HttpContext.Current.User.Identity.GetUserName(); var lista = new ListaDePlacaParaReparoOQC(); GridView1.DataSource = lista.ListaPlacaParaReparo(UserLogado); GridView1.DataBind(); if (GridView1.Rows.Count > 0) { Logado.InnerText = "Ola, " + UserLogadoName + " segue abaixo sua lista de placas para reparo!"; Panel7.Visible = true; } else { Logado.InnerText = "Ola, " + UserLogadoName + " não há nenhuma placa registrada para você!"; Panel7.Visible = false; } } catch (Exception ex) { ErrorMessage.Text = "Erro ao listar os dados: " + ex.Message; } }
/// <summary> /// ESTE ABAIXO MOSTRA A INFORMAÇAÕ NO FORMULARIO DE REPARO FEITO PELO TECNICO. /// ESTACIA DA CLASS LISTADEPLACAPARAREPAROOQC - METODO: MOSTRARDADOSPARAREPAIR /// </summary> //public void MostrarDadosParaReparo() //{ // try // { // string objCod = lblCodigo.Text; // var objLista = new ListaDePlacaParaReparoOQC(); // Pesquisas objModel = objLista.MostrarDadosRepaiMan(objCod); // if(objModel!=null) // { // lblUn.Text = objModel.UN; // lblCN.Text = objModel.CN; // lblCausa.Text = objModel.Causa; // lblPartNumber.Text = objModel.Causa; // lblLote.Text = objModel.Lote; // lblLocation.Text = objModel.Location; // } // } // catch (Exception ex) // { // ErrorMessageRepairMan.Text = "Erro ao listar : " + ex.Message; // } //} protected void btnSalvar_Click(object sender, EventArgs e) { var objModel = new SeacherRepair(); objModel.EntradaId = Convert.ToInt32(lblEntrada.Text); objModel.RepairMainId = Convert.ToInt32(lblCodigo.Text); objModel.ActionRepair = Convert.ToString(ddlAction.SelectedItem.Text); objModel.UserName = Convert.ToString(ddlSendRepair.SelectedValue); var updateAction = new ListaDePlacaParaReparoOQC(); updateAction.UpdateRepairManAction(objModel); updateAction.UpdateTecnicoAfterActionRepairMan(objModel); updateAction.UpdateStatusFinalAfterActionRepairMan(objModel); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Registro feito com sucesso!');", true); ListaPlacaParaReparo(); }
protected void ddlLocation_TextChanged(object sender, EventArgs e) { if (ddlLocation.SelectedValue != "0") { string part = ddlLocation.SelectedItem.Text; var list = new ListaDePlacaParaReparoOQC(); Pesquisas mod = list.ListaBom(part); if (mod != null) { txtPartNumber.Text = mod.PartNumber; } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Nenhum Part-Number encontrado');", true); } } }
protected void btnSalvar_Click(object sender, EventArgs e) { if (ddlSendRepair.SelectedItem.Text != "ALL") { var objModel = new SeacherRepair(); objModel.EntradaId = Convert.ToInt32(lblEntrada.Text); objModel.RepairMainId = Convert.ToInt32(lblCodigo.Text); objModel.ActionRepair = Convert.ToString(ddlAction.SelectedItem.Text); objModel.UserName = Convert.ToString(ddlSendRepair.SelectedValue); var updateAction = new ListaDePlacaParaReparoOQC(); updateAction.UpdateRepairManAction(objModel); updateAction.UpdateTecnicoAfterActionRepairMan(objModel); updateAction.UpdateStatusFinalAfterActionRepairMan(objModel); /*******/ string UserLagado = HttpContext.Current.User.Identity.GetUserId(); var objMod = new SeacherRepair(); objMod.EntradaId = Convert.ToInt32(lblCodigo.Text); objMod.UserName = UserLagado; updateAction.UpdateRepairMan(objMod); /*FIM*/ ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Registro feito com sucesso!');", true); ListaPlacaParaReparo(); } else if (ddlSendRepair.SelectedItem.Text == "ALL") { var objModel = new SeacherRepair(); objModel.EntradaId = Convert.ToInt32(lblEntrada.Text); objModel.RepairMainId = Convert.ToInt32(lblCodigo.Text); objModel.ActionRepair = Convert.ToString(ddlAction.SelectedItem.Text); objModel.UserName = Convert.ToString(ddlSendRepair.SelectedValue); var updateAction = new ListaDePlacaParaReparoOQC(); updateAction.UpdateRepairManAction(objModel); updateAction.UpdateTecnicoAfterActionRepairManNULL(objModel); updateAction.UpdateStatusFinalAfterActionRepairMan(objModel); /*******/ string UserLagado = HttpContext.Current.User.Identity.GetUserId(); var objMod = new SeacherRepair(); objMod.EntradaId = Convert.ToInt32(lblCodigo.Text); objMod.UserName = UserLagado; updateAction.UpdateRepairMan(objMod); /*FIM*/ ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Registro feito com sucesso!');", true); ListaPlacaParaReparo(); } }
/// <summary> /// THIS METHOD REGISTER TO ANY TECHNICIAN. /// WHERE ANYONE CAN TO MAKE THE REPAIR THIS BOARD. /// </summary> public void InsertAnalysisRepairAll() { try { string IdAction = "WAITING"; DAL.ProcessRepair mod = new DAL.ProcessRepair(); mod.RepairMan = ddlSendRepair.SelectedValue; mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.ActionRepainMan = Convert.ToString(IdAction); mod.LocationSmd = ddlLocation.SelectedItem.Text; mod.PartNumber = txtPartNumber.Text; var reg = new ListaDePlacaParaReparoOQC(); reg.InsertAnalisysRepairAll(mod); } catch (Exception ex) { ErrorMessage.Text = "Error to the Insert Analysis RepairMan: " + ex.Message; } }
/// <summary> /// AQUI FAZ O UPDATE NA TABELA PRINCIPAL /// </summary> public void UpdateReparo() { try { string user = HttpContext.Current.User.Identity.GetUserName(); DAL.ProcessRepair mod = new DAL.ProcessRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.UN = txtUn.Text; mod.DefectCauseId = Convert.ToInt32(ddlDefectCause.SelectedValue); mod.LocationSmd = ddlLocation.SelectedItem.Text; mod.lote = txtLote.Text; mod.ActionId = Convert.ToInt32(ddlAction.SelectedValue); mod.TecnicoResponsavel = user; mod.statusRepair = ddlStatus.SelectedItem.Text; var add = new ListaDePlacaParaReparoOQC(); add.UptadeRepair(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Registro feito com sucesso');", true); } catch (Exception ex) { ErrorMessage.Text = "Error ao atualizar o repapro! " + ex.Message; //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Registro feito com sucesso');", true); } }
protected void btnSalvar_Click(object sender, EventArgs e) { if (lblStatusFinally.Text == "") { UpdateReparo(); ListaPlacaParaReparo(); } if (ddlSendRepair.SelectedItem.Text != "ALL" && lblStatusFinally.Text == "" && ddlStatus.SelectedValue == "4") { InsertAnalysisRepairMan(); ListaPlacaParaReparo(); } if (ddlSendRepair.SelectedItem.Text != "ALL" && ddlStatus.SelectedValue == "4" && lblStatusFinally.Text == "WAITING") { var mod = new SeacherRepair(); string statusFinal = ""; mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; var obj = new Class_ListToRepair(); obj.UpdateReturnRepair(mod); InsertAnalysisRepairMan(); ListaPlacaParaReparo(); } if (ddlSendRepair.SelectedItem.Text == "ALL" && lblStatusFinally.Text == "") { string user = HttpContext.Current.User.Identity.GetUserId(); DAL.ProcessRepair mod = new DAL.ProcessRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.RepairMan = user; var obj = new Class_ListToRepair(); obj.UpdateUserName(mod); InsertAnalysisRepairAll(); ListaPlacaParaReparo(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "PASS/TERMINATE") { string user = HttpContext.Current.User.Identity.GetUserId(); var mod = new SeacherRepair(); string statusFinal = "PASS/TERMINATE"; mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; mod.UserName = user; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); add.UpdateTerminateNULL(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Reparo Finalizado com sucesso.');", true); ListaPlacaParaReparo(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "SCRAP/TERMINATE") { string user = HttpContext.Current.User.Identity.GetUserId(); string statusFinal = "SCRAP/TERMINATE"; var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; mod.UserName = user; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); add.UpdateTerminateNULL(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Item enviado para Scrap.');", true); ListaPlacaParaReparo(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "FEEDBACK") { string user = HttpContext.Current.User.Identity.GetUserId(); string statusFinal = "FEEDBACK/TERMINATE"; var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; mod.UserName = user; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); add.UpdateTerminateNULL(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Item enviado para Feedack.');", true); ListaPlacaParaReparo(); } if (ddlStatus.SelectedValue == "4" && lblStatusFinally.Text == "WAITING" && ddlSendRepair.SelectedItem.Text == "ALL") { string statusFinal = ""; string user = HttpContext.Current.User.Identity.GetUserId(); var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; mod.UserName = user; var add = new Class_ListToRepair(); //Atualizar o dados de returno ao reparo add.UpdateReturnRepair(mod); //Atualiza o usuario para a tabela tecnicoMaisPlaca add.UpdateTerminateNULL(mod); //Insiere um novo registro na tabela AnalysisRepairMan InsertAnalysisRepairAll(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Reparo retornado com sucesso!');", true); ListaPlacaParaReparo(); } ListaPlacaParaReparo(); }
/// <summary> /// BOTÃO PARA O EVENDO DOS METODOS UPDATE REPARO, INSERT ANALYSIS REPAIMAN E LISTA PLACAS /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSalvar_Click(object sender, EventArgs e) { if (lblStatusFinally.Text == "") { if (txtLote.Text == "" && txtUn.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Campos UN e Lote não pode ser vazio! Caso não exista preencha com N/A');", true); } else { UpdateReparo(); } } if (ddlSendRepair.SelectedItem.Text != "SELECIONE A REPARADORA" && lblStatusFinally.Text == "") { InsertAnalysisRepairMan(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "PASS") { var mod = new SeacherRepair(); string statusFinal = "TERMINATE"; mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Reparo Finalizado com sucesso.');", true); ListaPlacaParaReparo(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "SCRAP") { string statusFinal = "SCRAP"; var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Item enviado para Scrap.');", true); ListaPlacaParaReparo(); } if (lblStatusFinally.Text == "WAITING" && ddlStatus.SelectedItem.Text == "FEEDBACK") { string statusFinal = "FEEDBACK"; var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; var add = new ListaDePlacaParaReparoOQC(); add.UpdateTerminate(mod); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Item enviado para Feedack.');", true); ListaPlacaParaReparo(); } if (ddlStatus.SelectedValue == "4" && lblStatusFinally.Text == "WAITING") { string statusFinal = ""; var mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(lblCodigo.Text); mod.StatusRepair = ddlStatus.SelectedItem.Text; mod.StatusFinal = statusFinal; var add = new ListaDePlacaParaReparoOQC(); add.UpdateReturnRepair(mod); InsertAnalysisRepairMan(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Reparo retornado com sucesso!');", true); ListaPlacaParaReparo(); } ListaPlacaParaReparo(); }