public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, PATIENT_UDFs objSave)
{
Int32 objReturn = 0;
PATIENT_UDFsDB objDB = new PATIENT_UDFsDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static PATIENT_UDFs GetItemByPatientUdf(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 PATIENT_ID, Int32 STD_REG_UDFs_ID)
{
PATIENT_UDFs objReturn = null;
PATIENT_UDFsDB objDB = new PATIENT_UDFsDB();
objReturn = objDB.GetItemByPatientUdf(CURRENT_USER, CURRENT_REGISTRY_ID, PATIENT_ID, STD_REG_UDFs_ID);
return(objReturn);
}
public static PATIENT_UDFs GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
PATIENT_UDFs objReturn = null;
PATIENT_UDFsDB objDB = new PATIENT_UDFsDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ID);
return(objReturn);
}
public PATIENT_UDFs ParseReaderCustom(DataRow row)
{
PATIENT_UDFs objReturn = new PATIENT_UDFs
{
CREATED = (DateTime)GetNullableObject(row.Field <object>("PATIENT_UDFs_CREATED")),
CREATEDBY = (string)GetNullableObject(row.Field <object>("PATIENT_UDFs_CREATEDBY")),
ID = (Int32)GetNullableObject(row.Field <object>("PATIENT_UDFs_ID")),
PATIENT_ID = (Int32)GetNullableObject(row.Field <object>("PATIENT_UDFs_PATIENT_ID")),
STD_REG_UDFs_ID = (Int32)GetNullableObject(row.Field <object>("PATIENT_UDFs_STD_REG_UDFs_ID")),
UDF_Value = (string)GetNullableObject(row.Field <object>("PATIENT_UDFs_UDF_Value")),
UPDATED = (DateTime)GetNullableObject(row.Field <object>("PATIENT_UDFs_UPDATED")),
UPDATEDBY = (string)GetNullableObject(row.Field <object>("PATIENT_UDFs_UPDATEDBY"))
};
return(objReturn);
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, PATIENT_UDFs objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID));
}
protected void BtnSave_Click(object sender, EventArgs e)
{
ServiceInterfaceManager.LogInformation("POSTBACK_EVENT", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
try
{
if (UserSession.CurrentRegistryId > 0 && UserSession.CurrentPatientId > 0)
{
if (tblForm.Rows != null)
{
foreach (TableRow row in tblForm.Rows)
{
if (row.Cells != null && row.Cells.Count > 1)
{
if (row.Cells[1].Controls != null && row.Cells[1].Controls.Count > 1)
{
HiddenField hide = (HiddenField)row.Cells[1].Controls[0];
if (hide != null)
{
int STD_REG_UDFs_Id = 0;
if (int.TryParse(hide.Value, out STD_REG_UDFs_Id))
{
string strResponse = string.Empty;
TextBox txt = (TextBox)row.Cells[1].Controls[1];
if (txt != null)
{
strResponse = txt.Text;
}
PATIENT_UDFs pUdf = ServiceInterfaceManager.PATIENT_UDFs_GET_BY_PATIENT_UDF(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentPatientId, STD_REG_UDFs_Id);
if (pUdf == null)
{
pUdf = new PATIENT_UDFs();
}
pUdf.CREATED = pUdf.UPDATED = DateTime.Now;
pUdf.CREATEDBY = pUdf.UPDATEDBY = User.Identity.Name;
pUdf.PATIENT_ID = UserSession.CurrentPatientId;
pUdf.STD_REG_UDFs_ID = STD_REG_UDFs_Id;
pUdf.UDF_Value = strResponse;
pUdf.ID = ServiceInterfaceManager.PATIENT_UDFs_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, pUdf);
if (pUdf.ID > 0)
{
lblResult.Text = "User-Defined Fields have been saved<br /><br />";
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("already exists"))
{
lblResult.Text = "The User-Defined Field you are saving already exists<br /><br />";
}
else
{
ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
throw ex;
}
}
}
private void SetupForm(List <STD_REG_UDFs> udfs)
{
viewReferral.LoadForm(UserSession.CurrentReferralId);
viewPatient.LoadForm(UserSession.CurrentPatientId);
if (udfs == null)
{
pnlForm.Visible = false;
lblResult.Text = "Currently no User-Defined Fields exist for this Registry<br /><br />";
}
else
{
int rowIndex = 0;
foreach (STD_REG_UDFs udf in udfs)
{
HiddenField hide = new HiddenField();
hide.ID = "hide" + udf.NAME.Replace(" ", string.Empty).ToUpper();
hide.Value = udf.ID.ToString();
TextBox txt = new TextBox();
txt.ID = "txt" + udf.NAME.Replace(" ", string.Empty).ToUpper();
txt.ToolTip = "Enter value for " + udf.NAME;
if (!Page.IsPostBack)
{
PATIENT_UDFs pUdf = ServiceInterfaceManager.PATIENT_UDFs_GET_BY_PATIENT_UDF(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentPatientId, udf.ID);
if (pUdf != null)
{
txt.Text = pUdf.UDF_Value;
}
}
else
{
if (Request != null && Request.Form != null && Request.Form["ctl00$MainContent$" + txt.ID] != null)
{
txt.Text = Request.Form["ctl00$MainContent$" + txt.ID].ToString();
}
}
Label lbl = new Label();
lbl.ID = "lbl" + udf.NAME.Replace(" ", string.Empty).ToUpper();
lbl.Text = lbl.ToolTip = udf.NAME;
lbl.AssociatedControlID = txt.ID;
TableCell lblCell = new TableCell();
lblCell.Controls.Add(lbl);
TableCell txtCell = new TableCell();
txtCell.Controls.Add(hide);
txtCell.Controls.Add(txt);
TableRow newRow = new TableRow();
newRow.Cells.Add(lblCell);
newRow.Cells.Add(txtCell);
tblForm.Rows.AddAt(rowIndex, newRow);
rowIndex++;
}
}
}
public PATIENT_UDFs GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
PATIENT_UDFs objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_PATIENT_UDFs_getitem", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@ID", ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, PATIENT_UDFs objSave)
{
Int32 objReturn = 0;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_PATIENT_UDFs_save", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CREATED);
p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
p = new SqlParameter("@ID", SqlDbType.Int, 4);
p.Direction = ParameterDirection.InputOutput;
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ID);
p = new SqlParameter("@PATIENT_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PATIENT_ID);
p = new SqlParameter("@STD_REG_UDFs_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.STD_REG_UDFs_ID);
p = new SqlParameter("@UDF_Value", SqlDbType.VarChar, -1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.UDF_Value);
p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.UPDATED);
p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
//int cnt = sCmd.ExecuteNonQuery();
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
objReturn = (Int32)sCmd.Parameters["@ID"].Value;
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
