/// <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;
}
