/// <summary>
/// Insere Politica de Reparo
/// </summary>
/// <param name="model">Dados a serem inseridos</param>
/// <param name="usu_id">Id do Usuário Logado</param>
/// <param name="ip">IP do Usuário Logado</param>
/// <returns>int</returns>
public int PoliticaReparo_Inserir(PoliticaReparoModel model, int usu_id, string ip)
{
try
{
using (SqlConnection con = new SqlConnection(strConn))
{
con.Open();
SqlCommand com = new SqlCommand();
com.CommandText = "STP_INS_REPARO_POLITICA";
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Clear();
System.Data.SqlClient.SqlParameter p_return = new System.Data.SqlClient.SqlParameter();
p_return.Direction = System.Data.ParameterDirection.ReturnValue;
com.Parameters.Add(p_return);
com.Parameters[0].Size = 32000;
com.Parameters.AddWithValue("@rpt_id", model.rpt_id);
com.Parameters.AddWithValue("@leg_id", model.leg_id);
com.Parameters.AddWithValue("@ale_id", model.ale_id);
com.Parameters.AddWithValue("@atp_id", model.atp_id);
com.Parameters.AddWithValue("@aca_id", model.aca_id);
com.Parameters.AddWithValue("@usu_id", usu_id);
com.Parameters.AddWithValue("@ip", ip);
com.ExecuteScalar();
return(Convert.ToInt32(p_return.Value));
}
}
catch (Exception ex)
{
int id = 0;
new LogSistemaDAO().InserirLogErro(new LogErro(ex, this.GetType().Name, new StackTrace().GetFrame(0).GetMethod().Name), out id);
throw new Exception(ex.Message);
}
}
/// <summary>
/// Insere Politica de Reparo
/// </summary>
/// <param name="model">Dados a serem inseridos</param>
/// <returns>JsonResult</returns>
public JsonResult PoliticaReparo_Inserir(PoliticaReparoModel model)
{
return(Json(new ReparoBLL().PoliticaReparo_Inserir(model), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Busca grid home
/// </summary>
/// <param name="model">Dados de Filtro</param>
/// <returns>JsonResult</returns>
public JsonResult PoliticaReparo_GetbyID(PoliticaReparoModel model)
{
return(Json(new { data = new ReparoBLL().PoliticaReparo_GetbyID(model) }, JsonRequestBehavior.AllowGet));
}
// *************** POLITICA DE REPARO *************************************************************
/// <summary>
/// Preenche Grid da Home Politica de Reparo
/// </summary>
/// <param name="model">Dados de Filtro</param>
/// <returns>Lista de PoliticaReparoModel</returns>
public List <PoliticaReparoModel> PoliticaReparo_GetbyID(PoliticaReparoModel model)
{
string ale_id = "0";
if (model.ale_id != null)
{
string[] ale = model.ale_id.Split('-');
ale_id = ale[0];
}
string aca_id = "0";
if (model.aca_id != null)
{
string[] aca = model.aca_id.Split('-');
aca_id = aca[0];
}
string leg_id = "0";
if (model.leg_id != null)
{
string[] leg = model.leg_id.Split('-');
leg_id = leg[0];
}
string atp_id = "0";
if (model.atp_id != null)
{
string[] atp = model.atp_id.Split('-');
atp_id = atp[0];
}
string rpt_id = "0";
if (model.rpt_id != null)
{
string[] rpt = model.rpt_id.Split('-');
rpt_id = rpt[0];
}
List <PoliticaReparoModel> lista = new List <PoliticaReparoModel>();
using (SqlConnection con = new SqlConnection(conn.strConn))
{
con.Open();
SqlCommand com = new SqlCommand("STP_SEL_POLITICA_REPARO_PARAMETROS", con);
com.CommandType = CommandType.StoredProcedure;
System.Data.SqlClient.SqlParameter p_return = new System.Data.SqlClient.SqlParameter();
p_return.Direction = System.Data.ParameterDirection.ReturnValue;
com.Parameters.Add(p_return);
com.Parameters[0].Size = 32000;
com.Parameters.AddWithValue("@ACA_ID", aca_id);
com.Parameters.AddWithValue("@ALE_ID", ale_id);
com.Parameters.AddWithValue("@ATP_ID", atp_id);
com.Parameters.AddWithValue("@RPT_ID", rpt_id);
com.Parameters.AddWithValue("@LEG_ID", leg_id);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
lista.Add(new PoliticaReparoModel
{
aca_codigo = reader["aca_codigo"] == DBNull.Value ? string.Empty : reader["aca_codigo"].ToString(),
aca_descricao = reader["aca_descricao"] == DBNull.Value ? string.Empty : reader["aca_descricao"].ToString(),
ale_descricao = reader["ale_descricao"] == DBNull.Value ? string.Empty : reader["ale_descricao"].ToString(),
ale_codigo = reader["ale_codigo"] == DBNull.Value ? string.Empty : reader["ale_codigo"].ToString(),
atp_descricao = reader["atp_descricao"] == DBNull.Value ? string.Empty : reader["atp_descricao"].ToString(),
atp_codigo = reader["atp_codigo"] == DBNull.Value ? string.Empty : reader["atp_codigo"].ToString(),
leg_codigo = reader["leg_codigo"] == DBNull.Value ? string.Empty : reader["leg_codigo"].ToString(),
leg_descricao = reader["leg_descricao"] == DBNull.Value ? string.Empty : reader["leg_descricao"].ToString(),
rpp_id = reader["rpp_id"] == DBNull.Value ? string.Empty : reader["rpp_id"].ToString(),
rpt_codigo = reader["rpt_codigo"] == DBNull.Value ? string.Empty : reader["rpt_codigo"].ToString(),
rpt_descricao = reader["rpt_descricao"] == DBNull.Value ? string.Empty : reader["rpt_descricao"].ToString(),
leg_id = reader["leg_id"] == DBNull.Value ? string.Empty : reader["leg_id"].ToString(),
atp_id = reader["atp_id"] == DBNull.Value ? string.Empty : reader["atp_id"].ToString(),
ale_id = reader["ale_id"] == DBNull.Value ? string.Empty : reader["ale_id"].ToString(),
aca_id = reader["aca_id"] == DBNull.Value ? string.Empty : reader["aca_id"].ToString()
});
}
return(lista.ToList());
}
}
/// <summary>
/// Dados da Politica selecionada
/// </summary>
/// <param name="model">Dados de Filtro</param>
/// <returns>Lista de PoliticaReparoModel</returns>
public List <PoliticaReparoModel> PoliticaReparo_GetbyID(PoliticaReparoModel model)
{
return(new ReparoDAO().PoliticaReparo_GetbyID(model));
}
/// Insere Politica de Reparo
/// </summary>
/// <param name="model">Dados a serem inseridos</param>
/// <returns>int</returns>
public int PoliticaReparo_Inserir(PoliticaReparoModel model)
{
Usuario paramUsuario = (Usuario)System.Web.HttpContext.Current.Session["Usuario"];
return(new ReparoDAO().PoliticaReparo_Inserir(model, paramUsuario.usu_id, paramUsuario.usu_ip));
}