List <string> ILogging.EntriesRequest()
{
LogEntriesEventArgs args = new LogEntriesEventArgs();
GetEntries?.Invoke(this, args);
return(args.Args);
}
public async Task <bool> UploadEntryForDoctor(uint idDoc)
{
bool isUpdate = false;
if (connect.IsConnect())
{
string selectEntryQuery = "SELECT r.id, r.fio, e.date_registration, p.id, p.l_name, p.f_name, p.t_name, " +
"p.sex, p.birthday, p.address, p.phone_number, " +
"s.id, s.lable, s.price, s.action_service FROM entry AS e " +
"JOIN registrator AS r ON r.id = e.id_registrator " +
"JOIN patient AS p ON p.id = e.id_patient " +
"JOIN service AS s ON s.id = e.id_service " +
"WHERE e.id_doctor = @idDoc AND e.date_registration > LAST_DAY(CURDATE()) + INTERVAL 1 DAY - INTERVAL 1 MONTH AND " +
"e.date_registration < DATE_ADD(LAST_DAY(CURDATE()), INTERVAL 1 DAY)";
using (MySqlCommand command = new MySqlCommand(selectEntryQuery, connect.GetConnect))
{
command.Parameters.AddWithValue("@idDoc", idDoc);
using (DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
isUpdate = true;
while (await reader.ReadAsync())
{
GetEntries.Add(new Entry()
{
RegistratorEntry = new Registrator()
{
Id = await reader.GetFieldValueAsync <uint>(0), Fio = reader.GetString(1)
},
DateRegistration = reader.GetDateTime(2),
PatientEntry = new Patient()
{
Id = await reader.GetFieldValueAsync <uint>(3),
LastName = reader.GetString(4),
FirstName = reader.GetString(5),
ThridName = reader.GetString(6),
Sex = reader.GetString(7),
Birthday = reader.GetDateTime(8),
Address = reader.GetString(9),
PhoneNumber = reader.GetString(10)
},
ServiceEntry = new Service()
{
Id = await reader.GetFieldValueAsync <uint>(11),
Lable = reader.GetString(12),
Price = await reader.GetFieldValueAsync <uint>(13),
Action = reader.GetString(14)
}
});
}
}
reader.Close();
}
}
connect.Close();
}
return(isUpdate);
}
internal ProcDetails(string[] args)
{
this.args = args;
this.SystemValuesGetter = this.GetSystemValues;
this.InputGetter = this.GetConsoleInput;
this.EnvironmentVariablesGetter = this.GetEnvironmentVariables;
this.CoreSiteGetter = this.GetCoreSiteXml;
this.HiveSiteGetter = this.GetHiveSiteXml;
this.MapRedSiteGetter = this.GetMapRedSiteXml;
}
public object Search([FromBody] GetEntries query)
{
using (var dbCtx = new AddressBookEntities())
{
var pb = (from s in dbCtx.entries
where s.PhonebookId == query.PhonebookId
select s).ToList();
return(JsonConvert.DeserializeObject <EntriesResult[]>(JsonConvert.SerializeObject(pb)));
}
}
internal ProcDetails(string[] args)
{
this.args = args;
this.SystemValuesGetter = this.GetSystemValues;
this.InputGetter = this.GetConsoleInput;
this.EnvironmentVariablesGetter = this.GetEnvironmentVariables;
this.CoreSiteGetter = this.GetCoreSiteXml;
this.HiveSiteGetter = this.GetHiveSiteXml;
this.MapRedSiteGetter = this.GetMapRedSiteXml;
}
