public EditServiceForm(DateDTO dateDTO, List <int> dishDTOs)
{
InitializeComponent();
LoadData(dishesGrid, dishDTOs);
idToSave = dateDTO.Id;
}
public IHttpActionResult Put(DateDTO dateDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
dateService.Put(dateDTO);
return(Ok());
}
public static void TestDeserializeNotExpectedJSON()
{
using (StreamReader stream = new StreamReader($"{_baseDirectory}/resources/random-example.json"))
{
string json = stream.ReadToEnd();
DateDTO dto = JsonSerializer.Deserialize <DateDTO>(json);
Assert.Equal(default(DateTime), dto.Date);
Assert.Equal(default(int), dto.Age);
}
}
public void Create(DateDTO dateDTO)
{
using (var db = new ModelContext())
{
Date date = db.Dates.Create();
date.DateNumber = dateDTO.DateNumber;
date.CategoryId = dateDTO.CategoryId;
db.Dates.Add(date);
db.SaveChanges();
}
}
public static void TestDeserializeJSON()
{
using (StreamReader stream = new StreamReader($"{_baseDirectory}/resources/date-example.json"))
{
string json = stream.ReadToEnd();
DateDTO dto = JsonSerializer.Deserialize <DateDTO>(json);
DateTime expectedDate = new DateTime(1968, 1, 24, 18, 3, 23, DateTimeKind.Utc);
Assert.Equal(expectedDate, dto.Date);
Assert.Equal(50, dto.Age);
}
}
public IActionResult Post(DateDTO dto)
{
_medicationsConsumptionService.GeneratePdf(dto);
if (_sftpService.SendFile("Report_" + dto.From.Day.ToString() + "." + dto.From.Month.ToString() + "." + dto.From.Year.ToString() + "-" + dto.To.Day.ToString() + "." + dto.To.Month.ToString() + "." + dto.To.Year.ToString() + ".pdf"))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public IActionResult Post(DateDTO dto)
{
_medicationsConsumptionService.GeneratePdf(dto);
if (_sftpService.SendFile("izvjestaj.pdf"))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public void Put(DateDTO dateDTO)
{
using (var db = new ModelContext())
{
Date existingDate = db.Dates
.Where(m => m.Id == dateDTO.Id)
.FirstOrDefault();
if (existingDate != null)
{
existingDate.DateNumber = dateDTO.DateNumber;
existingDate.CategoryId = dateDTO.CategoryId;
db.SaveChanges();
}
}
}
public DateDTO GetDateByCategory(int categoryId, int id)
{
using (var db = new ModelContext())
{
List <Date> dates = db.Dates.Where(m => m.CategoryId == categoryId && m.Id == id).ToList();
List <DateDTO> dtos = new List <DateDTO>();
foreach (var date in dates)
{
DateDTO dto = new DateDTO();
dto.Id = date.Id;
dto.DateNumber = date.DateNumber;
dto.CategoryId = date.CategoryId;
dto.MatchesIds = date.Matches
.Select(m => m.Id)
.ToList();
dtos.Add(dto);
}
return(dtos.FirstOrDefault());
}
}
public List <DateDTO> GetAll()
{
using (var db = new ModelContext())
{
List <Date> dates = db.Dates.ToList();
List <DateDTO> dtos = new List <DateDTO>();
foreach (var date in dates)
{
DateDTO dto = new DateDTO();
dto.Id = date.Id;
dto.DateNumber = date.DateNumber;
dto.CategoryId = date.CategoryId;
dto.MatchesIds = date.Matches
.Select(m => m.Id)
.ToList();
dtos.Add(dto);
}
return(dtos);
}
}
public void GeneratePdf(DateDTO dto)
{
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
PdfWriter wr = PdfWriter.GetInstance(doc, new FileStream("izvjestaj.pdf", FileMode.Create));
doc.Open();
iTextSharp.text.Paragraph p = new iTextSharp.text.Paragraph("\t\t Medications consumption records \n");
doc.Add(p);
foreach (IdentifiableDTO <MedicationsConsumptionDTO> medication in GetAll().ToList())
{
if (medication.EntityDTO.DateOfConsumtion >= dto.From && medication.EntityDTO.DateOfConsumtion <= dto.To)
{
iTextSharp.text.Paragraph p1 = new iTextSharp.text.Paragraph("\n Name: " + medication.EntityDTO.Name + " -- Quantity: " + medication.EntityDTO.Quantity + " -- Date: " + medication.EntityDTO.DateOfConsumtion);
doc.Add(p1);
}
}
doc.Close();
}
private DataRow GetDotBiTich(DataTable tblDotBiTich, LoaiBiTich loaiBitich, string tenLinhMuc, string ngay, string noiBitich)
{
string tenLMLower = tenLinhMuc.ToLower();
string ngaySo = Memory.GetIntOfDateFrom(ngay);
foreach (DataRow row in tblDotBiTich.Rows)
{
string sdate = Memory.GetIntOfDateFrom(row[DotBiTichConst.NgayBiTich].ToString());
if (row[DotBiTichConst.LinhMuc].ToString().ToLower().Equals(tenLMLower) &&
(int)row[DotBiTichConst.LoaiBiTich] == (int)loaiBitich &&
sdate.CompareTo(ngaySo) == 0
)
{
return(row);
}
}
DataRow newRow = tblDotBiTich.NewRow();
newRow[DotBiTichConst.LinhMuc] = tenLinhMuc;
newRow[DotBiTichConst.LoaiBiTich] = (int)loaiBitich;
newRow[DotBiTichConst.MaDotBiTich] = Memory.Instance.GetNextId(DotBiTichConst.TableName, DotBiTichConst.MaDotBiTich, false);
newRow[DotBiTichConst.NgayBiTich] = ngay;
newRow[DotBiTichConst.NoiBiTich] = noiBitich;
newRow[DotBiTichConst.UpdateDate] = DateTime.Now;
//tao mo ta cho dot bi tich
DateDTO dateDTO = Memory.GetDatePart(ngay);
string mota = string.Format("Đợt bí tích{0}{1}{2}",
dateDTO.Day != "" ? " ngày " + dateDTO.Day : "",
dateDTO.Month != "" ? " tháng " + dateDTO.Month : "",
dateDTO.Year != "" ? " năm " + dateDTO.Year : "");
newRow[DotBiTichConst.MoTa] = mota;
tblDotBiTich.Rows.Add(newRow);
tongDotBiTich++;
return(newRow);
}
public void DateUpdate(DateDTO dateDTO)
{
var updateDate = datesTelegram.GetAll().SingleOrDefault(c => c.Id == dateDTO.Id);
//GetTelegramDates.Update((mapper.Map<DateDTO, Dates>(dateDTO, updateDate)));
//! TODO !
}
public int DateCreate(DateDTO dateDTO)
{
var createDate = datesTelegram.Create(mapper.Map <Dates>(dateDTO));
return((int)createDate.Id);
}
public ActionResult DeleteByDate(int systemId, [FromBody] DateDTO date)
{
_logService.DeleteByDate(systemId, date.Date);
return(Ok());
}
