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