private int CheckStaffNameExist(string displayName, int staffNameId, int staffId) { RunStoredProcedure rsp = new RunStoredProcedure(); // check if staff name exists in db int exist = rsp.StoredProcedureReturnInt("Proc_CheckStaffNameExist", "staffName", displayName, "count"); // if staff name exists, activate the correct staff name from db if (exist > 0) { // activate staff name on logged in user rsp.StoredProcedureUpdateBool("Proc_UpdateStaffName_Varchar", "active", true, "staffName", displayName); // get staff name id staffNameId = rsp.StoredProcedureReturnInt("Proc_GetStaffNameId_StaffName", "staffName", displayName, "staffNameId"); } // staff name does not exists in db, create a new staff name id and make it active else { // add a new staff name and return staff name id staffNameId = rsp.StoredProcedureInsertRow("Proc_AddStaffName", "staffName", displayName, "staffNameId"); } // update staff name id in staff table rsp.StoredProcedureUpdateInt("Proc_UpdateStaffNameId", "staffNameId", staffNameId, "staffId", staffId); return(staffNameId); }