} //------------------------------------
//this procedure inserts a new payment details
public void DeletePaymentDetails(CommonExchange.SysAccess userInfo, CommonExchange.PaymentDetails paymentInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.DeletePaymentDetails(userInfo, paymentInfo);
}
if (_paymentDetailsTable != null)
{
Int32 index = 0;
foreach (DataRow payRow in _paymentDetailsTable.Rows)
{
if (String.Equals(paymentInfo.ReceiptNo, payRow["receipt_no"].ToString()))
{
DataRow delRow = _paymentDetailsTable.Rows[index];
delRow.Delete();
break;
}
index++;
}
_paymentDetailsTable.AcceptChanges();
}
} //------------------------------------
} //--------------------------------
//this procedure inserts a new payment details
public void InsertPaymentDetails(CommonExchange.SysAccess userInfo, CommonExchange.PaymentDetails paymentInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.InsertPaymentDetails(userInfo, ref paymentInfo);
}
if (_paymentDetailsTable != null)
{
DataRow newRow = _paymentDetailsTable.NewRow();
newRow["receipt_no"] = paymentInfo.ReceiptNo;
newRow["date_paid"] = paymentInfo.DatePaid;
newRow["amount"] = paymentInfo.Amount;
newRow["discount"] = paymentInfo.Discount;
newRow["payment_type"] = paymentInfo.PaymentType;
newRow["bank_name"] = paymentInfo.BankName;
newRow["check_no"] = paymentInfo.CheckNo;
newRow["card_number"] = paymentInfo.CardNumber;
newRow["card_type"] = paymentInfo.CardType;
newRow["card_expire"] = paymentInfo.CardExpire;
_paymentDetailsTable.Rows.Add(newRow);
_paymentDetailsTable.AcceptChanges();
}
} //--------------------------------------
} //-----------------------------
//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);
}
} //---------------------------------
} //--------------------------------------
//this procedure inserts a new payment details
public void UpdatePaymentDetails(CommonExchange.SysAccess userInfo, CommonExchange.PaymentDetails paymentInfo)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
dbLib.UpdatePaymentDetails(userInfo, paymentInfo);
}
if (_paymentDetailsTable != null)
{
Int32 index = 0;
foreach (DataRow payRow in _paymentDetailsTable.Rows)
{
if (String.Equals(paymentInfo.ReceiptNo, payRow["receipt_no"].ToString()))
{
DataRow editRow = _paymentDetailsTable.Rows[index];
editRow.BeginEdit();
editRow["date_paid"] = paymentInfo.DatePaid;
editRow["amount"] = paymentInfo.Amount;
editRow["discount"] = paymentInfo.Discount;
editRow["payment_type"] = paymentInfo.PaymentType;
editRow["bank_name"] = paymentInfo.BankName;
editRow["check_no"] = paymentInfo.CheckNo;
editRow["card_number"] = paymentInfo.CardNumber;
editRow["card_type"] = paymentInfo.CardType;
editRow["card_expire"] = paymentInfo.CardExpire;
editRow.EndEdit();
break;
}
index++;
}
_paymentDetailsTable.AcceptChanges();
}
} //------------------------------------
} //---------------------------------
//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 payment details table
public DataTable SelectByRegistrationIDPaymentDetails(CommonExchange.SysAccess userInfo, String registrationSysId, Boolean isNewQuery)
{
if (isNewQuery)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
_paymentDetailsTable = dbLib.SelectByRegistrationIDPaymentDetails(userInfo, registrationSysId);
}
}
DataTable dbTable = new DataTable("PaymentDetailsTemp");
dbTable.Columns.Add("receipt_no", System.Type.GetType("System.String"));
dbTable.Columns.Add("date_paid", System.Type.GetType("System.DateTime"));
dbTable.Columns.Add("amount", System.Type.GetType("System.Decimal"));
dbTable.Columns.Add("discount", System.Type.GetType("System.Decimal"));
dbTable.Columns.Add("payment_type", System.Type.GetType("System.Byte"));
dbTable.Columns.Add("bank_name", System.Type.GetType("System.String"));
dbTable.Columns.Add("check_no", System.Type.GetType("System.String"));
dbTable.Columns.Add("card_number", System.Type.GetType("System.String"));
dbTable.Columns.Add("card_type", System.Type.GetType("System.String"));
dbTable.Columns.Add("card_expire", System.Type.GetType("System.String"));
if (_paymentDetailsTable != null)
{
foreach (DataRow payRow in _paymentDetailsTable.Rows)
{
DataRow newRow = dbTable.NewRow();
newRow["receipt_no"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "receipt_no", "");
newRow["date_paid"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "date_paid", DateTime.Parse(s_serverDateTime));
newRow["amount"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "amount", Decimal.Parse("0"));
newRow["discount"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "discount", Decimal.Parse("0"));
newRow["payment_type"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "payment_type", Byte.Parse("0"));
newRow["bank_name"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "bank_name", "");
newRow["check_no"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "check_no", "");
newRow["card_number"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "card_number", "");
newRow["card_type"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "card_type", "");
newRow["card_expire"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "card_expire", "");
dbTable.Rows.Add(newRow);
}
dbTable.AcceptChanges();
}
DataTable payTable = new DataTable("PaymentDetailsSortByDate");
payTable.Columns.Add("receipt_no", System.Type.GetType("System.String"));
payTable.Columns.Add("date_paid", System.Type.GetType("System.String"));
payTable.Columns.Add("amount_paid", System.Type.GetType("System.String"));
payTable.Columns.Add("discount", System.Type.GetType("System.String"));
payTable.Columns.Add("amount_balance", System.Type.GetType("System.String"));
Decimal amountPayable = this.GetTotalAmountPayable();
DataRow[] selectRow = dbTable.Select("", "date_paid ASC");
foreach (DataRow payRow in selectRow)
{
DataRow newRow = payTable.NewRow();
newRow["receipt_no"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "receipt_no", "");
newRow["date_paid"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "date_paid", DateTime.Parse(s_serverDateTime)).ToLongDateString();
newRow["amount_paid"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "amount", Decimal.Parse("0")).ToString("N");
newRow["discount"] = DatabaseLib.ProcStatic.DataRowConvert(payRow, "discount", Decimal.Parse("0")).ToString("N");
amountPayable = this.GetAmountBalance(amountPayable, DatabaseLib.ProcStatic.DataRowConvert(payRow, "receipt_no", ""));
newRow["amount_balance"] = amountPayable.ToString("N");
payTable.Rows.Add(newRow);
}
payTable.AcceptChanges();
return(payTable);
} //-----------------------------------------
} //------------------------------------
#endregion
#region Programmer-Defined Function Procedures
//this function returns the patient registration details
public DataTable SelectByRegistrationIDRegistrationDetails(CommonExchange.SysAccess userInfo, String registrationSysId, Boolean isNewQuery)
{
if (isNewQuery)
{
using (DatabaseLib.DbLibRegistrationManager dbLib = new DatabaseLib.DbLibRegistrationManager())
{
_registrationDetailsTable = dbLib.SelectByRegistrationIDRegistrationDetails(userInfo, registrationSysId);
}
}
DataTable dbTable = new DataTable("PatientRegistrationDetailsTemp");
dbTable.Columns.Add("details_id", System.Type.GetType("System.Int64"));
dbTable.Columns.Add("sysid_procedure", System.Type.GetType("System.String"));
dbTable.Columns.Add("date_administered", System.Type.GetType("System.DateTime"));
dbTable.Columns.Add("tooth_no", System.Type.GetType("System.String"));
dbTable.Columns.Add("amount", System.Type.GetType("System.Decimal"));
dbTable.Columns.Add("remarks", System.Type.GetType("System.String"));
dbTable.Columns.Add("procedure_name", System.Type.GetType("System.String"));
if (_registrationDetailsTable != null)
{
foreach (DataRow detailsRow in _registrationDetailsTable.Rows)
{
DataRow newRow = dbTable.NewRow();
newRow["details_id"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "details_id", Int64.Parse("0"));
newRow["sysid_procedure"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "sysid_procedure", "");
newRow["date_administered"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "date_administered", DateTime.Parse(s_serverDateTime));
newRow["tooth_no"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "tooth_no", "");
newRow["amount"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "amount", Decimal.Parse("0"));
newRow["remarks"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "remarks", "");
newRow["procedure_name"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "procedure_name", "");
dbTable.Rows.Add(newRow);
}
dbTable.AcceptChanges();
}
DataTable regTable = new DataTable("PatientRegistrationDetailsSortByDate");
regTable.Columns.Add("details_id", System.Type.GetType("System.Int64"));
regTable.Columns.Add("date_administered", System.Type.GetType("System.String"));
regTable.Columns.Add("procedure_name", System.Type.GetType("System.String"));
regTable.Columns.Add("tooth_no", System.Type.GetType("System.String"));
regTable.Columns.Add("amount", System.Type.GetType("System.String"));
DataRow[] selectRow = dbTable.Select("", "date_administered DESC");
foreach (DataRow detailsRow in selectRow)
{
DataRow newRow = regTable.NewRow();
newRow["details_id"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "details_id", Int64.Parse("0"));
newRow["date_administered"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "date_administered",
DateTime.Parse(s_serverDateTime)).ToLongDateString();
newRow["procedure_name"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "procedure_name", "");
newRow["tooth_no"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "tooth_no", "");
newRow["amount"] = DatabaseLib.ProcStatic.DataRowConvert(detailsRow, "amount", Decimal.Parse("0")).ToString("N");
regTable.Rows.Add(newRow);
}
regTable.AcceptChanges();
return(regTable);
} //------------------------------------
