public List <vw_CaseDefectsData> GetVictimsByCaseID(int CaseID, int SessionID)
{
var victims = (from _case in DataContext.Cases_Cases
join _session in DataContext.Cases_CaseSessions on _case.ID equals _session.CaseID
join _victim in DataContext.Cases_CaseVictims on _case.ID equals _victim.CaseID
join _personVictim in DataContext.Configurations_Persons on _victim.PersonID equals _personVictim.ID
join _victimsSessionLog in DataContext.Cases_VictimsSessionsLog on _victim.ID equals _victimsSessionLog.VictimID into VSLog
from _vslog in VSLog.DefaultIfEmpty()
join _PresenceStatus in DataContext.Configurations_Lookups on _vslog.PresenceStatusID equals _PresenceStatus.ID into PStatus
from _ps in PStatus.DefaultIfEmpty()
where _case.ID == CaseID && _session.ID == SessionID && _case.IsDeleted != true
select new vw_CaseDefectsData
{
ID = _victim.ID,
PersonID = _victim.PersonID,
Name = _personVictim.FullName,
NationalID = _personVictim.NationalID,
DefectType = PartyTypes.Victim,
IsCivilRightProsecutor = _victim.IsCivilRightProsecutor,
Presence = _vslog == null ? 0 :(PresenceStatus)_vslog.PresenceStatusID,
JobName = _personVictim.JobTitle,
NationalityType = _personVictim.NationalityID,
PassportNumber = _personVictim.PassportNumber,
Birthdate = _personVictim.Birthdate,
Order = _victim.Order,
Address = _personVictim.Address,
Nationality = _personVictim.Configurations_Lookups.Name,
}).ToList();
return(victims);
}
public static void Update(int senha, PStatus status)
{
NonQuery($"Erro ao atualizar status de lista de espera. ({ErrorCodes.DB0040})", (c) => {
c.CommandText = $"update {Name} set {nameof(_Status)} = @status where {nameof(Senha)} = @senha;";
c.Parameters.AddWithValue("@senha", senha);
c.Parameters.AddWithValue("@status", ES.ps[status]);
return(c);
});
}
//For Deep Copy
public Product(Product other)
{
topSellerStatus = other.topSellerStatus;
name = other.name;
type = other.type;
productID = other.productID;
location = other.location;
inStock = other.inStock;
stockCount = other.stockCount;
price = other.price;
}
public static void Update(int senha, Fila fila, PStatus status)
{
NonQuery("Erro ao atualizar lista de espera.", (c) => {
c.CommandText = $"update {Name} set {nameof(Fila)} = @fila, {nameof(_Status)} = @status " +
$"where {nameof(Senha)} = @senha;";
c.Parameters.AddWithValue("@senha", senha);
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
return(c);
});
}
public static void Insert(string paciente, DateTime dt, PStatus status, Fila encaminhado, bool prioridade)
{
NonQuery($"Erro ao inserir em lista de espera. ({ErrorCodes.DB0033})", (c) => {
c.CommandText = $"insert into {Name} values (null, @paciente, @time, @status, @encaminhado, @prioridade);";
c.Parameters.AddWithValue("@paciente", paciente);
c.Parameters.AddWithValue("@time", dt.ToString("yyyy-MM-dd HH:mm:ss"));
c.Parameters.AddWithValue("@status", Get(status));
c.Parameters.AddWithValue("@encaminhado", ES.f[encaminhado]);
c.Parameters.AddWithValue("@prioridade", prioridade);
return(c);
});
}
public static void Update(string paciente, bool prioridade, Fila fila, PStatus status)
{
NonQuery($"", (c) => {
c.CommandText = $"update {Name} set " +
$" {nameof(Prioridade)} = @prioridade, " +
$" {nameof(Fila)} = @fila, " +
$" {nameof(_Status)} = @status " +
$"where {nameof(Paciente)} = @cpf;";
c.Parameters.AddWithValue("@cpf", paciente);
c.Parameters.AddWithValue("@prioridade", prioridade);
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
return(c);
});
}
public Product(string _name, PType _type, int _location, int _stockCount, int _price, int _productID = 0)
{
topSellerStatus = new TopSeller(_productID);
name = _name;
type = _type;
productID = _productID;
location = _location;
stockCount = _stockCount;
price = _price;
if (stockCount == 0)
{
inStock = PStatus.Empty;
}
else if (stockCount <= 20)
{
inStock = PStatus.LowQuantity;
}
else
{
inStock = PStatus.InStock;
}
}
//Methods
public void Buy(int num = 1)
{
if (this.inStock == PStatus.Empty)
{
throw new InvalidOperationException("No Product Left to buy!");
}
this.StockCount = this.StockCount - num;
if (stockCount == 0)
{
inStock = PStatus.Empty;
}
else if (stockCount <= 20)
{
inStock = PStatus.LowQuantity;
}
else
{
inStock = PStatus.InStock;
}
this.topSellerStatus.SellCounter = this.topSellerStatus.SellCounter + num;
}
public static string Get(PStatus status)
{
if (status == PStatus.Esperando)
{
return("Esperando");
}
else if (status == PStatus.EmAtendimento)
{
return("Em atendimento");
}
else if (status == PStatus.ACaminho)
{
return("A caminho");
}
else if (status == PStatus.Atendido)
{
return("Atendido");
}
else
{
throw new NotImplementedException();
}
}
public List <vw_CaseDefectsData> GetDefendantsByCaseID(int CaseID, int SessionID)
{
var defendants = (from _case in DataContext.Cases_Cases
join _session in DataContext.Cases_CaseSessions on _case.ID equals _session.CaseID
join _defendant in DataContext.Cases_CaseDefendants on _case.ID equals _defendant.CaseID
join _defendantCaseLog in DataContext.Cases_DefendatnsCaseLog on _defendant.ID equals _defendantCaseLog.DefendantID
join _personDefendant in DataContext.Configurations_Persons on _defendant.PersonID equals _personDefendant.ID
join Look in DataContext.Configurations_Lookups on _personDefendant.NationalityID equals Look.ID
join _defendantsSessionLog in DataContext.Cases_DefendatnsSessionsLog on _defendant.ID equals _defendantsSessionLog.DefendantID into DSLog
from _dslog in DSLog.DefaultIfEmpty()
join _PresenceStatus in DataContext.Configurations_Lookups on _dslog.PresenceStatusID equals _PresenceStatus.ID into PStatus
from _ps in PStatus.DefaultIfEmpty()
join _PoliceStationStatus in DataContext.Configurations_Lookups on _defendantCaseLog.PoliceStationStatusID equals _PoliceStationStatus.ID
where _case.ID == CaseID && _case.IsDeleted != true && _session.ID == SessionID && !_defendantCaseLog.ToDate.HasValue
select new vw_CaseDefectsData
{
ID = (int)_defendant.ID,
PersonID = _defendant.PersonID,
Name = _personDefendant.FullName,
NationalID = _personDefendant.NationalID,
DefectType = PartyTypes.Defendant,
IsCivilRightProsecutor = _defendant.IsCivilRightProsecutor,
Presence = _dslog == null ? 0 : (PresenceStatus)_dslog.PresenceStatusID,
Status = _defendantCaseLog.PoliceStationStatusID,
JobName = _personDefendant.JobTitle,
NationalityType = _personDefendant.NationalityID,
PassportNumber = _personDefendant.PassportNumber,
Birthdate = _personDefendant.Birthdate,
Order = _defendant.Order,
Nationality = Look.Name,
Address = _personDefendant.Address,
// Age = DateTime.Now.Year - (DateTime)_personDefendant.Year
}).Distinct().ToList();
return(defendants);
}
public static List <_ListaEspera> Select(Fila fila, PStatus status)
{
var lista = new List <_ListaEspera>();
var c = new MySqlCommand();
c.CommandText =
$"select " +
$" a.{nameof(Senha)}," + // 0
$" a.{nameof(Paciente)}," + // 1
$" a.{nameof(_DateTime)}," + // 2
$" a.{nameof(_Status)}," + // 3
$" a.{nameof(Prioridade)}," + // 4
$" a.{nameof(Fila)}," + // 5
$" b.{nameof(Pessoas.Nome)}," + // 6
$" b.{nameof(Pessoas.Nascimento)} " + // 7
$"from {Name} as a " +
$"inner join {Pessoas.p.TableName} as b on a.{nameof(Paciente)} = b.{nameof(Pessoas.CPF)} " +
$"where {nameof(Fila)} = @fila and {nameof(_Status)} = @status " +
$"order by {nameof(_DateTime)} desc " +
$"limit 500;";
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
QueryRLoop("Erro ao obter pesquisa em lista de espera.", c, (r) => {
lista.Add(new _ListaEspera()
{
Senha = r.GetInt32(0),
CPF = r.GetString(1),
Atualizacao = r.GetMySqlDateTime(2).GetDateTime(),
Status = r.GetString(3),
Prioridade = r.GetBoolean(4),
Fila = r.GetString(5),
Nome = r.GetString(6),
Nascimento_Paciente = r.GetMySqlDateTime(7).GetDateTime()
});
});
return(lista);
}
public void ExecutionEnd(PStatus status)
{
this.Status = status;
this.End = DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
OnPropertyChanged("End");
}
public static void Insert(string paciente, PStatus status, Fila encaminhado, bool prioridade)
{
Insert(paciente, DateTime.Now, status, encaminhado, prioridade);
}
public static void Update(int senha, string paciente, bool prioridade, DateTime dt, Fila fila, PStatus status)
{
NonQuery("Erro ao atualizar lista de espera.", (c) => {
c.CommandText = $"update {Name} set " +
$" {nameof(Paciente)} = @pac, " +
$" {nameof(Prioridade)} = @prio, " +
$" {nameof(_DateTime)} = @time, " +
$" {nameof(Fila)} = @fila, " +
$" {nameof(_Status)} = @status " +
$"where {nameof(Senha)} = @senha;";
c.Parameters.AddWithValue("@pac", paciente);
c.Parameters.AddWithValue("@prio", prioridade);
c.Parameters.AddWithValue("@time", dt.ToString("yyyy-MM-dd HH:mm:ss"));
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
c.Parameters.AddWithValue("@senha", senha);
return(c);
});
}
public static void InsertOrUpdate(string paciente, bool prioridade, Fila fila, PStatus status)
{
var lista = Select_Paciente(paciente);
if (lista == null)
{
Insert(paciente, status, fila, prioridade);
}
else
{
Update(paciente, prioridade, fila, status);
Update_DT_Paciente(paciente);
}
}
