} //-------------------------------
//############################################END LINKBUTTON lnkChange EVENTS##############################################################
//############################################BUTTON btnSearch EVENTS#####################################################################
//event is raised when the button is clicked
private void btnSearchClick(object sender, EventArgs e)
{
try
{
using (DentalLib.ProcedureSearchOnTextboxList frmProcedure = new DentalLib.ProcedureSearchOnTextboxList(_userInfo, false))
{
frmProcedure.ShowDialog(this);
if (frmProcedure.HasSelected)
{
CommonExchange.Procedure procInfo = frmProcedure.ProcedureInformation;
_detailsInfo.ProcedureSystemId = procInfo.ProcedureSystemId;
_detailsInfo.ProcedureName = procInfo.ProcedureName;
this.lblProcedureId.Text = _detailsInfo.ProcedureSystemId;
this.lblProcedureName.Text = _detailsInfo.ProcedureName;
Decimal amount = 0;
if (Decimal.TryParse(procInfo.Amount.ToString(), out amount))
{
_detailsInfo.Amount = procInfo.Amount;
this.txtAmount.Text = _detailsInfo.Amount.ToString("N");
}
}
}
}
catch (Exception ex)
{
DentalLib.ProcStatic.ShowErrorDialog(ex.Message, "Procedure List Error");
}
} //----------------------------------------
} //----------------------------
//this procedure updates a procedure information
public void UpdateProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
dbLib.UpdateProcedureInformation(userInfo, procedureInfo);
}
Int32 index = 0;
if (_procedureTable != null)
{
foreach (DataRow procRow in _procedureTable.Rows)
{
if (String.Equals(procRow["sysid_procedure"].ToString(), procedureInfo.ProcedureSystemId))
{
DataRow editRow = _procedureTable.Rows[index];
editRow.BeginEdit();
editRow["procedure_name"] = procedureInfo.ProcedureName;
editRow["amount"] = procedureInfo.Amount;
editRow.EndEdit();
}
index++;
}
_procedureTable.AcceptChanges();
}
} //---------------------------
//############################################CLASS ProcedureInformation EVENTS#######################################################
//event is raised when the class is loaded
protected virtual void ClassLoad(object sender, EventArgs e)
{
if (!DatabaseLib.ProcStatic.IsSystemAccessAdmin(_userInfo))
{
DentalLib.ProcStatic.ShowErrorDialog("You are not allowed to access this module.",
"Procedure Information");
_hasErrors = true;
this.Close();
}
_procedureInfo = new CommonExchange.Procedure();
}
public ProcedureInformationUpdate(CommonExchange.SysAccess userInfo, ProcedureLogic procedureManager, CommonExchange.Procedure procedureInfo)
:
base(userInfo)
{
this.InitializeComponent();
_procedureInfo = procedureInfo;
_procedureInfoTemp = procedureInfo;
_procedureManager = procedureManager;
this.FormClosing += new FormClosingEventHandler(ClassClosing);
this.btnUpdate.Click += new EventHandler(btnUpdateClick);
this.btnClose.Click += new EventHandler(btnCloseClick);
}
} //--------------------------------
//this procedure updates a procedure information
public void UpdateProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (SqlCommand sqlComm = new SqlCommand())
{
sqlComm.Connection = userInfo.Connection;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "dental.UpdateProcedureInformation";
sqlComm.Parameters.Add("@sysid_procedure", SqlDbType.VarChar).Value = procedureInfo.ProcedureSystemId;
sqlComm.Parameters.Add("@procedure_name", SqlDbType.VarChar).Value = procedureInfo.ProcedureName;
sqlComm.Parameters.Add("@amount", SqlDbType.Decimal).Value = procedureInfo.Amount;
sqlComm.Parameters.Add("@edited_by", SqlDbType.VarChar).Value = userInfo.UserId;
sqlComm.ExecuteNonQuery();
}
} //--------------------------------
//this procedure inserts a new procedure information
public void InsertProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
dbLib.InsertProcedureInformation(userInfo, ref procedureInfo);
}
if (_procedureTable != null)
{
DataRow newRow = _procedureTable.NewRow();
newRow["sysid_procedure"] = procedureInfo.ProcedureSystemId;
newRow["procedure_name"] = procedureInfo.ProcedureName;
newRow["amount"] = procedureInfo.Amount;
_procedureTable.Rows.Add(newRow);
}
_procedureTable.AcceptChanges();
} //----------------------------
} //---------------------------
//this function returns the procedure details
public CommonExchange.Procedure GetBySystemIdProcedureInformationDetails(String procedureSysId)
{
CommonExchange.Procedure procedureInfo = new CommonExchange.Procedure();
if (_procedureTable != null)
{
String strFilter = "sysid_procedure = '" + procedureSysId + "'";
DataRow[] selectRow = _procedureTable.Select(strFilter, "procedure_name ASC");
foreach (DataRow procRow in selectRow)
{
procedureInfo.ProcedureSystemId = DatabaseLib.ProcStatic.DataRowConvert(procRow, "sysid_procedure", "");
procedureInfo.ProcedureName = DatabaseLib.ProcStatic.DataRowConvert(procRow, "procedure_name", "");
procedureInfo.Amount = DatabaseLib.ProcStatic.DataRowConvert(procRow, "amount", Decimal.Parse("0"));
break;
}
}
return(procedureInfo);
} //------------------------------
} //----------------------
#endregion
#region Programmer-Defined Function Procedures
//this function determines if the procedure name already exists
public Boolean IsExistsNameProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
return(dbLib.IsExistsNameProcedureInformation(userInfo, procedureInfo));
}
} //-----------------------------
} //------------------------
//this function determines if the procedure name already exists
public Boolean IsExistsNameProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
Boolean isExist = false;
using (SqlCommand sqlComm = new SqlCommand())
{
sqlComm.Connection = userInfo.Connection;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "dental.IsExistsNameProcedureInformation";
sqlComm.Parameters.Add("@sysid_procedure", SqlDbType.VarChar).Value = procedureInfo.ProcedureSystemId;
sqlComm.Parameters.Add("@procedure_name", SqlDbType.VarChar).Value = procedureInfo.ProcedureName;
sqlComm.Parameters.Add("@system_user_id", SqlDbType.VarChar).Value = userInfo.UserId;
isExist = (Boolean)sqlComm.ExecuteScalar();
}
return(isExist);
} //-----------------------