public bool Update(Guid?id)
{
try
{
bool isSaved = false;
using (var db = new HMSEntities())
{
BillHistory entity = db.BillHistories.FirstOrDefault(t => t.OPDHistoryId == id);
entity.PrintCopys = entity.PrintCopys + 1;
entity.LastPrintedOn = DateTime.Now;
entity.LastPrintedBy = UserDetailSession.Id;
db.SaveChanges();
isSaved = true;
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public BillHistoryModel GetByOPDId(Guid id)
{
try
{
BillHistoryModel model = new BillHistoryModel();
using (var db = new HMSEntities())
{
BillHistory entity = db.BillHistories.Find(id);
if (entity != null)
{
model.Id = entity.Id;
model.PatientId = entity.PatientId;
model.OPDHistoryId = entity.OPDHistoryId;
model.ReceiptNumber = entity.ReceiptNumber;
model.PrintCopys = entity.PrintCopys;
model.CreatedOn = entity.CreatedOn;
model.CreatedBy = entity.CreatedBy;
model.LastPrintedOn = entity.LastPrintedOn;
model.LastPrintedBy = entity.LastPrintedBy;
}
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Create(BillHistoryModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
BillHistory entity = new BillHistory();
entity.PatientId = model.PatientId;
entity.OPDHistoryId = model.OPDHistoryId;
entity.PrintCopys = 1;
int?recpNumber = db.BillHistories.Select(t => t.ReceiptNumber).DefaultIfEmpty(0).Max();
entity.ReceiptNumber = recpNumber == null ? 1 : recpNumber.Value + 1;
entity.CreatedOn = DateTime.Now;
entity.CreatedBy = UserDetailSession.Id;
db.BillHistories.Add(entity);
db.SaveChanges();
isSaved = true;
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}