/// <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();
}
