public void EditLawsuit(LawsuitViewModel model)
{
Lawsuit lawsuit = lawsuitRepository.get(model.id);
if (lawsuit != null)
{
lawsuit.dateTimeOfEvent = model.dateTimeOfEvent;
lawsuit.location = locationRepository.get(model.location);
lawsuit.judge = contactRepository.get(model.judge);
lawsuit.courtType = model.courtType;
lawsuit.processId = model.processId;
lawsuit.courtroomNumber = model.courtroomNumber;
lawsuit.prosecutor = contactRepository.get(model.prosecutor);
lawsuit.defendant = contactRepository.get(model.defendant);
lawsuit.note = model.note;
lawsuit.typeOfProcess = typeOfRepository.get(model.typeOfProcess);
this.lawsuitRepository.update(lawsuit);
}
}
public static List <Block> GetLawsuitBlocks(int lawsuitId, LawsuitDB DB, Defines.BlockIncludeTypesEnum includeType = Defines.BlockIncludeTypesEnum.All)
{
Lawsuit lawsuit = DB.Lawsuits.Select(i => i).Where(i => i.LawsuitId == lawsuitId).First();
List <Block> blocks = new List <Block>();
List <LawsuitBlock> lawsuitBlockList = lawsuit.LawsuitBlocks.ToList();
lawsuitBlockList.Sort(Utils.BlockComparer);
foreach (LawsuitBlock pair in lawsuitBlockList)
{
Block block = DB.Blocks.Where(i => i.BlockId == pair.BlockId).First();
if (includeType == Defines.BlockIncludeTypesEnum.All)
{
blocks.Add(block);
}
else if (block.BlockIncludeType == (int)includeType)
{
blocks.Add(block);
}
}
return(blocks);
}
public void UpdateLawsuit(int id, Lawsuit newLawsuit)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("update lawsuits set date=@date, location=@location, judge=@judge, inst_type=@inst_type, procedure_id=@procedure_id, courtroom=@courtroom, plaintiff=@plaintiff, defendant=@defendant, note=@note, procedure_type=@procedure_type where id=@id", conn);
cmd.Parameters.Add("@id", MySqlDbType.Int32).Value = id;
cmd.Parameters.Add("@date", MySqlDbType.DateTime).Value = newLawsuit.date;
cmd.Parameters.Add("@location", MySqlDbType.Int32).Value = newLawsuit.location;
cmd.Parameters.Add("@judge", MySqlDbType.Int32).Value = newLawsuit.judge;
cmd.Parameters.Add("@inst_type", MySqlDbType.VarChar).Value = newLawsuit.inst_type;
cmd.Parameters.Add("@procedure_id", MySqlDbType.VarChar).Value = newLawsuit.procedure_id;
cmd.Parameters.Add("@courtroom", MySqlDbType.Int32).Value = newLawsuit.courtroom;
cmd.Parameters.Add("@plaintiff", MySqlDbType.Int32).Value = newLawsuit.plaintiff;
cmd.Parameters.Add("@defendant", MySqlDbType.Int32).Value = newLawsuit.defendant;
cmd.Parameters.Add("@note", MySqlDbType.VarChar).Value = newLawsuit.note;
cmd.Parameters.Add("@procedure_type", MySqlDbType.VarChar).Value = newLawsuit.procedure_type;
var num = cmd.ExecuteNonQuery();
conn.Close();
}
}
public void CreateMultipleRecords(int records)
{
for (int i = 1; i == records; i++)
{
string rec = records.ToString();
Lawsuit lawsuit = new Lawsuit();
lawsuit.SuitNumber = "Test001002-" + rec;
lawsuit.SuitCreationTime = DateTime.Today;
lawsuit.CourtCosts = 333.03m;
lawsuit.LawofficeId = 1; //OfficeId 1 deve existir primeiro
try
{
Assert.True(true);
}
catch (DbUpdateException ex)
{
Console.WriteLine($"### Erro: Record numero - {i}");
continue;
}
}
}
public IHttpActionResult Create([FromBody] LawViewModel lawViewModel)
{
var validation = new MainValidator().Validate(lawViewModel);
if (validation.IsValid)
{
Lawsuit ls = new Lawsuit();
ls.SuitNumber = lawViewModel.NumeroDoProcesso;
ls.SuitCreationTime = lawViewModel.dataDeCriacaoDoProcesso;
ls.CourtCosts = lawViewModel.valor;
ls.LawofficeId = lawViewModel.escritorioId;
var result = _service.Create(ls);
if (result == ServiceEnums.CreateState.Success)
{
return(Ok(result));
}
return(StatusCode(HttpStatusCode.PartialContent));
}
return(BadRequest());
}
public void Put(int id, [FromBody] Lawsuit lawsuit)
{
this.context.UpdateLawsuit(id, lawsuit);
}
public void Post([FromBody] Lawsuit lawsuit)
{
this.context.AddLawsuit(lawsuit);
}
public static List <Block> GetLawsuitBlocks(Lawsuit lawsuit, LawsuitDB DB, Defines.BlockIncludeTypesEnum type = Defines.BlockIncludeTypesEnum.All)
{
return(Utils.GetLawsuitBlocks(lawsuit.LawsuitId, DB, type));
}
public static int LawsuitComparer(Lawsuit a, Lawsuit b)
{
return(a.LawsuitWeight.CompareTo(b.LawsuitWeight));
}
public void add(Lawsuit lawsuit)
{
context.Lawsuits.Add(lawsuit);
context.SaveChanges();
}
