public void EditDoctor()
{
try
{
ClinicUser clinicUser = new ClinicUser();
clinicUser.ClinicUserId = selectedDoctor.ClinicUserId;
clinicUser.FullName = selectedDoctor.FullName;
clinicUser.DateOfBirth = selectedDoctor.DateOfBirth;
clinicUser.IDNumber = selectedDoctor.IDNumber;
clinicUser.GenderId = selectedDoctor.GenderId;
clinicUser.Citizenship = selectedDoctor.Citizenship;
clinicUser.Username = selectedDoctor.Username;
clinicUser.Password = selectedDoctor.Password;
ClinicDoctor clinicDoctor = new ClinicDoctor();
clinicDoctor.ClinicDoctorId = selectedDoctor.ClinicDoctorId;
clinicDoctor.ClinicUserId = selectedDoctor.ClinicUserId;
clinicDoctor.UniqueNumber = selectedDoctor.UniqueNumber;
clinicDoctor.BancAccount = selectedDoctor.BancAccount;
clinicDoctor.DepartmentId = selectedDoctor.DepartmentId;
clinicDoctor.WorkShiftId = selectedDoctor.WorkShiftId;
clinicDoctor.InChargeOfAdmission = selectedDoctor.InChargeOfAdmission;
clinicDoctor.ClinicManagerId = selectedDoctor.ClinicManagerId;
AddDoctorView addDoctorView = new AddDoctorView(User, clinicUser, clinicDoctor, true);
addDoctorView.Show();
doctorView.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void WhenAddDoctor_ThenAddsDoctorToClinic()
{
var doctor = new ClinicDoctor("adoctorid", "afirstname", "alastname");
var entity = new ClinicEntity(this.logger.Object, this.idFactory.Object);
entity.RegisterDoctor(doctor);
this.personService.Setup(ps => ps.Create(It.IsAny <string>(), It.IsAny <string>()))
.Returns(new Person
{
Id = "apersonid", Name = new PersonName {
FirstName = "afirstname", LastName = "alastname"
}
});
this.storage.Setup(s => s.Load(It.Is <Identifier>(i => i == "aclinicid")))
.Returns(entity);
this.storage.Setup(s => s.Save(It.Is <ClinicEntity>(e => e.Unavailabilities.Count == 1)))
.Returns(entity);
var result =
this.clinicsApplication.RegisterDoctor(this.caller.Object, "aclinicid", "afirstname", "alastname");
result.Should().NotBeNull();
this.personService.Verify(ps => ps.Create("afirstname", "alastname"));
}
public void WhenAddDoctor_ThenDoctorAdded()
{
var doctor = new ClinicDoctor("adoctorid", "afirstname", "alastname");
this.entity.RegisterDoctor(doctor);
this.entity.Doctors.Doctors.Single().Should().Be("adoctorid".ToIdentifier());
this.entity.Events[1].Should().BeOfType <Events.Clinic.DoctorRegisteredToClinic>();
}
public static Doctor ToDoctor(this ClinicDoctor doctor)
{
var dto = doctor.ConvertTo <Doctor>();
dto.Name = new PersonName
{
FirstName = doctor.FirstName,
LastName = doctor.LastName
};
return(dto);
}
public AddDoctorViewModel(ClinicUser userAdmin, ClinicUser user, ClinicDoctor clinicDoctor, AddDoctorView addDoctorViewOpen, bool isForEdit)
{
this.userAdmin = userAdmin;
this.userDoctor = clinicDoctor;
this.user = user;
this.isForEdit = isForEdit;
addDoctorView = addDoctorViewOpen;
GenderList = new ObservableCollection <Gender>(service.GetAllGender());
SelectedGender = GenderList.FirstOrDefault(p => p.GenderId == user.GenderId);
DepartmentList = new ObservableCollection <Department>(service.GetAllDepartment());
SelectedDepartment = DepartmentList.FirstOrDefault(p => p.DepartmentId == userDoctor.DepartmentId);
WorkShiftList = new ObservableCollection <Workshift>(service.GetAllWorkshift());
SelectedWorkShift = WorkShiftList.FirstOrDefault(p => p.WorkShiftId == userDoctor.WorkShiftId);
ManagerList = new ObservableCollection <vwManager>(service.GetAllManager());
SelectedManager = ManagerList.FirstOrDefault(p => p.ClinicManagerId == userDoctor.ClinicManagerId);
}
public int AddNewDoctor(ClinicDoctor user)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
if (user.ClinicDoctorId == 0)
{
ClinicDoctor newClinicUser = new ClinicDoctor();
newClinicUser.ClinicUserId = user.ClinicUserId;
newClinicUser.UniqueNumber = user.UniqueNumber;
newClinicUser.BancAccount = user.BancAccount;
newClinicUser.DepartmentId = user.DepartmentId;
newClinicUser.WorkShiftId = user.WorkShiftId;
newClinicUser.InChargeOfAdmission = user.InChargeOfAdmission;
newClinicUser.ClinicManagerId = user.ClinicManagerId;
context.ClinicDoctors.Add(newClinicUser);
context.SaveChanges();
user.ClinicDoctorId = newClinicUser.ClinicDoctorId;
return(user.ClinicDoctorId);
}
else
{
ClinicDoctor editClinicUser = (from p in context.ClinicDoctors where p.ClinicDoctorId == user.ClinicDoctorId select p).First();
editClinicUser.ClinicUserId = user.ClinicUserId;
editClinicUser.UniqueNumber = user.UniqueNumber;
editClinicUser.BancAccount = user.BancAccount;
editClinicUser.DepartmentId = user.DepartmentId;
editClinicUser.WorkShiftId = user.WorkShiftId;
editClinicUser.InChargeOfAdmission = user.InChargeOfAdmission;
editClinicUser.ClinicManagerId = user.ClinicManagerId;
editClinicUser.ClinicDoctorId = user.ClinicDoctorId;
context.SaveChanges();
Logging.LoggAction("AddDoctorViewModel", "Info", "Succesfull edited doctor");
return(user.ClinicDoctorId);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
Logging.LoggAction("AddDoctorViweModel", "Error", ex.ToString());
return(0);
}
}
public bool CheckBancAccount(long bancAccount)
{
try
{
using (MedicaClinicEntities2 context = new MedicaClinicEntities2())
{
ClinicDoctor clinicUser = (from d in context.ClinicDoctors where d.BancAccount == bancAccount select d).FirstOrDefault();
if (clinicUser != null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="T:DoctorRosterItem"/> class.
/// </summary>
public DoctorRosterItem(ClinicDoctor.Entities.DoctorRoster entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:CustomerItem"/> class.
/// </summary>
public CustomerItem(ClinicDoctor.Entities.Customer entity)
: base()
{
_entity = entity;
}
/// <summary>
/// 初始化所有的属性，包括引用类型的属性自己的属性
/// </summary>
public override void ReInitializeAllProperties()
{
try
{
if (AdmitInfo != null)
{
AdmitInfo.ReInitializeAllProperties();
}
if (DischargeInfo != null)
{
DischargeInfo.ReInitializeAllProperties();
}
if (AdmissionKind != null)
{
AdmissionKind.ReInitializeAllProperties();
}
if (AdmitStatus != null)
{
AdmitStatus.ReInitializeAllProperties();
}
if (DischargeStatus != null)
{
DischargeStatus.ReInitializeAllProperties();
}
if (DiagnosisOfClinic != null)
{
DiagnosisOfClinic.ReInitializeAllProperties();
}
if (ClinicDoctor != null)
{
ClinicDoctor.ReInitializeAllProperties();
}
if (ChineseDiagnosisOfClinic != null)
{
ChineseDiagnosisOfClinic.ReInitializeAllProperties();
}
if (ChineseDiagnosisOfClinic2 != null)
{
ChineseDiagnosisOfClinic2.ReInitializeAllProperties();
}
if (Resident != null)
{
Resident.ReInitializeAllProperties();
}
if (AttendingPhysician != null)
{
AttendingPhysician.ReInitializeAllProperties();
}
if (Director != null)
{
Director.ReInitializeAllProperties();
}
if (CareLevel != null)
{
CareLevel.ReInitializeAllProperties();
}
}
catch (Exception)
{
}
}
/// <summary>
/// Initializes a new instance of the <see cref="T:DoctorFuncItem"/> class.
/// </summary>
public DoctorFuncItem(ClinicDoctor.Entities.DoctorFunc entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Update an existing row in the datasource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.Staff object to update.</param>
/// <remarks>
/// After updating the datasource, the ClinicDoctor.Entities.Staff object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Update(TransactionManager transactionManager, ClinicDoctor.Entities.Staff entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Staff_Update", _useStoredProcedure);
database.AddInParameter(commandWrapper, "@Id", DbType.Int64, entity.Id );
database.AddInParameter(commandWrapper, "@OriginalId", DbType.Int64, entity.OriginalId);
database.AddInParameter(commandWrapper, "@FirstName", DbType.String, entity.FirstName );
database.AddInParameter(commandWrapper, "@LastName", DbType.String, entity.LastName );
database.AddInParameter(commandWrapper, "@ShortName", DbType.String, entity.ShortName );
database.AddInParameter(commandWrapper, "@UserName", DbType.String, entity.UserName );
database.AddInParameter(commandWrapper, "@Email", DbType.String, entity.Email );
database.AddInParameter(commandWrapper, "@Address", DbType.String, entity.Address );
database.AddInParameter(commandWrapper, "@HomePhone", DbType.String, entity.HomePhone );
database.AddInParameter(commandWrapper, "@WorkPhone", DbType.String, entity.WorkPhone );
database.AddInParameter(commandWrapper, "@CellPhone", DbType.String, entity.CellPhone );
database.AddInParameter(commandWrapper, "@Birthdate", DbType.DateTime, (entity.Birthdate.HasValue ? (object) entity.Birthdate : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@IsFemale", DbType.Boolean, entity.IsFemale );
database.AddInParameter(commandWrapper, "@Title", DbType.String, entity.Title );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@Roles", DbType.String, entity.Roles );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Update", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
//Stop Tracking Now that it has been updated and persisted.
if (DataRepository.Provider.EnableEntityTracking)
EntityManager.StopTracking(entity.EntityTrackingKey);
entity.OriginalId = entity.Id;
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Update", entity));
return Convert.ToBoolean(results);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:ContentItem"/> class.
/// </summary>
public ContentItem(ClinicDoctor.Entities.Content entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:GroupItem"/> class.
/// </summary>
public GroupItem(ClinicDoctor.Entities.Group entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:RoomItem"/> class.
/// </summary>
public RoomItem(ClinicDoctor.Entities.Room entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Inserts a ClinicDoctor.Entities.RosterType object into the datasource using a transaction.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.RosterType object to insert.</param>
/// <remarks>
/// After inserting into the datasource, the ClinicDoctor.Entities.RosterType object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Insert(TransactionManager transactionManager, ClinicDoctor.Entities.RosterType entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.RosterType_Insert", _useStoredProcedure);
database.AddOutParameter(commandWrapper, "@Id", DbType.Int64, 8);
database.AddInParameter(commandWrapper, "@Title", DbType.String, entity.Title );
database.AddInParameter(commandWrapper, "@IsBooked", DbType.Boolean, entity.IsBooked );
database.AddInParameter(commandWrapper, "@ColorCode", DbType.String, entity.ColorCode );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Insert", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
object _id = database.GetParameterValue(commandWrapper, "@Id");
entity.Id = (System.Int64)_id;
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Insert", entity));
return Convert.ToBoolean(results);
}
/// <summary>
/// Inserts a ClinicDoctor.Entities.DoctorRoster object into the datasource using a transaction.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.DoctorRoster object to insert.</param>
/// <remarks>
/// After inserting into the datasource, the ClinicDoctor.Entities.DoctorRoster object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Insert(TransactionManager transactionManager, ClinicDoctor.Entities.DoctorRoster entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.DoctorRoster_Insert", _useStoredProcedure);
database.AddInParameter(commandWrapper, "@Id", DbType.String, entity.Id );
database.AddInParameter(commandWrapper, "@DoctorUserName", DbType.String, entity.DoctorUserName );
database.AddInParameter(commandWrapper, "@DoctorShortName", DbType.String, entity.DoctorShortName );
database.AddInParameter(commandWrapper, "@DoctorEmail", DbType.String, entity.DoctorEmail );
database.AddInParameter(commandWrapper, "@RosterTypeId", DbType.Int64, entity.RosterTypeId );
database.AddInParameter(commandWrapper, "@RosterTypeTitle", DbType.String, entity.RosterTypeTitle );
database.AddInParameter(commandWrapper, "@ColorCode", DbType.String, entity.ColorCode );
database.AddInParameter(commandWrapper, "@IsBooked", DbType.Boolean, (entity.IsBooked.HasValue ? (object) entity.IsBooked : System.DBNull.Value));
database.AddInParameter(commandWrapper, "@StartTime", DbType.DateTime, entity.StartTime );
database.AddInParameter(commandWrapper, "@EndTime", DbType.DateTime, entity.EndTime );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@IsComplete", DbType.Boolean, entity.IsComplete );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Insert", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
entity.OriginalId = entity.Id;
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Insert", entity));
return Convert.ToBoolean(results);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:AppointmentItem"/> class.
/// </summary>
public AppointmentItem(ClinicDoctor.Entities.Appointment entity)
: base()
{
_entity = entity;
}
public AddDoctorView(ClinicUser adminUser, ClinicUser user, ClinicDoctor doctor, bool isForEdit)
{
InitializeComponent();
this.DataContext = new AddDoctorViewModel(adminUser, user, doctor, this, isForEdit);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:StaffItem"/> class.
/// </summary>
public StaffItem(ClinicDoctor.Entities.Staff entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:RosterTypeItem"/> class.
/// </summary>
public RosterTypeItem(ClinicDoctor.Entities.RosterType entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:FloorItem"/> class.
/// </summary>
public FloorItem(ClinicDoctor.Entities.Floor entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Update an existing row in the datasource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.Appointment object to update.</param>
/// <remarks>
/// After updating the datasource, the ClinicDoctor.Entities.Appointment object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Update(TransactionManager transactionManager, ClinicDoctor.Entities.Appointment entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Appointment_Update", _useStoredProcedure);
database.AddInParameter(commandWrapper, "@Id", DbType.String, entity.Id );
database.AddInParameter(commandWrapper, "@OriginalId", DbType.String, entity.OriginalId);
database.AddInParameter(commandWrapper, "@CustomerId", DbType.String, entity.CustomerId );
database.AddInParameter(commandWrapper, "@CustomerName", DbType.String, entity.CustomerName );
database.AddInParameter(commandWrapper, "@ContentId", DbType.Int64, (entity.ContentId.HasValue ? (object) entity.ContentId : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@ContentTitle", DbType.String, entity.ContentTitle );
database.AddInParameter(commandWrapper, "@DoctorUsername", DbType.String, entity.DoctorUsername );
database.AddInParameter(commandWrapper, "@DoctorShortName", DbType.String, entity.DoctorShortName );
database.AddInParameter(commandWrapper, "@DoctorEmail", DbType.String, entity.DoctorEmail );
database.AddInParameter(commandWrapper, "@RoomId", DbType.Int64, (entity.RoomId.HasValue ? (object) entity.RoomId : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@RoomTitle", DbType.String, entity.RoomTitle );
database.AddInParameter(commandWrapper, "@NurseUsername", DbType.String, entity.NurseUsername );
database.AddInParameter(commandWrapper, "@NurseShortName", DbType.String, entity.NurseShortName );
database.AddInParameter(commandWrapper, "@StatusId", DbType.Int64, (entity.StatusId.HasValue ? (object) entity.StatusId : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@StatusTitle", DbType.String, entity.StatusTitle );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@StartTime", DbType.DateTime, (entity.StartTime.HasValue ? (object) entity.StartTime : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@EndTime", DbType.DateTime, (entity.EndTime.HasValue ? (object) entity.EndTime : System.DBNull.Value) );
database.AddInParameter(commandWrapper, "@ColorCode", DbType.String, entity.ColorCode );
database.AddInParameter(commandWrapper, "@IsComplete", DbType.Boolean, entity.IsComplete );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Update", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
//Stop Tracking Now that it has been updated and persisted.
if (DataRepository.Provider.EnableEntityTracking)
EntityManager.StopTracking(entity.EntityTrackingKey);
entity.OriginalId = entity.Id;
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Update", entity));
return Convert.ToBoolean(results);
}
/// <summary>
/// Initializes a new instance of the <see cref="T:FunctionalityItem"/> class.
/// </summary>
public FunctionalityItem(ClinicDoctor.Entities.Functionality entity)
: base()
{
_entity = entity;
}
/// <summary>
/// Update an existing row in the datasource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.RosterType object to update.</param>
/// <remarks>
/// After updating the datasource, the ClinicDoctor.Entities.RosterType object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Update(TransactionManager transactionManager, ClinicDoctor.Entities.RosterType entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.RosterType_Update", _useStoredProcedure);
database.AddInParameter(commandWrapper, "@Id", DbType.Int64, entity.Id );
database.AddInParameter(commandWrapper, "@Title", DbType.String, entity.Title );
database.AddInParameter(commandWrapper, "@IsBooked", DbType.Boolean, entity.IsBooked );
database.AddInParameter(commandWrapper, "@ColorCode", DbType.String, entity.ColorCode );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Update", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
//Stop Tracking Now that it has been updated and persisted.
if (DataRepository.Provider.EnableEntityTracking)
EntityManager.StopTracking(entity.EntityTrackingKey);
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Update", entity));
return Convert.ToBoolean(results);
}
/// <summary>
/// Inserts a ClinicDoctor.Entities.Customer object into the datasource using a transaction.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">ClinicDoctor.Entities.Customer object to insert.</param>
/// <remarks>
/// After inserting into the datasource, the ClinicDoctor.Entities.Customer object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
/// <returns>Returns true if operation is successful.</returns>
/// <exception cref="System.Exception">The command could not be executed.</exception>
/// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
/// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
public override bool Insert(TransactionManager transactionManager, ClinicDoctor.Entities.Customer entity)
{
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Customer_Insert", _useStoredProcedure);
database.AddInParameter(commandWrapper, "@Id", DbType.String, entity.Id );
database.AddInParameter(commandWrapper, "@FirstName", DbType.String, entity.FirstName );
database.AddInParameter(commandWrapper, "@LastName", DbType.String, entity.LastName );
database.AddInParameter(commandWrapper, "@Address", DbType.String, entity.Address );
database.AddInParameter(commandWrapper, "@HomePhone", DbType.String, entity.HomePhone );
database.AddInParameter(commandWrapper, "@WorkPhone", DbType.String, entity.WorkPhone );
database.AddInParameter(commandWrapper, "@CellPhone", DbType.String, entity.CellPhone );
database.AddInParameter(commandWrapper, "@Birthdate", DbType.DateTime, (entity.Birthdate.HasValue ? (object) entity.Birthdate : System.DBNull.Value));
database.AddInParameter(commandWrapper, "@IsFemale", DbType.Boolean, entity.IsFemale );
database.AddInParameter(commandWrapper, "@Title", DbType.String, entity.Title );
database.AddInParameter(commandWrapper, "@Note", DbType.String, entity.Note );
database.AddInParameter(commandWrapper, "@IsDisabled", DbType.Boolean, entity.IsDisabled );
database.AddInParameter(commandWrapper, "@CreateUser", DbType.String, entity.CreateUser );
database.AddInParameter(commandWrapper, "@CreateDate", DbType.DateTime, entity.CreateDate );
database.AddInParameter(commandWrapper, "@UpdateUser", DbType.String, entity.UpdateUser );
database.AddInParameter(commandWrapper, "@UpdateDate", DbType.DateTime, entity.UpdateDate );
int results = 0;
//Provider Data Requesting Command Event
OnDataRequesting(new CommandEventArgs(commandWrapper, "Insert", entity));
if (transactionManager != null)
{
results = Utility.ExecuteNonQuery(transactionManager, commandWrapper);
}
else
{
results = Utility.ExecuteNonQuery(database,commandWrapper);
}
entity.OriginalId = entity.Id;
entity.AcceptChanges();
//Provider Data Requested Command Event
OnDataRequested(new CommandEventArgs(commandWrapper, "Insert", entity));
return Convert.ToBoolean(results);
}
