public Core.GeneralDatabaseResponse Save(Core.Medicine data) { using (OMSDataContext omsDataContext = new OMSDataContext()) { if (data.MedicineId == 0)//Add Mode { try { var medicines = new Medicine(); medicines.CompanyName = data.CompanyName; medicines.GenericName = data.GenericName; medicines.IsDeleted = data.IsDeleted; medicines.IsPrescriptionRequired = data.IsPrescriptionRequired; medicines.MedicineName = data.MedicineName; medicines.ToBeDisplayedInFrontEnd = data.ToBeDisplayedInFrontEnd; medicines.CreatedAt = DateTime.Now; medicines.CreatedBy = data.CreatedBy; omsDataContext.Medicines.InsertOnSubmit(medicines); omsDataContext.SubmitChanges(); return GeneralDatabaseResponse.SuccessfullInsert; } catch (Exception) { return GeneralDatabaseResponse.UnsuccessfullInsert; } } else //Edit Mode { try { var medicine = (from med in omsDataContext.Medicines where med.Id == data.MedicineId select med).FirstOrDefault(); medicine.CompanyName = data.CompanyName; medicine.GenericName = data.GenericName; medicine.IsDeleted = data.IsDeleted; medicine.IsPrescriptionRequired = data.IsPrescriptionRequired; medicine.MedicineName = data.MedicineName; medicine.ToBeDisplayedInFrontEnd = data.ToBeDisplayedInFrontEnd; medicine.UpdatedAt = DateTime.Now; medicine.UpdatedBy = data.UpdatedBy; omsDataContext.SubmitChanges(); return GeneralDatabaseResponse.SuccessfullUpdate; } catch (Exception) { return GeneralDatabaseResponse.UnsuccessfullUpdate; } } } }
public Guid GetUserId(string userName) { using (OMSDataContext onlineMedicalStoreDataAccess = new OMSDataContext()) { try { var userId = (from membership in onlineMedicalStoreDataAccess.aspnet_Memberships join user in onlineMedicalStoreDataAccess.aspnet_Users on membership.UserId equals user.UserId where user.UserName == userName select membership).FirstOrDefault().UserId; return userId; } catch (Exception) { return new Guid(); } } }
public GeneralDatabaseResponse DeleteMedicine(int id) { using (OMSDataContext omsDataContext = new OMSDataContext()) { try { var medicine = (from med in omsDataContext.Medicines where med.Id == id select med).FirstOrDefault(); medicine.IsDeleted = true; omsDataContext.SubmitChanges(); return GeneralDatabaseResponse.SuccessfullUpdate; } catch (Exception) { return GeneralDatabaseResponse.UnsuccessfullUpdate; } } }
public GeneralDatabaseResponse UnlockUser(string userName) { using (OMSDataContext onlineMedicalStoreDataAccess = new OMSDataContext()) { try { var userToUnlock = (from membership in onlineMedicalStoreDataAccess.aspnet_Memberships join user in onlineMedicalStoreDataAccess.aspnet_Users on membership.UserId equals user.UserId where user.UserName == userName select membership).FirstOrDefault(); if (userToUnlock != null) { userToUnlock.IsLockedOut = false; } onlineMedicalStoreDataAccess.SubmitChanges(); return GeneralDatabaseResponse.SuccessfullUpdate; } catch (Exception) { return GeneralDatabaseResponse.UnsuccessfullUpdate; } } }
public List<Core.Medicine> GetAllMedicines() { using (OMSDataContext omsDataContext = new OMSDataContext()) { List<Core.Medicine> medicinesList = (from medicines in omsDataContext.Medicines where medicines.IsDeleted == false select new Core.Medicine { MedicineId = medicines.Id, CompanyName = medicines.CompanyName, CreatedAt = medicines.CreatedAt, CreatedBy = medicines.CreatedBy, GenericName = medicines.GenericName, IsDeleted = medicines.IsDeleted, IsPrescriptionRequired = medicines.IsPrescriptionRequired, MedicineName = medicines.MedicineName, ToBeDisplayedInFrontEnd = medicines.ToBeDisplayedInFrontEnd, }).ToList(); return medicinesList; } }