//Verifica Atraso
public bool EmAtraso(Locacao loc, string conString)
{
try
{
using (Conexao c = new Conexao(conString))
{
c.Query($"Select count(*) From Locacao Where Id = {loc.Id} And Status = 0 And Convert(Date,DtDevolucao,120) < convert(date,getdate(),120)");
return(G1.GetInt(c.DtSql().Rows[0][0]) > 0);
}
}
catch (Exception e)
{
throw
new Exception("Erro Locação em Atraso\n" + e.Message);
}
}
public int InsertReturnId(string nomeDoMetodo = null)
{
try
{
query.Append(";Select SCOPE_IDENTITY()");
Cmd.CommandText = Convert.ToString(query);
SqlDataAdapter sqlAdapter = new SqlDataAdapter(Cmd);
DataTable d = new DataTable();
d.BeginLoadData();
sqlAdapter.Fill(d);
d.EndLoadData();
Cmd.CommandText = null;
query.Clear();
return(G1.GetInt(d.Rows[0][0]));
}
catch (Exception e)
{
Cmd.CommandText = null;
query = null;
throw new Exception(nomeDoMetodo + " - " + e.Message, e.InnerException);
}
}
