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 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;
}
}
}
