public void Save(expense dbItem)
{
if (dbItem.id == Guid.Empty) //create
{
dbItem.id = Guid.NewGuid();
context.expenses.Add(dbItem);
}
else //edit
{
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public bool updatePatinetBasicInfo(Entities.Patient patient)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Patient patientEntity = ctx.Patients.Find(patient.PatientID);
if (patientEntity == null)
{
return(false);
}
patientEntity.Name = patient.Name;
patientEntity.Mobile = patient.Mobile;
patientEntity.Notice = patient.Notice;
patientEntity.Phone = patient.Phone;
patientEntity.Address = patient.Address;
patientEntity.BrithDate = patient.BrithDate;
patientEntity.E_mail = patient.E_mail;
patientEntity.gender = patient.gender;
ctx.Entry(patientEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public bool alterAppointment(AppointmentViewModelFull appointment)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Appointment appointmentEntity = ctx.Appointments.Find(appointment.id);
if (appointmentEntity == null)
{
return(false);
}
appointmentEntity.ClinicID = appointment.ClinicID;
appointmentEntity.DoctorID = appointment.DoctorID;
appointmentEntity.PatientID = appointment.PatientID;
appointmentEntity.Reason = appointment.Reason;
appointmentEntity.Status = appointment.Status;
appointmentEntity.Start_date = appointment.start_date;
appointmentEntity.End_date = appointment.end_date;
appointmentEntity.Text = appointment.text;
ctx.Entry(appointmentEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public ResponseModel CreateNode(A_GlAccount aObj)
{
if (aObj != null)
{
A_GlAccount nameEsist = _db.A_GlAccount.FirstOrDefault(x => x.Name == aObj.Name);
if (nameEsist != null)
{
return(_aModel.Respons(false, "Given Name Exists In The Chart Of Account"));
}
}
try
{
A_GlAccount aParent = _db.A_GlAccount.FirstOrDefault(x => x.A_GlAccountId == aObj.ParentId);
if (aParent != null)
{
aParent.TransactionAllowed = false;
_db.A_GlAccount.Attach(aParent);
_db.Entry(aParent).State = EntityState.Modified;
aObj.TransactionAllowed = true;
aObj.CreatedDate = DateTime.Now;
aObj.AccountType = aParent.AccountType;
aObj.BalanceType = aParent.BalanceType;
}
aObj.IsActive = true;
aObj.IsDeleted = false;
_db.A_GlAccount.Add(aObj);
_db.SaveChanges();
return(_aModel.Respons(true, " Congratulation : A new node created successfully"));
}
catch (Exception ex)
{
return(_aModel.Respons(false, ex.Message));
}
}
public bool SaveTreatmentMatrail(IEnumerable <MatrailToSaveViewModel> matrailList, int treatmentID)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
foreach (var item in matrailList)
{
MaterialTreatment materialTreatment = ctx.MaterialTreatments.Where(x => x.TeratmentID == treatmentID && x.MaterialID == item.MatrailID).FirstOrDefault();
if (materialTreatment == null)
{
materialTreatment = ctx.MaterialTreatments.Create();
materialTreatment.TeratmentID = treatmentID;
materialTreatment.MaterialID = item.MatrailID;
materialTreatment.MaterialCost = ctx.Materials.Find(item.MatrailID).MaterialCost;
materialTreatment.Quantity = item.Quantity;
ctx.MaterialTreatments.Add(materialTreatment);
}
else
{
materialTreatment.Quantity = item.Quantity;
ctx.Entry(materialTreatment).State = System.Data.Entity.EntityState.Modified;
}
count += ctx.SaveChanges();
}
}
return(count > 0 ? true : false);
}
public bool UpdateWarehouse(Warehouse warehouse)
{
int result = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
ctx.Entry(warehouse).State = System.Data.Entity.EntityState.Modified;
result = ctx.SaveChanges();
}
return(false);
}
public bool updateTreatment(Treatment treatment)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
ctx.Entry(treatment).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public void Save(owner dbItem)
{
if (dbItem.id == Guid.Empty) //create
{
dbItem.id = Guid.NewGuid();
owner checkUnique = context.owners.Where(x => x.id == dbItem.id).FirstOrDefault();
while (checkUnique != null)
{
dbItem.id = Guid.NewGuid();
checkUnique = context.owners.Where(x => x.id == dbItem.id).FirstOrDefault();
}
context.owners.Add(dbItem);
}
else //edit
{
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public bool alterSerssionProbertyValue(SessionValue sessionValue, string probertyValue)
{
int check = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
sessionValue.SessionValue1 = probertyValue;
ctx.Entry(sessionValue).State = System.Data.Entity.EntityState.Modified;
check = ctx.SaveChanges();
}
return(check > 0 ? true : false);
}
public Guid Save(rent dbItem)
{
if (dbItem.id == Guid.Empty) //create
{
dbItem.id = Guid.NewGuid();
context.rents.Add(dbItem);
}
else //edit
{
context.rents.Attach(dbItem);
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
//field yang tidak ditentukan oleh user
//entry.Property(e => e.is_delete).IsModified = false;
}
context.SaveChanges();
return(dbItem.id);
}
public Guid Save(api_rent dbItem)
{
//kamus
api_rent checkUnique;
log_api_rent log;
//algoritma
if (dbItem.id == Guid.Empty) //create
{
dbItem.id = Guid.NewGuid();
checkUnique = FindByPk(dbItem.id);
while (checkUnique != null)
{
dbItem.id = Guid.NewGuid();
checkUnique = FindByPk(dbItem.id);
}
context.api_rent.Add(dbItem);
}
else //edit
{
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
}
//save log_api_rent
log = new log_api_rent
{
id = Guid.NewGuid(),
id_api_rent = dbItem.id,
created_time = DateTimeOffset.Now
};
if (dbItem.cancellation_status != null)
{
log.status = dbItem.cancellation_status;
}
else
{
log.status = dbItem.status;
}
context.log_api_rent.Add(log);
context.SaveChanges();
return(dbItem.id);
}
public bool withdrawMatrailFromWarehouse(int matrailID, int?storgeID, int quantity)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Warehouse warehouse = ctx.Warehouses.Where(x => x.StorageID == storgeID && x.ItemID == matrailID).FirstOrDefault();
if (warehouse == null)
{
return(false);
}
warehouse.Available -= quantity;
ctx.Entry(warehouse).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public bool updateCustomMaterial(CustomMaterialViewModel customMaterialViewModel)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
CustomMaterial customMatrailEntity = ctx.CustomMaterials.Find(customMaterialViewModel.CustomMaterialID);
customMatrailEntity.ReciveDate = customMaterialViewModel.ReciveDate;
customMatrailEntity.Name = customMaterialViewModel.Name;
customMatrailEntity.Description = customMaterialViewModel.Description;
customMatrailEntity.Cost = customMaterialViewModel.Cost;
customMatrailEntity.Payed = customMaterialViewModel.payed == 1 ? true : false;
ctx.Entry(customMatrailEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public bool updatePatientStatus(AppointmentStatusViewModel appointmentStatusViewModel)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Appointment appointmentEntity = ctx.Appointments.Find(appointmentStatusViewModel.id);
if (appointmentEntity == null)
{
return(false);
}
appointmentEntity.Status = appointmentStatusViewModel.Status;
ctx.Entry(appointmentEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public bool updatePrescription(PrescriptionViewModel prescription)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Prescription prescriptionEntity = ctx.Prescriptions.Find(prescription.PrescriptionID);
if (prescriptionEntity == null)
{
return(false);
}
prescriptionEntity.Notice = prescription.Notice;
prescriptionEntity.Dose = prescription.Dose;
ctx.Entry(prescriptionEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public bool updatePatinetHistory(PatientHistoryViewModel patientHistory)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
PatientHistory patientHistoryEntity = ctx.PatientHistories.Find(patientHistory.HistoryID);
if (patientHistoryEntity == null)
{
return(false);
}
patientHistoryEntity.Name = patientHistory.Name;
patientHistoryEntity.Descripation = patientHistory.Descripation;
ctx.Entry(patientHistoryEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public long Save(log dbItem)
{
if (dbItem.id == 0) //create
{
context.logs.Add(dbItem);
}
else //edit
{
context.logs.Attach(dbItem);
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
//field yang tidak ditentukan oleh user
//entry.Property(e => e.is_delete).IsModified = false;
}
context.SaveChanges();
return(dbItem.id);
}
public bool updatePatinetImage(ImagesViewModel patientImagesViewModel)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
Image patientImageEntity = ctx.Images.Find(patientImagesViewModel.ImageID);
if (patientImageEntity == null)
{
return(false);
}
patientImageEntity.Name = patientImagesViewModel.Name;
patientImageEntity.Notice = patientImagesViewModel.Notice;
patientImageEntity.ImageCategoryID = patientImagesViewModel.ImageCategoryID;
ctx.Entry(patientImageEntity).State = System.Data.Entity.EntityState.Modified;
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
public void Save(d_notification dbItem)
{
if (dbItem.id == 0) //create
{
//penanggulangan data null
if (context.d_notification.Count() > 0)
{
dbItem.id = context.d_notification.Max(n => n.id) + 1;
}
else
{
dbItem.id = 1;
}
context.d_notification.Add(dbItem);
}
else //edit
{
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void Update(T obj)
{
_aTable.Attach(obj);
_db.Entry(obj).State = EntityState.Modified;
}
public ResponseModel ProcessUnprocessedData(List <UnprocessedData> unprocessedData, int costCenterId)
{
using (var transaction = _db.Database.BeginTransaction())
{
try
{
string debtAccountCode = null;
string creditAccountCode = null;
if (costCenterId == 1)
{
foreach (var data in unprocessedData)
{
debtAccountCode = _db.A_CostCenter.SingleOrDefault(x => x.A_CostCenterId == costCenterId && x.Particular == data.Particular).DebitAccount.ToString();
creditAccountCode = _db.A_CostCenter.SingleOrDefault(x => x.A_CostCenterId == costCenterId && x.Particular == data.Particular).CreditAccount.ToString();
if (String.IsNullOrWhiteSpace(debtAccountCode) || String.IsNullOrWhiteSpace(creditAccountCode))
{
return(_aModel.Respons(false, "Debit or credit account in Cost Center Not Found"));
}
else
{
if (data.A_GLTransactionId > 0)
{
Int32 A_GlAccountId = 0;
A_GlAccountId = _db.A_GlAccount.SingleOrDefault(x => x.Code == debtAccountCode).A_GlAccountId;
A_GlTransactionDetails aGlTransactionDetailsDebit = _db.A_GlTransactionDetails.SingleOrDefault(i => i.A_GlTransactionId == data.A_GLTransactionId && i.A_GlAccountId == A_GlAccountId);
aGlTransactionDetailsDebit.DebitAmount = data.Amount;
_db.A_GlTransactionDetails.Attach(aGlTransactionDetailsDebit);
_db.Entry(aGlTransactionDetailsDebit).State = EntityState.Modified;
_db.SaveChanges();
A_GlAccountId = _db.A_GlAccount.SingleOrDefault(x => x.Code == creditAccountCode).A_GlAccountId;
A_GlTransactionDetails aGlTransactionDetailsCredit = _db.A_GlTransactionDetails.SingleOrDefault(i => i.A_GlTransactionId == data.A_GLTransactionId && i.A_GlAccountId == A_GlAccountId);
aGlTransactionDetailsCredit.CreditAmount = data.Amount;
_db.A_GlTransactionDetails.Attach(aGlTransactionDetailsCredit);
_db.Entry(aGlTransactionDetailsCredit).State = EntityState.Modified;
_db.SaveChanges();
SupplierInvestment aInvestment = _db.SupplierInvestments.SingleOrDefault(x => x.SupplierInvestmentId == data.Id);
if (aInvestment != null)
{
aInvestment.ProcessStatus = 2;
aInvestment.A_GlTransactionId = data.A_GLTransactionId;
_db.SupplierInvestments.Attach(aInvestment);
_db.Entry(aInvestment).State = EntityState.Modified;
_db.SaveChanges();
}
}
else
{
A_GlTransaction aGlTransaction = new A_GlTransaction()
{
TransactionDate = DateTime.Now,
EntryMethod = 2,
Description = data.Particular,
A_CostCenterId = costCenterId
};
_db.A_GlTransaction.Add(aGlTransaction);
_db.SaveChanges();
A_GlTransactionDetails aGlTransactionDetailsforDebt = new A_GlTransactionDetails()
{
A_GlAccountId = _db.A_GlAccount.SingleOrDefault(x => x.Code == debtAccountCode).A_GlAccountId,
A_GlTransactionId = aGlTransaction.A_GlTransactionId,
DebitAmount = data.Amount,
CreditAmount = 0,
TransactionDate = DateTime.Now,
Particular = data.Particular
};
_db.A_GlTransactionDetails.Add(aGlTransactionDetailsforDebt);
_db.SaveChanges();
A_GlTransactionDetails aGlTransactionDetailsforCredit = new A_GlTransactionDetails()
{
A_GlAccountId = _db.A_GlAccount.SingleOrDefault(x => x.Code == creditAccountCode).A_GlAccountId,
A_GlTransactionId = aGlTransaction.A_GlTransactionId,
DebitAmount = 0,
CreditAmount = data.Amount,
TransactionDate = DateTime.Now,
Particular = data.Particular
};
_db.A_GlTransactionDetails.Add(aGlTransactionDetailsforCredit);
_db.SaveChanges();
SupplierInvestment aInvestment = _db.SupplierInvestments.SingleOrDefault(x => x.SupplierInvestmentId == data.Id);
if (aInvestment != null)
{
aInvestment.ProcessStatus = 2;
aInvestment.A_GlTransactionId = aGlTransaction.A_GlTransactionId;
_db.SupplierInvestments.Attach(aInvestment);
_db.Entry(aInvestment).State = EntityState.Modified;
_db.SaveChanges();
}
}
}
}
}
transaction.Commit();
return(_aModel.Respons(true, "Data processing done successfully"));
}
catch (Exception ex)
{
transaction.Rollback();
return(_aModel.Respons(false, "Sorry ! Some error occured"));
}
}
}