public static List<ItemDoanhThu> GetDoanhThuFromHistory(DateTime dateTime, DaysFormat daysFormat)
{
List<ItemDoanhThu> result = new List<ItemDoanhThu>();
string strCommand = "";
if(daysFormat == DaysFormat.Ngay)
{
strCommand = " SELECT * FROM " + ClinicConstant.HistoryTable + " WHERE Day = " + Helper.ConvertToSqlString(dateTime.ToString("yyyy-MM-dd"));
}
if (daysFormat == DaysFormat.Thang)
{
strCommand = " SELECT * FROM " + ClinicConstant.HistoryTable + " WHERE month(Day) = " + dateTime.Month.ToString();
}
using (DbDataReader reader = DatabaseFactory.Instance.ExecuteReader(strCommand, null) as DbDataReader)
{
while (reader.Read())
{
ItemDoanhThu item = new ItemDoanhThu();
item.Date = reader.GetDateTime(reader.GetOrdinal(ClinicConstant.HistoryTable_Day)).ToString("dd-MM-yyyy");
item.NameOfDoctor = reader[ClinicConstant.HistoryTable_NameDoctor].ToString();
item.IdPatient = reader[ClinicConstant.HistoryTable_Id].ToString();
item.AllMedicines = reader[ClinicConstant.HistoryTable_Medicines].ToString();
string Services = "";
item.Money = CalcuMoneyFromAllMedicines(item.AllMedicines, ref Services);
item.Services = Services;
item.NamePatient = GetNameFromIdPatient(item.IdPatient);
item.LoaiKham = reader[ClinicConstant.HistoryTable_NameLoaiKham].ToString();
item.Diagnose = reader[ClinicConstant.HistoryTable_Diagnose].ToString();
if (result.Where(x => x.IdPatient == item.IdPatient && x.Date == item.Date).FirstOrDefault() == null)
{
result.Add(item);
}
}
}
return result;
}
internal static List<ItemDoanhThu> DoanhThuTheoThang(IDatabase db, DateTime dateTime)
{
List<ItemDoanhThu> result = new List<ItemDoanhThu>();
string strCommand = " SELECT * FROM doanhthu WHERE month(time) = " + dateTime.Month.ToString();
using (DbDataReader reader = db.ExecuteReader(strCommand, null) as DbDataReader)
{
while (reader.Read())
{
ItemDoanhThu item = new ItemDoanhThu();
item.Date = reader.GetDateTime(reader.GetOrdinal(ClinicConstant.DoanhThuTable_Time)).ToString("dd-MM-yyyy");
item.NameOfDoctor = reader[ClinicConstant.DoanhThuTable_Namedoctor].ToString();
item.Money = (int)reader[ClinicConstant.DoanhThuTable_Money];
item.IdPatient = reader[ClinicConstant.DoanhThuTable_IdPatient].ToString();
item.NamePatient = reader[ClinicConstant.DoanhThuTable_NamePatient].ToString();
item.Services = reader[ClinicConstant.DoanhThuTable_Services].ToString();
item.LoaiKham = reader[ClinicConstant.DoanhThuTable_LoaiKham].ToString();
try
{
int idHistory = (int)reader[ClinicConstant.HistoryTable_IdHistory];
item.Diagnose = GetDiagnoseFromHistoryByIdHistory(idHistory, DatabaseFactory.Instance2);
}
catch { item.Diagnose = ""; }
if (result.Where(x => x.IdPatient == item.IdPatient && x.Date == item.Date).FirstOrDefault() == null)
{
result.Add(item);
}
}
}
return result;
}
