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