public DataTable GetUserbyID(BaseDataLite bd, string id) //Получить всех пользователей по id заявки
{
string query = $"SELECT * FROM Users where id = '{id}'";
command = new SQLiteCommand(query, bd.connection);
command.ExecuteNonQuery();
adapter = new SQLiteDataAdapter(query, connection);
table = new DataTable();
adapter.Fill(table);
return(table);
}
public DataTable GetUserbyName(BaseDataLite bd, string sname) //Получить все записи по фамилии
{
string query = $"SELECT * FROM Users where secound_name = '{sname}'";
command = new SQLiteCommand(query, bd.connection);
command.ExecuteNonQuery();
adapter = new SQLiteDataAdapter(query, connection);
table = new DataTable();
adapter.Fill(table);
return(table);
}
public DataTable ShowAll(BaseDataLite bd, string tablename) //Вывести всю таблицу
{
string query = $"SELECT * FROM {tablename}";
command = new SQLiteCommand(query, bd.connection);
command.ExecuteNonQuery();
adapter = new SQLiteDataAdapter(query, connection);
table = new DataTable();
adapter.Fill(table);
return(table);
}
public DataTable GetLoanbyStatus(BaseDataLite bd, string status) //Получить все записи опр. статуса заявки
{
try
{
string query = $"SELECT * FROM Loan where status = '{status}'";
command = new SQLiteCommand(query, bd.connection);
command.ExecuteNonQuery();
adapter = new SQLiteDataAdapter(query, connection);
table = new DataTable();
adapter.Fill(table);
return(table);
}
catch (Exception)
{
return(null);
}
}
public static BClaim FillClaim(int id, BaseDataLite bd)
{
DataTable loantb = bd.GetLoanbyID(bd, $"{id}");
BClaim claim = new BClaim();
claim.Id = id;
claim.SumLoan = Convert.ToInt32(loantb.Rows[0][2]);
claim.Days = Convert.ToInt32(loantb.Rows[0][3]);
claim.Fine = Convert.ToInt32(loantb.Rows[0][11]);
claim.CardNumber = Convert.ToString(loantb.Rows[0][7]);
claim.type = Convert.ToString(loantb.Rows[0][9]);
claim.status = Convert.ToString(loantb.Rows[0][8]);
claim.PaidOut = Convert.ToInt32(loantb.Rows[0][12]);
claim.SumPaid = Convert.ToInt32(loantb.Rows[0][10]);
claim.FirstDate = DateTime.Parse(Convert.ToString(loantb.Rows[0][4]));
claim.LastDate = claim.FirstDate.AddDays(claim.Days);
return(claim);
}
public DataTable GetLoanbyID(BaseDataLite bd, string id) //Получить зайвку по id
{
try
{
string query = $"SELECT * FROM Loan where id ={id} ";
command = new SQLiteCommand(query, connection);
command.ExecuteNonQuery();
adapter = new SQLiteDataAdapter(query, connection);
table = new DataTable();
adapter.Fill(table);
if (table.Rows[0][0] == DBNull.Value)
{
return(null);
}
return(table);
}
catch (Exception)
{
return(null);
}
}