// Ian Bell - 10/13/2012 // Recieves dictionary with branchNo value. // Checks: // 1. branchNo isn't empty // 2. branchNo doesn't exceed db field length // 3. branchNo exists in db // 4. deleting branchNo won't violate foriegn key constraints // Passes staff info to data tier if it passes all tests // returns table with appropriate error message if staff info fails any test public DataSet deleteBranch(Dictionary<String, String> branchNo) { DataSet ds = generateErrorDataSet(); String errorMessage = ""; try { DataTier dt = new DataTier(); if (branchNo["branchNo"].Length > 0) // ensure that a value was passed { if(branchNo["branchNo"].Length > 4) errorMessage = "The maximum length of a Staff Number is 4 characters"; else if (dt.branchExists(branchNo).Tables[1].Rows[0][0].ToString() != "True") errorMessage = "No Branch with that Branch Number exists."; else if (dt.branchNumberConstraintExists(branchNo).Tables[1].Rows[0][0].ToString() == "True") errorMessage = "You can't delete that Branch while there are Staff and/or Properties for Rent assigned to it."; } else errorMessage = "You must enter a Branch Number."; if (errorMessage.Length == 0) dt.deleteBranch(branchNo); if (errorMessage.Length > 0) ds.Tables[0].Rows.Add(errorMessage); } catch (Exception ex) { logError(ex, "BusinessTier", "deleteBranch"); errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator"; ds.Tables[0].Rows.Add(errorMessage); } return ds; }
// Ian Bell - 10/13/2012 // Recieves dictionary with branch information values. // Checks: // 1. branch info doesn't exceed db field lengths // 2. branchNo isn't empty // 3. branchNo exists in db // Passes staff info to data tier if it passes all tests // returns table with appropriate error message if staff info fails any test public DataSet updateBranch(Dictionary<String, String> updateBranchInfo) { DataSet ds = generateErrorDataSet(); String errorMessage = ""; try { DataTier dt = new DataTier(); errorMessage = checkBranchFieldLengths(updateBranchInfo); if (errorMessage.Length == 0)// they entered a branchNo that doesn't exceed the field length { if (updateBranchInfo["branchNo"].Length > 0) // they entered a branchNo that doesn't exceed the field length { if (dt.branchExists(updateBranchInfo).Tables[1].Rows[0][0].ToString() != "True") errorMessage = "No Branch with that Branch Number exists."; } else errorMessage = "You must enter a Branch Number."; } if (errorMessage.Length == 0) ds = dt.updateBranch(updateBranchInfo); if (errorMessage.Length > 0) ds.Tables[0].Rows.Add(errorMessage); } catch (Exception ex) { logError(ex, "BusinessTier", "updateBranch"); errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator"; ds.Tables[0].Rows.Add(errorMessage); } return ds; }