public JsonResult DeleteAppointment(string Id)
{
bool Success = false;
//DateTime sysTime = DateTime.Now;
if (!string.IsNullOrEmpty(Id))
{
try
{
HcDoctorAppointmentEntity obj = (HcDoctorAppointmentEntity)ExecuteDB(HCareTaks.AG_GetSingleHcDoctorAppointmentRecordById, Id);
obj.Id = Id;
//obj.Updatedby = !string.IsNullOrEmpty(Uid) ? Uid : null;
obj.Updatedby = Session["UserId"].ToString();
obj.Updatedtime = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
obj.Status = "Cancelled";
obj.QueryFlag = "Cancelled";
Success = (bool)ExecuteDB(HCareTaks.AG_UpdateHcDoctorAppointmentInfo, obj);
//DateTime dbTime = DateTime.ParseExact(Dates, "dd/MM/yyyy", null);
//string AppDate = dbTime.ToString("dddd, dd MMMM yyyy") + " & " + Times;
//double tDays = (dbTime.AddDays(1) - sysTime).TotalDays;
//if (Status == "Pending" && tDays < 0) { DeleteAppointments(Id); Status = "Cancelled"; }
}
catch { }
}
string Message = Success ? "Process has been done successfully." : "Sorry something went wrong!";
return(Json(new { Success = Success, Message = Message }));
}
public bool UpdateHcDoctorAppointmentInfo(HcDoctorAppointmentEntity hcDoctorAppointmentEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_Doctor_Appointment SET PatientUID= @Patientuid, DoctorID= @Doctorid, Dates= @Dates, TimeID= @Timeid, Reasons= @Reasons, PayMethod= @Paymethod, Status= @Status, UpdatedBy= @Updatedby, UpdatedTime= @Updatedtime WHERE Id=@Id";
if (hcDoctorAppointmentEntity.QueryFlag == "Cancelled")
{
sql = "UPDATE HC_Doctor_Appointment SET Status= @Status, UpdatedBy= @Updatedby, UpdatedTime= @Updatedtime WHERE Id=@Id";
}
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcDoctorAppointmentEntity.Id);
db.AddInParameter(dbCommand, "Patientuid", DbType.String, hcDoctorAppointmentEntity.Patientuid);
db.AddInParameter(dbCommand, "Doctorid", DbType.String, hcDoctorAppointmentEntity.Doctorid);
db.AddInParameter(dbCommand, "Dates", DbType.String, hcDoctorAppointmentEntity.Dates);
db.AddInParameter(dbCommand, "Timeid", DbType.String, hcDoctorAppointmentEntity.Timeid);
db.AddInParameter(dbCommand, "Reasons", DbType.String, hcDoctorAppointmentEntity.Reasons);
db.AddInParameter(dbCommand, "Paymethod", DbType.String, hcDoctorAppointmentEntity.Paymethod);
db.AddInParameter(dbCommand, "Status", DbType.String, hcDoctorAppointmentEntity.Status);
db.AddInParameter(dbCommand, "Updatedby", DbType.String, hcDoctorAppointmentEntity.Updatedby);
db.AddInParameter(dbCommand, "Updatedtime", DbType.String, hcDoctorAppointmentEntity.Updatedtime);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public JsonResult SaveAppointment(HcDoctorAppointmentEntity obj)
{
bool Success = false;
if (!string.IsNullOrEmpty(obj.Doctorid) && !string.IsNullOrEmpty(obj.Dates) && !string.IsNullOrEmpty(obj.Timeid) && !string.IsNullOrEmpty(obj.Reasons) && !string.IsNullOrEmpty(obj.Paymethod))
{
try
{
obj.Patientuid =
obj.Createdby = Session["UserId"].ToString();
obj.Createdtime = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
obj.Status = "Upcoming";
obj.Dates = DateFormatWebToDb(obj.Dates);
obj.Id = (string)ExecuteDB(HCareTaks.AG_SaveHcDoctorAppointmentInfo, obj);
if (!string.IsNullOrEmpty(obj.Id))
{
Success = true;
}
}
catch { }
}
string Message = Success ? "Process has been done successfully." : "Sorry something went wrong!";
return(Json(new { Success = Success, Message = Message }));
}
public object UpdateHcDoctorAppointmentInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcDoctorAppointmentEntity hcDoctorAppointmentEntity = (HcDoctorAppointmentEntity)param;
HcDoctorAppointmentDAL hcDoctorAppointmentDAL = new HcDoctorAppointmentDAL();
retObj = (object)hcDoctorAppointmentDAL.UpdateHcDoctorAppointmentInfo(hcDoctorAppointmentEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public DataTable GetAllHcDoctorAppointmentRecord(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = @"SELECT A.ID, A.PatientUID, U.FirstName+' '+U.LastName as Username, U.Gender,
(SELECT FLOOR((CAST (GetDate() AS INTEGER) - CAST( cast(U.DOB as datetime) AS INTEGER)) / 365.25)) AS Age,
A.DoctorID, A.Dates, A.TimeID, A.Reasons, A.PayMethod, A.Status, A.CreatedBy, A.CreatedTime, A.UpdatedBy, A.UpdatedTime
, D.Name DoctorName, D.Specialist, (Select Name From HC_Doctor_Departments z Where z.ID = D.Department) DoctorDeptName, T.Times,
A.symtomps_image_path, A.prescription_image_path
FROM HC_Doctor_Appointment A
Left Join HC_DoctorInfo D ON D.ID = A.DoctorID
Left Join HC_Users U ON U.ID = A.PatientUID
Left Join HC_Doctor_Times T ON T.ID = A.TimeID
Where 1=1";
HcDoctorAppointmentEntity obj = new HcDoctorAppointmentEntity();
if (param != null)
{
obj = (HcDoctorAppointmentEntity)param;
}
if (!string.IsNullOrEmpty(obj.QueryFlag) && obj.QueryFlag == "Patient")
{
if (!string.IsNullOrEmpty(obj.Patientuid))
{
sql += " And A.PatientUID = '" + obj.Patientuid + "'";
}
if (!string.IsNullOrEmpty(obj.Status))
{
sql += " And A.Status = '" + obj.Status + "'";
}
}
else if (!string.IsNullOrEmpty(obj.QueryFlag) && obj.QueryFlag == "Doctor")
{
if (!string.IsNullOrEmpty(obj.Patientuid))
{
sql += " And A.DoctorID = '" + obj.Patientuid + "'";
}
}
if (!string.IsNullOrEmpty(obj.Id))
{
sql += " And A.ID = '" + obj.Id + "'";
}
sql += " Order By Convert(dateTime,A.CreatedTime,103) Desc";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(dbCommand);
return(ds.Tables[0]);
}
string ManageAppointmentData()
{
string Upcoming = @"<div class='appointment-list bg-info p-10 mb-20'><h4>Upcoming Appointment</h4>
<table class='table table-sm table-responsive table-hover'><thead>
<tr><th>#</th><th>Doctor</th><th>Reasons</th><th>Appointment</th><th>Created</th><th>∇</th></tr></thead><tbody>",
Completed = @"<div class='appointment-list bg-success p-10 mb-20'><h4>Completed Appointment</h4>
<table class='table table-sm table-responsive'><thead>
<tr><th>#</th><th>Doctor</th><th>Reasons</th><th>Appointment</th><th>Created</th></tr></thead><tbody>",
Cancelled = @"<div class='appointment-list bg-danger p-10 mb-20'><h4>Cancelled Appointment</h4>
<table class='table table-sm table-responsive'><thead>
<tr><th>#</th><th>Doctor</th><th>Reasons</th><th>Appointment</th><th>Created</th></tr></thead><tbody>";
HcDoctorAppointmentEntity obj = new HcDoctorAppointmentEntity();
obj.Patientuid = Session["UserId"].ToString();
DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllHcDoctorAppointmentRecord, obj);
int Up = 1, Co = 1, Ca = 1;
foreach (DataRow dr in dt.Rows)
{
string Id = dr["Id"].ToString(),
Status = dr["Status"].ToString(),
Times = dr["Times"].ToString(),
Dates = dr["Dates"].ToString() + "<br><small>" + Times + "</small>",
Created = dr["CreatedTime"].ToString().Substring(0, 10),
Reasons = dr["Reasons"].ToString(),
Doctor = dr["DoctorName"].ToString() + "<br><small>" + dr["DoctorDeptName"].ToString() + "</small>";
if (Status == "Upcoming")
{
string Action = "<i class='fa fa-times text-danger iPointer' onclick=\"DeleteAppointment('" + Id + "')\" title='Cancel This Appointment'></i>";
Upcoming += "<tr><td>" + Up + "</td><td>" + Doctor + "</td><td>" + Reasons + "</td><td>" + Dates + "</td><td>" + Created + "</td><td>" + Action + "</td></tr>";
Up++;
}
else if (Status == "Completed")
{
Completed += "<tr><td>" + Co + "</td><td>" + Doctor + "</td><td>" + Reasons + "</td><td>" + Dates + "</td><td>" + Created + "</td></tr>";
Co++;
}
else if (Status == "Cancelled")
{
Cancelled += "<tr><td>" + Ca + "</td><td>" + Doctor + "</td><td>" + Reasons + "</td><td>" + Dates + "</td><td>" + Created + "</td></tr>";
Ca++;
}
}
return(Upcoming + "</tbody></table></div>" + Completed + "</tbody></table></div>" + Cancelled + "</tbody></table></div>");
}
public object SaveHcDoctorAppointmentInfo(HcDoctorAppointmentEntity hcDoctorAppointmentEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_Doctor_Appointment ( PatientUID, DoctorID, Dates, TimeID, Reasons, PayMethod, Status, CreatedBy, CreatedTime ) output inserted.ID VALUES ( @Patientuid, @Doctorid, @Dates, @Timeid, @Reasons, @Paymethod, @Status, @Createdby, @Createdtime )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Patientuid", DbType.String, hcDoctorAppointmentEntity.Patientuid);
db.AddInParameter(dbCommand, "Doctorid", DbType.String, hcDoctorAppointmentEntity.Doctorid);
db.AddInParameter(dbCommand, "Dates", DbType.String, hcDoctorAppointmentEntity.Dates);
db.AddInParameter(dbCommand, "Timeid", DbType.String, hcDoctorAppointmentEntity.Timeid);
db.AddInParameter(dbCommand, "Reasons", DbType.String, hcDoctorAppointmentEntity.Reasons);
db.AddInParameter(dbCommand, "Paymethod", DbType.String, hcDoctorAppointmentEntity.Paymethod);
db.AddInParameter(dbCommand, "Status", DbType.String, hcDoctorAppointmentEntity.Status);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcDoctorAppointmentEntity.Createdby);
db.AddInParameter(dbCommand, "Createdtime", DbType.String, hcDoctorAppointmentEntity.Createdtime);
var id = db.ExecuteScalar(dbCommand, transaction).ToString();
return(id);
}
public HcDoctorAppointmentEntity GetSingleHcDoctorAppointmentRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, PatientUID, DoctorID, Dates, TimeID, Reasons, PayMethod, Status, CreatedBy, CreatedTime, UpdatedBy, UpdatedTime FROM HC_Doctor_Appointment WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcDoctorAppointmentEntity hcDoctorAppointmentEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcDoctorAppointmentEntity = new HcDoctorAppointmentEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["PatientUID"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Patientuid = dataReader["PatientUID"].ToString();
}
if (dataReader["DoctorID"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Doctorid = dataReader["DoctorID"].ToString();
}
if (dataReader["Dates"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Dates = dataReader["Dates"].ToString();
}
if (dataReader["TimeID"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Timeid = dataReader["TimeID"].ToString();
}
if (dataReader["Reasons"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Reasons = dataReader["Reasons"].ToString();
}
if (dataReader["PayMethod"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Paymethod = dataReader["PayMethod"].ToString();
}
if (dataReader["Status"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Status = dataReader["Status"].ToString();
}
if (dataReader["CreatedBy"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Createdby = dataReader["CreatedBy"].ToString();
}
if (dataReader["CreatedTime"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Createdtime = dataReader["CreatedTime"].ToString();
}
if (dataReader["UpdatedBy"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Updatedby = dataReader["UpdatedBy"].ToString();
}
if (dataReader["UpdatedTime"] != DBNull.Value)
{
hcDoctorAppointmentEntity.Updatedtime = dataReader["UpdatedTime"].ToString();
}
}
}
return(hcDoctorAppointmentEntity);
}