/// <summary> /// AQUI FAÇO O REGISTRO DOS DADOS QUE BUSCO NO BANCO FIREBIRD DE MAINLINE. /// </summary> /// <param name="objMod"></param> public void InsertInputRepairOfMainLine(SeacherRepair objMod) { try { OpenConnection(); string strInsert = string.Format(@"INSERT INTO dbo.EntradaRepairMain VALUES(@data,@hora,@codigoFirebird,@model,@sintomas,@line,@un,@cn,@user,NULL,'MAIN')"); using (cmd = new SqlCommand(strInsert, conn)) { cmd.Parameters.AddWithValue("@data", objMod.data); cmd.Parameters.AddWithValue("@hora", objMod.hora); cmd.Parameters.AddWithValue("@codigoFirebird", objMod.CodFirebird); cmd.Parameters.AddWithValue("@model", objMod.Modelo); cmd.Parameters.AddWithValue("@sintomas", objMod.Simtomas); cmd.Parameters.AddWithValue("@line", objMod.Block); cmd.Parameters.AddWithValue("@un", objMod.UN); cmd.Parameters.AddWithValue("@cn", objMod.CN); cmd.Parameters.AddWithValue("@user", objMod.UserName); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the Insert the Material of Mainline: " + ex.Message); } finally { ClosedConnection(); } }
/// <summary> /// NPC /// </summary> /// <param name="Cod"></param> /// <param name="CN"></param> /// <returns></returns> public SeacherRepair GetCodRegisterNPC(string Cod, string CN) { try { OpenConnection(); string strGet = string.Format(@"SELECT TOP(1) CodReparoMain FROM dbo.EntradaRepairMain WHERE CN = @cn ORDER BY CodReparoMain DESC"); using (cmd = new SqlCommand(strGet, conn)) { cmd.Parameters.AddWithValue("@cn", CN); using (Dr = cmd.ExecuteReader()) { SeacherRepair objMod = null; while (Dr.Read()) { objMod = new SeacherRepair(); objMod.EntradaId = Convert.ToInt32(Dr["CodReparoMain"]); } return(objMod); } } } catch (SqlException ex) { throw new Exception("Erro ao retornar o codigo: " + ex.Message); } finally { ClosedConnection(); } }
public void RegistrarProcessoTerminate(SeacherRepair objModel) { try { OpenConnection(); string strInsert = string.Format(@"INSERT INTO dbo.ProcessoTerminate VALUES(@date,@hora,@user,@status,@descr,@EntradaId)"); using (cmd = new SqlCommand(strInsert, conn)) { string data = DateTime.Now.ToString("yyyy/MM/dd"); string hora = DateTime.Now.ToString("HH:mm:ss"); cmd.Parameters.AddWithValue("@date", data); cmd.Parameters.AddWithValue("@hora", hora); cmd.Parameters.AddWithValue("@user", objModel.UserName); cmd.Parameters.AddWithValue("@status", objModel.StatusTerminate); cmd.Parameters.AddWithValue("@descr", objModel.Descricao); cmd.Parameters.AddWithValue("@EntradaId", objModel.EntradaId); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the Insert the process terminate: " + ex.Message); } finally { ClosedConnection(); } }
/// <summary> /// ESTE METODO FAZ O REGISTRO DOS APARELHOS DE REPARO QUE VEM DA MAINLINE DO BANCO /// FIREBIRD DO SISTEMA DO TEROSSI. /// </summary> public void InsertInputRepairOfMainlin() { try { if (DdlSimtomas.SelectedItem.Text != "SELECIONE O SINTOMA" && ddlBlocks.SelectedItem.Text != "SELECIONE A LINHA") { string user = HttpContext.Current.User.Identity.GetUserId(); SeacherRepair objMod = new SeacherRepair(); //objMod.data = Convert.ToDateTime(DataGlobal); //objMod.hora = HoraGlobal; //objMod.CodFirebird = CodFireGlobal; objMod.Modelo = txtModels.Text; objMod.Simtomas = DdlSimtomas.SelectedItem.Text; objMod.Block = ddlBlocks.SelectedItem.Text; objMod.UN = txtUn.Text; objMod.CN = PnGlobal; objMod.UserName = user; var ObjInsert = new RegistrosEntrada(); ObjInsert.InsertInputRepairOfNPC(objMod); txtCn.Text = string.Empty; } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Linha ou Sintomas não foram selecionado! Selecione e tente novamente');", true); } } catch (Exception ex) { Panel1.Visible = true; lblMsgError.Text = "Erro ao registrar os dados de reparo: " + ex.Message; } }
public void InsertInputRepairOfNPC(SeacherRepair objMod) { try { OpenConnection(); string strInsert = string.Format(@"INSERT INTO dbo.EntradaRepairMain VALUES(@data,@hora,NULL,@model,@sintomas,@line,@un,@cn,@user,NULL,'NPC')"); using (cmd = new SqlCommand(strInsert, conn)) { string data = DateTime.Now.ToString("yyyy/MM/dd"); string hora = DateTime.Now.ToString("HH:mm;ss"); cmd.Parameters.AddWithValue("@data", data); cmd.Parameters.AddWithValue("@hora", hora); cmd.Parameters.AddWithValue("@model", objMod.Modelo); cmd.Parameters.AddWithValue("@sintomas", objMod.Simtomas); cmd.Parameters.AddWithValue("@line", objMod.Block); cmd.Parameters.AddWithValue("@un", objMod.UN); cmd.Parameters.AddWithValue("@cn", objMod.CN); cmd.Parameters.AddWithValue("@user", objMod.UserName); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the Insert the Material of NPC: " + ex.Message); } finally { ClosedConnection(); } }
/// <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 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(); } }
public SeacherRepair GetDataToInput(string cod, string cn) { try { AbreConexaoFirebird(); string str = string.Format(@"SELECT B.COD004,A.DTA005,A.HRA005,B.FER004,C.DES028,D.NUM045,NPN004 FROM MAI005 A INNER JOIN MAI004C B ON A.COD005 = B.COD004 INNER JOIN OQC028 C ON B.DEF004 = C.COD028 INNER JOIN OQC045 D ON B.LIN004 = D.COD045 WHERE COD004 = @cod OR NPN004= @cn"); using (cmd = new FbCommand(str, conn)) { cmd.Parameters.AddWithValue("@cod", cod); cmd.Parameters.AddWithValue("@cn", cn); using (Dr = cmd.ExecuteReader()) { SeacherRepair mod = null; while (Dr.Read()) { mod = new SeacherRepair(); mod.CodFirebird = Convert.ToString(Dr["COD004"]); mod.data = Convert.ToDateTime(Dr["DTA005"]); mod.hora = Convert.ToString(Dr["HRA005"]); mod.Modelo = Convert.ToString(Dr["FER004"]); mod.Simtomas = Convert.ToString(Dr["DES028"]); mod.Block = Convert.ToString(Dr["NUM045"]); mod.CN = Convert.ToString(Dr["NPN004"]); } return(mod); } } } catch (SqlException ex) { throw new Exception("Error to the list datas: " + ex.Message); } finally { FechaConexaoFirebird(); } }
/// <summary> /// /// </summary> /// <returns></returns> public List <SeacherRepair> ListarDadosParaTecnico() { try { OpenConnection(); string srtObj = string.Format(@"SELECT A.EntradaId,A.DateRepair,A.HoraRepair,B.Model,B.Sintomas,B.CN,B.UN,CodFirebird,B.Line FROM PrincipalProcessRepair A INNER JOIN EntradaRepairMain B ON A.EntradaId = B.CodReparoMain WHERE A.Status = 'WAINTING'"); using (cmd = new SqlCommand(srtObj, conn)) { List <SeacherRepair> list = new List <SeacherRepair>(); using (Dr = cmd.ExecuteReader()) { SeacherRepair mod = null; while (Dr.Read()) { mod = new SeacherRepair(); mod.EntradaId = Convert.ToInt32(Dr[0]); mod.DateRepair = Convert.ToDateTime(Dr[1]); mod.Model = Convert.ToString(Dr[2]); mod.Sintomas = Convert.ToString(Dr[3]); mod.CN = Convert.ToString(Dr[4]); mod.UN = Convert.ToString(Dr[5]); mod.CodFirebird = Convert.ToString(Dr[6]); mod.Line = Convert.ToString(Dr[7]); list.Add(mod); } return(list); } } } catch (SqlException ex) { throw new Exception("Error: " + ex.Message); } finally { ClosedConnection(); } }
public void TerminateProcessRegister(SeacherRepair objModel) { OpenConnection(); string strInsert = string.Format(@"INSERT INTO TerminatePBA VALUES(@data,@hora,@user,@status,@descr,@entradaId)"); using (cmd = new SqlCommand(strInsert, conn)) { string data = DateTime.Now.ToString("yyyy/MM/dd"); string hora = DateTime.Now.ToString("HH:mm:ss"); cmd.Parameters.AddWithValue("@data", data); cmd.Parameters.AddWithValue("@hora", hora); cmd.Parameters.AddWithValue("@user", objModel.UserName); cmd.Parameters.AddWithValue("@status", objModel.StatusFinal); cmd.Parameters.AddWithValue("@descr", objModel.Descricao); cmd.Parameters.AddWithValue("@entradaId", objModel.EntradaId); cmd.ExecuteNonQuery(); } ClosedConnection(); }
/// <summary> /// /// </summary> /// <param name="objCod"></param> public void UpdateStatusFinalAfterActionRepairMan(SeacherRepair objCod) { try { OpenConnection(); string strUpdate = string.Format(@"UPDATE PrincipalProcessRepair SET StatusFinal ='WAITING' WHERE EntradaId=@cod"); using (cmd = new SqlCommand(strUpdate, conn)) { cmd.Parameters.AddWithValue("@cod", objCod.EntradaId); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the update the Status Final : " + ex.Message); } finally { ClosedConnection(); } }
/// <summary> /// /// </summary> /// <param name="objCod"></param> public void UpdateRepairMan(SeacherRepair objCod) { try { OpenConnection(); string strUpdate = string.Format(@"UPDATE AnalysisRepairMan SET UserName =@user WHERE RepairMainId=@cod"); using (cmd = new SqlCommand(strUpdate, conn)) { cmd.Parameters.AddWithValue("@cod", objCod.EntradaId); cmd.Parameters.AddWithValue("@user", objCod.UserName); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the update the Status Final : " + ex.Message); } finally { ClosedConnection(); } }
/// <summary> /// /// </summary> /// <param name="objCod"></param> public void UpdateTecnicoAfterActionRepairManNULL(SeacherRepair objCod) { try { OpenConnection(); string strUpdate = string.Format(@"UPDATE TecnicoMaisPlaca SET UserName =NULL WHERE EntradaId=@cod"); using (cmd = new SqlCommand(strUpdate, conn)) { cmd.Parameters.AddWithValue("@cod", objCod.EntradaId); // cmd.Parameters.AddWithValue("@user", objCod.UserName); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the update Action RepairMan : " + ex.Message); } finally { ClosedConnection(); } }
public void UpdateProcessTerminate(SeacherRepair objModel) { try { OpenConnection(); string strUpdate = string.Format(@"UPDATE PrincipalProcessRepair SET StatusRepair =@statusrepair,StatusFinal=@statusfinal WHERE EntradaId =@cod"); using (cmd = new SqlCommand(strUpdate, conn)) { cmd.Parameters.AddWithValue("@cod", objModel.EntradaId); cmd.Parameters.AddWithValue("@statusrepair", objModel.StatusRepair); cmd.Parameters.AddWithValue("@statusfinal", objModel.StatusRepair); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw new Exception("Error to the update: " + ex.Message); } finally { ClosedConnection(); } }
/// <summary> /// ESTE METODO FAZ O REGISTRO DOS APARELHOS DE REPARO QUE VEM DA MAINLINE DO BANCO /// FIREBIRD DO SISTEMA DO TEROSSI. /// </summary> public void InsertInputRepairOfMainlin() { try { string user = HttpContext.Current.User.Identity.GetUserId(); SeacherRepair objMod = new SeacherRepair(); objMod.data = Convert.ToDateTime(DataGlobal); objMod.hora = HoraGlobal; objMod.CodFirebird = CodFireGlobal; objMod.Modelo = txtModels.Text; objMod.Simtomas = txtSimtomas.Text; objMod.Block = txtBlocks.Text; objMod.UN = txtUn.Text; objMod.CN = CNGlobal; objMod.UserName = user; var ObjInsert = new RegistrosEntrada(); ObjInsert.InsertInputRepairOfMainLine(objMod); } catch (Exception ex) { Panel1.Visible = true; lblMsgError.Text = "Erro ao registrar os dados de reparo: " + ex.Message; } }
public SeacherRepair GetDataEntradaReparo(string cn) { try { OpenConnection(); string str = string.Format(@"SELECT A.EntradaId,A.Serial,B.Modelo,C.Sintomas,Block FROM dbo.EntradaReparo A INNER JOIN dbo.Modelos B ON A.ModeloId = B.ModeloId INNER JOIN dbo.Sintomas C ON A.SintomasId = C.SintomasId INNER JOIN dbo.Blocks D ON A.BlockId = D.BlockId WHERE A.Serial = @cn"); using (cmd = new SqlCommand(str, conn)) { cmd.Parameters.AddWithValue("@cn", cn); using (Dr = cmd.ExecuteReader()) { SeacherRepair model = null; while (Dr.Read()) { model = new SeacherRepair(); model.Modelo = Convert.ToString(Dr["Modelo"]); model.Simtomas = Convert.ToString(Dr["Sintomas"]); model.Block = Convert.ToString(Dr["Block"]); model.EntradaId = Convert.ToInt32(Dr["EntradaId"]); } return(model); } } } catch (SqlException ex) { throw new Exception("Error to search the data of incoming repair: " + ex.Message); } finally { ClosedConnection(); } }
protected void lkbSearch_Click(object sender, EventArgs e) { try { string cn = txtCn.Text; string cod = txtCn.Text; PnGlobal = txtCn.Text; //var listar = new GetDataEntradaRepair(); var listar = new Class_Get_Dropdown_NPC(); Model_NPC mod = listar.GetDataToInput(cod, cn); if (mod != null) { txtModels.Text = mod.Model; txtPartNumber.Text = mod.PartNumbe; } else { lblMsgError.Text = "Nenhum item encontrado para este codigo: "; } /*AQUI CHAMO O METODO PARA REGISTRAR OS DADOS QUE VEM DE MAIN LINE NO BANCO SQL LOGO APOS A PESQUISA DOS MESMO*/ InsertInputRepairOfMainlin(); /*FIM */ var RetunCod = new GetDataEntradaRepair(); SeacherRepair modCod = RetunCod.GetCodRegisterNPC(cod, cn); if (modCod != null) { lblCodEntrada.Text = Convert.ToString(modCod.EntradaId); } } catch (Exception ex) { Panel1.Visible = true; lblMsgError.Text = "Error to the search: " + ex.Message; } try { titleLista.Visible = true; string pn = txtCn.Text; var listaGrid = new GetDataEntradaRepair(); GrdLista.DataSource = listaGrid.GetAllDataPerPartnumber(PnGlobal); GrdLista.DataBind(); if (GrdLista.Rows.Count < 1) { Panel1.Visible = true; lblMsgError.Text = "Nenhum item encontrado, pois não há entrada registrada. "; } Entrada mod = listaGrid.CountRegisterEntrada(PnGlobal);//AQUI FAZ CONTAGEM DOS REGISTROS if (mod != null) { lblCount.InnerText = "Total de Reparos: " + mod.Serial; } else { lblCount.InnerText = "Nenhum item encontrado: " + mod.Serial; } } catch (Exception ex) { Panel1.Visible = true; lblMsgError.Text = "Nenhuma entrada encontrada: " + ex.Message; } }
/// <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(); }
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(); }