public void Update(Doctor item)
{
var doctorEntity = new DoctorEntity();
doctorMapper.MapToEntity(item, doctorEntity);
doctorRepository.Update(doctorEntity);
}
private bool AdditionOfParameters(DoctorEntity tempObject, string Command)
{
SqlCommand command = new SqlCommand(Command);
SqlParameter UserNameParameter = new SqlParameter("@dUserName", SqlDbType.NVarChar, 50);
UserNameParameter.Value = tempObject.doctorUserName;
SqlParameter PasswordParameter = new SqlParameter("@dPassword", SqlDbType.NVarChar, 50);
PasswordParameter.Value = tempObject.doctorPassword;
SqlParameter NameParameter = new SqlParameter("@dName", SqlDbType.NVarChar, 100);
NameParameter.Value = tempObject.doctorName;
SqlParameter DoctorSpecialityParameter = new SqlParameter("@dSpeciality", SqlDbType.NVarChar, 50);
DoctorSpecialityParameter.Value = tempObject.doctorSpeciality;
//Adding parameters
command.Parameters.Add(UserNameParameter);
command.Parameters.Add(PasswordParameter);
command.Parameters.Add(NameParameter);
command.Parameters.Add(DoctorSpecialityParameter);
if (ObjectOfDataAccess.ExecuteCommand(command) == 1)
{
return(true);
}
else
{
return(false);
}
}
// Method used for doctors when he successfully logged in, store its connection id for usage
public void Connect(int doctorUserId)
{
try
{
DoctorEntity doctorEntity = _docTalkDBContext.DoctorEntities.FirstOrDefault(x => x.UserId == doctorUserId);
if (doctorEntity != null)
{
doctorEntity.DoctorConnectionId = Context.ConnectionId;
}
else
{
DoctorEntity doctorEntities = new DoctorEntity()
{
DoctorConnectionId = Context.ConnectionId,
UserId = doctorUserId
};
_docTalkDBContext.DoctorEntities.Add(doctorEntities);
}
_docTalkDBContext.SaveChanges();
}
catch (System.Exception ex)
{
throw ex;
}
}
public MainMDIForm(DoctorEntity doctor)
{
InitializeComponent();
_de = doctor;
initDoctorEntity();
}
/// <summary>
/// Get a doctor by given id
/// </summary>
/// <returns></returns>
public DoctorEntity GetDoctorById(int doctorId)
{
Doctor daDoctor = _dataAccessService.DoctorRepository.GetItemById(doctorId);
if (daDoctor == null)
{
return(null);
}
DoctorEntity doctor = new DoctorEntity
{
Id = doctorId,
FirstName = daDoctor.FirstName,
LastName = daDoctor.LastName,
Roles = (from r in _dataAccessService.DoctorRoleRepository.GetAllItems()
from x in _dataAccessService.DoctorRoleXrefRepository.GetAllItems()
where r.Id == x.DoctorRoleID && x.DoctorID == doctorId
select new DoctorRoleEntity {
Id = r.Id, DoctorRoleName = r.DoctorRoleName
}
).ToList()
};
return(doctor);
}
public void UpdateDoctorsName(DoctorEntity doctor)
{
CreateSqlCommandSP("UpdateDoctorsName");
AddParameterInt("@id", doctor.id);
AddParameterString("@name", doctor.name);
dataReader = ExecuteReader();
}
public void Remove(Doctor item)
{
DoctorEntity entity = new DoctorEntity();
doctorMapper.MapToEntity(item, entity);
repository.Delete(entity);
}
public DoctorEntity GetDoctorById(int doctorId)
{
try
{
DoctorEntity doctor = new DoctorEntity();
CreateSqlCommandSP("GetDoctorById");
AddParameterInt("@id", doctorId);
dataReader = ExecuteReader();
if (dataReader.Read())
{
doctor.id = dataReader.GetInt32(0);
doctor.idOrdination = dataReader.GetInt32(1);
doctor.name = dataReader.GetString(2);
doctor.lastName = dataReader.GetString(3);
}
return(doctor);
}
catch (Exception exc)
{
throw exc;
}
finally
{
CloseConnection();
}
return(null);
}
public void Add(Doctor item)
{
DoctorEntity entity = new DoctorEntity();
doctorMapper.MapToEntity(item, entity);
repository.Create(entity);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
DoctorEntity doctorEntity = await db.Doctors.FindAsync(id);
db.People.Remove(doctorEntity);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void InsertIntoDoctor(DoctorEntity doctor)
{
CreateSqlCommandSP("InsertIntoDoctor");
AddParameterString("@name", doctor.name);
AddParameterString("@lastName", doctor.lastName);
AddParameterInt("@idOrdination", doctor.idOrdination);
dataReader = ExecuteReader();
}
public void Task_Doctor_showData_Selective_NotPresent()
{
//Arrange
List <DoctorEntity> db = InitialSeed.doctorSeed();
//Act
DoctorEntity db1 = DAL.showData(db, 2);
//Assert
Assert.NotEqual(db1, db[0]);
}
public async Task <ActionResult> Edit([Bind(Include = "Id,FirstName,LastName,Age,Email,Password,Information,Location")] DoctorEntity doctorEntity)
{
if (ModelState.IsValid)
{
db.Entry(doctorEntity).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(doctorEntity));
}
public static DoctorEntity doctorSeed2()
{
DoctorEntity de1 = new DoctorEntity();
de1.dId = 2;
de1.doctorType = "Dentist";
de1.personEntity.name = "Amita";
de1.personEntity.address = "Bch";
de1.personEntity.email = "*****@*****.**";
de1.personEntity.gender = "F";
return(de1);
}
public void Task_Doctor_insertData()
{
//Arrange
List <DoctorEntity> db = InitialSeed.doctorSeed();
List <DoctorEntity> db1 = InitialSeed.doctorSeed1();
DoctorEntity de = InitialSeed.doctorSeed2();
//Act
List <DoctorEntity> db2 = DAL.insertData(db, de);
//Assert
Assert.NotEqual(db1, db2);
}
public void SaveDoctor(DoctorEntity entity)
{
if (entity.Id == 0)
{
_context.Add(entity);
}
else
{
_context.Update(entity);
}
_context.SaveChanges();
}
// GET: DoctorEntities/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DoctorEntity doctorEntity = await db.Doctors.FindAsync(id);
if (doctorEntity == null)
{
return(HttpNotFound());
}
return(View(doctorEntity));
}
public static List <DoctorEntity> doctorSeed()
{
List <DoctorEntity> db = new List <DoctorEntity>();
DoctorEntity de = new DoctorEntity();
de.dId = 1;
de.doctorType = "Cardiac";
de.personEntity.name = "Ashif";
de.personEntity.address = "Abc";
de.personEntity.email = "*****@*****.**";
de.personEntity.gender = "M";
db.Add(de);
return(db);
}
public DataTable ToCheckLoginCredentials(DoctorEntity tempObject)
{
string checkCommand = "SELECT * FROM doctor WHERE dUserName = @dUserName AND dPassword = @dPassword";
SqlCommand command = new SqlCommand(checkCommand);
SqlParameter UserNameParameter = new SqlParameter("@dUserName", SqlDbType.NVarChar, 50);
UserNameParameter.Value = tempObject.doctorUserName;
SqlParameter PasswordParameter = new SqlParameter("@dPassword", SqlDbType.NVarChar, 50);
PasswordParameter.Value = tempObject.doctorPassword;
//Adding command
command.Parameters.Add(UserNameParameter);
command.Parameters.Add(PasswordParameter);
var d = ObjectOfDataAccess.Query(command);
if (d.Rows.Count == 1)
{
//Login Success
//string userName = d.Rows[0][2].ToString();
/*(List<DoctorEntity> doctor = new List<DoctorEntity>();
* for (int i = 0; i < d.Rows.Count; i++)
* {
* DoctorEntity _de = new DoctorEntity();
*
* _de.doctorUserName = d.Rows[i][0].ToString();
* _de.doctorPassword = d.Rows[i][1].ToString();
* _de.doctorName = d.Rows[i][2].ToString();
* _de.doctorSpeciality = d.Rows[i][3].ToString();
*
* doctor.Add(_de);
* }
*
* //return userName;
*
* return doctor;*/
return(d);
}
else
{
return(null);
}
}
public void ReleaseDoctor(string contextId)
{
try
{
DoctorEntity doctorContext = _docTalkDBContext.DoctorEntities.FirstOrDefault(x => x.DoctorConnectionId == contextId);
if (doctorContext != null)
{
doctorContext.DoctorConnectionId = "";
Doctor doctor = doctorContext.Doctor;
doctor.IsLocked = false;
_docTalkDBContext.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public List <DoctorEntity> GetAllDoctors()
{
CreateSqlCommandSP("GetAllDoctors");
dataReader = ExecuteReader();
List <DoctorEntity> listDoctors = new List <DoctorEntity>();
while (dataReader.Read())
{
DoctorEntity doctor = new DoctorEntity();
doctor.id = dataReader.GetInt32(0);
doctor.idOrdination = dataReader.GetInt32(1);
doctor.name = dataReader.GetString(2);
doctor.lastName = dataReader.GetString(3);
listDoctors.Add(doctor);
}
return(listDoctors);
}
public async Task JoinRoom()
{
try
{
string roomName = Guid.NewGuid().ToString();
Doctor avilableDoctor = GetAvailableDoctor();
if (avilableDoctor != null)
{
LockDoctor(avilableDoctor);
DoctorEntity assignUserContext = avilableDoctor.DoctorEntities.FirstOrDefault();
if (assignUserContext != null)
{
AddRoom(roomName, assignUserContext.DoctorConnectionId, Context.ConnectionId);
await Groups.Add(Context.ConnectionId, roomName);
await Groups.Add(assignUserContext.DoctorConnectionId, roomName);
Message message = new Message()
{
groupName = roomName,
message = "joined to Room"
};
await Clients.Group(roomName).addChatMessage(message, "GroupCreated");
}
}
else
{
Message message = new Message()
{
groupName = roomName,
message = "No Doctor is available to create room"
};
await Clients.Group(roomName).SendAsync("No Doctor is available to Join room");
}
}
catch (Exception)
{
throw;
}
}
public static DoctorEntity LoadDoctorById(int doctorId, int hospitalId)
{
DoctorEntity doctor = null;
using (LinqDBDataContext data = new LinqDBDataContext())
{
doctor = (from d in data.Doctors
from dh in d.Doctor_Hospitals
where d.Doctor_ID == doctorId &&
dh.Hospital_ID == hospitalId
select new DoctorEntity()
{
Doctor_ID = d.Doctor_ID,
First_Name = d.First_Name,
Last_Name = d.Last_Name,
Gender = d.Gender,
Degree = d.Degree,
Experience = d.Experience,
Working_Day = d.Working_Day
}).SingleOrDefault();
if (doctor != null)
{
List <Speciality> specialities = null;
Photo photo = new Photo();
specialities = (from d in data.Doctors
from ds in d.Doctor_Specialities
where doctor.Doctor_ID == d.Doctor_ID
select ds.Speciality).ToList <Speciality>();
photo = (from p in data.Photos
where doctor.Doctor_ID == p.Doctor_ID
select p).SingleOrDefault();
doctor.Specialities = specialities;
doctor.Photo = photo;
}
}
return(doctor);
}
