/// <summary> /// Action to open referral in edit mode /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult createreferral(string id = "0") { try { Referral objReferralinfo = new Referral(); int nReferralId = Methods.doInt(Methods.base64Decode(id)); var Referal = new GHC_PatientReferralData(); if (nReferralId > 0) { // GET REFERRAL INFORMATION string sSQL = "Select * from GHC_PatientReferral where nReferralID = " + nReferralId + " "; DataRow dr = DBMethods.GetInfoById(sSQL); if (dr != null) { Referal.nReferralID = Methods.doInt(dr["nReferralID"]); Referal.sContactNo = Methods.CorrectDBNull(dr["sContactNo"]); Referal.sOtherImportantContacts = Methods.CorrectDBNull(dr["sOtherImportantContacts"]); Referal.dReferralDate = (Methods.CorrectDBNull(dr["dReferralDate"].ToString()) != "") ? (DateTime?)Convert.ToDateTime(Convert.ToDateTime(Methods.CorrectDBNull(dr["dReferralDate"])).ToShortDateString()) : null; Referal.sReferralSource = Methods.CorrectDBNull(dr["sReferralSource"]); Referal.sReferralPhone = Methods.CorrectDBNull(dr["sReferralPhone"]); Referal.sReferralFax = Methods.CorrectDBNull(dr["sReferralFax"]); Referal.sReferralAddress = Methods.CorrectDBNull(dr["sReferralAddress"]); Referal.sClientName = Methods.CorrectDBNull(dr["sClientName"]); Referal.dDateOfBirth = (Methods.CorrectDBNull(dr["dDateOfBirth"].ToString()) != "") ? (DateTime?)Convert.ToDateTime(Convert.ToDateTime(Methods.CorrectDBNull(dr["dDateOfBirth"])).ToShortDateString()) : null; Referal.bGender = Methods.doBoolean(dr["bGender"]); Referal.sEthnicity = Methods.CorrectDBNull(dr["sEthnicity"]); Referal.sMedicaidNo = Methods.CorrectDBNull(dr["sMedicaidNo"]); Referal.sResidingWith = Methods.CorrectDBNull(dr["sResidingWith"]); Referal.sSocialSecurityNo = Methods.CorrectDBNull(dr["sSocialSecurityNo"]); Referal.sAddress = Methods.CorrectDBNull(dr["sAddress"]); Referal.sEmail = Methods.CorrectDBNull(dr["sEmail"]); Referal.sNameOfLegalGuardian = Methods.CorrectDBNull(dr["sNameOfLegalGuardian"]); Referal.sPresentingConcerns = Methods.CorrectDBNull(dr["sPresentingConcerns"]); Referal.sDiagnosis = Methods.CorrectDBNull(dr["sDiagnosis"]); Referal.sServicesRequested = Methods.CorrectDBNull(dr["sServicesRequested"]); Referal.sLocationOfServices = Methods.CorrectDBNull(dr["sLocationOfServices"]); Referal.sTypeOfInsurance = Methods.CorrectDBNull(dr["sTypeOfInsurance"]); Referal.sPolicyNo = Methods.CorrectDBNull(dr["sPolicyNo"]); Referal.sGroupNo = Methods.CorrectDBNull(dr["sGroupNo"]); Referal.sPhoneNo = Methods.CorrectDBNull(dr["sPhoneNo"]); } } objReferralinfo.objGHC_PatientReferralData = Referal; return View(objReferralinfo); } catch (Exception ex) { CommonRepository.LogError(sController, "createreferral", ex.ToString()); Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Error]"); Session[Helpers.CommonConstants.MessageType] = "2"; return RedirectToAction("viewreferrals"); } }
/// <summary> /// Action to open referral listing page /// </summary> /// <returns></returns> public ActionResult viewreferrals() { Referral objReferral = new Referral(); try { DataSet ds = objDBGHC_PatientReferral.GHC_PatientReferral_GetAll("dDateAdded", "DESC"); if (ds != null && ds.Tables[1] != null) { List<GHC_PatientReferralData> sList = new List<GHC_PatientReferralData>(); foreach (DataRow row in ds.Tables[1].Rows) { var nRecord = new GHC_PatientReferralData(); nRecord.sReferralSource = Methods.CorrectDBNull(row["sReferralSource"]); nRecord.dReferralDate = (Methods.CorrectDBNull(row["dReferralDate"].ToString()) != "") ? (DateTime?)Convert.ToDateTime(Convert.ToDateTime(Methods.CorrectDBNull(row["dReferralDate"])).ToShortDateString()) : null ; nRecord.sClientName = Methods.CorrectDBNull(row["sClientName"]); nRecord.sReferralPhone = Methods.CorrectDBNull(row["sReferralPhone"]); nRecord.nReferralID = Methods.doInt(row["nReferralID"]); sList.Add(nRecord); } objReferral.objGHC_PatientReferralDataList = sList; } return View(objReferral); } catch (Exception ex) { CommonRepository.LogError(sController, "viewreferrals", ex.ToString()); Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Error]"); Session[Helpers.CommonConstants.MessageType] = "2"; return RedirectToAction("index", "dashboard"); } }
public int GHC_PatientReferral_Update(GHC_PatientReferralData objGHC_PatientReferral) { int rowsAffected = 0; SqlConnection connection = null; try { connection = (SqlConnection)new DBConnect().ConnectionObject; SqlCommand Command = new SqlCommand("GHC_GHC_PatientReferral_Update", connection); Command.CommandType = CommandType.StoredProcedure; Command.Parameters.AddWithValue("@nReferralID",objGHC_PatientReferral.nReferralID); Command.Parameters.AddWithValue("@dReferralDate",objGHC_PatientReferral.dReferralDate); Command.Parameters.AddWithValue("@sReferralSource",objGHC_PatientReferral.sReferralSource); Command.Parameters.AddWithValue("@sReferralPhone",objGHC_PatientReferral.sReferralPhone); Command.Parameters.AddWithValue("@sReferralFax",objGHC_PatientReferral.sReferralFax); Command.Parameters.AddWithValue("@sReferralAddress",objGHC_PatientReferral.sReferralAddress); Command.Parameters.AddWithValue("@sClientName",objGHC_PatientReferral.sClientName); Command.Parameters.AddWithValue("@dDateOfBirth",objGHC_PatientReferral.dDateOfBirth); Command.Parameters.AddWithValue("@bGender",objGHC_PatientReferral.bGender); Command.Parameters.AddWithValue("@sEthnicity",objGHC_PatientReferral.sEthnicity); Command.Parameters.AddWithValue("@sMedicaidNo",objGHC_PatientReferral.sMedicaidNo); Command.Parameters.AddWithValue("@sSocialSecurityNo",objGHC_PatientReferral.sSocialSecurityNo); Command.Parameters.AddWithValue("@sResidingWith",objGHC_PatientReferral.sResidingWith); Command.Parameters.AddWithValue("@sAddress",objGHC_PatientReferral.sAddress); Command.Parameters.AddWithValue("@sContactNo",objGHC_PatientReferral.sContactNo); Command.Parameters.AddWithValue("@sEmail",objGHC_PatientReferral.sEmail); Command.Parameters.AddWithValue("@sNameOfLegalGuardian",objGHC_PatientReferral.sNameOfLegalGuardian); Command.Parameters.AddWithValue("@sOtherImportantContacts",objGHC_PatientReferral.sOtherImportantContacts); Command.Parameters.AddWithValue("@sPresentingConcerns",objGHC_PatientReferral.sPresentingConcerns); Command.Parameters.AddWithValue("@sDiagnosis",objGHC_PatientReferral.sDiagnosis); Command.Parameters.AddWithValue("@sServicesRequested",objGHC_PatientReferral.sServicesRequested); Command.Parameters.AddWithValue("@sLocationOfServices",objGHC_PatientReferral.sLocationOfServices); Command.Parameters.AddWithValue("@sTypeOfInsurance",objGHC_PatientReferral.sTypeOfInsurance); Command.Parameters.AddWithValue("@sPolicyNo",objGHC_PatientReferral.sPolicyNo); Command.Parameters.AddWithValue("@sGroupNo",objGHC_PatientReferral.sGroupNo); Command.Parameters.AddWithValue("@sPhoneNo",objGHC_PatientReferral.sPhoneNo); Command.Parameters.AddWithValue("@dDateModified",objGHC_PatientReferral.dDateModified); Command.Parameters.AddWithValue("@nModifiedBy",objGHC_PatientReferral.nModifiedBy); SqlParameter returnValueParam = new SqlParameter("@RETURN_VALUE", SqlDbType.Int); returnValueParam.Direction = ParameterDirection.ReturnValue; Command.Parameters.Add(returnValueParam); connection.Open(); Command.ExecuteNonQuery(); rowsAffected = Convert.ToInt32(returnValueParam.Value); } catch { rowsAffected = 0; } finally { if (connection != null) connection.Close(); connection.Dispose(); } return rowsAffected; }