} //-----------------------------
//this procedure deletes a registration details
public void DeleteRegistrationDetails(CommonExchange.SysAccess userInfo, CommonExchange.RegistrationDetails detailsInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.DeleteRegistrationDetails(userInfo, detailsInfo);
}
if (_registrationDetailsTable != null)
{
Int32 index = 0;
foreach (DataRow detailsRow in _registrationDetailsTable.Rows)
{
if (detailsInfo.DetailsId == DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "details_id", Int64.Parse("0")))
{
DataRow delRow = _registrationDetailsTable.Rows[index];
delRow.Delete();
break;
}
index++;
}
_registrationDetailsTable.AcceptChanges();
}
} //--------------------------------
} //-----------------------
//this procedure inserts a new registration details
public void InsertRegistrationDetails(CommonExchange.SysAccess userInfo, CommonExchange.RegistrationDetails detailsInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.InsertRegistrationDetails(userInfo, detailsInfo);
}
} //---------------------------------
public PatientChargesUpdate(CommonExchange.SysAccess userInfo, CommonExchange.Patient patientInfo, CommonExchange.Registration regInfo,
CommonExchange.RegistrationDetails detailsInfo, ChargesLogic chargesManager)
: base(userInfo, patientInfo, regInfo, chargesManager)
{
this.InitializeComponent();
_detailsInfo = detailsInfo;
_detailsInfoTemp = detailsInfo;
this.FormClosing += new FormClosingEventHandler(ClassClosing);
this.btnUpdate.Click += new EventHandler(btnUpdateClick);
this.btnDelete.Click += new EventHandler(btnDeleteClick);
this.btnClose.Click += new EventHandler(btnCloseClick);
}
} //-----------------------------
//this procedure deletes a registration details
public void DeleteRegistrationDetails(CommonExchange.SysAccess userInfo, CommonExchange.RegistrationDetails detailsInfo)
{
using (SqlCommand sqlComm = new SqlCommand())
{
sqlComm.Connection = userInfo.Connection;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "dental.DeleteRegistrationDetails";
sqlComm.Parameters.Add("@details_id", SqlDbType.BigInt).Value = detailsInfo.DetailsId;
sqlComm.Parameters.Add("@deleted_by", SqlDbType.VarChar).Value = userInfo.UserId;
sqlComm.ExecuteNonQuery();
}
} //-----------------------------
} //-----------------------------------
//this procedure inserts a new registration details
public void InsertRegistrationDetails(CommonExchange.SysAccess userInfo, CommonExchange.RegistrationDetails detailsInfo)
{
using (SqlCommand sqlComm = new SqlCommand())
{
sqlComm.Connection = userInfo.Connection;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "dental.InsertRegistrationDetails";
sqlComm.Parameters.Add("@sysid_registration", SqlDbType.VarChar).Value = detailsInfo.RegistrationSystemId;
sqlComm.Parameters.Add("@sysid_procedure", SqlDbType.VarChar).Value = detailsInfo.ProcedureSystemId;
sqlComm.Parameters.Add("@date_administered", SqlDbType.DateTime).Value = DateTime.Parse(detailsInfo.DateAdministered);
sqlComm.Parameters.Add("@tooth_no", SqlDbType.VarChar).Value = detailsInfo.ToothNo;
sqlComm.Parameters.Add("@amount", SqlDbType.Decimal).Value = detailsInfo.Amount;
sqlComm.Parameters.Add("@remarks", SqlDbType.VarChar).Value = detailsInfo.Remarks;
sqlComm.Parameters.Add("@created_by", SqlDbType.VarChar).Value = userInfo.UserId;
sqlComm.ExecuteNonQuery();
}
} //-----------------------------
//############################################CLASS PatientCharges EVENTS#######################################################
//event is raised when the class is loaded
protected virtual void ClassLoad(object sender, EventArgs e)
{
if (!DatabaseLib.ProcStatic.IsSystemAccessAdmin(_userInfo) && !DatabaseLib.ProcStatic.IsSystemAccessDentalUser(_userInfo))
{
DentalLib.ProcStatic.ShowErrorDialog("You are not allowed to access this module.",
"Patient Charges");
_hasErrors = true;
this.Close();
}
else if (!DatabaseLib.ProcStatic.IsSystemAccessAdmin(_userInfo))
{
this.lnkChange.Visible = false;
}
_detailsInfo = new CommonExchange.RegistrationDetails();
_detailsInfo.DateAdministered = _chargesManager.ServerDateTime;
_detailsInfo.RegistrationSystemId = _regInfo.RegistrationSystemId;
this.lblDate.Text = DateTime.Parse(_detailsInfo.DateAdministered).ToLongDateString();
} //------------------------------------------------------------
} //---------------------------------
//this procedure updates a registration details
public void UpdateRegistrationDetails(CommonExchange.SysAccess userInfo, CommonExchange.RegistrationDetails detailsInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.UpdateRegistrationDetails(userInfo, detailsInfo);
}
if (_registrationDetailsTable != null)
{
Int32 index = 0;
foreach (DataRow detailsRow in _registrationDetailsTable.Rows)
{
if (detailsInfo.DetailsId == DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "details_id", Int64.Parse("0")))
{
DataRow editRow = _registrationDetailsTable.Rows[index];
editRow.BeginEdit();
editRow["sysid_procedure"] = detailsInfo.ProcedureSystemId;
editRow["date_administered"] = detailsInfo.DateAdministered;
editRow["tooth_no"] = detailsInfo.ToothNo;
editRow["amount"] = detailsInfo.Amount;
editRow["remarks"] = detailsInfo.Remarks;
editRow["procedure_name"] = detailsInfo.ProcedureName;
editRow.EndEdit();
break;
}
index++;
}
_registrationDetailsTable.AcceptChanges();
}
} //-----------------------------
} //------------------------------------
//this function returns the registration details
public CommonExchange.RegistrationDetails GetRegistrationDetails(Int64 detailsId)
{
CommonExchange.RegistrationDetails detailsInfo = new CommonExchange.RegistrationDetails();
if (_registrationDetailsTable != null)
{
String strFilter = "details_id = '" + detailsId.ToString() + "'";
DataRow[] selectRow = _registrationDetailsTable.Select(strFilter);
foreach (DataRow detailsRow in selectRow)
{
detailsInfo.DetailsId = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "details_id", Int64.Parse("0"));
detailsInfo.ProcedureSystemId = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "sysid_procedure", "");
detailsInfo.DateAdministered = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "date_administered",
DateTime.Parse(s_serverDateTime)).ToLongDateString();
detailsInfo.ToothNo = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "tooth_no", "");
detailsInfo.Amount = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "amount", Decimal.Parse("0"));
detailsInfo.Remarks = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "remarks", "");
detailsInfo.ProcedureName = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "procedure_name", "");
}
}
return(detailsInfo);
} //-----------------------------
