public BDPhysicianSalary PhysicianSalarySaveChange(BDPhysicianSalary _bDPhysicianSalary) { try { // BDPhysicianSalary operation add & edit var dbPhysicianSalary = _contextDatabase.BDPhysicianSalaries.SingleOrDefault(s => s.PhysicianPriceID == _bDPhysicianSalary.PhysicianPriceID); if (dbPhysicianSalary != null) { // Update BDPhysicianSalary _contextDatabase.Entry(dbPhysicianSalary).CurrentValues.SetValues(_bDPhysicianSalary); _contextDatabase.BDPhysicianSalaries.Attach(dbPhysicianSalary); _contextDatabase.SaveChanges(); return(dbPhysicianSalary); } else { // Insert BDPhysicianSalary into the database _contextDatabase.BDPhysicianSalaries.Add(_bDPhysicianSalary); _contextDatabase.SaveChanges(); return(_bDPhysicianSalary); } } catch (Exception ex) { throw; } return(null); }
/// <summary> /// ma object to control in UI form /// </summary> /// <param name="newObj"></param> private void ObjectToUI(BDPhysicianSalary newObj) { txtId.Text = newObj.PhysicianPriceID.ToString(); dateTimePicker1.Value = newObj.FromDate; dateTimePicker2.Value = newObj.ToDate; numericUpDown2.Value = newObj.PhysicianSalary; cbx_PhysicianName.SelectedValue = newObj.PhysicianID; }
/// <summary> /// Get data from UI to create new Object /// </summary> /// <returns></returns> private BDPhysicianSalary ObjectFromUI() { BDPhysicianSalary newObj = new BDPhysicianSalary(); newObj.PhysicianPriceID = int.Parse(txtId.Text); newObj.FromDate = dateTimePicker1.Value; newObj.ToDate = dateTimePicker2.Value; newObj.PhysicianSalary = numericUpDown2.Value; newObj.PhysicianID = int.Parse(cbx_PhysicianName.SelectedValue.ToString()); return(newObj); }
public bool ValidatePhysicianSalary(BDPhysicianSalary _bDPhysicianSalary) { try { var query = _contextDatabase.BDPhysicianSalaries.AsQueryable(); if (_bDPhysicianSalary.PhysicianPriceID != null && _bDPhysicianSalary.PhysicianPriceID > 0) { query = query.Where(a => a.PhysicianPriceID != _bDPhysicianSalary.PhysicianPriceID).AsQueryable(); } query = query.Where(a => a.PhysicianID == _bDPhysicianSalary.PhysicianID).AsQueryable(); query = query.Where(a => (a.FromDate >= _bDPhysicianSalary.ToDate && a.ToDate <= _bDPhysicianSalary.ToDate) || (a.FromDate <= _bDPhysicianSalary.FromDate && a.ToDate >= _bDPhysicianSalary.FromDate)).AsQueryable(); return(!query.Any()); } catch (Exception ex) { throw; } return(false); }