protected void CadastrarButton_Click(object sender, EventArgs e)
{
try
{
if (DropDownListTpServico.SelectedIndex > 0)
{
ObjServico = FactoryServico.GetNewServico();
ObjServico.IdTipo = Convert.ToInt32(DropDownListTpServico.SelectedValue);
ObjServico.NomeServ = Nome.Value;
ObjServico.DescServ = DescServ.Value;
ObjServico.Sla = Convert.ToDouble(SLA.Value);
if (new ManterServico(ObjServico).CadastraServico())
{
Mensagem = "Serviço cadastrado com sucesso.";
ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "Alerta('" + Mensagem + "')", true);
}
else
{
Mensagem = "Não foi possível cadastrar o serviço";
ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "Alerta('" + Mensagem + "')", true);
}
}
}
catch (Exception Ex)
{
LogException.InsereLogBd(Ex);
MsgLabel.Text = LogException.CodigoErroBd();
}
}
public List <Servico> ConsultaServicosDAO()
{
try
{
List <Servico> ServicoList = new List <Servico>();
SqlDataReader Dr = null;
SqlCommand Cmd = null;
using (SqlConnection Con = new Conexao().ConexaoDB())
{
Cmd = new SqlCommand(@"
SELECT *
FROM [dbo].[Servico]
WHERE ativo = 1 and idEmpresa = @Empresa", Con);
Cmd.Parameters.AddWithValue("@Empresa", InfoGlobal.GlobalIdEmpresa);
Dr = Cmd.ExecuteReader();
while (Dr.Read())
{
Servico Servicos = FactoryServico.GetNewServico();
Servicos.Id = Dr.GetInt32(0);
Servicos.IdTipo = Dr.GetInt32(1);
Servicos.NomeServ = Dr.GetString(2);
Servicos.DescServ = Dr.GetString(3);
Servicos.Sla = Dr.GetInt32(4);
Servicos.IdStatus = Dr.GetInt32(5);
ServicoList.Add(Servicos);
}
return(ServicoList);
}
}
catch (SqlException)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Session["perfil"].Equals("Gestor") && !Session["perfil"].Equals("Administrador"))
{
Response.Redirect("\\Views\\SGA\\Inicio.aspx", false);
}
if (!Page.IsPostBack)
{
Mensagem = "Consulta de tipos de serviços.";
ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "Alerta('" + Mensagem + "')", true);
}
foreach (var Result in new ManterServico().ConsultaTpServicos())
{
TipoServico Tp = FactoryServico.GetNewTpServico();
Tp.Id = Result.Id;
Tp.NomeTipoServ = Result.NomeTipoServ;
ListaTpServicoSelect.Add(Tp);
}
if (Request.QueryString["OpInatTpServico"] != null && Request.QueryString["OpInatTpServico"].Equals("True"))
{
Mensagem = "Tipo de serviço inativado com sucesso.";
ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "Alerta('" + Mensagem + "')", true);
}
else if (Request.QueryString["OpInatTpServico"] != null && Request.QueryString["OpInatTpServico"].Equals("False"))
{
Mensagem = "Ocorreu um erro ao inativar o tipo de serviço.";
ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "Alerta('" + Mensagem + "')", true);
}
}
catch (Exception Ex)
{
LogException.InsereLogBd(Ex);
MsgLabel.Text = LogException.CodigoErroBd();
}
}
public List <TipoServico> ConsultaTpServicosDAO()
{
try
{
List <TipoServico> ServicoTpList = new List <TipoServico>();
SqlDataReader Dr = null;
using (SqlConnection Con = new Conexao().ConexaoDB())
{
SqlCommand Cmd = new SqlCommand(@"
SELECT [idTipoServ]
,[tipo]
FROM [dbo].[TipoServico]
WHERE ativo = 1
ORDER BY Tipo;", Con);
Dr = Cmd.ExecuteReader();
while (Dr.Read())
{
TipoServico TpServ = FactoryServico.GetNewTpServico();
TpServ.Id = Dr.GetInt32(0);
TpServ.NomeTipoServ = Dr.GetString(1);
ServicoTpList.Add(TpServ);
}
return(ServicoTpList);
}
}
catch (SqlException)
{
throw;
}
}
