public void Update(BranchManagementBO branchMngmntBO, int branchIDforupdate) { string queryString = ""; queryString = @"SBPUpdateBranch"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@branchID", SqlDbType.Int, branchIDforupdate); _dbConnection.AddParameter("@branchName", SqlDbType.VarChar, branchMngmntBO.BranchName); _dbConnection.AddParameter("@address", SqlDbType.VarChar, branchMngmntBO.BranchAddress); _dbConnection.AddParameter("@telePhone", SqlDbType.VarChar, branchMngmntBO.TelePhone); _dbConnection.AddParameter("@fax", SqlDbType.VarChar, branchMngmntBO.Fax); _dbConnection.AddParameter("@eMail", SqlDbType.VarChar, branchMngmntBO.Email); _dbConnection.AddParameter("@web", SqlDbType.VarChar, branchMngmntBO.Web); _dbConnection.AddParameter("@openDate", SqlDbType.DateTime, branchMngmntBO.BranchOpeningdate.ToShortDateString()); _dbConnection.AddParameter("@isActive ", SqlDbType.Int, branchMngmntBO.BranchIsActive); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void Insert(BranchManagementBO branchMngmntBO) { string queryString = ""; CommonBAL commonBAL = new CommonBAL(); branchMngmntBO.BranchId = commonBAL.GenerateID("SBP_Broker_Branch", "Branch_ID"); queryString = @"SBPSaveBranch"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@branchID", SqlDbType.Int, branchMngmntBO.BranchId); _dbConnection.AddParameter("@branchName", SqlDbType.VarChar, branchMngmntBO.BranchName); _dbConnection.AddParameter("@address", SqlDbType.VarChar, branchMngmntBO.BranchAddress); _dbConnection.AddParameter("@telePhone", SqlDbType.VarChar, branchMngmntBO.TelePhone); _dbConnection.AddParameter("@fax", SqlDbType.VarChar, branchMngmntBO.Fax); _dbConnection.AddParameter("@eMail", SqlDbType.VarChar, branchMngmntBO.Email); _dbConnection.AddParameter("@web", SqlDbType.VarChar, branchMngmntBO.Web); _dbConnection.AddParameter("@openDate", SqlDbType.DateTime, branchMngmntBO.BranchOpeningdate.ToShortDateString()); _dbConnection.AddParameter("@isActive ", SqlDbType.Int, branchMngmntBO.BranchIsActive); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }