public JsonResult FillData(string prefix)
{
DataSet ds = new DataSet();
List <PatientFeedback> Search = new List <Models.Patient.PatientFeedback>();
try
{
ds = patientfeedback.GetPatient(Convert.ToInt32(prefix));
PatientFeedback AddFeedback = new PatientFeedback();
Search.Add(
new PatientFeedback
{
ContactNo = ds.Tables[0].Rows[0]["MobileNo"].ToString(),
EmailId = ds.Tables[0].Rows[0]["EmailId"].ToString(),
Address = ds.Tables[0].Rows[0]["Address"].ToString(),
ConsultantDoctor = ds.Tables[0].Rows[0]["ConsultantDrName"].ToString(),
ReferredDr = ds.Tables[0].Rows[0]["ReferredDrName"].ToString(),
DoctorID = ds.Tables[0].Rows[0]["ConsultantDrID"].ToString(),
ReferredByDoctorID = ds.Tables[0].Rows[0]["ReferredDrID"].ToString()
});
}
catch (Exception ex)
{
throw ex;
}
return(Json(Search, JsonRequestBehavior.AllowGet));
}
/// <summary>This method calls <c>PatientFeedbackRepository</c> to change satus of <c>PatientFeedback</c> atribute <c>isPublished</c> on True></summary>
public PatientFeedback PublishPatientFeedback(int id)
{
PatientFeedback patientFeedback = patientFeedbackRepository.GetEntity(id);
patientFeedback.IsPublished = true;
patientFeedbackRepository.UpdateEntity(patientFeedback);
return(patientFeedback);
}
public ActionResult PatientFeedback()
{
BL_PatientFeedback patientfeedback1 = new BL_PatientFeedback();
PatientFeedback AddServiceMod = new PatientFeedback();
AddServiceMod.dsgrid = patientfeedback1.GetAllFeedbackForm();
return(View(AddServiceMod));
}
public bool PatientFeedback(PatientFeedback obj)
{
Connect();
int feedback = 0;
string[] QuesName = obj.QuestionName.Split(',');
QuesName = QuesName.Where(name => !string.IsNullOrEmpty(name)).ToArray();
string[] headnameid = obj.QuestionHeadID.Split(',');
headnameid = headnameid.Where(name => !string.IsNullOrEmpty(name)).ToArray();
string[] review = obj.ReviewType.Split(',');
string[] user = obj.Username.Split(',');
string[] remark = obj.Comments.Split(',');
string[] userquestionheadid = obj.userquestionhead.Split(',');
for (int count = 0; count < QuesName.Length; count++)
{
SqlCommand cmd = new SqlCommand("IUFeedbackForm", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.FeedBackFormID == 0)
{
cmd.Parameters.AddWithValue("@FeedBackFormID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
//if (obj.ReferenceCode == null)
// cmd.Parameters.AddWithValue("@ReferenceCode", string.Empty);
//else
// cmd.Parameters.AddWithValue("@ReferenceCode", obj.ReferenceCode);
cmd.Parameters.AddWithValue("@QuestionHeadID", headnameid[count]);
cmd.Parameters.AddWithValue("@Name", obj.Name);
cmd.Parameters.AddWithValue("@QuestionName", QuesName[count]);
cmd.Parameters.AddWithValue("@ReferredByDoctorID", obj.ReferredByDoctorID);
cmd.Parameters.AddWithValue("@DoctorID", obj.DoctorID);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@MobileNo", obj.ContactNo);
cmd.Parameters.AddWithValue("@EmailID", obj.EmailId);
cmd.Parameters.AddWithValue("@UserName", user[count]);
cmd.Parameters.AddWithValue("@Comments", remark[count]);
cmd.Parameters.AddWithValue("@ReviewType", review[count]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
feedback = cmd.ExecuteNonQuery();
con.Close();
}
if (feedback > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult DeleteConfirmed(int id)
{
PatientFeedback patientFeedback = db.PatientFeedbacks.Find(id);
FileManager.Delete(patientFeedback.Photo);
db.PatientFeedbacks.Remove(patientFeedback);
db.SaveChanges();
return(RedirectToAction("Index"));
}
[HttpPut("publishFeedback/{id}")] // PUT /api/patientFeedback/publishFeedback/{id}
public IActionResult PublishFeedback(int id)
{
PatientFeedback result = App.Instance().PatientFeedbackService.PublishPatientFeedback(id);
if (result == null)
{
return(NotFound());
}
return(Ok(PatientFeedbackMapper.PatientFeedbackToPatientFeedbackDto(result)));
}
[HttpPost] // POST /api/patientFeedback
public IActionResult Add(PatientFeedbackDto dto)
{
if (dto.Text.Length <= 0)
{
return(BadRequest());
}
PatientFeedback patientFeedback = PatientFeedbackMapper.PatientFeedbackDtoToPatientFeedback(dto, null);
App.Instance().PatientFeedbackService.AddEntity(patientFeedback);
return(Ok());
}
public ActionResult Create([Bind(Include = "Id,Photo,Name,Text")] PatientFeedback patientFeedback, HttpPostedFileBase Photo)
{
if (ModelState.IsValid)
{
patientFeedback.Photo = FileManager.Upload(Photo);
db.PatientFeedbacks.Add(patientFeedback);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patientFeedback));
}
public static PatientFeedback PatientFeedbackDtoToPatientFeedback(PatientFeedbackDto dto, Patient patient)
{
PatientFeedback patientFeedback = new PatientFeedback();
patientFeedback.IsForPublishing = dto.IsForPublishing;
patientFeedback.IsPublished = dto.IsPublished;
patientFeedback.IsAnonymous = dto.IsAnonymous;
patientFeedback.PatientId = dto.PatientId;
patientFeedback.Patient = null;
patientFeedback.Text = dto.Text;
return(patientFeedback);
}
// GET: Manage/PatientFeedbacks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PatientFeedback patientFeedback = db.PatientFeedbacks.Find(id);
if (patientFeedback == null)
{
return(HttpNotFound());
}
return(View(patientFeedback));
}
// Patient Feedback
public JsonResult FeedbackPat()
{
Models.PatientFeedback doc = new PatientFeedback();
string LivePatient = Session["PatientUserName"].ToString();
DataSet data = doc.GetDoctorInFeedback(LivePatient);
List <SelectListItem> docList = new List <SelectListItem>();
foreach (DataRow dr in data.Tables[0].Rows)
{
docList.Add(new SelectListItem {
Text = dr["DOCTOR_ID"].ToString() + " : Dr. " + dr["STAFF_NAME"].ToString(), Value = dr["DOCTOR_ID"].ToString()
});
}
return(Json(docList, JsonRequestBehavior.AllowGet));
}
public static PatientFeedbackDto PatientFeedbackToPatientFeedbackDto(PatientFeedback patientFeedback)
{
PatientFeedbackDto dto = new PatientFeedbackDto();
dto.Id = patientFeedback.Id;
dto.IsForPublishing = patientFeedback.IsForPublishing;
dto.IsPublished = patientFeedback.IsPublished;
dto.IsAnonymous = patientFeedback.IsAnonymous;
dto.PatientId = patientFeedback.PatientId;
dto.Patient = patientFeedback.Patient.Name + " " + patientFeedback.Patient.Surname;
dto.PublishingDate = patientFeedback.PublishingDate.ToString("dd.MM.yyyy. HH:mm");
dto.Text = patientFeedback.Text;
return(dto);
}
public ActionResult Edit([Bind(Include = "Id,Photo,Name,Text")] PatientFeedback patientFeedback, HttpPostedFileBase Photo)
{
db.Entry(patientFeedback).State = EntityState.Modified;
if (Photo == null)
{
db.Entry(patientFeedback).Property(a => a.Photo).IsModified = false;
}
else
{
FileManager.Delete(patientFeedback.Photo);
patientFeedback.Photo = FileManager.Upload(Photo);
}
if (ModelState.IsValid)
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patientFeedback));
}
public JsonResult GetAllFeedbackForm()
{
BL_PatientFeedback patientfeedback1 = new BL_PatientFeedback();
PatientFeedback AddServiceMod = new PatientFeedback();
AddServiceMod.dsgrid = patientfeedback1.GetAllFeedbackForm();
List <PatientFeedback> search = new List <PatientFeedback>();
foreach (DataRow dr in AddServiceMod.dsgrid.Tables[0].Rows)
{
search.Add(new PatientFeedback
{
QuestionHeadID = dr["QuestionHeadID"].ToString(),
QuestionHeadName = dr["QuestionHeadName"].ToString(),
QuestionName = dr["QuestionName"].ToString(),
});
}
return(new JsonResult {
Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public void UpdateEntity(PatientFeedback entity)
{
patientFeedbackRepository.UpdateEntity(entity);
}
public void DeleteEntity(PatientFeedback entity)
{
patientFeedbackRepository.DeleteEntity(entity);
}
/// <summary> This method calls <c>PatientFeedbackRepository</c> to post new <c>PatientFeedback</c>. </summary>
public PatientFeedback AddEntity(PatientFeedback entity)
{
entity.PublishingDate = DateTime.Now;
return(patientFeedbackRepository.AddEntity(entity));
}
public ActionResult PatientFeedback(PatientFeedback obj, FormCollection fm)
{
{
string username = fm["Username"].ToString();
string comment = fm["Comments"].ToString();
string headnameid = fm["headid"].ToString();
string name = fm["Qestion"].ToString();
string ReviewType = fm["ReviewType"].ToString();
obj.remark = fm["remark"].ToString();
string remark = obj.remark;
obj.userquestionhead = fm["userquestionhead"].ToString();
string userquestionhead = obj.userquestionhead;
string[] remark1 = comment.Split(',');
string[] userquestionhead1 = userquestionhead.Split(',');
string[] username1 = username.Split(',');
List <string> stringlist = new List <string>();
List <string> remarklist = new List <string>();
string[] headnameid1 = headnameid.Split(',');
for (int j = 0; j < (username1.Length); j++)
{
for (int i = 0; i < headnameid1.Length; i++)
{
if (userquestionhead1[j] == headnameid1[i])
{
stringlist.Add(username1[j]);
}
}
}
for (int j = 0; j < (remark1.Length); j++)
{
for (int i = 0; i < headnameid1.Length; i++)
{
if (userquestionhead1[j] == headnameid1[i])
{
remarklist.Add(remark1[j]);
}
}
}
string emp = string.Join(",", stringlist);
obj.Username = emp;
string comm = string.Join(",", remarklist);
obj.Comments = comm;
try
{
//if (obj.Comments != "" || obj.Comments != null)
//{
// obj.Comments = fm["comment"].ToString();
//}
//else
//{
// obj.Comments = "";
//}
if (obj.ReviewType != "" || obj.ReviewType != null)
{
obj.ReviewType = fm["ReviewType"].ToString();
}
else
{
obj.ReviewType = "";
}
obj.QuestionName = "";
if (obj.QuestionName != "" || obj.QuestionName != null)
{
obj.QuestionName = fm["Qestion"].ToString();
}
else
{
obj.QuestionName = "";
}
if (obj.QuestionHeadID != "" || obj.QuestionHeadID != null)
{
obj.QuestionHeadID = fm["headid"].ToString();
}
else
{
obj.QuestionHeadID = "";
}
BL_PatientFeedback patientfeedback1 = new BL_PatientFeedback();
if (patientfeedback1.PatientFeedback(obj))
{
ModelState.Clear();
ViewData["flag"] = "Done";
}
else
{
ViewData["flag"] = "Error";
}
return(PatientFeedback());
}
catch (Exception)
{
return(View());
}
}
}
