public void EditDataBlood(string bloodSerial, string bloodGroup, string section, ShafaCommon.Types.ShafaDateType editDate, out string message) { message = string.Empty; DAL.Model.DatabaseContext databaseContext = null; try { databaseContext = new DAL.Model.DatabaseContext(); #region Validation if (string.IsNullOrWhiteSpace(bloodSerial)) { message = BloodBusinessLogicalLayer.Properties.Resources.validationBloodSerial; } if (string.IsNullOrWhiteSpace(message) == false) { ShafaCommon.Common.MessageManager.ShowMessageBox (message); return; } #endregion /Validation DAL.Model.Blood blood = databaseContext.Bloods .Where(current => string.Compare(current.BloodSerial, bloodSerial) == 0) .FirstOrDefault(); if (blood == null) { ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringNotFoundBlood); return; } else { blood.BloodSerial = bloodSerial; blood.BloodGorup = bloodGroup; blood.Section = section; blood.EditDate = editDate.ToString(); } databaseContext.SaveChanges(); ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringEditBlood); } catch (Exception ex) { ShafaCommon.Common.ExceptionManager.ManageException(ex); } }
public void DeletDataBlood(string bloodSerial, out string message) { message = string.Empty; DAL.Model.DatabaseContext databaseContext = null; try { databaseContext = new DAL.Model.DatabaseContext(); #region Validation if (string.IsNullOrWhiteSpace(bloodSerial)) { message = BloodBusinessLogicalLayer.Properties.Resources.validationBloodSerial; } if (string.IsNullOrWhiteSpace(message) == false) { ShafaCommon.Common.MessageManager.ShowMessageBox (message); return; } #endregion /Validation DAL.Model.Blood blood = databaseContext.Bloods .Where(current => string.Compare(current.BloodSerial, bloodSerial) == 0) .FirstOrDefault(); if (blood == null) { ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringNotFoundBlood); return; } else { databaseContext.Bloods.Remove(blood); databaseContext.SaveChanges(); } ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringFoundBlood); } catch (Exception ex) { ShafaCommon.Common.ExceptionManager.ManageException(ex); } }
public System.Collections.Generic.List <ViewModel.BloodViewModel> GetSingleBlood(string bloodSerial) { DAL.Model.DatabaseContext databaseContext = null; databaseContext = new DAL.Model.DatabaseContext(); return(databaseContext.Bloods.Where(current => string.Compare(current.BloodSerial, bloodSerial) == 0).Select(value => new ViewModel.BloodViewModel { BloodID = value.BloodID, BloodSerial = value.BloodSerial, BloodGorup = value.BloodGorup, Section = value.Section, RegisterDate = value.RegisterDate, } ).ToList()); }
public System.Collections.Generic.List <ViewModel.BloodViewModel> GetBetweenRegisterDate(System.DateTime firstDate, System.DateTime lastDate) { DAL.Model.DatabaseContext databaseContext = null; databaseContext = new DAL.Model.DatabaseContext(); return(databaseContext.Bloods.Where(current => string.Compare(current.RegisterDate.ToString(), firstDate.ToString()) >= 0 && string.Compare(current.RegisterDate.ToString(), lastDate.ToString()) <= 0).Select(value => new ViewModel.BloodViewModel { BloodID = value.BloodID, BloodSerial = value.BloodSerial, BloodGorup = value.BloodGorup, Section = value.Section, RegisterDate = value.RegisterDate, } ).ToList()); }
public System.Collections.Generic.List <ViewModel.BloodViewModel> GetALLBloodViews() { DAL.Model.DatabaseContext databaseContext = null; databaseContext = new DAL.Model.DatabaseContext(); return(databaseContext.Bloods.Select(value => new ViewModel.BloodViewModel { BloodID = value.BloodID, BloodSerial = value.BloodSerial, BloodGorup = value.BloodGorup, Section = value.Section, RegisterDate = value.RegisterDate, EditDate = value.EditDate, } ).ToList()); }
private System.Collections.Generic.List <DAL.Model.Blood> GetSimilarSerial(string bloodSerial) { DAL.Model.DatabaseContext dataBaseContext = null; try { dataBaseContext = new DAL.Model.DatabaseContext(); System.Collections.Generic.List <DAL.Model.Blood> bloods = null; if (string.IsNullOrWhiteSpace(bloodSerial)) { return(bloods = dataBaseContext.Bloods .OrderBy(current => current.BloodSerial) .ToList()); } else { return(bloods = dataBaseContext.Bloods .Where(current => current.BloodSerial.Contains(bloodSerial)) .OrderBy(current => current.BloodSerial) .ToList()); } } catch (System.Exception ex) { throw (ShafaCommon.Common.ExceptionManagerUtility.AddInnerException(ex, BloodBusinessLogicalLayer.Properties.Resources.errGetBlood)); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
public void SaveDataBlood(string bloodSerial, string bloodGroup, string section, ShafaCommon.Types.ShafaDateType registerDate, out string message) { message = string.Empty; DAL.Model.DatabaseContext databaseContext = null; try { databaseContext = new DAL.Model.DatabaseContext(); #region Validation if (string.IsNullOrWhiteSpace(bloodSerial)) { message = BloodBusinessLogicalLayer.Properties.Resources.validationBloodSerial; } if (string.IsNullOrWhiteSpace(bloodGroup)) { if (string.IsNullOrWhiteSpace(message) == false) { message += System.Environment.NewLine; } message += BloodBusinessLogicalLayer.Properties.Resources.validationBloodGroup; return; } if (string.IsNullOrWhiteSpace(section.ToString())) { if (string.IsNullOrWhiteSpace(message) == false) { message += System.Environment.NewLine; } message += BloodBusinessLogicalLayer.Properties.Resources.validationSection; return; } if (string.IsNullOrWhiteSpace(registerDate.ToString())) { if (string.IsNullOrWhiteSpace(message) == false) { message += System.Environment.NewLine; } message += BloodBusinessLogicalLayer.Properties.Resources.validationRegisterDate; } if (string.IsNullOrWhiteSpace(message) == false) { ShafaCommon.Common.MessageManager.ShowMessageBox (message); return; } #endregion /Validation DAL.Model.Blood blood = databaseContext.Bloods .Where(current => string.Compare(current.BloodSerial, bloodSerial) == 0) .FirstOrDefault(); if (blood != null) { ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringFoundBlood); return; } else { blood = new DAL.Model.Blood { BloodSerial = bloodSerial, BloodGorup = bloodGroup, Section = section, RegisterDate = registerDate.ToString(), EditDate = string.Empty, }; } databaseContext.Bloods.Add(blood); databaseContext.SaveChanges(); ShafaCommon.Common.MessageManager.ShowMessageBox (BloodBusinessLogicalLayer.Properties.Resources.stringSaveBlood); } catch (Exception ex) { ShafaCommon.Common.ExceptionManager.ManageException(ex); } }