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