public bool AlterarStatusTicket(ModelTicket modelTicket)
{
string instrucao = string.Format(@"UPDATE tbPedidoItens SET Ticket = 'Gerado' WHERE Codigo = @Codigo");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@Codigo", modelTicket.Codigo);
return(Convert.ToBoolean(command.ExecuteNonQuery()));
}
public bool GerarTicket(ModelTicket modelTicket)
{
try
{
string instrucao = string.Format(@"INSERT INTO tbTicket (GeradoPor, Data, Valor, Status) VALUES (@GeradoPor, @Data, @Valor, @Status)");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@GeradoPor", modelTicket.GeradoPor);
command.Parameters.AddWithValue("@Data", modelTicket.Data);
command.Parameters.AddWithValue("@Valor", modelTicket.Valor);
command.Parameters.AddWithValue("@Status", modelTicket.Status);
return(Convert.ToBoolean(command.ExecuteNonQuery()));
}
catch
{
throw;
}
}
public bool TicketAlterarStatus(ModelTicket modelTicketa)
{
try
{
string instrucao = string.Format(@"UPDATE tbTicket SET Status = 'Finalizado' WHERE Codigo = @Codigo");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@Codigo", modelTicketa.Codigo);
return(Convert.ToBoolean(command.ExecuteNonQuery()));
}
catch
{
throw;
}
finally
{
controllerConfiguracaoSQL.Fechar();
}
}
public bool valorTicketPago(ModelTicket modelTicket)
{
try
{
string instrucao = string.Format(@"UPDATE tbTicket SET Valor = Valor - @Valor WHERE Codigo = @Codigo");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@Codigo", modelTicket.Codigo);
command.Parameters.AddWithValue("@Valor", modelTicket.ValorPago);
return(Convert.ToBoolean(command.ExecuteNonQuery()));
}
catch
{
throw;
}
finally
{
controllerConfiguracaoSQL.Fechar();
}
}
public int GerarTicket(ModelTicket modelTicket)
{
try
{
string instrucao = string.Format(@"INSERT INTO tbTicket (GeradoPor, Data, Valor, Status) VALUES (@GeradoPor, @Data, @Valor, @Status); SELECT @@IDENTITY;");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@GeradoPor", modelTicket.GeradoPor);
command.Parameters.AddWithValue("@Data", modelTicket.Data);
command.Parameters.AddWithValue("@Valor", modelTicket.Valor);
command.Parameters.AddWithValue("@Status", modelTicket.Status);
return(Convert.ToInt32(command.ExecuteScalar()));
}
catch
{
throw;
}
finally
{
controllerConfiguracaoSQL.Fechar();
}
}
public bool VerificarTicketZerado(ModelTicket modelTicket)
{
try
{
string instrucao = string.Format(@"SELECT * FROM tbTicket WHERE Codigo = @Codigo AND Valor = '0.00'");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@Codigo", modelTicket.Codigo);
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
return(true);
}
return(false);
}
catch
{
throw;
}
finally
{
controllerConfiguracaoSQL.Fechar();
}
}
public decimal VerificarTicket(ModelTicket modelTicket)
{
try
{
string instrucao = string.Format(@"SELECT * FROM tbTicket WHERE Codigo = @Codigo AND Status = 'Em Aberto'");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar());
command.Parameters.AddWithValue("@Codigo", modelTicket.Codigo);
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
sqlDataReader.Read();
return(Convert.ToDecimal(sqlDataReader["Valor"].ToString()));
}
return(0);
}
catch
{
throw;
}
finally
{
controllerConfiguracaoSQL.Fechar();
}
}
